APPS.AR_LATE_CHARGE_PKG dependencies on AR_SUBMISSION_CTRL_GT

Line 2323: INSERT INTO ar_submission_ctrl_gt

2319: argument3 => p_gl_date,
2320: argument4 => p_cal_int_date,
2321: argument5 => p_api_bulk_size );
2322: IF x_out_request_id <> 0 THEN
2323: INSERT INTO ar_submission_ctrl_gt
2324: (worker_id , --p_batch_source_id
2325: batch_id , --
2326: script_name , --script_name
2327: status , --

Line 2358: FROM ar_submission_ctrl_gt

2354: ,p_sub_name IN VARCHAR2)
2355: IS
2356: CURSOR reqs IS
2357: SELECT request_id
2358: FROM ar_submission_ctrl_gt
2359: WHERE status <> 'COMPLETE'
2360: AND script_name = p_sub_name;
2361: l_req_id NUMBER;
2362: l_phase VARCHAR2(50);

Line 2388: UPDATE ar_submission_ctrl_gt

2384: dev_phase=>l_dev_phase,
2385: dev_status=>l_dev_status,
2386: message=>l_message);
2387: IF l_dev_phase = 'COMPLETE' THEN
2388: UPDATE ar_submission_ctrl_gt
2389: SET status = 'COMPLETE'
2390: WHERE request_id = l_req_id;
2391: END IF;
2392: END LOOP;

Line 2420: FROM ar_submission_ctrl_gt

2416: x_status OUT NOCOPY VARCHAR2)
2417: IS
2418: CURSOR reqs IS
2419: SELECT request_id
2420: FROM ar_submission_ctrl_gt
2421: WHERE status = 'COMPLETE'
2422: AND script_name = p_sub_name;
2423: l_req_id NUMBER;
2424: lbool BOOLEAN;

Line 3546: INSERT INTO ar_submission_ctrl_gt

3542: argument4 => p_gl_date,
3543: argument5 => p_cal_int_date,
3544: argument6 => p_api_bulk_size );
3545: IF x_out_request_id <> 0 THEN
3546: INSERT INTO ar_submission_ctrl_gt
3547: (worker_id , --p_batch_source_id
3548: batch_id , --
3549: script_name , --script_name
3550: status , --