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;
6355: lx_error_rec OKL_API.error_rec_type;
6356:
6357: CURSOR req_id_csr IS
6358: SELECT
6359: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
6360: FROM dual;
6361:
6362: ------------------------------------------------------------
6363: -- Operating Unit
6552: FUNCTION delete_report_data return BOOLEAN
6553:
6554: IS
6555: l_row_count NUMBER;
6556: l_parent_request_id NUMBER := Fnd_Global.conc_priority_request; --Request ID of Master program
6557: BEGIN
6558: fnd_file.put_line(fnd_file.log,'P_DELETE_DATA_YN :'||P_DELETE_DATA_YN);
6559: fnd_file.put_line(fnd_file.log,'l_parent_request_id :'||l_parent_request_id);
6560: