DBA Data[Home] [Help]

APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on AMW_PROCEDURE_REV_S

Line 1043: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;

1039:
1040: FOR ap_rec IN c_srceng_ap
1041: LOOP
1042: select amw_procedures_s.nextval into l_audit_procedure_id from dual;
1043: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;
1044: -- l_audit_procedure_id :=amw_procedures_s.nextval;
1045: -- l_audit_procedure_rev_id :=amw_procedure_rev_s.nextval;
1046: insert into AMW_AUDIT_PROCEDURES_B (
1047: PROJECT_ID,

Line 1045: -- l_audit_procedure_rev_id :=amw_procedure_rev_s.nextval;

1041: LOOP
1042: select amw_procedures_s.nextval into l_audit_procedure_id from dual;
1043: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;
1044: -- l_audit_procedure_id :=amw_procedures_s.nextval;
1045: -- l_audit_procedure_rev_id :=amw_procedure_rev_s.nextval;
1046: insert into AMW_AUDIT_PROCEDURES_B (
1047: PROJECT_ID,
1048: ATTRIBUTE10,
1049: ATTRIBUTE11,

Line 1431: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;

1427:
1428: FOR ap_rec IN c_srceng_ap
1429: LOOP
1430: select amw_procedures_s.nextval into l_audit_procedure_id from dual;
1431: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;
1432: -- l_audit_procedure_id :=amw_procedures_s.nextval;
1433: -- l_audit_procedure_rev_id :=amw_procedure_rev_s.nextval;
1434: insert into AMW_AUDIT_PROCEDURES_B (
1435: PROJECT_ID,

Line 1433: -- l_audit_procedure_rev_id :=amw_procedure_rev_s.nextval;

1429: LOOP
1430: select amw_procedures_s.nextval into l_audit_procedure_id from dual;
1431: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;
1432: -- l_audit_procedure_id :=amw_procedures_s.nextval;
1433: -- l_audit_procedure_rev_id :=amw_procedure_rev_s.nextval;
1434: insert into AMW_AUDIT_PROCEDURES_B (
1435: PROJECT_ID,
1436: ATTRIBUTE10,
1437: ATTRIBUTE11,