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,
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,
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,
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,