eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_SCOPE_PVT dependencies on FND_GLOBAL

Line 17: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

13: -- End of Comments
14: -- ===============================================================
15: g_pkg_name CONSTANT VARCHAR2 (30) := 'AMW_SCOPE_PVT';
16: g_file_name CONSTANT VARCHAR2 (12) := 'amwvscpb.pls';
17: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
18: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
19:
20: PROCEDURE raise_scope_update_event(
21: p_entity_type IN VARCHAR2,

Line 18: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

14: -- ===============================================================
15: g_pkg_name CONSTANT VARCHAR2 (30) := 'AMW_SCOPE_PVT';
16: g_file_name CONSTANT VARCHAR2 (12) := 'amwvscpb.pls';
17: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
18: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
19:
20: PROCEDURE raise_scope_update_event(
21: p_entity_type IN VARCHAR2,
22: p_entity_id IN NUMBER,

Line 278: FND_GLOBAL.USER_ID,

274: LEVEL_ID)
275: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
276: p_entity_type,
277: p_entity_id,
278: FND_GLOBAL.USER_ID,
279: SYSDATE,
280: SYSDATE,
281: FND_GLOBAL.USER_ID,
282: FND_GLOBAL.USER_ID,

Line 281: FND_GLOBAL.USER_ID,

277: p_entity_id,
278: FND_GLOBAL.USER_ID,
279: SYSDATE,
280: SYSDATE,
281: FND_GLOBAL.USER_ID,
282: FND_GLOBAL.USER_ID,
283: 'ORGANIZATION',
284: p_org_new_tbl(each_rec).org_id,
285: 'SUBSIDIARY',

Line 282: FND_GLOBAL.USER_ID,

278: FND_GLOBAL.USER_ID,
279: SYSDATE,
280: SYSDATE,
281: FND_GLOBAL.USER_ID,
282: FND_GLOBAL.USER_ID,
283: 'ORGANIZATION',
284: p_org_new_tbl(each_rec).org_id,
285: 'SUBSIDIARY',
286: l_temp_sub_parent_id,

Line 322: FND_GLOBAL.USER_ID,

318: LEVEL_ID )
319: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
320: p_entity_type,
321: p_entity_id,
322: FND_GLOBAL.USER_ID,
323: SYSDATE,
324: SYSDATE,
325: FND_GLOBAL.USER_ID,
326: FND_GLOBAL.USER_ID,

Line 325: FND_GLOBAL.USER_ID,

321: p_entity_id,
322: FND_GLOBAL.USER_ID,
323: SYSDATE,
324: SYSDATE,
325: FND_GLOBAL.USER_ID,
326: FND_GLOBAL.USER_ID,
327: 'ORGANIZATION',
328: p_org_new_tbl(each_rec).org_id,
329: 'LINEOFBUSINESS',

Line 326: FND_GLOBAL.USER_ID,

322: FND_GLOBAL.USER_ID,
323: SYSDATE,
324: SYSDATE,
325: FND_GLOBAL.USER_ID,
326: FND_GLOBAL.USER_ID,
327: 'ORGANIZATION',
328: p_org_new_tbl(each_rec).org_id,
329: 'LINEOFBUSINESS',
330: l_temp_parent_id,

Line 354: FND_GLOBAL.USER_ID,

350: LEVEL_ID )
351: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
352: p_entity_type,
353: p_entity_id,
354: FND_GLOBAL.USER_ID,
355: SYSDATE,
356: SYSDATE,
357: FND_GLOBAL.USER_ID,
358: FND_GLOBAL.USER_ID,

Line 357: FND_GLOBAL.USER_ID,

353: p_entity_id,
354: FND_GLOBAL.USER_ID,
355: SYSDATE,
356: SYSDATE,
357: FND_GLOBAL.USER_ID,
358: FND_GLOBAL.USER_ID,
359: 'ORGANIZATION',
360: p_org_new_tbl(each_rec).org_id,
361: 'DUMMYLOB',

Line 358: FND_GLOBAL.USER_ID,

354: FND_GLOBAL.USER_ID,
355: SYSDATE,
356: SYSDATE,
357: FND_GLOBAL.USER_ID,
358: FND_GLOBAL.USER_ID,
359: 'ORGANIZATION',
360: p_org_new_tbl(each_rec).org_id,
361: 'DUMMYLOB',
362: -999,

Line 431: FND_GLOBAL.USER_ID,

427: LEVEL_ID )
428: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
429: p_entity_type,
430: p_entity_id,
431: FND_GLOBAL.USER_ID,
432: SYSDATE,
433: SYSDATE,
434: FND_GLOBAL.USER_ID,
435: FND_GLOBAL.USER_ID,

Line 434: FND_GLOBAL.USER_ID,

430: p_entity_id,
431: FND_GLOBAL.USER_ID,
432: SYSDATE,
433: SYSDATE,
434: FND_GLOBAL.USER_ID,
435: FND_GLOBAL.USER_ID,
436: 'SUBSIDIARY',
437: p_sub_new_tbl(each_sub).subsidiary_id,
438: 'SUBSIDIARY',

Line 435: FND_GLOBAL.USER_ID,

431: FND_GLOBAL.USER_ID,
432: SYSDATE,
433: SYSDATE,
434: FND_GLOBAL.USER_ID,
435: FND_GLOBAL.USER_ID,
436: 'SUBSIDIARY',
437: p_sub_new_tbl(each_sub).subsidiary_id,
438: 'SUBSIDIARY',
439: l_temp_sub_parent_id,

Line 462: FND_GLOBAL.USER_ID,

458: LEVEL_ID )
459: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
460: p_entity_type,
461: p_entity_id,
462: FND_GLOBAL.USER_ID,
463: SYSDATE,
464: SYSDATE,
465: FND_GLOBAL.USER_ID,
466: FND_GLOBAL.USER_ID,

Line 465: FND_GLOBAL.USER_ID,

461: p_entity_id,
462: FND_GLOBAL.USER_ID,
463: SYSDATE,
464: SYSDATE,
465: FND_GLOBAL.USER_ID,
466: FND_GLOBAL.USER_ID,
467: 'SUBSIDIARY',
468: p_sub_new_tbl(each_sub).subsidiary_id,
469: 'ROOTNODE',

Line 466: FND_GLOBAL.USER_ID,

462: FND_GLOBAL.USER_ID,
463: SYSDATE,
464: SYSDATE,
465: FND_GLOBAL.USER_ID,
466: FND_GLOBAL.USER_ID,
467: 'SUBSIDIARY',
468: p_sub_new_tbl(each_sub).subsidiary_id,
469: 'ROOTNODE',
470: -1,

Line 540: FND_GLOBAL.USER_ID,

536: LEVEL_ID )
537: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
538: p_entity_type,
539: p_entity_id,
540: FND_GLOBAL.USER_ID,
541: SYSDATE,
542: SYSDATE,
543: FND_GLOBAL.USER_ID,
544: FND_GLOBAL.USER_ID,

Line 543: FND_GLOBAL.USER_ID,

539: p_entity_id,
540: FND_GLOBAL.USER_ID,
541: SYSDATE,
542: SYSDATE,
543: FND_GLOBAL.USER_ID,
544: FND_GLOBAL.USER_ID,
545: 'LINEOFBUSINESS',
546: p_lob_new_tbl(each_lob).lob_id,
547: 'LINEOFBUSINESS',

Line 544: FND_GLOBAL.USER_ID,

540: FND_GLOBAL.USER_ID,
541: SYSDATE,
542: SYSDATE,
543: FND_GLOBAL.USER_ID,
544: FND_GLOBAL.USER_ID,
545: 'LINEOFBUSINESS',
546: p_lob_new_tbl(each_lob).lob_id,
547: 'LINEOFBUSINESS',
548: l_temp_lob_parent_id,

Line 571: FND_GLOBAL.USER_ID,

567: LEVEL_ID )
568: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
569: p_entity_type,
570: p_entity_id,
571: FND_GLOBAL.USER_ID,
572: SYSDATE,
573: SYSDATE,
574: FND_GLOBAL.USER_ID,
575: FND_GLOBAL.USER_ID,

Line 574: FND_GLOBAL.USER_ID,

570: p_entity_id,
571: FND_GLOBAL.USER_ID,
572: SYSDATE,
573: SYSDATE,
574: FND_GLOBAL.USER_ID,
575: FND_GLOBAL.USER_ID,
576: 'LINEOFBUSINESS',
577: p_lob_new_tbl(each_lob).lob_id,
578: 'ROOTNODE',

Line 575: FND_GLOBAL.USER_ID,

571: FND_GLOBAL.USER_ID,
572: SYSDATE,
573: SYSDATE,
574: FND_GLOBAL.USER_ID,
575: FND_GLOBAL.USER_ID,
576: 'LINEOFBUSINESS',
577: p_lob_new_tbl(each_lob).lob_id,
578: 'ROOTNODE',
579: -1,

Line 771: FND_GLOBAL.USER_ID,

767: LEVEL_ID )
768: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
769: p_entity_type,
770: p_entity_id,
771: FND_GLOBAL.USER_ID,
772: SYSDATE,
773: SYSDATE,
774: FND_GLOBAL.USER_ID,
775: FND_GLOBAL.USER_ID,

Line 774: FND_GLOBAL.USER_ID,

770: p_entity_id,
771: FND_GLOBAL.USER_ID,
772: SYSDATE,
773: SYSDATE,
774: FND_GLOBAL.USER_ID,
775: FND_GLOBAL.USER_ID,
776: 'ORG',
777: p_org_tbl(each_rec).org_id,
778: 'ORG',

Line 775: FND_GLOBAL.USER_ID,

771: FND_GLOBAL.USER_ID,
772: SYSDATE,
773: SYSDATE,
774: FND_GLOBAL.USER_ID,
775: FND_GLOBAL.USER_ID,
776: 'ORG',
777: p_org_tbl(each_rec).org_id,
778: 'ORG',
779: l_temp_parent_id,

Line 802: FND_GLOBAL.USER_ID,

798: LEVEL_ID )
799: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
800: p_entity_type,
801: p_entity_id,
802: FND_GLOBAL.USER_ID,
803: SYSDATE,
804: SYSDATE,
805: FND_GLOBAL.USER_ID,
806: FND_GLOBAL.USER_ID,

Line 805: FND_GLOBAL.USER_ID,

801: p_entity_id,
802: FND_GLOBAL.USER_ID,
803: SYSDATE,
804: SYSDATE,
805: FND_GLOBAL.USER_ID,
806: FND_GLOBAL.USER_ID,
807: 'ORG',
808: p_org_tbl(each_rec).org_id,
809: 'ROOTNODE',

Line 806: FND_GLOBAL.USER_ID,

802: FND_GLOBAL.USER_ID,
803: SYSDATE,
804: SYSDATE,
805: FND_GLOBAL.USER_ID,
806: FND_GLOBAL.USER_ID,
807: 'ORG',
808: p_org_tbl(each_rec).org_id,
809: 'ROOTNODE',
810: -1,

Line 1119: FND_GLOBAL.USER_ID,

1115: SCOPE_MODIFIED_DATE)
1116: SELECT amw_execution_scope_s.nextval,
1117: p_entity_type,
1118: p_entity_id,
1119: FND_GLOBAL.USER_ID,
1120: SYSDATE,
1121: SYSDATE,
1122: FND_GLOBAL.USER_ID,
1123: FND_GLOBAL.USER_ID,

Line 1122: FND_GLOBAL.USER_ID,

1118: p_entity_id,
1119: FND_GLOBAL.USER_ID,
1120: SYSDATE,
1121: SYSDATE,
1122: FND_GLOBAL.USER_ID,
1123: FND_GLOBAL.USER_ID,
1124: 'C',
1125: 1,
1126: audit_rec.subsidiary_valueset,

Line 1123: FND_GLOBAL.USER_ID,

1119: FND_GLOBAL.USER_ID,
1120: SYSDATE,
1121: SYSDATE,
1122: FND_GLOBAL.USER_ID,
1123: FND_GLOBAL.USER_ID,
1124: 'C',
1125: 1,
1126: audit_rec.subsidiary_valueset,
1127: audit_rec.company_code,

Line 1182: FND_GLOBAL.USER_ID,

1178: SCOPE_MODIFIED_DATE)
1179: SELECT amw_execution_scope_s.nextval,
1180: p_entity_type,
1181: p_entity_id,
1182: FND_GLOBAL.USER_ID,
1183: SYSDATE,
1184: SYSDATE,
1185: FND_GLOBAL.USER_ID,
1186: FND_GLOBAL.USER_ID,

Line 1185: FND_GLOBAL.USER_ID,

1181: p_entity_id,
1182: FND_GLOBAL.USER_ID,
1183: SYSDATE,
1184: SYSDATE,
1185: FND_GLOBAL.USER_ID,
1186: FND_GLOBAL.USER_ID,
1187: 'C',
1188: 2,
1189: audit_rec.subsidiary_valueset,

Line 1186: FND_GLOBAL.USER_ID,

1182: FND_GLOBAL.USER_ID,
1183: SYSDATE,
1184: SYSDATE,
1185: FND_GLOBAL.USER_ID,
1186: FND_GLOBAL.USER_ID,
1187: 'C',
1188: 2,
1189: audit_rec.subsidiary_valueset,
1190: audit_rec.company_code,

Line 1234: FND_GLOBAL.USER_ID,

1230: SCOPE_MODIFIED_DATE )
1231: SELECT amw_execution_scope_s.nextval,
1232: p_entity_type,
1233: p_entity_id,
1234: FND_GLOBAL.USER_ID,
1235: SYSDATE,
1236: SYSDATE,
1237: FND_GLOBAL.USER_ID,
1238: FND_GLOBAL.USER_ID,

Line 1237: FND_GLOBAL.USER_ID,

1233: p_entity_id,
1234: FND_GLOBAL.USER_ID,
1235: SYSDATE,
1236: SYSDATE,
1237: FND_GLOBAL.USER_ID,
1238: FND_GLOBAL.USER_ID,
1239: 'C',
1240: 3,
1241: audit_rec.subsidiary_valueset,

Line 1238: FND_GLOBAL.USER_ID,

1234: FND_GLOBAL.USER_ID,
1235: SYSDATE,
1236: SYSDATE,
1237: FND_GLOBAL.USER_ID,
1238: FND_GLOBAL.USER_ID,
1239: 'C',
1240: 3,
1241: audit_rec.subsidiary_valueset,
1242: audit_rec.company_code,

Line 1287: FND_GLOBAL.USER_ID,

1283: SCOPE_MODIFIED_DATE)
1284: SELECT amw_execution_scope_s.nextval,
1285: p_entity_type,
1286: p_entity_id,
1287: FND_GLOBAL.USER_ID,
1288: SYSDATE,
1289: SYSDATE,
1290: FND_GLOBAL.USER_ID,
1291: FND_GLOBAL.USER_ID,

Line 1290: FND_GLOBAL.USER_ID,

1286: p_entity_id,
1287: FND_GLOBAL.USER_ID,
1288: SYSDATE,
1289: SYSDATE,
1290: FND_GLOBAL.USER_ID,
1291: FND_GLOBAL.USER_ID,
1292: 'C',
1293: 2,
1294: audit_rec.subsidiary_valueset,

Line 1291: FND_GLOBAL.USER_ID,

1287: FND_GLOBAL.USER_ID,
1288: SYSDATE,
1289: SYSDATE,
1290: FND_GLOBAL.USER_ID,
1291: FND_GLOBAL.USER_ID,
1292: 'C',
1293: 2,
1294: audit_rec.subsidiary_valueset,
1295: audit_rec.company_code,

Line 1340: FND_GLOBAL.USER_ID,

1336: SCOPE_MODIFIED_DATE )
1337: SELECT amw_execution_scope_s.nextval,
1338: p_entity_type,
1339: p_entity_id,
1340: FND_GLOBAL.USER_ID,
1341: SYSDATE,
1342: SYSDATE,
1343: FND_GLOBAL.USER_ID,
1344: FND_GLOBAL.USER_ID,

Line 1343: FND_GLOBAL.USER_ID,

1339: p_entity_id,
1340: FND_GLOBAL.USER_ID,
1341: SYSDATE,
1342: SYSDATE,
1343: FND_GLOBAL.USER_ID,
1344: FND_GLOBAL.USER_ID,
1345: 'C',
1346: 3,
1347: audit_rec.subsidiary_valueset,

Line 1344: FND_GLOBAL.USER_ID,

1340: FND_GLOBAL.USER_ID,
1341: SYSDATE,
1342: SYSDATE,
1343: FND_GLOBAL.USER_ID,
1344: FND_GLOBAL.USER_ID,
1345: 'C',
1346: 3,
1347: audit_rec.subsidiary_valueset,
1348: audit_rec.company_code,

Line 1423: FND_GLOBAL.USER_ID,

1419: SCOPE_MODIFIED_DATE)
1420: SELECT amw_execution_scope_s.nextval,
1421: p_entity_type,
1422: p_entity_id,
1423: FND_GLOBAL.USER_ID,
1424: SYSDATE,
1425: SYSDATE,
1426: FND_GLOBAL.USER_ID,
1427: FND_GLOBAL.USER_ID,

Line 1426: FND_GLOBAL.USER_ID,

1422: p_entity_id,
1423: FND_GLOBAL.USER_ID,
1424: SYSDATE,
1425: SYSDATE,
1426: FND_GLOBAL.USER_ID,
1427: FND_GLOBAL.USER_ID,
1428: 'C',
1429: 4,
1430: l_subsidiary_valueset,

Line 1427: FND_GLOBAL.USER_ID,

1423: FND_GLOBAL.USER_ID,
1424: SYSDATE,
1425: SYSDATE,
1426: FND_GLOBAL.USER_ID,
1427: FND_GLOBAL.USER_ID,
1428: 'C',
1429: 4,
1430: l_subsidiary_valueset,
1431: l_company_code,

Line 1530: FND_GLOBAL.USER_ID,

1526: SCOPE_MODIFIED_DATE)
1527: SELECT amw_execution_scope_s.nextval,
1528: p_entity_type,
1529: p_entity_id,
1530: FND_GLOBAL.USER_ID,
1531: SYSDATE,
1532: SYSDATE,
1533: FND_GLOBAL.USER_ID,
1534: FND_GLOBAL.USER_ID,

Line 1533: FND_GLOBAL.USER_ID,

1529: p_entity_id,
1530: FND_GLOBAL.USER_ID,
1531: SYSDATE,
1532: SYSDATE,
1533: FND_GLOBAL.USER_ID,
1534: FND_GLOBAL.USER_ID,
1535: 'C',
1536: p_level_id,
1537: p_subsidiary_vs,

Line 1534: FND_GLOBAL.USER_ID,

1530: FND_GLOBAL.USER_ID,
1531: SYSDATE,
1532: SYSDATE,
1533: FND_GLOBAL.USER_ID,
1534: FND_GLOBAL.USER_ID,
1535: 'C',
1536: p_level_id,
1537: p_subsidiary_vs,
1538: p_subsidiary_code,

Line 1767: fnd_global.user_id,

1763: object_version_number
1764: )
1765: SELECT AMW_RISK_ASSOCIATIONS_S.nextval,
1766: sysdate,
1767: fnd_global.user_id,
1768: sysdate,
1769: fnd_global.user_id,
1770: fnd_global.user_id,
1771: risk.risk_id,

Line 1769: fnd_global.user_id,

1765: SELECT AMW_RISK_ASSOCIATIONS_S.nextval,
1766: sysdate,
1767: fnd_global.user_id,
1768: sysdate,
1769: fnd_global.user_id,
1770: fnd_global.user_id,
1771: risk.risk_id,
1772: risk.risk_rev_id,
1773: p_audit_project_id,

Line 1770: fnd_global.user_id,

1766: sysdate,
1767: fnd_global.user_id,
1768: sysdate,
1769: fnd_global.user_id,
1770: fnd_global.user_id,
1771: risk.risk_id,
1772: risk.risk_rev_id,
1773: p_audit_project_id,
1774: scope_rec.organization_id,

Line 1825: FND_GLOBAL.USER_ID,

1821: object_version_number
1822: )
1823: SELECT AMW_CONTROL_ASSOCIATIONS_S.nextval,
1824: SYSDATE,
1825: FND_GLOBAL.USER_ID,
1826: SYSDATE,
1827: FND_GLOBAL.USER_ID,
1828: FND_GLOBAL.USER_ID,
1829: control.control_id,

Line 1827: FND_GLOBAL.USER_ID,

1823: SELECT AMW_CONTROL_ASSOCIATIONS_S.nextval,
1824: SYSDATE,
1825: FND_GLOBAL.USER_ID,
1826: SYSDATE,
1827: FND_GLOBAL.USER_ID,
1828: FND_GLOBAL.USER_ID,
1829: control.control_id,
1830: control.control_rev_id,
1831: p_audit_project_id,

Line 1828: FND_GLOBAL.USER_ID,

1824: SYSDATE,
1825: FND_GLOBAL.USER_ID,
1826: SYSDATE,
1827: FND_GLOBAL.USER_ID,
1828: FND_GLOBAL.USER_ID,
1829: control.control_id,
1830: control.control_rev_id,
1831: p_audit_project_id,
1832: scope_rec.organization_id,

Line 1888: FND_GLOBAL.USER_ID,

1884: object_type,
1885: object_version_number)
1886: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1887: SYSDATE,
1888: FND_GLOBAL.USER_ID,
1889: SYSDATE,
1890: FND_GLOBAL.USER_ID,
1891: FND_GLOBAL.USER_ID,
1892: ttt.audit_procedure_id,

Line 1890: FND_GLOBAL.USER_ID,

1886: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1887: SYSDATE,
1888: FND_GLOBAL.USER_ID,
1889: SYSDATE,
1890: FND_GLOBAL.USER_ID,
1891: FND_GLOBAL.USER_ID,
1892: ttt.audit_procedure_id,
1893: ttt.audit_procedure_rev_id,
1894: p_audit_project_id,

Line 1891: FND_GLOBAL.USER_ID,

1887: SYSDATE,
1888: FND_GLOBAL.USER_ID,
1889: SYSDATE,
1890: FND_GLOBAL.USER_ID,
1891: FND_GLOBAL.USER_ID,
1892: ttt.audit_procedure_id,
1893: ttt.audit_procedure_rev_id,
1894: p_audit_project_id,
1895: ttt.organization_id,

Line 1961: FND_GLOBAL.USER_ID,

1957: object_type,
1958: object_version_number)
1959: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1960: SYSDATE,
1961: FND_GLOBAL.USER_ID,
1962: SYSDATE,
1963: FND_GLOBAL.USER_ID,
1964: FND_GLOBAL.USER_ID,
1965: ttt.audit_procedure_id,

Line 1963: FND_GLOBAL.USER_ID,

1959: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1960: SYSDATE,
1961: FND_GLOBAL.USER_ID,
1962: SYSDATE,
1963: FND_GLOBAL.USER_ID,
1964: FND_GLOBAL.USER_ID,
1965: ttt.audit_procedure_id,
1966: ttt.audit_procedure_rev_id,
1967: p_audit_project_id,

Line 1964: FND_GLOBAL.USER_ID,

1960: SYSDATE,
1961: FND_GLOBAL.USER_ID,
1962: SYSDATE,
1963: FND_GLOBAL.USER_ID,
1964: FND_GLOBAL.USER_ID,
1965: ttt.audit_procedure_id,
1966: ttt.audit_procedure_rev_id,
1967: p_audit_project_id,
1968: ttt.organization_id,

Line 2033: fnd_global.user_id,

2029: object_type,
2030: object_version_number)
2031: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2032: sysdate,
2033: fnd_global.user_id,
2034: sysdate,
2035: fnd_global.user_id,
2036: fnd_global.user_id,
2037: ttt.audit_procedure_id,

Line 2035: fnd_global.user_id,

2031: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2032: sysdate,
2033: fnd_global.user_id,
2034: sysdate,
2035: fnd_global.user_id,
2036: fnd_global.user_id,
2037: ttt.audit_procedure_id,
2038: ttt.audit_procedure_rev_id,
2039: p_audit_project_id,

Line 2036: fnd_global.user_id,

2032: sysdate,
2033: fnd_global.user_id,
2034: sysdate,
2035: fnd_global.user_id,
2036: fnd_global.user_id,
2037: ttt.audit_procedure_id,
2038: ttt.audit_procedure_rev_id,
2039: p_audit_project_id,
2040: ttt.organization_id,

Line 2108: fnd_global.user_id,

2104: object_version_number
2105: )
2106: SELECT AMW_RISK_ASSOCIATIONS_S.nextval,
2107: sysdate,
2108: fnd_global.user_id,
2109: sysdate,
2110: fnd_global.user_id,
2111: fnd_global.user_id,
2112: risk.risk_id,

Line 2110: fnd_global.user_id,

2106: SELECT AMW_RISK_ASSOCIATIONS_S.nextval,
2107: sysdate,
2108: fnd_global.user_id,
2109: sysdate,
2110: fnd_global.user_id,
2111: fnd_global.user_id,
2112: risk.risk_id,
2113: risk.risk_rev_id,
2114: p_audit_project_id,

Line 2111: fnd_global.user_id,

2107: sysdate,
2108: fnd_global.user_id,
2109: sysdate,
2110: fnd_global.user_id,
2111: fnd_global.user_id,
2112: risk.risk_id,
2113: risk.risk_rev_id,
2114: p_audit_project_id,
2115: scope_org_rec.organization_id,

Line 2165: FND_GLOBAL.USER_ID,

2161: object_version_number
2162: )
2163: SELECT AMW_CONTROL_ASSOCIATIONS_S.nextval,
2164: SYSDATE,
2165: FND_GLOBAL.USER_ID,
2166: SYSDATE,
2167: FND_GLOBAL.USER_ID,
2168: FND_GLOBAL.USER_ID,
2169: control.control_id,

Line 2167: FND_GLOBAL.USER_ID,

2163: SELECT AMW_CONTROL_ASSOCIATIONS_S.nextval,
2164: SYSDATE,
2165: FND_GLOBAL.USER_ID,
2166: SYSDATE,
2167: FND_GLOBAL.USER_ID,
2168: FND_GLOBAL.USER_ID,
2169: control.control_id,
2170: control.control_rev_id,
2171: p_audit_project_id,

Line 2168: FND_GLOBAL.USER_ID,

2164: SYSDATE,
2165: FND_GLOBAL.USER_ID,
2166: SYSDATE,
2167: FND_GLOBAL.USER_ID,
2168: FND_GLOBAL.USER_ID,
2169: control.control_id,
2170: control.control_rev_id,
2171: p_audit_project_id,
2172: scope_org_rec.organization_id,

Line 2218: FND_GLOBAL.USER_ID,

2214: object_version_number
2215: )
2216: SELECT AMW_CONTROL_ASSOCIATIONS_S.nextval,
2217: SYSDATE,
2218: FND_GLOBAL.USER_ID,
2219: SYSDATE,
2220: FND_GLOBAL.USER_ID,
2221: FND_GLOBAL.USER_ID,
2222: control.control_id,

Line 2220: FND_GLOBAL.USER_ID,

2216: SELECT AMW_CONTROL_ASSOCIATIONS_S.nextval,
2217: SYSDATE,
2218: FND_GLOBAL.USER_ID,
2219: SYSDATE,
2220: FND_GLOBAL.USER_ID,
2221: FND_GLOBAL.USER_ID,
2222: control.control_id,
2223: control.control_rev_id,
2224: p_audit_project_id,

Line 2221: FND_GLOBAL.USER_ID,

2217: SYSDATE,
2218: FND_GLOBAL.USER_ID,
2219: SYSDATE,
2220: FND_GLOBAL.USER_ID,
2221: FND_GLOBAL.USER_ID,
2222: control.control_id,
2223: control.control_rev_id,
2224: p_audit_project_id,
2225: scope_org_rec.organization_id,

Line 2285: FND_GLOBAL.USER_ID,

2281: object_type,
2282: object_version_number)
2283: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2284: SYSDATE,
2285: FND_GLOBAL.USER_ID,
2286: SYSDATE,
2287: FND_GLOBAL.USER_ID,
2288: FND_GLOBAL.USER_ID,
2289: ttt.audit_procedure_id,

Line 2287: FND_GLOBAL.USER_ID,

2283: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2284: SYSDATE,
2285: FND_GLOBAL.USER_ID,
2286: SYSDATE,
2287: FND_GLOBAL.USER_ID,
2288: FND_GLOBAL.USER_ID,
2289: ttt.audit_procedure_id,
2290: ttt.audit_procedure_rev_id,
2291: p_audit_project_id,

Line 2288: FND_GLOBAL.USER_ID,

2284: SYSDATE,
2285: FND_GLOBAL.USER_ID,
2286: SYSDATE,
2287: FND_GLOBAL.USER_ID,
2288: FND_GLOBAL.USER_ID,
2289: ttt.audit_procedure_id,
2290: ttt.audit_procedure_rev_id,
2291: p_audit_project_id,
2292: ttt.organization_id,

Line 2356: FND_GLOBAL.USER_ID,

2352: object_type,
2353: object_version_number)
2354: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2355: SYSDATE,
2356: FND_GLOBAL.USER_ID,
2357: SYSDATE,
2358: FND_GLOBAL.USER_ID,
2359: FND_GLOBAL.USER_ID,
2360: ttt.audit_procedure_id,

Line 2358: FND_GLOBAL.USER_ID,

2354: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2355: SYSDATE,
2356: FND_GLOBAL.USER_ID,
2357: SYSDATE,
2358: FND_GLOBAL.USER_ID,
2359: FND_GLOBAL.USER_ID,
2360: ttt.audit_procedure_id,
2361: ttt.audit_procedure_rev_id,
2362: p_audit_project_id,

Line 2359: FND_GLOBAL.USER_ID,

2355: SYSDATE,
2356: FND_GLOBAL.USER_ID,
2357: SYSDATE,
2358: FND_GLOBAL.USER_ID,
2359: FND_GLOBAL.USER_ID,
2360: ttt.audit_procedure_id,
2361: ttt.audit_procedure_rev_id,
2362: p_audit_project_id,
2363: ttt.organization_id,

Line 2426: fnd_global.user_id,

2422: object_type,
2423: object_version_number)
2424: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2425: sysdate,
2426: fnd_global.user_id,
2427: sysdate,
2428: fnd_global.user_id,
2429: fnd_global.user_id,
2430: ttt.audit_procedure_id,

Line 2428: fnd_global.user_id,

2424: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2425: sysdate,
2426: fnd_global.user_id,
2427: sysdate,
2428: fnd_global.user_id,
2429: fnd_global.user_id,
2430: ttt.audit_procedure_id,
2431: ttt.audit_procedure_rev_id,
2432: p_audit_project_id,

Line 2429: fnd_global.user_id,

2425: sysdate,
2426: fnd_global.user_id,
2427: sysdate,
2428: fnd_global.user_id,
2429: fnd_global.user_id,
2430: ttt.audit_procedure_id,
2431: ttt.audit_procedure_rev_id,
2432: p_audit_project_id,
2433: ttt.organization_id,

Line 2556: fnd_global.user_id,

2552: entity_id,
2553: process_id,
2554: organization_id,
2555: process_org_rev_id,
2556: fnd_global.user_id,
2557: SYSDATE,
2558: fnd_global.user_id,
2559: SYSDATE,
2560: fnd_global.user_id

Line 2558: fnd_global.user_id,

2554: organization_id,
2555: process_org_rev_id,
2556: fnd_global.user_id,
2557: SYSDATE,
2558: fnd_global.user_id,
2559: SYSDATE,
2560: fnd_global.user_id
2561: FROM amw_execution_scope exec
2562: WHERE NOT EXISTS (SELECT 'Y'

Line 2560: fnd_global.user_id

2556: fnd_global.user_id,
2557: SYSDATE,
2558: fnd_global.user_id,
2559: SYSDATE,
2560: fnd_global.user_id
2561: FROM amw_execution_scope exec
2562: WHERE NOT EXISTS (SELECT 'Y'
2563: FROM amw_proc_cert_eval_sum pcert
2564: WHERE pcert.certification_id = exec.entity_id

Line 2584: fnd_global.user_id,

2580: last_update_date,
2581: last_update_login)
2582: SELECT entity_id,
2583: organization_id,
2584: fnd_global.user_id,
2585: SYSDATE,
2586: fnd_global.user_id,
2587: SYSDATE,
2588: fnd_global.user_id

Line 2586: fnd_global.user_id,

2582: SELECT entity_id,
2583: organization_id,
2584: fnd_global.user_id,
2585: SYSDATE,
2586: fnd_global.user_id,
2587: SYSDATE,
2588: fnd_global.user_id
2589: FROM amw_execution_scope exec
2590: WHERE NOT EXISTS (SELECT 'Y'

Line 2588: fnd_global.user_id

2584: fnd_global.user_id,
2585: SYSDATE,
2586: fnd_global.user_id,
2587: SYSDATE,
2588: fnd_global.user_id
2589: FROM amw_execution_scope exec
2590: WHERE NOT EXISTS (SELECT 'Y'
2591: FROM amw_org_cert_eval_sum ocert
2592: WHERE ocert.certification_id = exec.entity_id

Line 2768: fnd_global.user_id,

2764: object_type,
2765: object_version_number)
2766: SELECT AMW_RISK_ASSOCIATIONS_S.nextval,
2767: sysdate,
2768: fnd_global.user_id,
2769: sysdate,
2770: fnd_global.user_id,
2771: fnd_global.user_id,
2772: risk.risk_id,

Line 2770: fnd_global.user_id,

2766: SELECT AMW_RISK_ASSOCIATIONS_S.nextval,
2767: sysdate,
2768: fnd_global.user_id,
2769: sysdate,
2770: fnd_global.user_id,
2771: fnd_global.user_id,
2772: risk.risk_id,
2773: risk.risk_rev_id,
2774: p_entity_id,

Line 2771: fnd_global.user_id,

2767: sysdate,
2768: fnd_global.user_id,
2769: sysdate,
2770: fnd_global.user_id,
2771: fnd_global.user_id,
2772: risk.risk_id,
2773: risk.risk_rev_id,
2774: p_entity_id,
2775: ara.pk1,

Line 2825: fnd_global.user_id,

2821: object_type,
2822: object_version_number)
2823: SELECT AMW_CONTROL_ASSOCIATIONS_S.nextval,
2824: sysdate,
2825: fnd_global.user_id,
2826: sysdate,
2827: fnd_global.user_id,
2828: fnd_global.user_id,
2829: control.control_id,

Line 2827: fnd_global.user_id,

2823: SELECT AMW_CONTROL_ASSOCIATIONS_S.nextval,
2824: sysdate,
2825: fnd_global.user_id,
2826: sysdate,
2827: fnd_global.user_id,
2828: fnd_global.user_id,
2829: control.control_id,
2830: control.control_rev_id,
2831: p_entity_id,

Line 2828: fnd_global.user_id,

2824: sysdate,
2825: fnd_global.user_id,
2826: sysdate,
2827: fnd_global.user_id,
2828: fnd_global.user_id,
2829: control.control_id,
2830: control.control_rev_id,
2831: p_entity_id,
2832: each_rec.organization_id,

Line 2885: fnd_global.user_id,

2881: object_type,
2882: object_version_number)
2883: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2884: sysdate,
2885: fnd_global.user_id,
2886: sysdate,
2887: fnd_global.user_id,
2888: fnd_global.user_id,
2889: auditproc.audit_procedure_id,

Line 2887: fnd_global.user_id,

2883: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2884: sysdate,
2885: fnd_global.user_id,
2886: sysdate,
2887: fnd_global.user_id,
2888: fnd_global.user_id,
2889: auditproc.audit_procedure_id,
2890: auditproc.audit_procedure_rev_id,
2891: p_entity_id,

Line 2888: fnd_global.user_id,

2884: sysdate,
2885: fnd_global.user_id,
2886: sysdate,
2887: fnd_global.user_id,
2888: fnd_global.user_id,
2889: auditproc.audit_procedure_id,
2890: auditproc.audit_procedure_rev_id,
2891: p_entity_id,
2892: auditproc.organization_id,

Line 2956: fnd_global.user_id,

2952: object_version_number
2953: )
2954: SELECT AMW_RISK_ASSOCIATIONS_S.nextval,
2955: sysdate,
2956: fnd_global.user_id,
2957: sysdate,
2958: fnd_global.user_id,
2959: fnd_global.user_id,
2960: risk.risk_id,

Line 2958: fnd_global.user_id,

2954: SELECT AMW_RISK_ASSOCIATIONS_S.nextval,
2955: sysdate,
2956: fnd_global.user_id,
2957: sysdate,
2958: fnd_global.user_id,
2959: fnd_global.user_id,
2960: risk.risk_id,
2961: risk.risk_rev_id,
2962: p_entity_id,

Line 2959: fnd_global.user_id,

2955: sysdate,
2956: fnd_global.user_id,
2957: sysdate,
2958: fnd_global.user_id,
2959: fnd_global.user_id,
2960: risk.risk_id,
2961: risk.risk_rev_id,
2962: p_entity_id,
2963: scope_org_rec.organization_id,

Line 3013: FND_GLOBAL.USER_ID,

3009: object_version_number
3010: )
3011: SELECT AMW_CONTROL_ASSOCIATIONS_S.nextval,
3012: SYSDATE,
3013: FND_GLOBAL.USER_ID,
3014: SYSDATE,
3015: FND_GLOBAL.USER_ID,
3016: FND_GLOBAL.USER_ID,
3017: control.control_id,

Line 3015: FND_GLOBAL.USER_ID,

3011: SELECT AMW_CONTROL_ASSOCIATIONS_S.nextval,
3012: SYSDATE,
3013: FND_GLOBAL.USER_ID,
3014: SYSDATE,
3015: FND_GLOBAL.USER_ID,
3016: FND_GLOBAL.USER_ID,
3017: control.control_id,
3018: control.control_rev_id,
3019: p_entity_id,

Line 3016: FND_GLOBAL.USER_ID,

3012: SYSDATE,
3013: FND_GLOBAL.USER_ID,
3014: SYSDATE,
3015: FND_GLOBAL.USER_ID,
3016: FND_GLOBAL.USER_ID,
3017: control.control_id,
3018: control.control_rev_id,
3019: p_entity_id,
3020: scope_org_rec.organization_id,

Line 3075: fnd_global.user_id,

3071: object_type,
3072: object_version_number)
3073: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
3074: sysdate,
3075: fnd_global.user_id,
3076: sysdate,
3077: fnd_global.user_id,
3078: fnd_global.user_id,
3079: auditproc.audit_procedure_id,

Line 3077: fnd_global.user_id,

3073: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
3074: sysdate,
3075: fnd_global.user_id,
3076: sysdate,
3077: fnd_global.user_id,
3078: fnd_global.user_id,
3079: auditproc.audit_procedure_id,
3080: auditproc.audit_procedure_rev_id,
3081: p_entity_id,

Line 3078: fnd_global.user_id,

3074: sysdate,
3075: fnd_global.user_id,
3076: sysdate,
3077: fnd_global.user_id,
3078: fnd_global.user_id,
3079: auditproc.audit_procedure_id,
3080: auditproc.audit_procedure_rev_id,
3081: p_entity_id,
3082: auditproc.organization_id,

Line 3364: FND_GLOBAL.USER_ID,

3360: SCOPE_MODIFIED_DATE)
3361: SELECT amw_execution_scope_s.nextval,
3362: p_entity_type,
3363: p_entity_id,
3364: FND_GLOBAL.USER_ID,
3365: SYSDATE,
3366: SYSDATE,
3367: FND_GLOBAL.USER_ID,
3368: FND_GLOBAL.USER_ID,

Line 3367: FND_GLOBAL.USER_ID,

3363: p_entity_id,
3364: FND_GLOBAL.USER_ID,
3365: SYSDATE,
3366: SYSDATE,
3367: FND_GLOBAL.USER_ID,
3368: FND_GLOBAL.USER_ID,
3369: 'C',
3370: p_proc_hier_tbl(i).level_id,
3371: l_subsidiary_vs,

Line 3368: FND_GLOBAL.USER_ID,

3364: FND_GLOBAL.USER_ID,
3365: SYSDATE,
3366: SYSDATE,
3367: FND_GLOBAL.USER_ID,
3368: FND_GLOBAL.USER_ID,
3369: 'C',
3370: p_proc_hier_tbl(i).level_id,
3371: l_subsidiary_vs,
3372: l_sub_code,

Line 4031: because in R12, only FND_GLOBAL.user_name is allowed.

4027: l_user_name VARCHAR2(200);
4028: l_hasAccess VARCHAR2(15);
4029: BEGIN
4030: /*04.11.2006 npanandi: bug 5142733 fix -- commenting below if-else
4031: because in R12, only FND_GLOBAL.user_name is allowed.
4032: the rest are deprecated
4033: */
4034: /*IF FND_GLOBAL.party_id IS NOT NULL THEN
4035: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;

Line 4034: /*IF FND_GLOBAL.party_id IS NOT NULL THEN

4030: /*04.11.2006 npanandi: bug 5142733 fix -- commenting below if-else
4031: because in R12, only FND_GLOBAL.user_name is allowed.
4032: the rest are deprecated
4033: */
4034: /*IF FND_GLOBAL.party_id IS NOT NULL THEN
4035: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;
4036: ELSE
4037: */
4038: l_user_name := FND_GLOBAL.user_name;

Line 4035: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;

4031: because in R12, only FND_GLOBAL.user_name is allowed.
4032: the rest are deprecated
4033: */
4034: /*IF FND_GLOBAL.party_id IS NOT NULL THEN
4035: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;
4036: ELSE
4037: */
4038: l_user_name := FND_GLOBAL.user_name;
4039: /*END IF;

Line 4038: l_user_name := FND_GLOBAL.user_name;

4034: /*IF FND_GLOBAL.party_id IS NOT NULL THEN
4035: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;
4036: ELSE
4037: */
4038: l_user_name := FND_GLOBAL.user_name;
4039: /*END IF;
4040: */
4041:
4042: FOR org_rec IN c_root_orgs LOOP

Line 4078: because in R12, only FND_GLOBAL.user_name is allowed.

4074: -- OR fnd_profile.value('AMW_DATA_SECURITY_SWITCH') <> 'Y' THEN
4075: return 'Y';
4076: ELSE
4077: /*04.11.2006 npanandi: bug 5142733 fix -- commenting below if-else
4078: because in R12, only FND_GLOBAL.user_name is allowed.
4079: the rest are deprecated
4080: */
4081: /*IF FND_GLOBAL.party_id IS NOT NULL THEN
4082: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;

Line 4081: /*IF FND_GLOBAL.party_id IS NOT NULL THEN

4077: /*04.11.2006 npanandi: bug 5142733 fix -- commenting below if-else
4078: because in R12, only FND_GLOBAL.user_name is allowed.
4079: the rest are deprecated
4080: */
4081: /*IF FND_GLOBAL.party_id IS NOT NULL THEN
4082: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;
4083: ELSE*/
4084: l_user_name := FND_GLOBAL.user_name;
4085: /*END IF;

Line 4082: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;

4078: because in R12, only FND_GLOBAL.user_name is allowed.
4079: the rest are deprecated
4080: */
4081: /*IF FND_GLOBAL.party_id IS NOT NULL THEN
4082: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;
4083: ELSE*/
4084: l_user_name := FND_GLOBAL.user_name;
4085: /*END IF;
4086: */

Line 4084: l_user_name := FND_GLOBAL.user_name;

4080: */
4081: /*IF FND_GLOBAL.party_id IS NOT NULL THEN
4082: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;
4083: ELSE*/
4084: l_user_name := FND_GLOBAL.user_name;
4085: /*END IF;
4086: */
4087: l_hasAccess :=FND_DATA_SECURITY.check_function(
4088: p_api_version => 1.0,

Line 4158: because in R12, only FND_GLOBAL.user_name is allowed.

4154: l_user_name VARCHAR2(200);
4155: l_hasAccess VARCHAR2(15);
4156: BEGIN
4157: /*04.11.2006 npanandi: bug 5142733 fix -- commenting below if-else
4158: because in R12, only FND_GLOBAL.user_name is allowed.
4159: the rest are deprecated
4160: */
4161: /* IF FND_GLOBAL.party_id IS NOT NULL THEN
4162: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;

Line 4161: /* IF FND_GLOBAL.party_id IS NOT NULL THEN

4157: /*04.11.2006 npanandi: bug 5142733 fix -- commenting below if-else
4158: because in R12, only FND_GLOBAL.user_name is allowed.
4159: the rest are deprecated
4160: */
4161: /* IF FND_GLOBAL.party_id IS NOT NULL THEN
4162: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;
4163: ELSE
4164: */
4165: l_user_name := FND_GLOBAL.user_name;

Line 4162: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;

4158: because in R12, only FND_GLOBAL.user_name is allowed.
4159: the rest are deprecated
4160: */
4161: /* IF FND_GLOBAL.party_id IS NOT NULL THEN
4162: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;
4163: ELSE
4164: */
4165: l_user_name := FND_GLOBAL.user_name;
4166: /*END IF;*/

Line 4165: l_user_name := FND_GLOBAL.user_name;

4161: /* IF FND_GLOBAL.party_id IS NOT NULL THEN
4162: l_user_name := 'HZ_PARTY:'||FND_GLOBAL.party_id;
4163: ELSE
4164: */
4165: l_user_name := FND_GLOBAL.user_name;
4166: /*END IF;*/
4167:
4168: FOR proc_rec IN c_root_procs LOOP
4169: l_hasAccess :=FND_DATA_SECURITY.check_function(