DBA Data[Home] [Help]

APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on AMW_PROCEDURES_S

Line 1042: select amw_procedures_s.nextval into l_audit_procedure_id from dual;

1038: BEGIN
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 (

Line 1044: -- l_audit_procedure_id :=amw_procedures_s.nextval;

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,
1048: ATTRIBUTE10,

Line 1430: select amw_procedures_s.nextval into l_audit_procedure_id from dual;

1426: BEGIN
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 (

Line 1432: -- l_audit_procedure_id :=amw_procedures_s.nextval;

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,
1436: ATTRIBUTE10,