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.IGS_UC_EXP_APPLICANT_DTLS dependencies on FND_GLOBAL

Line 5: g_created_by NUMBER := fnd_global.user_id;

1: PACKAGE BODY igs_uc_exp_applicant_dtls AS
2: /* $Header: IGSUC44B.pls 120.6 2006/08/30 03:36:37 jbaber ship $ */
3:
4: -- Standard WHO columns to be used across all the package
5: g_created_by NUMBER := fnd_global.user_id;
6: g_last_updated_by NUMBER := g_created_by;
7: g_last_update_login NUMBER := fnd_global.login_id;
8:
9:

Line 7: g_last_update_login NUMBER := fnd_global.login_id;

3:
4: -- Standard WHO columns to be used across all the package
5: g_created_by NUMBER := fnd_global.user_id;
6: g_last_updated_by NUMBER := g_created_by;
7: g_last_update_login NUMBER := fnd_global.login_id;
8:
9:
10: PROCEDURE export_process ( errbuf OUT NOCOPY VARCHAR2,
11: retcode OUT NOCOPY NUMBER,

Line 635: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),

631: SYSDATE,
632: g_last_updated_by,
633: SYSDATE,
634: g_last_update_login,
635: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
636: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
637: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
638: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )
639: RETURNING batch_id INTO l_ad_batch_id;

Line 636: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

632: g_last_updated_by,
633: SYSDATE,
634: g_last_update_login,
635: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
636: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
637: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
638: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )
639: RETURNING batch_id INTO l_ad_batch_id;
640:

Line 637: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),

633: SYSDATE,
634: g_last_update_login,
635: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
636: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
637: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
638: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )
639: RETURNING batch_id INTO l_ad_batch_id;
640:
641: END IF;

Line 638: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )

634: g_last_update_login,
635: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
636: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
637: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
638: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id) )
639: RETURNING batch_id INTO l_ad_batch_id;
640:
641: END IF;
642:

Line 1075: fnd_global.user_id,

1071: program_id)
1072: VALUES (
1073: IGS_AD_INTERFACE_BATCH_ID_S.NEXTVAL,
1074: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),
1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,
1078: SYSDATE,
1079: fnd_global.login_id,

Line 1077: fnd_global.user_id,

1073: IGS_AD_INTERFACE_BATCH_ID_S.NEXTVAL,
1074: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),
1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,
1078: SYSDATE,
1079: fnd_global.login_id,
1080: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1081: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

Line 1079: fnd_global.login_id,

1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,
1078: SYSDATE,
1079: fnd_global.login_id,
1080: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1081: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1082: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1083: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)

Line 1080: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),

1076: SYSDATE,
1077: fnd_global.user_id,
1078: SYSDATE,
1079: fnd_global.login_id,
1080: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1081: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1082: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1083: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1084: )

Line 1081: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

1077: fnd_global.user_id,
1078: SYSDATE,
1079: fnd_global.login_id,
1080: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1081: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1082: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1083: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1084: )
1085: RETURNING batch_id INTO l_ad_batch_id;

Line 1082: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),

1078: SYSDATE,
1079: fnd_global.login_id,
1080: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1081: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1082: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1083: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1084: )
1085: RETURNING batch_id INTO l_ad_batch_id;
1086:

Line 1083: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)

1079: fnd_global.login_id,
1080: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1081: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1082: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1083: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1084: )
1085: RETURNING batch_id INTO l_ad_batch_id;
1086:
1087: END IF;

Line 2254: fnd_global.user_id,

2250: 'N',
2251: NULL,
2252: '2',
2253: 'N',
2254: fnd_global.user_id,
2255: SYSDATE,
2256: fnd_global.user_id,
2257: SYSDATE,
2258: fnd_global.login_id,

Line 2256: fnd_global.user_id,

2252: '2',
2253: 'N',
2254: fnd_global.user_id,
2255: SYSDATE,
2256: fnd_global.user_id,
2257: SYSDATE,
2258: fnd_global.login_id,
2259: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2260: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

Line 2258: fnd_global.login_id,

2254: fnd_global.user_id,
2255: SYSDATE,
2256: fnd_global.user_id,
2257: SYSDATE,
2258: fnd_global.login_id,
2259: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2260: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2261: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),
2262: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) );

Line 2259: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),

2255: SYSDATE,
2256: fnd_global.user_id,
2257: SYSDATE,
2258: fnd_global.login_id,
2259: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2260: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2261: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),
2262: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) );
2263:

Line 2260: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

2256: fnd_global.user_id,
2257: SYSDATE,
2258: fnd_global.login_id,
2259: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2260: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2261: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),
2262: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) );
2263:
2264: END IF; -- End of record already exists check => cur_get_hist_details%NOTFOUND

Line 2261: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),

2257: SYSDATE,
2258: fnd_global.login_id,
2259: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2260: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2261: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),
2262: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) );
2263:
2264: END IF; -- End of record already exists check => cur_get_hist_details%NOTFOUND
2265: CLOSE cur_get_hist_details ;

Line 2262: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) );

2258: fnd_global.login_id,
2259: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2260: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2261: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),
2262: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) );
2263:
2264: END IF; -- End of record already exists check => cur_get_hist_details%NOTFOUND
2265: CLOSE cur_get_hist_details ;
2266: