[Home] [Help]
387: routing_id PLS_INTEGER,
388: x_dep_routingstep_id PLS_INTEGER,
389: x_routingstep_id PLS_INTEGER,
390: dep_type PLS_INTEGER,
391: standard_delay NUMBER,
392: max_delay NUMBER,
393: transfer_pct NUMBER,
394: dep_routingstep_no PLS_INTEGER,
395: routingstep_no PLS_INTEGER,
2512: ||' frdp.routing_id, '
2513: ||' ((frd2.routingstep_id * 2) + 1) x_dep_routingstep_id, '
2514: ||' ((frd1.routingstep_id * 2) + 1) x_routingstep_id, '
2515: ||' decode(frdp.dep_type,0,1,2) dependency_type, '
2516: ||' frdp.standard_delay, '
2517: ||' frdp.max_delay, '
2518: ||' frdp.transfer_pct, '
2519: ||' frdp.dep_routingstep_no, '
2520: ||' frdp.routingstep_no, '
5261: -- reverse_cumulative_yield,net_planning_percent, := null;
5262: -- setup_duration,tear_down_duration, := null ;
5263: /*B2870041*/
5264: opr_uom_code(opr_index) := formula_detail_tab(effectivity.product_index).primary_uom_code ;
5265: -- standard_operation_code := null_value,
5266: opr_last_update_date(opr_index) := current_date_time ;
5267: opr_creation_date(opr_index) := current_date_time ;
5268:
5269: previous_id := rtg_org_dtl_tab(loop_index).routingstep_id;
5599: then loop thru the number of times the alternate resources are inserted
5600: and insert the Auxilary resources.
5601: This will take care of the combinations that has to come with the
5602: alternate resources. 1319610
5603: 08/10/00 - Bug# 1388757 Changed != to <> as per the Standards
5604: */
5605:
5606: statement_no := 130 ;
5607: IF ( rtg_org_dtl_tab(loop_index).prim_rsrc_ind <> 1) AND
6460: i_param_4 IN VARCHAR2
6461: )
6462: IS
6463: BEGIN
6464: /* This is temporary, AOL standards for error reporting will be needed */
6465: RAISE_APPLICATION_ERROR ( i_error_id, i_error_code );
6466: END Report_Error;
6467:
6468: /*
6927: setup_duration,
6928: tear_down_duration,
6929: uom_code,
6930: organization_id,
6931: standard_operation_code,
6932: deleted_flag,
6933: last_update_date,
6934: last_updated_by,
6935: creation_date,
7770: opr_stpdep_to_seq_id(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).x_routingstep_id;
7771: opr_stpdep_routing_sequence_id(dep_index) := p_x_aps_fmeff_id ;
7772: opr_stpdep_dependency_type(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).dep_type;
7773: opr_stpdep_sr_instance_id(dep_index) := instance_id ;
7774: opr_stpdep_min_time_offset(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).standard_delay;
7775: opr_stpdep_max_time_offset(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).max_delay;
7776: opr_stpdep_trans_pct(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).transfer_pct;
7777: opr_stpdep_frm_op_seq_num(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).dep_routingstep_no;
7778: opr_stpdep_to_op_seq_num(dep_index) := gmp_opr_stpdep_tbl(stpdp_cnt).routingstep_no;