APPS.CN_CALC_SUBMISSION_PVT dependencies on CN_CALC_SUBMISSION_BATCHES_ALL

Line 136: FROM cn_calc_submission_batches_all

132: l_quota_name cn_quotas.name%TYPE;
133:
134: CURSOR name_check (p_batch_name cn_calc_submission_batches.name%TYPE ) IS
135: SELECT 1
136: FROM cn_calc_submission_batches_all
137: WHERE name = p_batch_name
138: AND org_id = p_sub_batch_rec.org_id
139: AND (p_sub_batch_rec.calc_sub_batch_id IS NULL OR calc_sub_batch_id <> p_sub_batch_rec.calc_sub_batch_id);
140:

Line 809: update cn_calc_submission_batches_all sb

805: -- This procedure should be invoked only when retrieving calculation batch records in response to a search request
806: -- from the calculation batch search page.
807: PROCEDURE maintain_batch_status IS
808: BEGIN
809: update cn_calc_submission_batches_all sb
810: set status = 'FAILED'
811: where status = 'PROCESSING'
812: and concurrent_flag = 'Y'
813: and exists (select 1

Line 1023: from cn_calc_submission_batches_all

1019: x_process_status_code => l_process_status_code);
1020:
1021: select concurrent_flag
1022: into l_concurrent_flag
1023: from cn_calc_submission_batches_all
1024: where calc_sub_batch_id = p_calc_sub_batch_id;
1025:
1026: IF (l_concurrent_flag = 'N') THEN
1027: IF nvl(l_process_status_code,'FAIL') = 'SUCCESS' THEN