DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on FND_GLOBAL

Line 78: l_last_updated_by NUMBER := Fnd_Global.USER_ID;

74: P_DELETE_DATA_YN IN VARCHAR2,
75: p_num_processes IN NUMBER,
76: p_assigned_process IN VARCHAR2
77: ) IS
78: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
79: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
80: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID; --Request ID of this (Child) program
81: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program
82: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;

Line 79: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;

75: p_num_processes IN NUMBER,
76: p_assigned_process IN VARCHAR2
77: ) IS
78: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
79: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
80: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID; --Request ID of this (Child) program
81: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program
82: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
83: l_program_app_id NUMBER := Fnd_Global.PROG_APPL_ID ;

Line 80: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID; --Request ID of this (Child) program

76: p_assigned_process IN VARCHAR2
77: ) IS
78: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
79: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
80: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID; --Request ID of this (Child) program
81: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program
82: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
83: l_program_app_id NUMBER := Fnd_Global.PROG_APPL_ID ;
84: l_program_login_id NUMBER := Fnd_Global.conc_login_id ;

Line 81: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program

77: ) IS
78: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
79: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
80: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID; --Request ID of this (Child) program
81: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program
82: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
83: l_program_app_id NUMBER := Fnd_Global.PROG_APPL_ID ;
84: l_program_login_id NUMBER := Fnd_Global.conc_login_id ;
85:

Line 82: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;

78: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
79: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
80: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID; --Request ID of this (Child) program
81: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program
82: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
83: l_program_app_id NUMBER := Fnd_Global.PROG_APPL_ID ;
84: l_program_login_id NUMBER := Fnd_Global.conc_login_id ;
85:
86: l_api_name CONSTANT VARCHAR2(30) := 'pull_extract_data';

Line 83: l_program_app_id NUMBER := Fnd_Global.PROG_APPL_ID ;

79: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
80: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID; --Request ID of this (Child) program
81: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program
82: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
83: l_program_app_id NUMBER := Fnd_Global.PROG_APPL_ID ;
84: l_program_login_id NUMBER := Fnd_Global.conc_login_id ;
85:
86: l_api_name CONSTANT VARCHAR2(30) := 'pull_extract_data';
87: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 84: l_program_login_id NUMBER := Fnd_Global.conc_login_id ;

80: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID; --Request ID of this (Child) program
81: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program
82: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
83: l_program_app_id NUMBER := Fnd_Global.PROG_APPL_ID ;
84: l_program_login_id NUMBER := Fnd_Global.conc_login_id ;
85:
86: l_api_name CONSTANT VARCHAR2(30) := 'pull_extract_data';
87: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
88: l_api_version CONSTANT NUMBER := 1;

Line 2343: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID) --sechawla : why Null if -1 ?

2339: lx_error_rec OKL_API.error_rec_type;
2340:
2341: CURSOR req_id_csr IS
2342: SELECT
2343: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID) --sechawla : why Null if -1 ?
2344: FROM dual;
2345:
2346: ------------------------------------------------------------
2347: -- Operating Unit

Line 2781: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program

2777: FUNCTION delete_report_data return BOOLEAN
2778:
2779: IS
2780: l_row_count NUMBER;
2781: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program
2782: BEGIN
2783: fnd_file.put_line(fnd_file.log,'P_DELETE_DATA_YN :'||P_DELETE_DATA_YN);
2784: fnd_file.put_line(fnd_file.log,'l_parent_request_id :'||l_parent_request_id);
2785: