[Home] [Help]
382: routing_id NUMBER ,
383: x_dep_routingstep_id NUMBER ,
384: x_routingstep_id NUMBER ,
385: dep_type NUMBER ,
386: standard_delay NUMBER,
387: max_delay NUMBER,
388: transfer_pct NUMBER,
389: dep_routingstep_no NUMBER ,
390: routingstep_no NUMBER ,
2483: opr_stpdep_cursor := ' SELECT frdp.routing_id, '
2484: ||' ((frd2.routingstep_id * 2) + 1) x_dep_routingstep_id, '
2485: ||' ((frd1.routingstep_id * 2) + 1) x_routingstep_id, '
2486: ||' decode(frdp.dep_type,0,1,2) dependency_type, '
2487: ||' frdp.standard_delay, '
2488: ||' frdp.max_delay, '
2489: ||' frdp.transfer_pct, '
2490: ||' frdp.dep_routingstep_no, '
2491: ||' frdp.routingstep_no, '
4813: -- reverse_cumulative_yield,net_planning_percent, := null;
4814: -- setup_duration,tear_down_duration, := null ;
4815: /*B2870041*/
4816: opr_uom_code(opr_index) := formula_detail_tab(effectivity.product_index).aps_um ;
4817: -- standard_operation_code := null_value,
4818: opr_last_update_date(opr_index) := current_date_time ;
4819: opr_creation_date(opr_index) := current_date_time ;
4820:
4821: previous_id := rtg_org_dtl_tab(loop_index).routingstep_id;
5128: then loop thru the number of times the alternate resources are inserted
5129: and insert the Auxilary resources.
5130: This will take care of the combinations that has to come with the
5131: alternate resources. 1319610
5132: 08/10/00 - Bug# 1388757 Changed != to <> as per the Standards
5133: */
5134:
5135: statement_no := 130 ;
5136: IF ( rtg_org_dtl_tab(loop_index).prim_rsrc_ind <> 1) AND
6736: setup_duration,
6737: tear_down_duration,
6738: uom_code,
6739: organization_id,
6740: standard_operation_code,
6741: deleted_flag,
6742: last_update_date,
6743: last_updated_by,
6744: creation_date,
7464: opr_stpdep_to_seq_id(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).x_routingstep_id;
7465: opr_stpdep_routing_sequence_id(dep_index) := p_x_aps_fmeff_id ;
7466: opr_stpdep_dependency_type(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).dep_type;
7467: opr_stpdep_sr_instance_id(dep_index) := b_instance_id ;
7468: opr_stpdep_min_time_offset(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).standard_delay;
7469: opr_stpdep_max_time_offset(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).max_delay;
7470: opr_stpdep_trans_pct(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).transfer_pct;
7471: opr_stpdep_frm_op_seq_num(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).dep_routingstep_no;
7472: opr_stpdep_to_op_seq_num(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).routingstep_no;
9563: ||' decode(gbsd.dep_type,0,1,2) dependency_type, '
9564: ||' 1, '
9565: ||' :1, '
9566: ||' 2, '
9567: ||' gbsd.standard_delay, '
9568: ||' gbsd.max_delay, '
9569: ||' gbsd.transfer_percent, '
9570: ||' gbs1.batchstep_no, '
9571: ||' gbs2.batchstep_no, '
11154: * DESCRIPTION
11155: * This procedure is a wrapper for the preexisting sales_forecast procedure.
11156: * This version is set up with the proper parameters to be called as from the
11157: * concurrent manager. In addition, the main difference is the table into
11158: * which demands are inserted. The standard procedure inserts into
11159: * msc_st_demands.
11160: * This new procedure inserts into gmp_demands_api. The difference between
11161: * the two tables is the addition of a schedule_id column in
11162: * gmp_demands_api. Also, this version of sales_forecast begins by
11844: ||' ''CLASS'',2, '
11845: ||' ''CONFIG'',4, '
11846: ||' ''MODEL'',1, '
11847: ||' ''OPTION'' ,3, '
11848: ||' ''STANDARD'',6, -1), 1, ool.inventory_item_id, NULL) ORDERED_ITEM_ID, '
11849: ||' decode(ool.ORIGINAL_INVENTORY_ITEM_ID,-1,to_number(null), '
11850: ||' decode(ool.ITEM_RELATIONSHIP_TYPE,-1,to_number(null), '
11851: ||' 2, ool.ORIGINAL_INVENTORY_ITEM_ID, '
11852: ||' null,ool.ORIGINAL_INVENTORY_ITEM_ID, '
12023: ||' ''CLASS'',2, '
12024: ||' ''CONFIG'',4, '
12025: ||' ''MODEL'',1, '
12026: ||' ''OPTION'' ,3, '
12027: ||' ''STANDARD'',6, -1), 1, ool.inventory_item_id, NULL) ORDERED_ITEM_ID, '
12028: ||' decode(ool.ORIGINAL_INVENTORY_ITEM_ID,-1,to_number(null), '
12029: ||' decode(ool.ITEM_RELATIONSHIP_TYPE,-1,to_number(null), '
12030: ||' 2, ool.ORIGINAL_INVENTORY_ITEM_ID, '
12031: ||' null,ool.ORIGINAL_INVENTORY_ITEM_ID, '