APPS.AR_LATE_CHARGE_PKG dependencies on AR_SUBMISSION_CTRL_GT

Line 2283: INSERT INTO ar_submission_ctrl_gt

2279: argument3 => p_gl_date,
2280: argument4 => p_cal_int_date,
2281: argument5 => p_api_bulk_size );
2282: IF x_out_request_id <> 0 THEN
2283: INSERT INTO ar_submission_ctrl_gt
2284: (worker_id , --p_batch_source_id
2285: batch_id , --
2286: script_name , --script_name
2287: status , --

Line 2318: FROM ar_submission_ctrl_gt

2314: ,p_sub_name IN VARCHAR2)
2315: IS
2316: CURSOR reqs IS
2317: SELECT request_id
2318: FROM ar_submission_ctrl_gt
2319: WHERE status <> 'COMPLETE'
2320: AND script_name = p_sub_name;
2321: l_req_id NUMBER;
2322: l_phase VARCHAR2(50);

Line 2348: UPDATE ar_submission_ctrl_gt

2344: dev_phase=>l_dev_phase,
2345: dev_status=>l_dev_status,
2346: message=>l_message);
2347: IF l_dev_phase = 'COMPLETE' THEN
2348: UPDATE ar_submission_ctrl_gt
2349: SET status = 'COMPLETE'
2350: WHERE request_id = l_req_id;
2351: END IF;
2352: END LOOP;

Line 2380: FROM ar_submission_ctrl_gt

2376: x_status OUT NOCOPY VARCHAR2)
2377: IS
2378: CURSOR reqs IS
2379: SELECT request_id
2380: FROM ar_submission_ctrl_gt
2381: WHERE status = 'COMPLETE'
2382: AND script_name = p_sub_name;
2383: l_req_id NUMBER;
2384: lbool BOOLEAN;

Line 3506: INSERT INTO ar_submission_ctrl_gt

3502: argument4 => p_gl_date,
3503: argument5 => p_cal_int_date,
3504: argument6 => p_api_bulk_size );
3505: IF x_out_request_id <> 0 THEN
3506: INSERT INTO ar_submission_ctrl_gt
3507: (worker_id , --p_batch_source_id
3508: batch_id , --
3509: script_name , --script_name
3510: status , --