APPS.ECE_SPSO_TRANS2 dependencies on CHV_HORIZONTAL_SCHEDULES

Line 193: rec_hz chv_horizontal_schedules%ROWTYPE;

189: tbl_end tbl_hz_type;
190: tbl_for tbl_hz_type;
191: tbl_rel tbl_hz_type;
192: tbl_tot tbl_hz_type;
193: rec_hz chv_horizontal_schedules%ROWTYPE;
194:
195: x_max_col number := 60;
196: x_min_col number := 1;
197: x_detail_category varchar2(25);

Line 209: -- Get BUCET_DESCRIPTION from CHV_HORIZONTAL_SCHEDULES

205: /****************
206: ** Description **
207: ****************/
208:
209: -- Get BUCET_DESCRIPTION from CHV_HORIZONTAL_SCHEDULES
210:
211: xProgress := 'SPSO2B-10-1040';
212:
213: --DBMS_OUTPUT.PUT_LINE('LN1 '||sqlcode);

Line 216: FROM chv_horizontal_schedules

212:
213: --DBMS_OUTPUT.PUT_LINE('LN1 '||sqlcode);
214: SELECT *
215: INTO rec_hz
216: FROM chv_horizontal_schedules
217: WHERE schedule_item_id = rec_item.schedule_item_id
218: AND schedule_id = rec_item.schedule_id
219: AND row_type = 'BUCKET_DESCRIPTOR';
220:

Line 350: -- Get START_DATE from CHV_HORIZONTAL_SCHEDULES

346: /*****************
347: ** Start Date **
348: *****************/
349:
350: -- Get START_DATE from CHV_HORIZONTAL_SCHEDULES
351:
352: xProgress := 'SPSO2B-10-1060';
353:
354: BEGIN -- START DATE select block

Line 359: FROM chv_horizontal_schedules

355: xProgress := 'SPSO2B-10-1070';
356: --DBMS_OUTPUT.PUT_LINE('LN2 '||sqlcode);
357: SELECT *
358: INTO rec_hz
359: FROM chv_horizontal_schedules
360: WHERE schedule_item_id = rec_item.schedule_item_id
361: AND schedule_id = rec_item.schedule_id
362: AND row_type = 'BUCKET_START_DATE';
363:

Line 500: -- Get END_DATE from CHV_HORIZONTAL_SCHEDULES

496: /*************
497: ** End Date **
498: *************/
499:
500: -- Get END_DATE from CHV_HORIZONTAL_SCHEDULES
501:
502: xProgress := 'SPSO2B-10-1090';
503:
504: BEGIN -- END DATE select block

Line 509: FROM chv_horizontal_schedules

505: xProgress := 'SPSO2B-10-1100';
506: --DBMS_OUTPUT.PUT_LINE('LN3 '||sqlcode);
507: SELECT *
508: INTO rec_hz
509: FROM chv_horizontal_schedules
510: WHERE schedule_item_id = rec_item.schedule_item_id
511: AND schedule_id = rec_item.schedule_id
512: AND row_type = 'BUCKET_END_DATE';
513:

Line 650: -- Get RELEASE_QUANTITY from CHV_HORIZONTAL_SCHEDULES

646: /*********************
647: ** Release Quantity **
648: *********************/
649:
650: -- Get RELEASE_QUANTITY from CHV_HORIZONTAL_SCHEDULES
651:
652: xProgress := 'SPSO2B-10-1120';
653:
654: BEGIN -- RELEASE QUANTITY block

Line 658: FROM chv_horizontal_schedules

654: BEGIN -- RELEASE QUANTITY block
655: xProgress := 'SPSO2B-10-1130';
656: SELECT *
657: INTO rec_hz
658: FROM chv_horizontal_schedules
659: WHERE schedule_item_id = rec_item.schedule_item_id
660: AND schedule_id = rec_item.schedule_id
661: AND row_type = 'RELEASE_QUANTITY';
662:

Line 799: -- Get FORECAST_QUANTITY from CHV_HORIZONTAL_SCHEDULES

795: ** Forecast Quantity **
796: ************************/
797:
798:
799: -- Get FORECAST_QUANTITY from CHV_HORIZONTAL_SCHEDULES
800:
801: xProgress := 'SPSO2B-10-1150';
802:
803: BEGIN -- FORECAST QUANTITY select block

Line 808: FROM chv_horizontal_schedules

804: xProgress := 'SPSO2B-10-1160';
805: --DBMS_OUTPUT.PUT_LINE('LN5 '||sqlcode);
806: SELECT *
807: INTO rec_hz
808: FROM chv_horizontal_schedules
809: WHERE schedule_item_id = rec_item.schedule_item_id
810: AND schedule_id = rec_item.schedule_id
811: AND row_type = 'FORECAST_QUANTITY';
812:

Line 949: -- Get TOTAL_QUANTITY from CHV_HORIZONTAL_SCHEDULES

945: /********************
946: ** Total Quantity **
947: ********************/
948:
949: -- Get TOTAL_QUANTITY from CHV_HORIZONTAL_SCHEDULES
950:
951: xProgress := 'SPSO2B-10-1180';
952:
953: BEGIN -- TOTAL QUANTITY select block

Line 958: FROM chv_horizontal_schedules

954: xProgress := 'SPSO2B-10-1190';
955: --DBMS_OUTPUT.PUT_LINE('LN6 '||sqlcode);
956: SELECT *
957: INTO rec_hz
958: FROM chv_horizontal_schedules
959: WHERE schedule_item_id = rec_item.schedule_item_id
960: AND schedule_id = rec_item.schedule_id
961: AND row_type = 'TOTAL_QUANTITY';
962: