[Home] [Help]
395: /* Start : fields added to add resource */
396: type t_wljdi_department_id is table of wsm_lot_job_dtl_interface.department_id %type;
397: type t_wljdi_department_code is table of wsm_lot_job_dtl_interface.department_code %type;
398: type t_wljdi_activity_id is table of wsm_lot_job_dtl_interface.activity_id %type;
399: type t_wljdi_standard_rate_flag is table of wsm_lot_job_dtl_interface.standard_rate_flag %type;
400: type t_wljdi_usage_rate_or_amt is table of wsm_lot_job_dtl_interface.usage_rate_or_amount %type;
401:
402: type t_wljdi_basis_type is table of wsm_lot_job_dtl_interface.basis_type %type;
403: type t_wljdi_uom_code is table of wsm_lot_job_dtl_interface.uom_code %type;
424: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
425:
426: -- Added For LBJ Interface Alcoa Enhancement
427: type t_wljdi_recommended is table of wsm_lot_job_dtl_interface.recommended %type;
428: type t_wljdi_std_op_code is table of wsm_lot_job_dtl_interface.standard_operation_code %type;
429: type t_wljdi_std_op_id is table of wsm_lot_job_dtl_interface.standard_operation_id %type;
430: type t_wljdi_op_yield_enable is table of wsm_lot_job_dtl_interface.operation_yield_enabled %type;
431: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
432: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
425:
426: -- Added For LBJ Interface Alcoa Enhancement
427: type t_wljdi_recommended is table of wsm_lot_job_dtl_interface.recommended %type;
428: type t_wljdi_std_op_code is table of wsm_lot_job_dtl_interface.standard_operation_code %type;
429: type t_wljdi_std_op_id is table of wsm_lot_job_dtl_interface.standard_operation_id %type;
430: type t_wljdi_op_yield_enable is table of wsm_lot_job_dtl_interface.operation_yield_enabled %type;
431: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
432: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
433: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
443: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
444: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
445: type t_wljdi_supply_locator_id is table of wsm_lot_job_dtl_interface.supply_locator_id %type;
446: type t_wljdi_applied_resource_units is table of wsm_lot_job_dtl_interface.applied_resource_units %type;
447: type t_desc is table of bom_standard_operations.operation_description%type index by binary_integer;
448: type t_op_code is table of bom_standard_operations.operation_code%type index by binary_integer;
449:
450: /*Added below two types for bugfix:7248992 */
451: type t_wljdi_cum_yield is table of wsm_lot_job_dtl_interface.cumulative_yield %type;
444: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
445: type t_wljdi_supply_locator_id is table of wsm_lot_job_dtl_interface.supply_locator_id %type;
446: type t_wljdi_applied_resource_units is table of wsm_lot_job_dtl_interface.applied_resource_units %type;
447: type t_desc is table of bom_standard_operations.operation_description%type index by binary_integer;
448: type t_op_code is table of bom_standard_operations.operation_code%type index by binary_integer;
449:
450: /*Added below two types for bugfix:7248992 */
451: type t_wljdi_cum_yield is table of wsm_lot_job_dtl_interface.cumulative_yield %type;
452: type t_wljdi_rev_cum_yield is table of wsm_lot_job_dtl_interface.reverse_cumulative_yield %type;
522: /* Start : changes for adding resource ... */
523: v_wljdi_department_id t_wljdi_department_id := t_wljdi_department_id();
524: v_wljdi_department_code t_wljdi_department_code := t_wljdi_department_code();
525: v_wljdi_activity_id t_wljdi_activity_id := t_wljdi_activity_id();
526: v_wljdi_standard_rate_flag t_wljdi_standard_rate_flag := t_wljdi_standard_rate_flag();
527: v_wljdi_usage_rate_or_amt t_wljdi_usage_rate_or_amt := t_wljdi_usage_rate_or_amt();
528:
529: v_wljdi_basis_type t_wljdi_basis_type := t_wljdi_basis_type();
530: v_wljdi_uom_code t_wljdi_uom_code := t_wljdi_uom_code();
635: res_seq_num NUMBER,
636: sub_grp_num NUMBER,
637: rpl_grp_num NUMBER,
638: activity_id NUMBER,
639: standard_rate_flag NUMBER,
640: assigned_units NUMBER,
641: usage_rate_or_amount NUMBER,
642: usage_rate_or_amount_inverse NUMBER,
643: uom_code VARCHAR2(3),
688: basis_type NUMBER,
689: activity_id NUMBER,
690: schedule_seq_num NUMBER,
691: reco_flag VARCHAR2(1),
692: standard_rate NUMBER,
693: resource_code VARCHAR2(10)
694: );
695: type t_op_res is table of rec_op_res index by binary_integer;
696:
1288: department_code ,
1289: -- ST : Detailed Scheduling : Added for resource adding changes : end
1290: -- Added For LBJ Interface Alcoa Enhancement
1291: recommended,
1292: standard_operation_code,
1293: standard_operation_id,
1294: operation_yield_enabled,
1295: minimum_transfer_quantity,
1296: backflush_flag,
1289: -- ST : Detailed Scheduling : Added for resource adding changes : end
1290: -- Added For LBJ Interface Alcoa Enhancement
1291: recommended,
1292: standard_operation_code,
1293: standard_operation_id,
1294: operation_yield_enabled,
1295: minimum_transfer_quantity,
1296: backflush_flag,
1297: count_point_type,
1360: department_code ,
1361: /* ST : Detailed Scheduling : Added for resource adding changes : end */
1362: -- Added For LBJ Interface Alcoa Enhancement
1363: recommended,
1364: standard_operation_code,
1365: standard_operation_id,
1366: operation_yield_enabled,
1367: minimum_transfer_quantity,
1368: backflush_flag,
1361: /* ST : Detailed Scheduling : Added for resource adding changes : end */
1362: -- Added For LBJ Interface Alcoa Enhancement
1363: recommended,
1364: standard_operation_code,
1365: standard_operation_id,
1366: operation_yield_enabled,
1367: minimum_transfer_quantity,
1368: backflush_flag,
1369: count_point_type,
2193:
2194: -- Added For LBJ Interface Alcoa Enhancement
2195: if (l_sub_type = WSM_SUB_ADD) then
2196:
2197: -- This code Defaults Standard operation Id.
2198: if (v_wljdi_std_op_code(l_d) is not null) then
2199: begin
2200: select standard_operation_id
2201: into v_wljdi_std_op_id(l_d)
2196:
2197: -- This code Defaults Standard operation Id.
2198: if (v_wljdi_std_op_code(l_d) is not null) then
2199: begin
2200: select standard_operation_id
2201: into v_wljdi_std_op_id(l_d)
2202: from bom_standard_operations
2203: where organization_id = p_org_id
2204: and operation_code = v_wljdi_std_op_code(l_d)
2198: if (v_wljdi_std_op_code(l_d) is not null) then
2199: begin
2200: select standard_operation_id
2201: into v_wljdi_std_op_id(l_d)
2202: from bom_standard_operations
2203: where organization_id = p_org_id
2204: and operation_code = v_wljdi_std_op_code(l_d)
2205: and standard_operation_id = nvl(v_wljdi_std_op_id(l_d),standard_operation_id);
2206: exception
2201: into v_wljdi_std_op_id(l_d)
2202: from bom_standard_operations
2203: where organization_id = p_org_id
2204: and operation_code = v_wljdi_std_op_code(l_d)
2205: and standard_operation_id = nvl(v_wljdi_std_op_id(l_d),standard_operation_id);
2206: exception
2207: when others then
2208: raise e_inv_std_op;
2209: end;
2213: v_wljdi_std_op_code(l_d) is null) then
2214: begin
2215: select operation_code
2216: into v_wljdi_std_op_code(l_d)
2217: from bom_standard_operations
2218: where organization_id = p_org_id
2219: and standard_operation_id = v_wljdi_std_op_id(l_d);
2220: exception
2221: when others then
2215: select operation_code
2216: into v_wljdi_std_op_code(l_d)
2217: from bom_standard_operations
2218: where organization_id = p_org_id
2219: and standard_operation_id = v_wljdi_std_op_id(l_d);
2220: exception
2221: when others then
2222: raise e_inv_std_op;
2223: end;
2241: v_wljdi_backflush_flag(l_d),
2242: v_wljdi_op_yield_enable(l_d),
2243: v_wljdi_option_dep_flag(l_d),
2244: v_wljdi_inc_in_rollup(l_d)
2245: from bom_standard_operations
2246: where standard_operation_id = v_wljdi_std_op_id(l_d)
2247: and organization_id = p_org_id;
2248: exception
2249: when others then
2242: v_wljdi_op_yield_enable(l_d),
2243: v_wljdi_option_dep_flag(l_d),
2244: v_wljdi_inc_in_rollup(l_d)
2245: from bom_standard_operations
2246: where standard_operation_id = v_wljdi_std_op_id(l_d)
2247: and organization_id = p_org_id;
2248: exception
2249: when others then
2250: raise e_inv_std_op;
2603: department_id = nvl(l_v_dept_id(i),department_id),
2604: setup_id = l_v_setup_id(i), -- Added for bug fix 4704289
2605: /* ST : Detailed Scheduling end */
2606: -- Added For LBJ Interface Alcoa Enhancement
2607: standard_operation_id = l_v_std_op_id(i),
2608: operation_start_date = l_v_op_start_date(i),
2609: operation_completion_date = l_v_op_completion_date(i),
2610: minimum_transfer_quantity = l_v_min_trf_qty(i),
2611: count_point_type = l_v_count_point_type(i),
2613: backflush_flag = l_v_backflush_flag(i),
2614: operation_yield_enabled = l_v_op_yield_enable(i),
2615: option_dependent_flag = l_v_option_dep_flag(i),
2616: include_in_rollup = l_v_inc_in_rollup(i),
2617: standard_operation_code = l_v_std_op_code(i),
2618: recommended = l_v_recommended(i),
2619: inventory_item_id_old = l_v_item_old_id(i)
2620: where record_id = l_v_record_id(i);
2621:
2726: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2727: || p_error_msg, 1, 2000));
2728: when e_inv_std_op then
2729: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2730: fnd_message.set_token('FLD_NAME', 'standard_operation_id/standard_operation_code combination');
2731: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2732: p_error_code := -1;
2733: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2734: when e_invalid_min_trf_qty then
3167: l_res_unit_of_measure varchar2(3);
3168: l_res_default_basis_type number;
3169: l_res_default_activity_id number;
3170: l_res_autocharge_type number;
3171: l_res_standard_rate_flag number;
3172: l_res_batchable number;
3173: l_check_primary number;
3174: e_res_id_null exception;
3175: e_assgnd_units_null exception;
3844: select unit_of_measure,
3845: default_basis_type,
3846: default_activity_id,
3847: autocharge_type,
3848: standard_rate_flag,
3849: batchable,
3850: resource_code
3851: into l_res_unit_of_measure,
3852: l_res_default_basis_type,
3851: into l_res_unit_of_measure,
3852: l_res_default_basis_type,
3853: l_res_default_activity_id,
3854: l_res_autocharge_type,
3855: l_res_standard_rate_flag,
3856: l_res_batchable,
3857: l_res_code
3858: from bom_resources
3859: where resource_id=l_resource_id
4207: end if;
4208:
4209: p_v_res(l_i).res_seq_num := l_res_seq_num;
4210: p_v_res(l_i).autocharge_type := l_res_autocharge_type;
4211: p_v_res(l_i).standard_rate := nvl(l_res_standard_rate_flag,1);
4212: p_v_res(l_i).activity_id := l_activity_id;
4213: p_v_res(l_i).basis_type := l_basis_type ;
4214: p_v_res(l_i).uom_code := l_res_unit_of_measure;
4215: p_v_res(l_i).scheduled_flag := l_sch_flag;
5802: end if;
5803: end if; --p_handle_wip_cur_op end if
5804: ELSIF (p_substitution_type=WSM_SUB_ADD) THEN
5805:
5806: -- For a standard job, assembly should not be a component.
5807: begin
5808: select 1
5809: into l_comp_exist
5810: from dual
5811: where exists ( select 1
5812: from wip_discrete_jobs
5813: where wip_entity_id = p_wip_entity_id
5814: and organization_id = p_org_id
5815: and job_type = WIP_CONSTANTS.STANDARD
5816: and primary_item_id = l_item_id );
5817:
5818: raise e_no_assy_as_comp;
5819:
7465: GOTO skip_validate_constants;
7466: end if;
7467:
7468: l_stmt_num := 85;
7469: -- Dafault: job_type = 3 is non-standard job. Anything else/null => standard job
7470: if (v_wlji_job_type(v_idx) is null) or (v_wlji_job_type(v_idx) <> 3) then
7471: v_wlji_job_type(v_idx) := 1;
7472: end if;
7473:
7471: v_wlji_job_type(v_idx) := 1;
7472: end if;
7473:
7474: l_stmt_num := 95;
7475: -- Validate: mode_flag cannot be 2 for non-standard jobs, can only be 1
7476: if v_wlji_job_type(v_idx) = 3 then
7477: if v_wlji_mode_flag(v_idx) = 2 then
7478: l_aux_mesg := 'Mode Flag cannot be 2 for non-standard jobs';
7479: handle_invalid_field('MODE FlAG', l_aux_mesg, l_stmt_num);
7474: l_stmt_num := 95;
7475: -- Validate: mode_flag cannot be 2 for non-standard jobs, can only be 1
7476: if v_wlji_job_type(v_idx) = 3 then
7477: if v_wlji_mode_flag(v_idx) = 2 then
7478: l_aux_mesg := 'Mode Flag cannot be 2 for non-standard jobs';
7479: handle_invalid_field('MODE FlAG', l_aux_mesg, l_stmt_num);
7480: l_error_code := -1;
7481: GOTO skip_validate_constants;
7482: else
8408: GOTO abort_this_job;
8409: end if;
8410: if lbji_debug = 'Y' then
8411: fnd_file.put_line(fnd_file.log,
8412: 'Validate Non-standard References.. OK.');
8413: end if;
8414:
8415: end if; -- non-standard validations end
8416: ------------------------------------------------
8411: fnd_file.put_line(fnd_file.log,
8412: 'Validate Non-standard References.. OK.');
8413: end if;
8414:
8415: end if; -- non-standard validations end
8416: ------------------------------------------------
8417: -- }}} End: Validation of a non-std job creation
8418: ------------------------------------------------
8419:
8417: -- }}} End: Validation of a non-std job creation
8418: ------------------------------------------------
8419:
8420: -----------------------------------------------------
8421: -- {{{ Begin: validations for standard job creations
8422: -----------------------------------------------------
8423: if v_wlji_job_type(v_idx) = 1 then
8424:
8425: l_stmt_num := 310;
8906: -- }} get revisions
8907:
8908: end if; -- job type =1
8909: -----------------------------------------------------
8910: -- }}} End: validations for standard job creations
8911: -----------------------------------------------------
8912:
8913: l_stmt_num := 380;
8914: -- {{ Validate Date_Released, job_type 1 and 3
9523: -- Validation added for Bug 4919218: End
9524: else
9525: if lbji_debug = 'Y' then
9526: fnd_file.put_line(fnd_file.log,
9527: 'Update BOM/Routing alternates for standard job..');
9528: end if;
9529: end if;
9530:
9531: end if; -- }} if std-job
9535:
9536: --------------------------------------------
9537: -- {{{ Begin: Update of references (non-std)
9538: --------------------------------------------
9539: -- Non standard job bom/routing reference update.
9540: -- The assumption is that this module will NOT update the
9541: -- qty/dates/etc.,they will be taken care in the later modules.
9542: -- This module will just look at the reference info, and assume
9543: -- qty/date/etc to be same as the old values.
9660:
9661: end if; -- }} old_status_type = 1
9662:
9663: -- user can update the bom_reference and the routing reference of a
9664: -- non-standard job only if the job is unreleased.
9665: if (l_chg_bom_ref = 1 or l_chg_rtg_ref = 1) and
9666: l_cur_status_type <> 1
9667: then
9668: fnd_file.put_line(fnd_file.log,
9684: v_wlji_alt_rtg(v_idx) := l_cur_alt_rtg;
9685: else
9686: if lbji_debug = 'Y' then
9687: fnd_file.put_line(fnd_file.log,
9688: 'Update BOM/Routing references for non-standard job..');
9689: end if;
9690: end if;
9691:
9692: end if; -- }} job type = 3
9738: end if;
9739:
9740: if l_chg_bom_rev = 1 then
9741: -- validate bom rev/rev_date
9742: if l_cur_job_type = 1 then -- standard job
9743: l_stmt_num:= 660.1;
9744: wip_revisions.bom_revision (
9745: v_wlji_org_id(v_idx),
9746: v_wlji_item_id(v_idx),
9761: end if;
9762:
9763: if l_chg_rtg_rev = 1 then
9764: -- validate rtg rev/rev_date
9765: if l_cur_job_type = 1 then -- standard job
9766: l_stmt_num:= 670.1;
9767: wip_revisions.routing_revision (
9768: v_wlji_org_id(v_idx),
9769: v_wlji_item_id(v_idx),
13639: (BR.unit_of_measure),
13640: nvl(p_new_res_tbl(l_index).basis_type,BR.default_basis_type),
13641: uom.uom_class,
13642: br.batchable,
13643: nvl(BR.standard_rate_flag,2)
13644: into p_new_res_tbl(l_index).autocharge_type,
13645: p_new_res_tbl(l_index).uom_code,
13646: p_new_res_tbl(l_index).basis_type,
13647: l_uom_class,
13645: p_new_res_tbl(l_index).uom_code,
13646: p_new_res_tbl(l_index).basis_type,
13647: l_uom_class,
13648: l_batchable,
13649: p_new_res_tbl(l_index).standard_rate_flag
13650: from bom_resources BR,
13651: mtl_units_of_measure_vl uom
13652: where br.resource_id = p_new_res_tbl(l_index).resource_id
13653: and autocharge_type = nvl(p_new_res_tbl(l_index).autocharge_type,autocharge_type)
13652: where br.resource_id = p_new_res_tbl(l_index).resource_id
13653: and autocharge_type = nvl(p_new_res_tbl(l_index).autocharge_type,autocharge_type)
13654: and nvl(p_new_res_tbl(l_index).uom_code,br.unit_of_measure) = br.unit_of_measure -- uom.uom_code
13655: and br.unit_of_measure = uom.uom_code
13656: and nvl(BR.standard_rate_flag,-1) = nvl(nvl(p_new_res_tbl(l_index).standard_rate_flag,BR.standard_rate_flag),-1);
13657:
13658: EXCEPTION
13659: WHEN NO_DATA_FOUND THEN
13660: l_field_name := 'Resource Information';
13980: -- Now copy the values derived into the global table also..
13981: v_wljdi_uom_code(l_index) := p_new_res_tbl(l_index).uom_code;
13982: v_wljdi_basis_type(l_index) := p_new_res_tbl(l_index).basis_type;
13983: v_wljdi_res_autocharge_type(l_index) := p_new_res_tbl(l_index).autocharge_type;
13984: v_wljdi_standard_rate_flag(l_index) := p_new_res_tbl(l_index).standard_rate_flag;
13985: v_wljdi_department_id(l_index) := p_new_res_tbl(l_index).dept_id;
13986:
13987: l_index := p_new_res_tbl.next(l_index);
13988:
14214: l_new_res_tbl(l_temp).res_seq_num := v_wljdi_resource_seq_num(l_temp);
14215: l_new_res_tbl(l_temp).sub_grp_num := v_wljdi_substitute_group_num(l_temp);
14216: l_new_res_tbl(l_temp).rpl_grp_num := v_wljdi_replacement_group_num(l_temp);
14217: l_new_res_tbl(l_temp).activity_id := v_wljdi_activity_id(l_temp);
14218: l_new_res_tbl(l_temp).standard_rate_flag := v_wljdi_standard_rate_flag(l_temp);
14219: l_new_res_tbl(l_temp).assigned_units := v_wljdi_assigned_units(l_temp);
14220: l_new_res_tbl(l_temp).usage_rate_or_amount := v_wljdi_usage_rate_or_amt(l_temp);
14221: l_new_res_tbl(l_temp).usage_rate_or_amount_inverse := 0; /* calculate it shiva ..... */
14222: l_new_res_tbl(l_temp).uom_code := v_wljdi_uom_code(l_temp);
14269: l_new_res_tbl(l_temp).res_seq_num := v_wljdi_resource_seq_num(l_temp);
14270: l_new_res_tbl(l_temp).sub_grp_num := v_wljdi_substitute_group_num(l_temp);
14271: l_new_res_tbl(l_temp).rpl_grp_num := v_wljdi_replacement_group_num(l_temp);
14272: l_new_res_tbl(l_temp).activity_id := v_wljdi_activity_id(l_temp);
14273: l_new_res_tbl(l_temp).standard_rate_flag := v_wljdi_standard_rate_flag(l_temp);
14274: l_new_res_tbl(l_temp).assigned_units := v_wljdi_assigned_units(l_temp);
14275: l_new_res_tbl(l_temp).usage_rate_or_amount := v_wljdi_usage_rate_or_amt(l_temp);
14276: l_new_res_tbl(l_temp).usage_rate_or_amount_inverse := 0; /* calculate it shiva ..... */
14277: l_new_res_tbl(l_temp).uom_code := v_wljdi_uom_code(l_temp);
14365: group_sequence_number,
14366: parent_resource_seq,
14367:
14368: autocharge_type,
14369: standard_rate_flag,
14370: applied_resource_units,
14371: applied_resource_value,
14372: start_date,
14373: completion_date,
14431: v_wljdi_grp_seq_num(i),
14432: v_wljdi_parent_seq_num(i),
14433:
14434: v_wljdi_res_autocharge_type(i),
14435: v_wljdi_standard_rate_flag(i),
14436: 0,
14437: 0,
14438: v_wljdi_start_date(i),
14439: v_wljdi_completion_date(i),
14549: group_sequence_num,
14550: parent_resource_seq_num,
14551:
14552: autocharge_type,
14553: standard_rate_flag,
14554: reco_start_date,
14555: reco_completion_date,
14556:
14557: attribute_category,
14615: v_wljdi_grp_seq_num(i),
14616: v_wljdi_parent_seq_num(i),
14617:
14618: v_wljdi_res_autocharge_type(i),
14619: v_wljdi_standard_rate_flag(i),
14620: v_wljdi_start_date(i),
14621: v_wljdi_completion_date(i),
14622:
14623: v_wljdi_attribute_category(i),
14755:
14756: v_wljdi_department_id.delete(l_index);
14757: v_wljdi_department_code.delete(l_index);
14758: v_wljdi_activity_id.delete(l_index);
14759: v_wljdi_standard_rate_flag.delete(l_index);
14760: v_wljdi_usage_rate_or_amt.delete(l_index);
14761: v_wljdi_basis_type.delete(l_index);
14762: v_wljdi_uom_code.delete(l_index);
14763: v_wljdi_scheduled_flag.delete(l_index);
15047: /* ST : Detailed Scheduling : Added for resource adding changes */
15048: department_id ,
15049: department_code ,
15050: activity_id ,
15051: standard_rate_flag ,
15052: usage_rate_or_amount ,
15053: basis_type ,
15054: uom_code ,
15055: scheduled_flag ,
15073: attribute15 ,
15074: /* ST : Detailed Scheduling : Added for resource adding changes : end */
15075: -- Added For LBJ Interface Alcoa Enhancement
15076: recommended,
15077: standard_operation_code,
15078: standard_operation_id,
15079: operation_yield_enabled,
15080: minimum_transfer_quantity,
15081: backflush_flag,
15074: /* ST : Detailed Scheduling : Added for resource adding changes : end */
15075: -- Added For LBJ Interface Alcoa Enhancement
15076: recommended,
15077: standard_operation_code,
15078: standard_operation_id,
15079: operation_yield_enabled,
15080: minimum_transfer_quantity,
15081: backflush_flag,
15082: count_point_type,
15167: /* ST : Detailed Scheduling : Added for resource adding changes */
15168: department_id ,
15169: department_code ,
15170: activity_id ,
15171: standard_rate_flag ,
15172: usage_rate_or_amount ,
15173: --usage_rate_or_amount_inve ,
15174: basis_type ,
15175: uom_code ,
15199: attribute15 ,
15200: /* ST : Detailed Scheduling : Added for resource adding changes : end */
15201: -- Added For LBJ Interface Alcoa Enhancement
15202: recommended,
15203: standard_operation_code,
15204: standard_operation_id,
15205: operation_yield_enabled,
15206: minimum_transfer_quantity,
15207: backflush_flag,
15200: /* ST : Detailed Scheduling : Added for resource adding changes : end */
15201: -- Added For LBJ Interface Alcoa Enhancement
15202: recommended,
15203: standard_operation_code,
15204: standard_operation_id,
15205: operation_yield_enabled,
15206: minimum_transfer_quantity,
15207: backflush_flag,
15208: count_point_type,
15418: uom_code,
15419: basis_type,
15420: activity_id,
15421: autocharge_type,
15422: standard_rate_flag,
15423: start_date,
15424: completion_date,
15425: schedule_seq_num,
15426: substitute_group_num,
15445: supply_locator_id,
15446: mrp_net_flag,
15447: mps_required_quantity,
15448: mps_date_required,
15449: standard_operation_id,
15450: scheduled_quantity,
15451: operation_yield,
15452: operation_start_date,
15453: operation_completion_date,
15499: resource_hours,
15500: setup_code,
15501: cumulative_yield,
15502: reverse_cumulative_yield,
15503: standard_operation_code,
15504: operation_yield_enabled,
15505: include_in_rollup,
15506: option_dependent_flag,
15507: recommended)
15536: uom_code,
15537: basis_type,
15538: activity_id,
15539: autocharge_type,
15540: standard_rate_flag,
15541: start_date,
15542: completion_date,
15543: schedule_seq_num,
15544: substitute_group_num,
15563: supply_locator_id,
15564: mrp_net_flag,
15565: mps_required_quantity,
15566: mps_date_required,
15567: standard_operation_id,
15568: scheduled_quantity,
15569: operation_yield,
15570: operation_start_date,
15571: operation_completion_date,
15617: resource_hours,
15618: setup_code,
15619: cumulative_yield,
15620: reverse_cumulative_yield,
15621: standard_operation_code,
15622: operation_yield_enabled,
15623: include_in_rollup,
15624: option_dependent_flag,
15625: recommended
15764: v_wljdi_department_id := t_wljdi_department_id();
15765: v_wljdi_department_code := t_wljdi_department_code();
15766:
15767: v_wljdi_activity_id := t_wljdi_activity_id();
15768: v_wljdi_standard_rate_flag := t_wljdi_standard_rate_flag();
15769: v_wljdi_usage_rate_or_amt := t_wljdi_usage_rate_or_amt();
15770: v_wljdi_basis_type := t_wljdi_basis_type();
15771: v_wljdi_uom_code := t_wljdi_uom_code();
15772: v_wljdi_scheduled_flag := t_wljdi_scheduled_flag();
15865: /* ST : Detailed Scheduling : Considered for adding a resource */
15866: v_wljdi_department_id ,
15867: v_wljdi_department_code ,
15868: v_wljdi_activity_id ,
15869: v_wljdi_standard_rate_flag ,
15870: v_wljdi_usage_rate_or_amt ,
15871: v_wljdi_basis_type ,
15872: v_wljdi_uom_code ,
15873: v_wljdi_scheduled_flag ,
15965: /* ST : Detailed Scheduling : Considered for adding a resource */
15966: v_wljdi_department_id ,
15967: v_wljdi_department_code ,
15968: v_wljdi_activity_id ,
15969: v_wljdi_standard_rate_flag ,
15970: v_wljdi_usage_rate_or_amt ,
15971: v_wljdi_basis_type ,
15972: v_wljdi_uom_code ,
15973: v_wljdi_scheduled_flag ,
16137: RECO_COMPLETION_DATE,
16138: OPERATION_SEQUENCE_ID,
16139: ROUTING_SEQUENCE_ID,
16140: ORGANIZATION_ID,
16141: STANDARD_OPERATION_ID,
16142: STANDARD_OPERATION_CODE,
16143: DEPARTMENT_ID,
16144: DEPARTMENT_CODE,
16145: SCRAP_ACCOUNT,
16138: OPERATION_SEQUENCE_ID,
16139: ROUTING_SEQUENCE_ID,
16140: ORGANIZATION_ID,
16141: STANDARD_OPERATION_ID,
16142: STANDARD_OPERATION_CODE,
16143: DEPARTMENT_ID,
16144: DEPARTMENT_CODE,
16145: SCRAP_ACCOUNT,
16146: EST_ABSORPTION_ACCOUNT,
16290: into l_temp
16291: from dual
16292: where exists ( SELECT 1
16293: FROM bom_std_op_resources bsor
16294: WHERE bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16295: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE)
16296: or exists ( SELECT 1
16297: FROM bom_std_sub_op_resources bsor
16298: WHERE bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16294: WHERE bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16295: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE)
16296: or exists ( SELECT 1
16297: FROM bom_std_sub_op_resources bsor
16298: WHERE bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16299: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE);
16300: if l_temp=1 then
16301: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');
16302: p_error_msg := fnd_message.get;
16312: p_error_code := - 1;
16313: raise e_wljdi_common_error;
16314: end;
16315: l_temp :=0;
16316: -- This insert statement adds primary resources for standard operation.
16317:
16318: INSERT INTO WSM_COPY_OP_RESOURCES
16319: (wip_entity_id,
16320: operation_seq_num,
16331: phantom_flag,
16332: phantom_op_seq_num,
16333: phantom_item_id,
16334: activity_id,
16335: standard_rate_flag,
16336: assigned_units,
16337: max_assigned_units,
16338: firm_type,
16339: usage_rate_or_amount,
16391: null,
16392: null,
16393: null,
16394: bsor.activity_id,
16395: bsor.standard_rate_flag,
16396: bsor.assigned_units,
16397: bsor.assigned_units,
16398: 0, -- Unfirmed
16399: bsor.usage_rate_or_amount,
16436: null
16437: from wsm_copy_operations wco,
16438: bom_resources br,
16439: bom_std_op_resources bsor
16440: where bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16441: and br.resource_id = bsor.resource_id
16442: and nvl(br.disable_date, SYSDATE + 1) > SYSDATE
16443: and wco.organization_id = p_org_id
16444: and wco.wip_entity_id = p_wip_entity_id
16443: and wco.organization_id = p_org_id
16444: and wco.wip_entity_id = p_wip_entity_id
16445: and wco.operation_seq_num = v_wljdi_routing_op_seq_num(l_d);
16446:
16447: -- This insert statement adds substitute resources for standard operation.
16448:
16449: INSERT INTO WSM_COPY_OP_RESOURCES
16450: (wip_entity_id,
16451: operation_seq_num,
16462: phantom_flag,
16463: phantom_op_seq_num,
16464: phantom_item_id,
16465: activity_id,
16466: standard_rate_flag,
16467: assigned_units,
16468: max_assigned_units,
16469: firm_type,
16470: usage_rate_or_amount,
16522: null,
16523: null,
16524: null,
16525: bsor.activity_id,
16526: bsor.standard_rate_flag,
16527: bsor.assigned_units,
16528: bsor.assigned_units,
16529: 0, -- Unfirmed
16530: bsor.usage_rate_or_amount,
16568: from wsm_copy_operations wco,
16569: bom_resources br,
16570: bom_std_sub_op_resources bsor,
16571: wsm_copy_op_resources wcor
16572: where bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16573: and br.resource_id = bsor.resource_id
16574: and nvl(br.disable_date, SYSDATE + 1) > SYSDATE
16575: and wco.organization_id = p_org_id
16576: and wco.wip_entity_id = p_wip_entity_id
16576: and wco.wip_entity_id = p_wip_entity_id
16577: and wco.operation_seq_num = v_wljdi_routing_op_seq_num(l_d)
16578: and exists (select 1
16579: from bom_std_op_resources bsor1
16580: where bsor1.standard_operation_id = bsor.standard_operation_id
16581: and bsor1.substitute_group_num = bsor.substitute_group_num )
16582: and wcor.wip_entity_id = wco.wip_entity_id
16583: and wcor.operation_seq_num = wco.operation_seq_num
16584: and wcor.resource_seq_num = (select max(resource_seq_num)
17842: group_sequence_id,
17843: group_sequence_number,
17844: parent_resource_seq,
17845: autocharge_type,
17846: standard_rate_flag,
17847: applied_resource_units,
17848: applied_resource_value,
17849: start_date,
17850: completion_date,
17897: v_wljdi_grp_seq_id(l_d),
17898: v_wljdi_grp_seq_num(l_d),
17899: null,
17900: l_v_res(l_resource_id).autocharge_type,
17901: l_v_res(l_resource_id).standard_rate,
17902: 0,
17903: 0,
17904: l_v_res(l_resource_id).start_date,
17905: l_v_res(l_resource_id).completion_date,
17967: scheduled_flag,
17968: assigned_units,
17969: maximum_assigned_units,
17970: autocharge_type,
17971: standard_rate_flag,
17972: applied_resource_units,
17973: applied_resource_value,
17974: attribute_category,
17975: attribute1,
18017: l_v_res(l_resource_id).scheduled_flag,
18018: v_wljdi_assigned_units(l_d),
18019: l_v_res(l_resource_id).max_assg_units,
18020: l_v_res(l_resource_id).autocharge_type,
18021: l_v_res(l_resource_id).standard_rate,
18022: 0,
18023: 0,
18024: v_wljdi_attribute_category(l_d),
18025: v_wljdi_attribute1(l_d),
18153: phantom_flag,
18154: phantom_op_seq_num,
18155: phantom_item_id,
18156: activity_id,
18157: standard_rate_flag,
18158: assigned_units,
18159: max_assigned_units,
18160: firm_type,
18161: usage_rate_or_amount,
18213: null,
18214: null,
18215: null,
18216: l_v_res(l_resource_id).activity_id,
18217: l_v_res(l_resource_id).standard_rate,
18218: v_wljdi_assigned_units(l_d),
18219: l_v_res(l_resource_id).max_assg_units,
18220: l_v_res(l_resource_id).firm_type,
18221: v_wljdi_usage_rate_or_amt(l_d),
20291: 0, -- Since it's not a planned component
20292: 2, -- No quantity relation
20293: 1, -- Include in cost rollup
20294: 2, -- No ATP
20295: 4, -- Standard component
20296: v_wljdi_recommended(l_d),
20297: l_v_comp(l_in).date_required,
20298: wco.department_id,
20299: p_org_id,
21814: p_item,
21815: decode(p_job_type, 3, p_bom_reference_id, null),
21816: decode(p_job_type, 3, p_routing_reference_id, null),
21817: p_firm_planned_flag,
21818: decode(p_job_type, 3, wip_constants.nonstandard, wip_constants.standard),
21819: p_wip_supply_type,
21820: p_class_code,
21821: l_material_account,
21822: l_material_overhead_account,