[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