DBA Data[Home] [Help]

APPS.IGS_PS_USEC_SCHEDULE dependencies on FND_GLOBAL

Line 47: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id

43: p_val IN NUMBER
44: ) ;
45: FUNCTION get_alternate_code (p_c_cal_type IN VARCHAR2,
46: p_n_seq_num IN NUMBER)RETURN VARCHAR2;
47: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
48: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
49:
50:
51: PROCEDURE prgp_init_prs_sched(

Line 48: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id

44: ) ;
45: FUNCTION get_alternate_code (p_c_cal_type IN VARCHAR2,
46: p_n_seq_num IN NUMBER)RETURN VARCHAR2;
47: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
48: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
49:
50:
51: PROCEDURE prgp_init_prs_sched(
52: errbuf OUT NOCOPY VARCHAR2,

Line 2257: l_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID(); -- returns the concurrent request id;

2253: l_handler_location UTL_FILE.FILE_TYPE ;
2254: l_handler_region UTL_FILE.FILE_TYPE ; -- Added local variable as part of bug#2833850
2255: l_handler_check BOOLEAN;
2256: l_path_var VARCHAR2(80);
2257: l_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID(); -- returns the concurrent request id;
2258: l_prof_val_pres VARCHAR2(1); -- to check profile value is present in utl_file_dir of v$parameter
2259:
2260: -- Cursor to get room information to be exported to flat file
2261: CURSOR c_room IS