87: PARENT_PROCESS_ID)
88: SELECT amw_execution_scope_s.nextval,
89: 'PROJECT',
90: p_target_entity_id,
91: FND_GLOBAL.USER_ID,
92: SYSDATE,
93: SYSDATE,
94: FND_GLOBAL.USER_ID,
95: FND_GLOBAL.USER_ID,
90: p_target_entity_id,
91: FND_GLOBAL.USER_ID,
92: SYSDATE,
93: SYSDATE,
94: FND_GLOBAL.USER_ID,
95: FND_GLOBAL.USER_ID,
96: 'C',
97: LEVEL_ID,
98: SUBSIDIARY_VS,
91: FND_GLOBAL.USER_ID,
92: SYSDATE,
93: SYSDATE,
94: FND_GLOBAL.USER_ID,
95: FND_GLOBAL.USER_ID,
96: 'C',
97: LEVEL_ID,
98: SUBSIDIARY_VS,
99: SUBSIDIARY_CODE,
127: LEVEL_ID)
128: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
129: ENTITY_TYPE,
130: p_target_entity_id,
131: FND_GLOBAL.USER_ID,
132: SYSDATE,
133: SYSDATE,
134: FND_GLOBAL.USER_ID,
135: FND_GLOBAL.USER_ID,
130: p_target_entity_id,
131: FND_GLOBAL.USER_ID,
132: SYSDATE,
133: SYSDATE,
134: FND_GLOBAL.USER_ID,
135: FND_GLOBAL.USER_ID,
136: OBJECT_TYPE,
137: OBJECT_ID,
138: PARENT_OBJECT_TYPE,
131: FND_GLOBAL.USER_ID,
132: SYSDATE,
133: SYSDATE,
134: FND_GLOBAL.USER_ID,
135: FND_GLOBAL.USER_ID,
136: OBJECT_TYPE,
137: OBJECT_ID,
138: PARENT_OBJECT_TYPE,
139: PARENT_OBJECT_ID,
171: START_DATE,
172: COMPLETION_DATE,
173: TASK_MANAGER_PERSON_ID,
174: SYSDATE,
175: FND_GLOBAL.USER_ID,
176: SYSDATE,
177: FND_GLOBAL.USER_ID,
178: FND_GLOBAL.USER_ID,
179: 1
173: TASK_MANAGER_PERSON_ID,
174: SYSDATE,
175: FND_GLOBAL.USER_ID,
176: SYSDATE,
177: FND_GLOBAL.USER_ID,
178: FND_GLOBAL.USER_ID,
179: 1
180: from amw_audit_tasks_b
181: where audit_project_id = p_source_entity_id;
174: SYSDATE,
175: FND_GLOBAL.USER_ID,
176: SYSDATE,
177: FND_GLOBAL.USER_ID,
178: FND_GLOBAL.USER_ID,
179: 1
180: from amw_audit_tasks_b
181: where audit_project_id = p_source_entity_id;
182:
200: stl.DESCRIPTION,
201: stl.LANGUAGE,
202: stl.SOURCE_LANG,
203: SYSDATE,
204: FND_GLOBAL.USER_ID,
205: SYSDATE,
206: FND_GLOBAL.USER_ID,
207: FND_GLOBAL.USER_ID,
208: 1
202: stl.SOURCE_LANG,
203: SYSDATE,
204: FND_GLOBAL.USER_ID,
205: SYSDATE,
206: FND_GLOBAL.USER_ID,
207: FND_GLOBAL.USER_ID,
208: 1
209: from amw_audit_tasks_b b,
210: amw_audit_tasks_tl stl,
203: SYSDATE,
204: FND_GLOBAL.USER_ID,
205: SYSDATE,
206: FND_GLOBAL.USER_ID,
207: FND_GLOBAL.USER_ID,
208: 1
209: from amw_audit_tasks_b b,
210: amw_audit_tasks_tl stl,
211: amw_audit_tasks_b sb
340: l_engagement_type_id,
341: 'ACTI',
342: 'NOT_SUBMITTED',
343: 'N',
344: FND_GLOBAL.USER_ID,
345: SYSDATE,
346: SYSDATE,
347: FND_GLOBAL.USER_ID,
348: FND_GLOBAL.USER_ID,
343: 'N',
344: FND_GLOBAL.USER_ID,
345: SYSDATE,
346: SYSDATE,
347: FND_GLOBAL.USER_ID,
348: FND_GLOBAL.USER_ID,
349: 1
350: FROM dual
351: WHERE not exists (SELECT 'Y'
344: FND_GLOBAL.USER_ID,
345: SYSDATE,
346: SYSDATE,
347: FND_GLOBAL.USER_ID,
348: FND_GLOBAL.USER_ID,
349: 1
350: FROM dual
351: WHERE not exists (SELECT 'Y'
352: FROM AMW_AUDIT_PROJECTS
439:
440:
441: PA_INTERFACE_UTILS_PUB.SET_GLOBAL_INFO(
442: p_api_version_number => 1,
443: p_responsibility_id => FND_GLOBAL.RESP_ID,
444: p_user_id => FND_GLOBAL.USER_ID,
445: p_resp_appl_id => 242,
446: p_msg_count => l_msg_count,
447: p_msg_data => l_msg_data,
440:
441: PA_INTERFACE_UTILS_PUB.SET_GLOBAL_INFO(
442: p_api_version_number => 1,
443: p_responsibility_id => FND_GLOBAL.RESP_ID,
444: p_user_id => FND_GLOBAL.USER_ID,
445: p_resp_appl_id => 242,
446: p_msg_count => l_msg_count,
447: p_msg_data => l_msg_data,
448: p_return_status => l_return_status);
559:
560:
561: PA_INTERFACE_UTILS_PUB.SET_GLOBAL_INFO(
562: p_api_version_number => 1,
563: p_responsibility_id => FND_GLOBAL.RESP_ID,
564: p_user_id => FND_GLOBAL.USER_ID,
565: p_resp_appl_id => 242,
566: p_msg_count => l_msg_count,
567: p_msg_data => l_msg_data,
560:
561: PA_INTERFACE_UTILS_PUB.SET_GLOBAL_INFO(
562: p_api_version_number => 1,
563: p_responsibility_id => FND_GLOBAL.RESP_ID,
564: p_user_id => FND_GLOBAL.USER_ID,
565: p_resp_appl_id => 242,
566: p_msg_count => l_msg_count,
567: p_msg_data => l_msg_data,
568: p_return_status => l_return_status);
672: BEGIN
673:
674: PA_INTERFACE_UTILS_PUB.SET_GLOBAL_INFO(
675: p_api_version_number => 1,
676: p_responsibility_id => FND_GLOBAL.RESP_ID,
677: p_user_id => FND_GLOBAL.USER_ID,
678: p_resp_appl_id => 242,
679: p_msg_count => l_msg_count,
680: p_msg_data => l_msg_data,
673:
674: PA_INTERFACE_UTILS_PUB.SET_GLOBAL_INFO(
675: p_api_version_number => 1,
676: p_responsibility_id => FND_GLOBAL.RESP_ID,
677: p_user_id => FND_GLOBAL.USER_ID,
678: p_resp_appl_id => 242,
679: p_msg_count => l_msg_count,
680: p_msg_data => l_msg_data,
681: p_return_status => l_return_status);
762: BEGIN
763:
764: PA_INTERFACE_UTILS_PUB.SET_GLOBAL_INFO(
765: p_api_version_number => 1,
766: p_responsibility_id => FND_GLOBAL.RESP_ID,
767: p_user_id => FND_GLOBAL.USER_ID,
768: p_resp_appl_id => 242,
769: p_msg_count => l_msg_count,
770: p_msg_data => l_msg_data,
763:
764: PA_INTERFACE_UTILS_PUB.SET_GLOBAL_INFO(
765: p_api_version_number => 1,
766: p_responsibility_id => FND_GLOBAL.RESP_ID,
767: p_user_id => FND_GLOBAL.USER_ID,
768: p_resp_appl_id => 242,
769: p_msg_count => l_msg_count,
770: p_msg_data => l_msg_data,
771: p_return_status => l_return_status);
847: BEGIN
848:
849: PA_INTERFACE_UTILS_PUB.SET_GLOBAL_INFO(
850: p_api_version_number => 1,
851: p_responsibility_id => FND_GLOBAL.RESP_ID,
852: p_user_id => FND_GLOBAL.USER_ID,
853: p_resp_appl_id => 242,
854: p_msg_count => l_msg_count,
855: p_msg_data => l_msg_data,
848:
849: PA_INTERFACE_UTILS_PUB.SET_GLOBAL_INFO(
850: p_api_version_number => 1,
851: p_responsibility_id => FND_GLOBAL.RESP_ID,
852: p_user_id => FND_GLOBAL.USER_ID,
853: p_resp_appl_id => 242,
854: p_msg_count => l_msg_count,
855: p_msg_data => l_msg_data,
856: p_return_status => l_return_status);
1109: ap_rec.ATTRIBUTE2,
1110: ap_rec.ATTRIBUTE3,
1111: ap_rec. ATTRIBUTE4,
1112: SYSDATE,
1113: FND_GLOBAL.USER_ID,
1114: SYSDATE,
1115: FND_GLOBAL.USER_ID,
1116: FND_GLOBAL.LOGIN_ID,
1117: ap_rec.CLASSIFICATION
1111: ap_rec. ATTRIBUTE4,
1112: SYSDATE,
1113: FND_GLOBAL.USER_ID,
1114: SYSDATE,
1115: FND_GLOBAL.USER_ID,
1116: FND_GLOBAL.LOGIN_ID,
1117: ap_rec.CLASSIFICATION
1118: FROM dual;
1119:
1112: SYSDATE,
1113: FND_GLOBAL.USER_ID,
1114: SYSDATE,
1115: FND_GLOBAL.USER_ID,
1116: FND_GLOBAL.LOGIN_ID,
1117: ap_rec.CLASSIFICATION
1118: FROM dual;
1119:
1120: insert into AMW_AUDIT_PROCEDURES_TL (
1135: l_audit_procedure_rev_id,
1136: SYSDATE||B.NAME,
1137: B.DESCRIPTION,
1138: SYSDATE,
1139: FND_GLOBAL.USER_ID,
1140: SYSDATE,
1141: FND_GLOBAL.USER_ID,
1142: B.LAST_UPDATE_LOGIN,
1143: B.SECURITY_GROUP_ID,
1137: B.DESCRIPTION,
1138: SYSDATE,
1139: FND_GLOBAL.USER_ID,
1140: SYSDATE,
1141: FND_GLOBAL.USER_ID,
1142: B.LAST_UPDATE_LOGIN,
1143: B.SECURITY_GROUP_ID,
1144: B.LANGUAGE,
1145: B.SOURCE_LANG
1162: object_type,
1163: object_version_number)
1164: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1165: SYSDATE ,
1166: FND_GLOBAL.USER_ID,
1167: SYSDATE,
1168: FND_GLOBAL.USER_ID,
1169: SYSDATE,
1170: FND_GLOBAL.USER_ID ,
1164: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1165: SYSDATE ,
1166: FND_GLOBAL.USER_ID,
1167: SYSDATE,
1168: FND_GLOBAL.USER_ID,
1169: SYSDATE,
1170: FND_GLOBAL.USER_ID ,
1171: l_audit_procedure_id,
1172: l_audit_procedure_rev_id,
1166: FND_GLOBAL.USER_ID,
1167: SYSDATE,
1168: FND_GLOBAL.USER_ID,
1169: SYSDATE,
1170: FND_GLOBAL.USER_ID ,
1171: l_audit_procedure_id,
1172: l_audit_procedure_rev_id,
1173: p_dest_project_id,
1174: apa.pk2 ,
1252: object_type,
1253: object_version_number)
1254: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1255: SYSDATE ,
1256: FND_GLOBAL.USER_ID,
1257: SYSDATE,
1258: FND_GLOBAL.USER_ID,
1259: SYSDATE,
1260: FND_GLOBAL.USER_ID,
1254: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1255: SYSDATE ,
1256: FND_GLOBAL.USER_ID,
1257: SYSDATE,
1258: FND_GLOBAL.USER_ID,
1259: SYSDATE,
1260: FND_GLOBAL.USER_ID,
1261: apa.audit_procedure_id,
1262: apa.audit_procedure_rev_id,
1256: FND_GLOBAL.USER_ID,
1257: SYSDATE,
1258: FND_GLOBAL.USER_ID,
1259: SYSDATE,
1260: FND_GLOBAL.USER_ID,
1261: apa.audit_procedure_id,
1262: apa.audit_procedure_rev_id,
1263: p_dest_project_id,
1264: apa.pk2,
1497: ap_rec.ATTRIBUTE2,
1498: ap_rec.ATTRIBUTE3,
1499: ap_rec. ATTRIBUTE4,
1500: SYSDATE,
1501: FND_GLOBAL.USER_ID,
1502: SYSDATE,
1503: FND_GLOBAL.USER_ID,
1504: FND_GLOBAL.LOGIN_ID,
1505: ap_rec.CLASSIFICATION
1499: ap_rec. ATTRIBUTE4,
1500: SYSDATE,
1501: FND_GLOBAL.USER_ID,
1502: SYSDATE,
1503: FND_GLOBAL.USER_ID,
1504: FND_GLOBAL.LOGIN_ID,
1505: ap_rec.CLASSIFICATION
1506: FROM dual;
1507:
1500: SYSDATE,
1501: FND_GLOBAL.USER_ID,
1502: SYSDATE,
1503: FND_GLOBAL.USER_ID,
1504: FND_GLOBAL.LOGIN_ID,
1505: ap_rec.CLASSIFICATION
1506: FROM dual;
1507:
1508: insert into AMW_AUDIT_PROCEDURES_TL (
1523: l_audit_procedure_rev_id,
1524: SYSDATE||B.NAME,
1525: B.DESCRIPTION,
1526: SYSDATE,
1527: FND_GLOBAL.USER_ID,
1528: SYSDATE,
1529: FND_GLOBAL.USER_ID,
1530: B.LAST_UPDATE_LOGIN,
1531: B.SECURITY_GROUP_ID,
1525: B.DESCRIPTION,
1526: SYSDATE,
1527: FND_GLOBAL.USER_ID,
1528: SYSDATE,
1529: FND_GLOBAL.USER_ID,
1530: B.LAST_UPDATE_LOGIN,
1531: B.SECURITY_GROUP_ID,
1532: B.LANGUAGE,
1533: B.SOURCE_LANG
1550: object_type,
1551: object_version_number)
1552: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1553: SYSDATE ,
1554: FND_GLOBAL.USER_ID,
1555: SYSDATE,
1556: FND_GLOBAL.USER_ID,
1557: SYSDATE,
1558: FND_GLOBAL.USER_ID ,
1552: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1553: SYSDATE ,
1554: FND_GLOBAL.USER_ID,
1555: SYSDATE,
1556: FND_GLOBAL.USER_ID,
1557: SYSDATE,
1558: FND_GLOBAL.USER_ID ,
1559: l_audit_procedure_id,
1560: l_audit_procedure_rev_id,
1554: FND_GLOBAL.USER_ID,
1555: SYSDATE,
1556: FND_GLOBAL.USER_ID,
1557: SYSDATE,
1558: FND_GLOBAL.USER_ID ,
1559: l_audit_procedure_id,
1560: l_audit_procedure_rev_id,
1561: p_dest_project_id,
1562: apa.pk2 ,
1630: object_type,
1631: object_version_number)
1632: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1633: SYSDATE ,
1634: FND_GLOBAL.USER_ID,
1635: SYSDATE,
1636: FND_GLOBAL.USER_ID,
1637: SYSDATE,
1638: FND_GLOBAL.USER_ID,
1632: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1633: SYSDATE ,
1634: FND_GLOBAL.USER_ID,
1635: SYSDATE,
1636: FND_GLOBAL.USER_ID,
1637: SYSDATE,
1638: FND_GLOBAL.USER_ID,
1639: apa.audit_procedure_id,
1640: apa.audit_procedure_rev_id,
1634: FND_GLOBAL.USER_ID,
1635: SYSDATE,
1636: FND_GLOBAL.USER_ID,
1637: SYSDATE,
1638: FND_GLOBAL.USER_ID,
1639: apa.audit_procedure_id,
1640: apa.audit_procedure_rev_id,
1641: p_dest_project_id,
1642: apa.pk2,
1757:
1758: SELECT amw_execution_scope_s.nextval,
1759: 'PROJECT',
1760: p_target_entity_id,
1761: FND_GLOBAL.USER_ID,
1762: SYSDATE,
1763: SYSDATE,
1764: FND_GLOBAL.USER_ID,
1765: FND_GLOBAL.USER_ID,
1760: p_target_entity_id,
1761: FND_GLOBAL.USER_ID,
1762: SYSDATE,
1763: SYSDATE,
1764: FND_GLOBAL.USER_ID,
1765: FND_GLOBAL.USER_ID,
1766: 'C',
1767: LEVEL_ID,
1768: SUBSIDIARY_VS,
1761: FND_GLOBAL.USER_ID,
1762: SYSDATE,
1763: SYSDATE,
1764: FND_GLOBAL.USER_ID,
1765: FND_GLOBAL.USER_ID,
1766: 'C',
1767: LEVEL_ID,
1768: SUBSIDIARY_VS,
1769: SUBSIDIARY_CODE,
1807: PARENT_PROCESS_ID)
1808: SELECT amw_execution_scope_s.nextval,
1809: 'PROJECT',
1810: p_target_entity_id,
1811: FND_GLOBAL.USER_ID,
1812: SYSDATE,
1813: SYSDATE,
1814: FND_GLOBAL.USER_ID,
1815: FND_GLOBAL.USER_ID,
1810: p_target_entity_id,
1811: FND_GLOBAL.USER_ID,
1812: SYSDATE,
1813: SYSDATE,
1814: FND_GLOBAL.USER_ID,
1815: FND_GLOBAL.USER_ID,
1816: 'C',
1817: LEVEL_ID,
1818: SUBSIDIARY_VS,
1811: FND_GLOBAL.USER_ID,
1812: SYSDATE,
1813: SYSDATE,
1814: FND_GLOBAL.USER_ID,
1815: FND_GLOBAL.USER_ID,
1816: 'C',
1817: LEVEL_ID,
1818: SUBSIDIARY_VS,
1819: SUBSIDIARY_CODE,
1857: PARENT_PROCESS_ID)
1858: SELECT amw_execution_scope_s.nextval,
1859: 'PROJECT',
1860: p_target_entity_id,
1861: FND_GLOBAL.USER_ID,
1862: SYSDATE,
1863: SYSDATE,
1864: FND_GLOBAL.USER_ID,
1865: FND_GLOBAL.USER_ID,
1860: p_target_entity_id,
1861: FND_GLOBAL.USER_ID,
1862: SYSDATE,
1863: SYSDATE,
1864: FND_GLOBAL.USER_ID,
1865: FND_GLOBAL.USER_ID,
1866: 'C',
1867: LEVEL_ID,
1868: SUBSIDIARY_VS,
1861: FND_GLOBAL.USER_ID,
1862: SYSDATE,
1863: SYSDATE,
1864: FND_GLOBAL.USER_ID,
1865: FND_GLOBAL.USER_ID,
1866: 'C',
1867: LEVEL_ID,
1868: SUBSIDIARY_VS,
1869: SUBSIDIARY_CODE,