Record_Status is 'Changed' After Post_Query Trigger
Record_Status is 'Changed' After Post_Query Trigger due to which is keeps asking to Save record while closing the form having no changes.
Here is Post_Query Trigger
================
IF :xxhil_om_sanction_budget.ou_id IS NOT NULL THEN
select distinct parm_ou_name
into :xxhil_om_sanction_budget.NBT_ORG_CD --NON DB ITEM
from XXHIL_OM_ORG_V
where parm_ou_id= :xxhil_om_sanction_budget.ou_id;
END IF;
IF :xxhil_om_sanction_budget.item_id IS NOT NULL THEN
select segment1
into :xxhil_om_sanction_budget.NBT_ITEM_NAME --NON DB ITEM
from mtl_system_items_b
Tagged:
0