[Home] [Help]
382: routing_id PLS_INTEGER,
383: x_dep_routingstep_id PLS_INTEGER,
384: x_routingstep_id PLS_INTEGER,
385: dep_type PLS_INTEGER,
386: standard_delay NUMBER,
387: max_delay NUMBER,
388: transfer_pct NUMBER,
389: dep_routingstep_no PLS_INTEGER,
390: routingstep_no PLS_INTEGER,
2260: opr_stpdep_cursor := ' SELECT frdp.routing_id, '
2261: ||' ((frd2.routingstep_id * 2) + 1) x_dep_routingstep_id, '
2262: ||' ((frd1.routingstep_id * 2) + 1) x_routingstep_id, '
2263: ||' decode(frdp.dep_type,0,1,2) dependency_type, '
2264: ||' frdp.standard_delay, '
2265: ||' frdp.max_delay, '
2266: ||' frdp.transfer_pct, '
2267: ||' frdp.dep_routingstep_no, '
2268: ||' frdp.routingstep_no, '
4745: -- reverse_cumulative_yield,net_planning_percent, := null;
4746: -- setup_duration,tear_down_duration, := null ;
4747: /*B2870041*/
4748: opr_uom_code(opr_index) := formula_detail_tab(effectivity.product_index).primary_uom_code ;
4749: -- standard_operation_code := null_value,
4750: opr_last_update_date(opr_index) := current_date_time ;
4751: opr_creation_date(opr_index) := current_date_time ;
4752:
4753: previous_id := rtg_org_dtl_tab(loop_index).routingstep_id;
5083: then loop thru the number of times the alternate resources are inserted
5084: and insert the Auxilary resources.
5085: This will take care of the combinations that has to come with the
5086: alternate resources. 1319610
5087: 08/10/00 - Bug# 1388757 Changed != to <> as per the Standards
5088: */
5089:
5090: statement_no := 130 ;
5091: IF ( rtg_org_dtl_tab(loop_index).prim_rsrc_ind <> 1) AND
5920: i_param_4 IN VARCHAR2
5921: )
5922: IS
5923: BEGIN
5924: /* This is temporary, AOL standards for error reporting will be needed */
5925: RAISE_APPLICATION_ERROR ( i_error_id, i_error_code );
5926: END Report_Error;
5927:
5928: /*
6383: setup_duration,
6384: tear_down_duration,
6385: uom_code,
6386: organization_id,
6387: standard_operation_code,
6388: deleted_flag,
6389: last_update_date,
6390: last_updated_by,
6391: creation_date,
6975: opr_stpdep_to_seq_id(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).x_routingstep_id;
6976: opr_stpdep_routing_sequence_id(dep_index) := p_x_aps_fmeff_id ;
6977: opr_stpdep_dependency_type(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).dep_type;
6978: opr_stpdep_sr_instance_id(dep_index) := instance_id ;
6979: opr_stpdep_min_time_offset(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).standard_delay;
6980: opr_stpdep_max_time_offset(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).max_delay;
6981: opr_stpdep_trans_pct(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).transfer_pct;
6982: opr_stpdep_frm_op_seq_num(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).dep_routingstep_no;
6983: opr_stpdep_to_op_seq_num(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).routingstep_no;