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.

[Home] [Help]

APPS.IGS_UC_EXPORT_TO_OSS dependencies on FND_GLOBAL

Line 47: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;

43: ***************************************************************** */
44:
45: l_status CONSTANT NUMBER := 2;
46: l_record_status CONSTANT NUMBER := 2;
47: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
48: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
49: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
50: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
51: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

Line 48: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;

44:
45: l_status CONSTANT NUMBER := 2;
46: l_record_status CONSTANT NUMBER := 2;
47: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
48: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
49: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
50: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
51: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
52: l_ch_error igs_uc_app_choices.error_code%TYPE ;

Line 49: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

45: l_status CONSTANT NUMBER := 2;
46: l_record_status CONSTANT NUMBER := 2;
47: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
48: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
49: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
50: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
51: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
52: l_ch_error igs_uc_app_choices.error_code%TYPE ;
53: l_ch_batch_id igs_uc_app_choices.batch_id%TYPE ;

Line 50: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;

46: l_record_status CONSTANT NUMBER := 2;
47: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
48: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
49: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
50: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
51: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
52: l_ch_error igs_uc_app_choices.error_code%TYPE ;
53: l_ch_batch_id igs_uc_app_choices.batch_id%TYPE ;
54: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;

Line 51: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

47: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
48: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
49: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
50: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
51: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
52: l_ch_error igs_uc_app_choices.error_code%TYPE ;
53: l_ch_batch_id igs_uc_app_choices.batch_id%TYPE ;
54: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;
55: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;

Line 2401: fnd_global.user_id,

2397: program_update_date,
2398: program_id)
2399: VALUES ( l_imp_batch_id,
2400: fnd_message.get_string('IGS','IGS_UC_EXP_TO_OSS_BATCH_ID'),
2401: fnd_global.user_id,
2402: SYSDATE,
2403: fnd_global.user_id,
2404: SYSDATE,
2405: fnd_global.login_id,

Line 2403: fnd_global.user_id,

2399: VALUES ( l_imp_batch_id,
2400: fnd_message.get_string('IGS','IGS_UC_EXP_TO_OSS_BATCH_ID'),
2401: fnd_global.user_id,
2402: SYSDATE,
2403: fnd_global.user_id,
2404: SYSDATE,
2405: fnd_global.login_id,
2406: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2407: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

Line 2405: fnd_global.login_id,

2401: fnd_global.user_id,
2402: SYSDATE,
2403: fnd_global.user_id,
2404: SYSDATE,
2405: fnd_global.login_id,
2406: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2407: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2408: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
2409: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)

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

2402: SYSDATE,
2403: fnd_global.user_id,
2404: SYSDATE,
2405: fnd_global.login_id,
2406: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2407: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2408: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
2409: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
2410: );

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

2403: fnd_global.user_id,
2404: SYSDATE,
2405: fnd_global.login_id,
2406: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2407: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2408: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
2409: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
2410: );
2411:

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

2404: SYSDATE,
2405: fnd_global.login_id,
2406: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2407: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2408: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
2409: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
2410: );
2411:
2412: -- Get the ucas cource type id for import process

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

2405: fnd_global.login_id,
2406: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2407: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2408: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
2409: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
2410: );
2411:
2412: -- Get the ucas cource type id for import process
2413: c_src_type_id_rec := NULL ;

Line 2733: l_conc_request_id := fnd_global.conc_request_id();

2729: retcode := 0;
2730: l_no_setup := FALSE ;
2731: -- Get the Concurrent Request ID of the current export of UCAS application to
2732: -- OSS admission applications run . this is a global variable
2733: l_conc_request_id := fnd_global.conc_request_id();
2734:
2735: -- Checking whether the UK profile is enabled
2736: IF Not (igs_uc_utils.is_ucas_hesa_enabled) THEN
2737: Raise igs_uc_he_not_enabled_excep; -- user defined exception