APPS.ECE_SPSO_TRANS2 dependencies on CHV_HORIZONTAL_SCHEDULES

Line 173: rec_hz chv_horizontal_schedules%ROWTYPE;

169: tbl_end tbl_hz_type;
170: tbl_for tbl_hz_type;
171: tbl_rel tbl_hz_type;
172: tbl_tot tbl_hz_type;
173: rec_hz chv_horizontal_schedules%ROWTYPE;
174:
175: x_max_col number := 60;
176: x_min_col number := 1;
177: x_detail_category varchar2(25);

Line 189: -- Get BUCET_DESCRIPTION from CHV_HORIZONTAL_SCHEDULES

185: /****************
186: ** Description **
187: ****************/
188:
189: -- Get BUCET_DESCRIPTION from CHV_HORIZONTAL_SCHEDULES
190:
191: xProgress := 'SPSO2B-10-1040';
192:
193: --DBMS_OUTPUT.PUT_LINE('LN1 '||sqlcode);

Line 196: FROM chv_horizontal_schedules

192:
193: --DBMS_OUTPUT.PUT_LINE('LN1 '||sqlcode);
194: SELECT *
195: INTO rec_hz
196: FROM chv_horizontal_schedules
197: WHERE schedule_item_id = rec_item.schedule_item_id
198: AND schedule_id = rec_item.schedule_id
199: AND row_type = 'BUCKET_DESCRIPTOR';
200:

Line 330: -- Get START_DATE from CHV_HORIZONTAL_SCHEDULES

326: /*****************
327: ** Start Date **
328: *****************/
329:
330: -- Get START_DATE from CHV_HORIZONTAL_SCHEDULES
331:
332: xProgress := 'SPSO2B-10-1060';
333:
334: BEGIN -- START DATE select block

Line 339: FROM chv_horizontal_schedules

335: xProgress := 'SPSO2B-10-1070';
336: --DBMS_OUTPUT.PUT_LINE('LN2 '||sqlcode);
337: SELECT *
338: INTO rec_hz
339: FROM chv_horizontal_schedules
340: WHERE schedule_item_id = rec_item.schedule_item_id
341: AND schedule_id = rec_item.schedule_id
342: AND row_type = 'BUCKET_START_DATE';
343:

Line 480: -- Get END_DATE from CHV_HORIZONTAL_SCHEDULES

476: /*************
477: ** End Date **
478: *************/
479:
480: -- Get END_DATE from CHV_HORIZONTAL_SCHEDULES
481:
482: xProgress := 'SPSO2B-10-1090';
483:
484: BEGIN -- END DATE select block

Line 489: FROM chv_horizontal_schedules

485: xProgress := 'SPSO2B-10-1100';
486: --DBMS_OUTPUT.PUT_LINE('LN3 '||sqlcode);
487: SELECT *
488: INTO rec_hz
489: FROM chv_horizontal_schedules
490: WHERE schedule_item_id = rec_item.schedule_item_id
491: AND schedule_id = rec_item.schedule_id
492: AND row_type = 'BUCKET_END_DATE';
493:

Line 630: -- Get RELEASE_QUANTITY from CHV_HORIZONTAL_SCHEDULES

626: /*********************
627: ** Release Quantity **
628: *********************/
629:
630: -- Get RELEASE_QUANTITY from CHV_HORIZONTAL_SCHEDULES
631:
632: xProgress := 'SPSO2B-10-1120';
633:
634: BEGIN -- RELEASE QUANTITY block

Line 638: FROM chv_horizontal_schedules

634: BEGIN -- RELEASE QUANTITY block
635: xProgress := 'SPSO2B-10-1130';
636: SELECT *
637: INTO rec_hz
638: FROM chv_horizontal_schedules
639: WHERE schedule_item_id = rec_item.schedule_item_id
640: AND schedule_id = rec_item.schedule_id
641: AND row_type = 'RELEASE_QUANTITY';
642:

Line 779: -- Get FORECAST_QUANTITY from CHV_HORIZONTAL_SCHEDULES

775: ** Forecast Quantity **
776: ************************/
777:
778:
779: -- Get FORECAST_QUANTITY from CHV_HORIZONTAL_SCHEDULES
780:
781: xProgress := 'SPSO2B-10-1150';
782:
783: BEGIN -- FORECAST QUANTITY select block

Line 788: FROM chv_horizontal_schedules

784: xProgress := 'SPSO2B-10-1160';
785: --DBMS_OUTPUT.PUT_LINE('LN5 '||sqlcode);
786: SELECT *
787: INTO rec_hz
788: FROM chv_horizontal_schedules
789: WHERE schedule_item_id = rec_item.schedule_item_id
790: AND schedule_id = rec_item.schedule_id
791: AND row_type = 'FORECAST_QUANTITY';
792:

Line 929: -- Get TOTAL_QUANTITY from CHV_HORIZONTAL_SCHEDULES

925: /********************
926: ** Total Quantity **
927: ********************/
928:
929: -- Get TOTAL_QUANTITY from CHV_HORIZONTAL_SCHEDULES
930:
931: xProgress := 'SPSO2B-10-1180';
932:
933: BEGIN -- TOTAL QUANTITY select block

Line 938: FROM chv_horizontal_schedules

934: xProgress := 'SPSO2B-10-1190';
935: --DBMS_OUTPUT.PUT_LINE('LN6 '||sqlcode);
936: SELECT *
937: INTO rec_hz
938: FROM chv_horizontal_schedules
939: WHERE schedule_item_id = rec_item.schedule_item_id
940: AND schedule_id = rec_item.schedule_id
941: AND row_type = 'TOTAL_QUANTITY';
942: