[Home] [Help]
373: routing_id PLS_INTEGER ,
374: x_dep_routingstep_id PLS_INTEGER ,
375: x_routingstep_id PLS_INTEGER ,
376: dep_type PLS_INTEGER,
377: standard_delay NUMBER,
378: max_delay NUMBER,
379: transfer_pct NUMBER,
380: dep_routingstep_no PLS_INTEGER,
381: routingstep_no PLS_INTEGER,
2664: opr_stpdep_cursor := ' SELECT /*+ DRIVING_SITE(frd1) DRIVING_SITE(frd2) DRIVING_SITE(frdp) */ frdp.routing_id, '
2665: ||' ((frd2.routingstep_id * 2) + 1) x_dep_routingstep_id, '
2666: ||' ((frd1.routingstep_id * 2) + 1) x_routingstep_id, '
2667: ||' decode(frdp.dep_type,0,1,2) dependency_type, '
2668: ||' frdp.standard_delay, '
2669: ||' frdp.max_delay, '
2670: ||' frdp.transfer_pct, '
2671: ||' frdp.dep_routingstep_no, '
2672: ||' frdp.routingstep_no, '
5175: -- reverse_cumulative_yield,net_planning_percent, := null;
5176: -- setup_duration,tear_down_duration, := null ;
5177: /*B2870041*/
5178: opr_uom_code(opr_index) := formula_detail_tab(effectivity.product_index).aps_um ;
5179: -- standard_operation_code := null_value,
5180: opr_last_update_date(opr_index) := current_date_time ;
5181: opr_creation_date(opr_index) := current_date_time ;
5182:
5183: previous_id := rtg_org_dtl_tab(loop_index).routingstep_id;
5490: then loop thru the number of times the alternate resources are inserted
5491: and insert the Auxilary resources.
5492: This will take care of the combinations that has to come with the
5493: alternate resources. 1319610
5494: 08/10/00 - Bug# 1388757 Changed != to <> as per the Standards
5495: */
5496:
5497: statement_no := 130 ;
5498: IF ( rtg_org_dtl_tab(loop_index).prim_rsrc_ind <> 1) AND
7156: setup_duration,
7157: tear_down_duration,
7158: uom_code,
7159: organization_id,
7160: standard_operation_code,
7161: deleted_flag,
7162: last_update_date,
7163: last_updated_by,
7164: creation_date,
7942: opr_stpdep_to_seq_id(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).x_routingstep_id;
7943: opr_stpdep_routing_sequence_id(dep_index) := p_x_aps_fmeff_id ;
7944: opr_stpdep_dependency_type(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).dep_type;
7945: opr_stpdep_sr_instance_id(dep_index) := b_instance_id ;
7946: opr_stpdep_min_time_offset(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).standard_delay;
7947: opr_stpdep_max_time_offset(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).max_delay;
7948: opr_stpdep_trans_pct(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).transfer_pct;
7949: opr_stpdep_frm_op_seq_num(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).dep_routingstep_no;
7950: opr_stpdep_to_op_seq_num(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).routingstep_no;
10204: ||' decode(gbsd.dep_type,0,1,2) dependency_type, '
10205: ||' 1, '
10206: ||' :1, '
10207: ||' 2, '
10208: ||' gbsd.standard_delay, '
10209: ||' gbsd.max_delay, '
10210: ||' gbsd.transfer_percent, '
10211: ||' gbs1.batchstep_no, '
10212: ||' gbs2.batchstep_no, '
11904: * DESCRIPTION
11905: * This procedure is a wrapper for the preexisting sales_forecast procedure.
11906: * This version is set up with the proper parameters to be called as from the
11907: * concurrent manager. In addition, the main difference is the table into
11908: * which demands are inserted. The standard procedure inserts into
11909: * msc_st_demands.
11910: * This new procedure inserts into gmp_demands_api. The difference between
11911: * the two tables is the addition of a schedule_id column in
11912: * gmp_demands_api. Also, this version of sales_forecast begins by
12619: ||' ''CLASS'',2, '
12620: ||' ''CONFIG'',4, '
12621: ||' ''MODEL'',1, '
12622: ||' ''OPTION'' ,3, '
12623: ||' ''STANDARD'',6, -1), 1, ool.inventory_item_id, NULL) ORDERED_ITEM_ID, '
12624: ||' decode(ool.ORIGINAL_INVENTORY_ITEM_ID,-1,to_number(null), '
12625: ||' decode(ool.ITEM_RELATIONSHIP_TYPE,-1,to_number(null), '
12626: ||' 2, ool.ORIGINAL_INVENTORY_ITEM_ID, '
12627: ||' null,ool.ORIGINAL_INVENTORY_ITEM_ID, '
12801: ||' ''CLASS'',2, '
12802: ||' ''CONFIG'',4, '
12803: ||' ''MODEL'',1, '
12804: ||' ''OPTION'' ,3, '
12805: ||' ''STANDARD'',6, -1), 1, ool.inventory_item_id, NULL) ORDERED_ITEM_ID, '
12806: ||' decode(ool.ORIGINAL_INVENTORY_ITEM_ID,-1,to_number(null), '
12807: ||' decode(ool.ITEM_RELATIONSHIP_TYPE,-1,to_number(null), '
12808: ||' 2, ool.ORIGINAL_INVENTORY_ITEM_ID, '
12809: ||' null,ool.ORIGINAL_INVENTORY_ITEM_ID, '