DBA Data[Home] [Help]

APPS.IGS_EN_GEN_LEGACY dependencies on FND_GLOBAL

Line 1273: last_updated_by = NVL(fnd_global.user_id,-1) ,

1269: UPDATE igs_pe_typ_instances_all
1270: SET end_date = l_sysdate ,
1271: end_method = l_method ,
1272: last_update_date = SYSDATE,
1273: last_updated_by = NVL(fnd_global.user_id,-1) ,
1274: last_update_login = NVL(fnd_global.login_id,-1)
1275: WHERE type_instance_id = rec_per_inst.type_instance_id;
1276:
1277: IF l_user_id IS NOT NULL THEN

Line 1274: last_update_login = NVL(fnd_global.login_id,-1)

1270: SET end_date = l_sysdate ,
1271: end_method = l_method ,
1272: last_update_date = SYSDATE,
1273: last_updated_by = NVL(fnd_global.user_id,-1) ,
1274: last_update_login = NVL(fnd_global.login_id,-1)
1275: WHERE type_instance_id = rec_per_inst.type_instance_id;
1276:
1277: IF l_user_id IS NOT NULL THEN
1278: raise_person_type_event(

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

1343: NULL,
1344: l_method,
1345: NULL,
1346: NULL,
1347: NVL(fnd_global.user_id,-1),
1348: SYSDATE,
1349: NVL(fnd_global.user_id,-1),
1350: SYSDATE,
1351: NVL(fnd_global.login_id,-1),

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

1345: NULL,
1346: NULL,
1347: NVL(fnd_global.user_id,-1),
1348: SYSDATE,
1349: NVL(fnd_global.user_id,-1),
1350: SYSDATE,
1351: NVL(fnd_global.login_id,-1),
1352: igs_ge_gen_003.get_org_id);
1353:

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

1347: NVL(fnd_global.user_id,-1),
1348: SYSDATE,
1349: NVL(fnd_global.user_id,-1),
1350: SYSDATE,
1351: NVL(fnd_global.login_id,-1),
1352: igs_ge_gen_003.get_org_id);
1353:
1354: IF l_user_id IS NOT NULL THEN
1355: raise_person_type_event(

Line 1378: last_updated_by = NVL(fnd_global.user_id,-1) ,

1374: UPDATE igs_pe_typ_instances_all
1375: SET end_date = l_sysdate,
1376: end_method = l_method,
1377: last_update_date = SYSDATE ,
1378: last_updated_by = NVL(fnd_global.user_id,-1) ,
1379: last_update_login = NVL(fnd_global.login_id,-1)
1380: WHERE type_instance_id = rec_per_inst.type_instance_id;
1381:
1382: IF l_user_id IS NOT NULL THEN

Line 1379: last_update_login = NVL(fnd_global.login_id,-1)

1375: SET end_date = l_sysdate,
1376: end_method = l_method,
1377: last_update_date = SYSDATE ,
1378: last_updated_by = NVL(fnd_global.user_id,-1) ,
1379: last_update_login = NVL(fnd_global.login_id,-1)
1380: WHERE type_instance_id = rec_per_inst.type_instance_id;
1381:
1382: IF l_user_id IS NOT NULL THEN
1383: raise_person_type_event(

Line 1405: last_updated_by = NVL(fnd_global.user_id,-1) ,

1401: UPDATE igs_pe_typ_instances_all
1402: SET end_date = l_sysdate,
1403: end_method = l_method ,
1404: last_update_date = SYSDATE ,
1405: last_updated_by = NVL(fnd_global.user_id,-1) ,
1406: last_update_login = NVL(fnd_global.login_id,-1)
1407: WHERE type_instance_id = rec_per_inst.type_instance_id;
1408:
1409: IF l_user_id IS NOT NULL THEN

Line 1406: last_update_login = NVL(fnd_global.login_id,-1)

1402: SET end_date = l_sysdate,
1403: end_method = l_method ,
1404: last_update_date = SYSDATE ,
1405: last_updated_by = NVL(fnd_global.user_id,-1) ,
1406: last_update_login = NVL(fnd_global.login_id,-1)
1407: WHERE type_instance_id = rec_per_inst.type_instance_id;
1408:
1409: IF l_user_id IS NOT NULL THEN
1410: raise_person_type_event(

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

1474: NULL,
1475: l_method,
1476: NULL,
1477: NULL,
1478: NVL(fnd_global.user_id,-1),
1479: SYSDATE,
1480: NVL(fnd_global.user_id,-1),
1481: SYSDATE,
1482: NVL(fnd_global.login_id,-1),

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

1476: NULL,
1477: NULL,
1478: NVL(fnd_global.user_id,-1),
1479: SYSDATE,
1480: NVL(fnd_global.user_id,-1),
1481: SYSDATE,
1482: NVL(fnd_global.login_id,-1),
1483: igs_ge_gen_003.get_org_id);
1484:

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

1478: NVL(fnd_global.user_id,-1),
1479: SYSDATE,
1480: NVL(fnd_global.user_id,-1),
1481: SYSDATE,
1482: NVL(fnd_global.login_id,-1),
1483: igs_ge_gen_003.get_org_id);
1484:
1485: IF l_user_id IS NOT NULL THEN
1486: raise_person_type_event(