[Home] [Help]
1004: ATTRIBUTE2,
1005: ATTRIBUTE3,
1006: ATTRIBUTE4,
1007: CLASSIFICATION
1008: FROM AMW_AUDIT_PROCEDURES_B
1009: WHERE PROJECT_ID = p_source_project_id and
1010: (END_DATE>=SYSDATE or END_DATE is null);
1011: cursor c_tasks
1012: is
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,
1050: ATTRIBUTE12,
1268: 1
1269: from
1270: amw_ap_associations apa
1271: where apa.audit_procedure_id not in (
1272: select distinct audit_procedure_id from amw_audit_procedures_b where
1273: project_id=p_source_project_id
1274: )
1275: and apa.OBJECT_TYPE='PROJECT' and association_creation_date is not null
1276: and apa.pk1=p_source_project_id
1392: ATTRIBUTE2,
1393: ATTRIBUTE3,
1394: ATTRIBUTE4,
1395: CLASSIFICATION
1396: FROM AMW_AUDIT_PROCEDURES_B
1397: WHERE PROJECT_ID = p_source_project_id and
1398: (END_DATE>=SYSDATE or END_DATE is null);
1399: cursor c_tasks
1400: is
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,
1438: ATTRIBUTE12,
1646: 1
1647: from
1648: amw_ap_associations apa
1649: where apa.audit_procedure_id not in (
1650: select distinct audit_procedure_id from amw_audit_procedures_b where
1651: project_id=p_source_project_id
1652: )
1653: and apa.OBJECT_TYPE='PROJECT' and association_creation_date is not null
1654: and apa.pk1=p_source_project_id