DBA Data[Home] [Help]

APPS.IGS_PS_LGCY_CONC_PKG dependencies on FND_GLOBAL

Line 456: l_n_request_id := fnd_global.conc_request_id;

452: retcode := 0;
453:
454: /* Setting concurrent program values */
455:
456: l_n_request_id := fnd_global.conc_request_id;
457: l_n_prog_appl_id := fnd_global.prog_appl_id;
458: l_n_prog_id := fnd_global.conc_program_id;
459: l_d_prog_upd_dt := SYSDATE;
460: IF l_n_request_id = -1 THEN

Line 457: l_n_prog_appl_id := fnd_global.prog_appl_id;

453:
454: /* Setting concurrent program values */
455:
456: l_n_request_id := fnd_global.conc_request_id;
457: l_n_prog_appl_id := fnd_global.prog_appl_id;
458: l_n_prog_id := fnd_global.conc_program_id;
459: l_d_prog_upd_dt := SYSDATE;
460: IF l_n_request_id = -1 THEN
461: l_n_request_id := NULL;

Line 458: l_n_prog_id := fnd_global.conc_program_id;

454: /* Setting concurrent program values */
455:
456: l_n_request_id := fnd_global.conc_request_id;
457: l_n_prog_appl_id := fnd_global.prog_appl_id;
458: l_n_prog_id := fnd_global.conc_program_id;
459: l_d_prog_upd_dt := SYSDATE;
460: IF l_n_request_id = -1 THEN
461: l_n_request_id := NULL;
462: l_n_prog_appl_id := NULL;

Line 1026: NVL(fnd_global.user_id,-1),

1022: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_VERSION','LEGACY_PS_REC_TABLES'),
1023: l_unit_ver_rec.interface_id,
1024: l_n_msg_num,
1025: l_c_msg_txt,
1026: NVL(fnd_global.user_id,-1),
1027: SYSDATE,
1028: NVL(fnd_global.user_id,-1),
1029: SYSDATE,
1030: NVL(fnd_global.login_id,-1),

Line 1028: NVL(fnd_global.user_id,-1),

1024: l_n_msg_num,
1025: l_c_msg_txt,
1026: NVL(fnd_global.user_id,-1),
1027: SYSDATE,
1028: NVL(fnd_global.user_id,-1),
1029: SYSDATE,
1030: NVL(fnd_global.login_id,-1),
1031: l_n_request_id,
1032: l_n_prog_appl_id,

Line 1030: NVL(fnd_global.login_id,-1),

1026: NVL(fnd_global.user_id,-1),
1027: SYSDATE,
1028: NVL(fnd_global.user_id,-1),
1029: SYSDATE,
1030: NVL(fnd_global.login_id,-1),
1031: l_n_request_id,
1032: l_n_prog_appl_id,
1033: l_n_prog_id,
1034: l_d_prog_upd_dt

Line 1127: NVL(fnd_global.user_id,-1),

1123: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_TEACH_RESP','LEGACY_PS_REC_TABLES'),
1124: v_tab_unit_tr(i).interface_id,
1125: l_n_msg_num,
1126: l_c_msg_txt,
1127: NVL(fnd_global.user_id,-1),
1128: SYSDATE,
1129: NVL(fnd_global.user_id,-1),
1130: SYSDATE,
1131: NVL(fnd_global.login_id,-1),

Line 1129: NVL(fnd_global.user_id,-1),

1125: l_n_msg_num,
1126: l_c_msg_txt,
1127: NVL(fnd_global.user_id,-1),
1128: SYSDATE,
1129: NVL(fnd_global.user_id,-1),
1130: SYSDATE,
1131: NVL(fnd_global.login_id,-1),
1132: l_n_request_id,
1133: l_n_prog_appl_id,

Line 1131: NVL(fnd_global.login_id,-1),

1127: NVL(fnd_global.user_id,-1),
1128: SYSDATE,
1129: NVL(fnd_global.user_id,-1),
1130: SYSDATE,
1131: NVL(fnd_global.login_id,-1),
1132: l_n_request_id,
1133: l_n_prog_appl_id,
1134: l_n_prog_id,
1135: l_d_prog_upd_dt

Line 1231: NVL(fnd_global.user_id,-1),

1227: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_DISCP','LEGACY_PS_REC_TABLES'),
1228: v_tab_unit_dscp(i).interface_id,
1229: l_n_msg_num,
1230: l_c_msg_txt,
1231: NVL(fnd_global.user_id,-1),
1232: SYSDATE,
1233: NVL(fnd_global.user_id,-1),
1234: SYSDATE,
1235: NVL(fnd_global.login_id,-1),

Line 1233: NVL(fnd_global.user_id,-1),

1229: l_n_msg_num,
1230: l_c_msg_txt,
1231: NVL(fnd_global.user_id,-1),
1232: SYSDATE,
1233: NVL(fnd_global.user_id,-1),
1234: SYSDATE,
1235: NVL(fnd_global.login_id,-1),
1236: l_n_request_id,
1237: l_n_prog_appl_id,

Line 1235: NVL(fnd_global.login_id,-1),

1231: NVL(fnd_global.user_id,-1),
1232: SYSDATE,
1233: NVL(fnd_global.user_id,-1),
1234: SYSDATE,
1235: NVL(fnd_global.login_id,-1),
1236: l_n_request_id,
1237: l_n_prog_appl_id,
1238: l_n_prog_id,
1239: l_d_prog_upd_dt

Line 1334: NVL(fnd_global.user_id,-1),

1330: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_GRD_SCH','LEGACY_PS_REC_TABLES'),
1331: v_tab_unit_gs(i).interface_id,
1332: l_n_msg_num,
1333: l_c_msg_txt,
1334: NVL(fnd_global.user_id,-1),
1335: SYSDATE,
1336: NVL(fnd_global.user_id,-1),
1337: SYSDATE,
1338: NVL(fnd_global.login_id,-1),

Line 1336: NVL(fnd_global.user_id,-1),

1332: l_n_msg_num,
1333: l_c_msg_txt,
1334: NVL(fnd_global.user_id,-1),
1335: SYSDATE,
1336: NVL(fnd_global.user_id,-1),
1337: SYSDATE,
1338: NVL(fnd_global.login_id,-1),
1339: l_n_request_id,
1340: l_n_prog_appl_id,

Line 1338: NVL(fnd_global.login_id,-1),

1334: NVL(fnd_global.user_id,-1),
1335: SYSDATE,
1336: NVL(fnd_global.user_id,-1),
1337: SYSDATE,
1338: NVL(fnd_global.login_id,-1),
1339: l_n_request_id,
1340: l_n_prog_appl_id,
1341: l_n_prog_id,
1342: l_d_prog_upd_dt

Line 1437: NVL(fnd_global.user_id,-1),

1433: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_SEC','LEGACY_PS_REC_TABLES'),
1434: v_tab_usec(i).interface_id,
1435: l_n_msg_num,
1436: l_c_msg_txt,
1437: NVL(fnd_global.user_id,-1),
1438: SYSDATE,
1439: NVL(fnd_global.user_id,-1),
1440: SYSDATE,
1441: NVL(fnd_global.login_id,-1),

Line 1439: NVL(fnd_global.user_id,-1),

1435: l_n_msg_num,
1436: l_c_msg_txt,
1437: NVL(fnd_global.user_id,-1),
1438: SYSDATE,
1439: NVL(fnd_global.user_id,-1),
1440: SYSDATE,
1441: NVL(fnd_global.login_id,-1),
1442: l_n_request_id,
1443: l_n_prog_appl_id,

Line 1441: NVL(fnd_global.login_id,-1),

1437: NVL(fnd_global.user_id,-1),
1438: SYSDATE,
1439: NVL(fnd_global.user_id,-1),
1440: SYSDATE,
1441: NVL(fnd_global.login_id,-1),
1442: l_n_request_id,
1443: l_n_prog_appl_id,
1444: l_n_prog_id,
1445: l_d_prog_upd_dt

Line 1542: NVL(fnd_global.user_id,-1),

1538: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_GRD_SCH','LEGACY_PS_REC_TABLES'),
1539: v_tab_usec_gs(i).interface_id,
1540: l_n_msg_num,
1541: l_c_msg_txt,
1542: NVL(fnd_global.user_id,-1),
1543: SYSDATE,
1544: NVL(fnd_global.user_id,-1),
1545: SYSDATE,
1546: NVL(fnd_global.login_id,-1),

Line 1544: NVL(fnd_global.user_id,-1),

1540: l_n_msg_num,
1541: l_c_msg_txt,
1542: NVL(fnd_global.user_id,-1),
1543: SYSDATE,
1544: NVL(fnd_global.user_id,-1),
1545: SYSDATE,
1546: NVL(fnd_global.login_id,-1),
1547: l_n_request_id,
1548: l_n_prog_appl_id,

Line 1546: NVL(fnd_global.login_id,-1),

1542: NVL(fnd_global.user_id,-1),
1543: SYSDATE,
1544: NVL(fnd_global.user_id,-1),
1545: SYSDATE,
1546: NVL(fnd_global.login_id,-1),
1547: l_n_request_id,
1548: l_n_prog_appl_id,
1549: l_n_prog_id,
1550: l_d_prog_upd_dt

Line 1645: NVL(fnd_global.user_id,-1),

1641: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_SEC_OCCUR','LEGACY_PS_REC_TABLES'),
1642: v_tab_uso(i).interface_id,
1643: l_n_msg_num,
1644: l_c_msg_txt,
1645: NVL(fnd_global.user_id,-1),
1646: SYSDATE,
1647: NVL(fnd_global.user_id,-1),
1648: SYSDATE,
1649: NVL(fnd_global.login_id,-1),

Line 1647: NVL(fnd_global.user_id,-1),

1643: l_n_msg_num,
1644: l_c_msg_txt,
1645: NVL(fnd_global.user_id,-1),
1646: SYSDATE,
1647: NVL(fnd_global.user_id,-1),
1648: SYSDATE,
1649: NVL(fnd_global.login_id,-1),
1650: l_n_request_id,
1651: l_n_prog_appl_id,

Line 1649: NVL(fnd_global.login_id,-1),

1645: NVL(fnd_global.user_id,-1),
1646: SYSDATE,
1647: NVL(fnd_global.user_id,-1),
1648: SYSDATE,
1649: NVL(fnd_global.login_id,-1),
1650: l_n_request_id,
1651: l_n_prog_appl_id,
1652: l_n_prog_id,
1653: l_d_prog_upd_dt

Line 1748: NVL(fnd_global.user_id,-1),

1744: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_REF','LEGACY_PS_REC_TABLES'),
1745: v_tab_unit_ref(i).interface_id,
1746: l_n_msg_num,
1747: l_c_msg_txt,
1748: NVL(fnd_global.user_id,-1),
1749: SYSDATE,
1750: NVL(fnd_global.user_id,-1),
1751: SYSDATE,
1752: NVL(fnd_global.login_id,-1),

Line 1750: NVL(fnd_global.user_id,-1),

1746: l_n_msg_num,
1747: l_c_msg_txt,
1748: NVL(fnd_global.user_id,-1),
1749: SYSDATE,
1750: NVL(fnd_global.user_id,-1),
1751: SYSDATE,
1752: NVL(fnd_global.login_id,-1),
1753: l_n_request_id,
1754: l_n_prog_appl_id,

Line 1752: NVL(fnd_global.login_id,-1),

1748: NVL(fnd_global.user_id,-1),
1749: SYSDATE,
1750: NVL(fnd_global.user_id,-1),
1751: SYSDATE,
1752: NVL(fnd_global.login_id,-1),
1753: l_n_request_id,
1754: l_n_prog_appl_id,
1755: l_n_prog_id,
1756: l_d_prog_upd_dt

Line 1877: NVL(fnd_global.user_id,-1),

1873: fnd_message.get,
1874: v_tab_ins(i).interface_id,
1875: l_n_msg_num,
1876: l_c_msg_txt,
1877: NVL(fnd_global.user_id,-1),
1878: SYSDATE,
1879: NVL(fnd_global.user_id,-1),
1880: SYSDATE,
1881: NVL(fnd_global.login_id,-1),

Line 1879: NVL(fnd_global.user_id,-1),

1875: l_n_msg_num,
1876: l_c_msg_txt,
1877: NVL(fnd_global.user_id,-1),
1878: SYSDATE,
1879: NVL(fnd_global.user_id,-1),
1880: SYSDATE,
1881: NVL(fnd_global.login_id,-1),
1882: l_n_request_id,
1883: l_n_prog_appl_id,

Line 1881: NVL(fnd_global.login_id,-1),

1877: NVL(fnd_global.user_id,-1),
1878: SYSDATE,
1879: NVL(fnd_global.user_id,-1),
1880: SYSDATE,
1881: NVL(fnd_global.login_id,-1),
1882: l_n_request_id,
1883: l_n_prog_appl_id,
1884: l_n_prog_id,
1885: l_d_prog_upd_dt);