DBA Data[Home] [Help]

APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on FND_GLOBAL

Line 91: FND_GLOBAL.USER_ID,

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,

Line 94: 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,

Line 95: FND_GLOBAL.USER_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,
99: SUBSIDIARY_CODE,

Line 131: FND_GLOBAL.USER_ID,

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,

Line 134: 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,

Line 135: FND_GLOBAL.USER_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,
139: PARENT_OBJECT_ID,

Line 175: FND_GLOBAL.USER_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

Line 177: FND_GLOBAL.USER_ID,

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;

Line 178: FND_GLOBAL.USER_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:

Line 204: FND_GLOBAL.USER_ID,

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

Line 206: FND_GLOBAL.USER_ID,

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,

Line 207: FND_GLOBAL.USER_ID,

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

Line 344: FND_GLOBAL.USER_ID,

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,

Line 347: 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'

Line 348: FND_GLOBAL.USER_ID,

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

Line 443: p_responsibility_id => FND_GLOBAL.RESP_ID,

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,

Line 444: p_user_id => FND_GLOBAL.USER_ID,

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);

Line 563: p_responsibility_id => FND_GLOBAL.RESP_ID,

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,

Line 564: p_user_id => FND_GLOBAL.USER_ID,

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);

Line 676: p_responsibility_id => FND_GLOBAL.RESP_ID,

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,

Line 677: p_user_id => FND_GLOBAL.USER_ID,

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);

Line 766: p_responsibility_id => FND_GLOBAL.RESP_ID,

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,

Line 767: p_user_id => FND_GLOBAL.USER_ID,

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);

Line 851: p_responsibility_id => FND_GLOBAL.RESP_ID,

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,

Line 852: p_user_id => FND_GLOBAL.USER_ID,

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);

Line 1113: FND_GLOBAL.USER_ID,

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

Line 1115: FND_GLOBAL.USER_ID,

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:

Line 1116: FND_GLOBAL.LOGIN_ID,

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 (

Line 1139: FND_GLOBAL.USER_ID,

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,

Line 1141: FND_GLOBAL.USER_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

Line 1166: FND_GLOBAL.USER_ID,

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 ,

Line 1168: 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,

Line 1170: FND_GLOBAL.USER_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 ,

Line 1256: FND_GLOBAL.USER_ID,

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,

Line 1258: 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,

Line 1260: FND_GLOBAL.USER_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,

Line 1501: FND_GLOBAL.USER_ID,

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

Line 1503: FND_GLOBAL.USER_ID,

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:

Line 1504: FND_GLOBAL.LOGIN_ID,

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 (

Line 1527: FND_GLOBAL.USER_ID,

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,

Line 1529: FND_GLOBAL.USER_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

Line 1554: FND_GLOBAL.USER_ID,

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 ,

Line 1556: 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,

Line 1558: FND_GLOBAL.USER_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 ,

Line 1634: FND_GLOBAL.USER_ID,

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,

Line 1636: 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,

Line 1638: FND_GLOBAL.USER_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,

Line 1761: FND_GLOBAL.USER_ID,

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,

Line 1764: 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,

Line 1765: FND_GLOBAL.USER_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,
1769: SUBSIDIARY_CODE,

Line 1811: FND_GLOBAL.USER_ID,

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,

Line 1814: 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,

Line 1815: FND_GLOBAL.USER_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,
1819: SUBSIDIARY_CODE,

Line 1861: FND_GLOBAL.USER_ID,

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,

Line 1864: 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,

Line 1865: FND_GLOBAL.USER_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,
1869: SUBSIDIARY_CODE,