APPS.CN_CALC_SUB_BATCHES_PKG dependencies on CN_CALC_SUBMISSION_BATCHES_ALL

Line 68: INSERT INTO cn_calc_submission_batches_all

64: INTO l_calc_sub_batch_id
65: FROM dual;
66: END IF;
67:
68: INSERT INTO cn_calc_submission_batches_all
69: ( calc_sub_batch_id,
70: name,
71: start_date,
72: end_date,

Line 184: UPDATE cn_calc_submission_batches_all SET

180: ) IS
181:
182: BEGIN
183:
184: UPDATE cn_calc_submission_batches_all SET
185: calc_sub_batch_id = p_calc_sub_batch_id,
186: name = p_name,
187: start_date = p_start_date,
188: end_date = p_end_date,

Line 227: DELETE cn_calc_submission_batches_all

223:
224: Procedure delete_row ( p_calc_sub_batch_id NUMBER ) IS
225:
226: BEGIN
227: DELETE cn_calc_submission_batches_all
228: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
229:
230: IF (sql%notfound) THEN
231: raise no_data_found;

Line 278: SELECT * FROM cn_calc_submission_batches_all

274: P_LAST_UPDATE_DATE DATE ,
275: P_LAST_UPDATED_BY NUMBER
276: ) IS
277: CURSOR C IS
278: SELECT * FROM cn_calc_submission_batches_all
279: WHERE calc_sub_batch_id = p_calc_sub_batch_id
280: FOR UPDATE OF calc_sub_batch_id NOWAIT;
281:
282: Recinfo C%ROWTYPE;

Line 573: FROM cn_calc_submission_batches_all csb

569: x_calc_sub_batch_rec.start_date,
570: x_calc_sub_batch_rec.end_date,
571: x_calc_sub_batch_rec.calc_type,
572: x_calc_sub_batch_rec.interval_type_id
573: FROM cn_calc_submission_batches_all csb
574: WHERE csb.logical_batch_id = (SELECT pb.logical_batch_id
575: FROM cn_process_batches_all pb
576: WHERE pb.physical_batch_id = p_physical_batch_id
577: AND rownum = 1);

Line 596: from cn_calc_submission_batches_all csb

592: x_return VARCHAR2(1);
593: BEGIN
594: select intelligent_flag
595: into x_return
596: from cn_calc_submission_batches_all csb
597: where csb.logical_batch_id = (select logical_batch_id
598: from cn_process_batches_all pb
599: where pb.physical_batch_id = p_calc_batch_id
600: and rownum = 1);

Line 624: from cn_calc_submission_batches_all csb

620: l_calc_type VARCHAR2(30);
621: BEGIN
622: select calc_type
623: into l_calc_type
624: from cn_calc_submission_batches_all csb
625: where csb.logical_batch_id = (select logical_batch_id
626: from cn_process_batches_all pb
627: where pb.physical_batch_id = p_calc_batch_id
628: and rownum = 1);

Line 657: from cn_calc_submission_batches_all csb

653: x_return VARCHAR2(30);
654: BEGIN
655: select calc_type
656: into x_return
657: from cn_calc_submission_batches_all csb
658: where csb.logical_batch_id = (select logical_batch_id
659: from cn_process_batches_all pb
660: where pb.physical_batch_id = p_calc_batch_id
661: and rownum = 1);

Line 684: from cn_calc_submission_batches_all csb

680: x_return VARCHAR2(30);
681: BEGIN
682: select salesrep_option
683: into x_return
684: from cn_calc_submission_batches_all csb
685: where csb.logical_batch_id = (select logical_batch_id
686: from cn_process_batches_all pb
687: where pb.physical_batch_id = p_calc_batch_id
688: and rownum = 1);

Line 710: FROM cn_calc_submission_batches_all

706: l_concurrent_flag VARCHAR2(1);
707: BEGIN
708: SELECT concurrent_flag
709: INTO l_concurrent_flag
710: FROM cn_calc_submission_batches_all
711: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
712:
713: RETURN l_concurrent_flag;
714: END get_concurrent_flag;

Line 783: UPDATE cn_calc_submission_batches_all

779: l_calc_type VARCHAR2(30);
780: l_org_id number;
781:
782: BEGIN
783: UPDATE cn_calc_submission_batches_all
784: SET status = p_status
785: WHERE logical_batch_id = p_logical_batch_id;
786:
787: IF p_status = 'COMPLETE' THEN

Line 792: FROM cn_calc_submission_batches_all

788: SELECT salesrep_option, intelligent_flag, calc_type,
789: start_date, end_date, org_id
790: INTO l_salesrep_option, l_intel_flag, l_calc_type,
791: l_start_date, l_end_date, l_org_id
792: FROM cn_calc_submission_batches_all
793: WHERE logical_batch_id = p_logical_batch_id;
794:
795: IF l_calc_type = 'COMMISSION' THEN
796: IF l_salesrep_option = 'ALL_REPS'