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;
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 ;
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 ;
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:
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';
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;
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;
2353: lx_error_rec OKL_API.error_rec_type;
2354:
2355: CURSOR req_id_csr IS
2356: SELECT
2357: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID) --sechawla : why Null if -1 ?
2358: FROM dual;
2359:
2360: ------------------------------------------------------------
2361: -- Operating Unit
2791: FUNCTION delete_report_data return BOOLEAN
2792:
2793: IS
2794: l_row_count NUMBER;
2795: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program
2796: BEGIN
2797: fnd_file.put_line(fnd_file.log,'P_DELETE_DATA_YN :'||P_DELETE_DATA_YN);
2798: fnd_file.put_line(fnd_file.log,'l_parent_request_id :'||l_parent_request_id);
2799: