DBA Data[Home] [Help]

APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_AUDIT_PROCEDURE_INT_S

Line 181: update amw_audit_procedure_interface set AP_INTERFACE_ID= amw_audit_procedure_int_s.nextval where AP_INTERFACE_ID = 0

177: update amw_audit_procedure_interface set control_id = 0,task_id = 0,organization_id = 0,
178: audit_project_id = 0,audit_procedure_id = 0,audit_procedure_rev_id = 0,step_id = 0
179: where created_by = p_user_id and batch_id = p_batch_id;
180: -- To insert Audit Procedure Interface Id
181: update amw_audit_procedure_interface set AP_INTERFACE_ID= amw_audit_procedure_int_s.nextval where AP_INTERFACE_ID = 0
182: and batch_id = p_batch_id;
183: commit;
184:
185: -- To fetch Audit Project Id