13: -- Procedures TO populate transactions from CN_COMM_LINES_API into SCA interface tables and
14: -- transfer results back to CN_COMM_LINES_API from SCA output tables after credit allocation
15: -- History
16: -- 06/02/03 Mike Ting Created
17: -- Nov 17, 2005 vensrini add call to fnd_request.set_org_id to call_populate_resuts
18: -- before calling fnd_request.submit_request
19: -- Mar 31, 2005 vensrini Bug fix 5125980
20: --
21:
14: -- transfer results back to CN_COMM_LINES_API from SCA output tables after credit allocation
15: -- History
16: -- 06/02/03 Mike Ting Created
17: -- Nov 17, 2005 vensrini add call to fnd_request.set_org_id to call_populate_resuts
18: -- before calling fnd_request.submit_request
19: -- Mar 31, 2005 vensrini Bug fix 5125980
20: --
21:
22:
80: INTO l_org_id
81: FROM cn_sca_process_batches
82: WHERE sca_process_batch_id = x_physical_batch_id;
83:
84: fnd_request.set_org_id( l_org_id );
85:
86: x_request_id := fnd_request.submit_request
87: (
88: application => 'CN'
82: WHERE sca_process_batch_id = x_physical_batch_id;
83:
84: fnd_request.set_org_id( l_org_id );
85:
86: x_request_id := fnd_request.submit_request
87: (
88: application => 'CN'
89: ,program => x_conc_program
90: ,argument1 => x_parent_proc_audit_id
2299:
2300: -- Initialize API return status to success
2301: x_return_status := FND_API.G_RET_STS_SUCCESS;
2302:
2303: fnd_request.set_org_id( p_org_id ); -- vensrini
2304:
2305: x_process_audit_id :=
2306:
2307: FND_REQUEST.SUBMIT_REQUEST(
2303: fnd_request.set_org_id( p_org_id ); -- vensrini
2304:
2305: x_process_audit_id :=
2306:
2307: FND_REQUEST.SUBMIT_REQUEST(
2308: application => 'CN',
2309: program => 'CN_SCA_POPULATE_RESULTS',
2310: argument1 => TO_CHAR(p_start_date,'YYYY/MM/DD HH24:MI:SS'),
2311: argument2 => TO_CHAR(p_end_date,'YYYY/MM/DD HH24:MI:SS'),
2573:
2574: END IF;
2575:
2576: x_process_audit_id :=
2577: FND_REQUEST.SUBMIT_REQUEST(
2578: application => 'CN',
2579: program => 'CN_SCA_POPULATE_DATA',
2580: argument1 => TO_CHAR(p_start_date,'YYYY/MM/DD HH24:MI:SS'),
2581: argument2 => TO_CHAR(p_end_date,'YYYY/MM/DD HH24:MI:SS'),