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 344: FROM ar_submission_ctrl_gt

340: ,p_sub_name IN VARCHAR2)
341: IS
342: CURSOR reqs IS
343: SELECT request_id
344: FROM ar_submission_ctrl_gt
345: WHERE status <> 'COMPLETE'
346: AND script_name = p_sub_name;
347: l_req_id NUMBER;
348: l_phase VARCHAR2(50);

Line 372: UPDATE ar_submission_ctrl_gt

368: dev_phase=>l_dev_phase,
369: dev_status=>l_dev_status,
370: message=>l_message);
371: IF l_dev_phase = 'COMPLETE' THEN
372: UPDATE ar_submission_ctrl_gt
373: SET status = 'COMPLETE'
374: WHERE request_id = l_req_id;
375: --{If required, we can control the error handling at concurrent process level
376: -- but as this is part of the accounting posting process if revrec or rev analyser fails