APPS.AR_CREATE_ACCTING_SRS dependencies on AR_SUBMISSION_CTRL_GT

Line 81: INSERT INTO ar_submission_ctrl_gt

77: argument4=> p_max_wait,
78: argument5=> p_org_id );
79: IF x_out_request_id <> 0 THEN
80: outandlog('Revenue Recognition submitted for Org_id:'||p_org_id||' by the request '||x_out_request_id);
81: INSERT INTO ar_submission_ctrl_gt
82: (worker_id , --org_id
83: batch_id , --batch_id
84: script_name , --script_name
85: status , --

Line 127: INSERT INTO ar_submission_ctrl_gt

123: sub_request=>FALSE,
124: argument1 =>p_org_id);
125: IF x_out_request_id <> 0 THEN
126: outandlog('submit_rev_contigency for org_id :'||p_org_id||' has submitted the request :'||x_out_request_id);
127: INSERT INTO ar_submission_ctrl_gt
128: (worker_id , --org_id
129: batch_id , --batch_id
130: script_name , --script_name
131: status , --

Line 413: FROM ar_submission_ctrl_gt

409: ,p_sub_name IN VARCHAR2)
410: IS
411: CURSOR reqs IS
412: SELECT request_id
413: FROM ar_submission_ctrl_gt
414: WHERE status <> 'COMPLETE'
415: AND script_name = p_sub_name;
416: l_req_id NUMBER;
417: l_phase VARCHAR2(50);

Line 441: UPDATE ar_submission_ctrl_gt

437: dev_phase=>l_dev_phase,
438: dev_status=>l_dev_status,
439: message=>l_message);
440: IF l_dev_phase = 'COMPLETE' THEN
441: UPDATE ar_submission_ctrl_gt
442: SET status = 'COMPLETE'
443: WHERE request_id = l_req_id;
444: --{If required, we can control the error handling at concurrent process level
445: -- but as this is part of the accounting posting process if revrec or rev analyser fails