[Home] [Help]
8:
9: -- **********************************************************************************************
10: -- PACKAGE: WSM_LBJ_INTERFACE_PVT (OSFM 11.5.10 and above)
11: -- (1) This is to handle WSM Lot Based Job Interface
12: -- WSM_LOT_JOB_INTERFACE and WSM_LOT_JOB_DTL_INTERFACE
13: -- (2) The {{{ and }}} in the comments are used to allow better nevigation within
14: -- the source code, {{{ or {{ is the beginning of a block, }}} or }} is the end
15: -- Please maintain them to achieve better readability
16: -- **********************************************************************************************
324:
325: -- ==============================================================================================
326: -- nested table types used to bulk bind data from wljdi to the PL/SQL tables.
327: -- ==============================================================================================
328: type t_wljdi_record_id is table of wsm_lot_job_dtl_interface.record_id %type;
329: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
330: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
331: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
332: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
325: -- ==============================================================================================
326: -- nested table types used to bulk bind data from wljdi to the PL/SQL tables.
327: -- ==============================================================================================
328: type t_wljdi_record_id is table of wsm_lot_job_dtl_interface.record_id %type;
329: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
330: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
331: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
332: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
333: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
326: -- nested table types used to bulk bind data from wljdi to the PL/SQL tables.
327: -- ==============================================================================================
328: type t_wljdi_record_id is table of wsm_lot_job_dtl_interface.record_id %type;
329: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
330: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
331: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
332: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
333: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
334: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
327: -- ==============================================================================================
328: type t_wljdi_record_id is table of wsm_lot_job_dtl_interface.record_id %type;
329: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
330: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
331: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
332: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
333: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
334: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
335: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
328: type t_wljdi_record_id is table of wsm_lot_job_dtl_interface.record_id %type;
329: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
330: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
331: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
332: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
333: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
334: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
335: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
336: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
329: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
330: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
331: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
332: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
333: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
334: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
335: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
336: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
337: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
330: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
331: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
332: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
333: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
334: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
335: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
336: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
337: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
338: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
331: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
332: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
333: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
334: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
335: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
336: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
337: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
338: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
339: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
332: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
333: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
334: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
335: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
336: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
337: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
338: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
339: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
340: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
333: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
334: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
335: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
336: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
337: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
338: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
339: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
340: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
341: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
334: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
335: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
336: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
337: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
338: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
339: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
340: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
341: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
342: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
335: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
336: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
337: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
338: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
339: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
340: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
341: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
342: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
343: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
336: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
337: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
338: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
339: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
340: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
341: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
342: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
343: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
344: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
337: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
338: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
339: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
340: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
341: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
342: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
343: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
344: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
345:
338: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
339: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
340: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
341: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
342: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
343: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
344: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
345:
346:
339: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
340: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
341: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
342: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
343: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
344: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
345:
346:
347: -- BA: bug 3313463/3311695 8i compatibility
340: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
341: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
342: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
343: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
344: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
345:
346:
347: -- BA: bug 3313463/3311695 8i compatibility
348: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
344: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
345:
346:
347: -- BA: bug 3313463/3311695 8i compatibility
348: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
349: type t_wljdi_substitution_type is table of wsm_lot_job_dtl_interface.substitution_type %type;
350: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
351: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
352: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
345:
346:
347: -- BA: bug 3313463/3311695 8i compatibility
348: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
349: type t_wljdi_substitution_type is table of wsm_lot_job_dtl_interface.substitution_type %type;
350: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
351: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
352: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
353:
346:
347: -- BA: bug 3313463/3311695 8i compatibility
348: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
349: type t_wljdi_substitution_type is table of wsm_lot_job_dtl_interface.substitution_type %type;
350: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
351: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
352: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
353:
354: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
347: -- BA: bug 3313463/3311695 8i compatibility
348: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
349: type t_wljdi_substitution_type is table of wsm_lot_job_dtl_interface.substitution_type %type;
350: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
351: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
352: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
353:
354: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
355: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
348: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
349: type t_wljdi_substitution_type is table of wsm_lot_job_dtl_interface.substitution_type %type;
350: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
351: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
352: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
353:
354: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
355: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
356: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
350: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
351: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
352: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
353:
354: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
355: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
356: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
357: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
358: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
351: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
352: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
353:
354: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
355: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
356: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
357: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
358: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
359: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
352: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
353:
354: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
355: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
356: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
357: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
358: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
359: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
360: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
353:
354: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
355: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
356: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
357: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
358: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
359: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
360: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
361: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
354: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
355: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
356: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
357: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
358: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
359: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
360: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
361: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
362: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
355: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
356: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
357: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
358: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
359: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
360: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
361: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
362: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
363: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
356: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
357: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
358: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
359: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
360: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
361: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
362: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
363: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
364: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
357: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
358: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
359: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
360: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
361: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
362: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
363: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
364: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
365: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
358: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
359: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
360: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
361: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
362: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
363: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
364: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
365: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
366: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
359: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
360: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
361: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
362: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
363: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
364: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
365: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
366: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
367: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
360: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
361: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
362: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
363: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
364: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
365: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
366: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
367: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
368: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
361: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
362: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
363: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
364: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
365: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
366: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
367: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
368: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
369: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
362: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
363: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
364: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
365: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
366: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
367: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
368: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
369: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
370: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
363: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
364: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
365: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
366: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
367: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
368: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
369: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
370: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
371: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
364: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
365: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
366: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
367: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
368: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
369: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
370: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
371: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
372: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
365: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
366: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
367: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
368: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
369: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
370: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
371: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
372: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
373: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
366: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
367: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
368: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
369: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
370: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
371: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
372: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
373: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
374: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
367: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
368: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
369: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
370: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
371: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
372: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
373: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
374: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
375: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
368: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
369: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
370: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
371: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
372: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
373: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
374: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
375: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
376: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
369: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
370: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
371: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
372: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
373: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
374: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
375: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
376: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
377: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
370: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
371: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
372: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
373: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
374: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
375: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
376: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
377: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
378: -- EA: bug 3313463/3311695 8i compatibility
371: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
372: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
373: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
374: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
375: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
376: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
377: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
378: -- EA: bug 3313463/3311695 8i compatibility
379:
372: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
373: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
374: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
375: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
376: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
377: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
378: -- EA: bug 3313463/3311695 8i compatibility
379:
380: /* ST : Detailed scheduling : start */
373: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
374: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
375: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
376: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
377: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
378: -- EA: bug 3313463/3311695 8i compatibility
379:
380: /* ST : Detailed scheduling : start */
381: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
377: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
378: -- EA: bug 3313463/3311695 8i compatibility
379:
380: /* ST : Detailed scheduling : start */
381: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
382: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
383: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
384: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
385: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
378: -- EA: bug 3313463/3311695 8i compatibility
379:
380: /* ST : Detailed scheduling : start */
381: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
382: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
383: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
384: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
385: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
386: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
379:
380: /* ST : Detailed scheduling : start */
381: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
382: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
383: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
384: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
385: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
386: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
387: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
380: /* ST : Detailed scheduling : start */
381: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
382: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
383: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
384: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
385: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
386: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
387: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
388: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
381: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
382: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
383: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
384: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
385: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
386: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
387: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
388: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
389:
382: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
383: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
384: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
385: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
386: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
387: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
388: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
389:
390: /* Start : fields added to add resource */
383: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
384: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
385: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
386: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
387: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
388: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
389:
390: /* Start : fields added to add resource */
391: type t_wljdi_department_id is table of wsm_lot_job_dtl_interface.department_id %type;
384: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
385: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
386: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
387: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
388: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
389:
390: /* Start : fields added to add resource */
391: type t_wljdi_department_id is table of wsm_lot_job_dtl_interface.department_id %type;
392: type t_wljdi_department_code is table of wsm_lot_job_dtl_interface.department_code %type;
387: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
388: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
389:
390: /* Start : fields added to add resource */
391: type t_wljdi_department_id is table of wsm_lot_job_dtl_interface.department_id %type;
392: type t_wljdi_department_code is table of wsm_lot_job_dtl_interface.department_code %type;
393: type t_wljdi_activity_id is table of wsm_lot_job_dtl_interface.activity_id %type;
394: type t_wljdi_standard_rate_flag is table of wsm_lot_job_dtl_interface.standard_rate_flag %type;
395: type t_wljdi_usage_rate_or_amt is table of wsm_lot_job_dtl_interface.usage_rate_or_amount %type;
388: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
389:
390: /* Start : fields added to add resource */
391: type t_wljdi_department_id is table of wsm_lot_job_dtl_interface.department_id %type;
392: type t_wljdi_department_code is table of wsm_lot_job_dtl_interface.department_code %type;
393: type t_wljdi_activity_id is table of wsm_lot_job_dtl_interface.activity_id %type;
394: type t_wljdi_standard_rate_flag is table of wsm_lot_job_dtl_interface.standard_rate_flag %type;
395: type t_wljdi_usage_rate_or_amt is table of wsm_lot_job_dtl_interface.usage_rate_or_amount %type;
396:
389:
390: /* Start : fields added to add resource */
391: type t_wljdi_department_id is table of wsm_lot_job_dtl_interface.department_id %type;
392: type t_wljdi_department_code is table of wsm_lot_job_dtl_interface.department_code %type;
393: type t_wljdi_activity_id is table of wsm_lot_job_dtl_interface.activity_id %type;
394: type t_wljdi_standard_rate_flag is table of wsm_lot_job_dtl_interface.standard_rate_flag %type;
395: type t_wljdi_usage_rate_or_amt is table of wsm_lot_job_dtl_interface.usage_rate_or_amount %type;
396:
397: type t_wljdi_basis_type is table of wsm_lot_job_dtl_interface.basis_type %type;
390: /* Start : fields added to add resource */
391: type t_wljdi_department_id is table of wsm_lot_job_dtl_interface.department_id %type;
392: type t_wljdi_department_code is table of wsm_lot_job_dtl_interface.department_code %type;
393: type t_wljdi_activity_id is table of wsm_lot_job_dtl_interface.activity_id %type;
394: type t_wljdi_standard_rate_flag is table of wsm_lot_job_dtl_interface.standard_rate_flag %type;
395: type t_wljdi_usage_rate_or_amt is table of wsm_lot_job_dtl_interface.usage_rate_or_amount %type;
396:
397: type t_wljdi_basis_type is table of wsm_lot_job_dtl_interface.basis_type %type;
398: type t_wljdi_uom_code is table of wsm_lot_job_dtl_interface.uom_code %type;
391: type t_wljdi_department_id is table of wsm_lot_job_dtl_interface.department_id %type;
392: type t_wljdi_department_code is table of wsm_lot_job_dtl_interface.department_code %type;
393: type t_wljdi_activity_id is table of wsm_lot_job_dtl_interface.activity_id %type;
394: type t_wljdi_standard_rate_flag is table of wsm_lot_job_dtl_interface.standard_rate_flag %type;
395: type t_wljdi_usage_rate_or_amt is table of wsm_lot_job_dtl_interface.usage_rate_or_amount %type;
396:
397: type t_wljdi_basis_type is table of wsm_lot_job_dtl_interface.basis_type %type;
398: type t_wljdi_uom_code is table of wsm_lot_job_dtl_interface.uom_code %type;
399: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
393: type t_wljdi_activity_id is table of wsm_lot_job_dtl_interface.activity_id %type;
394: type t_wljdi_standard_rate_flag is table of wsm_lot_job_dtl_interface.standard_rate_flag %type;
395: type t_wljdi_usage_rate_or_amt is table of wsm_lot_job_dtl_interface.usage_rate_or_amount %type;
396:
397: type t_wljdi_basis_type is table of wsm_lot_job_dtl_interface.basis_type %type;
398: type t_wljdi_uom_code is table of wsm_lot_job_dtl_interface.uom_code %type;
399: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
400:
401: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
394: type t_wljdi_standard_rate_flag is table of wsm_lot_job_dtl_interface.standard_rate_flag %type;
395: type t_wljdi_usage_rate_or_amt is table of wsm_lot_job_dtl_interface.usage_rate_or_amount %type;
396:
397: type t_wljdi_basis_type is table of wsm_lot_job_dtl_interface.basis_type %type;
398: type t_wljdi_uom_code is table of wsm_lot_job_dtl_interface.uom_code %type;
399: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
400:
401: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
402: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
395: type t_wljdi_usage_rate_or_amt is table of wsm_lot_job_dtl_interface.usage_rate_or_amount %type;
396:
397: type t_wljdi_basis_type is table of wsm_lot_job_dtl_interface.basis_type %type;
398: type t_wljdi_uom_code is table of wsm_lot_job_dtl_interface.uom_code %type;
399: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
400:
401: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
402: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
403:
397: type t_wljdi_basis_type is table of wsm_lot_job_dtl_interface.basis_type %type;
398: type t_wljdi_uom_code is table of wsm_lot_job_dtl_interface.uom_code %type;
399: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
400:
401: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
402: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
403:
404: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
405: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
398: type t_wljdi_uom_code is table of wsm_lot_job_dtl_interface.uom_code %type;
399: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
400:
401: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
402: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
403:
404: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
405: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
406: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
400:
401: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
402: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
403:
404: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
405: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
406: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
407: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
408: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
401: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
402: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
403:
404: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
405: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
406: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
407: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
408: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
409: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
402: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
403:
404: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
405: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
406: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
407: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
408: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
409: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
410: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
403:
404: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
405: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
406: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
407: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
408: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
409: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
410: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
411: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
404: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
405: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
406: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
407: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
408: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
409: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
410: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
411: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
412: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
405: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
406: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
407: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
408: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
409: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
410: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
411: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
412: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
413: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
406: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
407: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
408: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
409: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
410: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
411: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
412: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
413: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
414: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
407: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
408: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
409: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
410: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
411: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
412: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
413: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
414: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
415: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
408: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
409: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
410: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
411: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
412: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
413: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
414: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
415: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
416: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
409: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
410: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
411: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
412: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
413: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
414: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
415: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
416: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
417: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
410: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
411: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
412: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
413: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
414: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
415: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
416: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
417: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
418: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
411: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
412: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
413: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
414: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
415: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
416: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
417: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
418: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
419: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
412: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
413: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
414: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
415: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
416: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
417: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
418: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
419: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
420:
413: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
414: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
415: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
416: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
417: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
418: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
419: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
420:
421: -- Added For LBJ Interface Alcoa Enhancement
414: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
415: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
416: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
417: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
418: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
419: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
420:
421: -- Added For LBJ Interface Alcoa Enhancement
422: type t_wljdi_recommended is table of wsm_lot_job_dtl_interface.recommended %type;
415: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
416: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
417: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
418: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
419: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
420:
421: -- Added For LBJ Interface Alcoa Enhancement
422: type t_wljdi_recommended is table of wsm_lot_job_dtl_interface.recommended %type;
423: type t_wljdi_std_op_code is table of wsm_lot_job_dtl_interface.standard_operation_code %type;
418: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
419: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
420:
421: -- Added For LBJ Interface Alcoa Enhancement
422: type t_wljdi_recommended is table of wsm_lot_job_dtl_interface.recommended %type;
423: type t_wljdi_std_op_code is table of wsm_lot_job_dtl_interface.standard_operation_code %type;
424: type t_wljdi_std_op_id is table of wsm_lot_job_dtl_interface.standard_operation_id %type;
425: type t_wljdi_op_yield_enable is table of wsm_lot_job_dtl_interface.operation_yield_enabled %type;
426: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
419: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
420:
421: -- Added For LBJ Interface Alcoa Enhancement
422: type t_wljdi_recommended is table of wsm_lot_job_dtl_interface.recommended %type;
423: type t_wljdi_std_op_code is table of wsm_lot_job_dtl_interface.standard_operation_code %type;
424: type t_wljdi_std_op_id is table of wsm_lot_job_dtl_interface.standard_operation_id %type;
425: type t_wljdi_op_yield_enable is table of wsm_lot_job_dtl_interface.operation_yield_enabled %type;
426: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
427: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
420:
421: -- Added For LBJ Interface Alcoa Enhancement
422: type t_wljdi_recommended is table of wsm_lot_job_dtl_interface.recommended %type;
423: type t_wljdi_std_op_code is table of wsm_lot_job_dtl_interface.standard_operation_code %type;
424: type t_wljdi_std_op_id is table of wsm_lot_job_dtl_interface.standard_operation_id %type;
425: type t_wljdi_op_yield_enable is table of wsm_lot_job_dtl_interface.operation_yield_enabled %type;
426: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
427: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
428: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
421: -- Added For LBJ Interface Alcoa Enhancement
422: type t_wljdi_recommended is table of wsm_lot_job_dtl_interface.recommended %type;
423: type t_wljdi_std_op_code is table of wsm_lot_job_dtl_interface.standard_operation_code %type;
424: type t_wljdi_std_op_id is table of wsm_lot_job_dtl_interface.standard_operation_id %type;
425: type t_wljdi_op_yield_enable is table of wsm_lot_job_dtl_interface.operation_yield_enabled %type;
426: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
427: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
428: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
429: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
422: type t_wljdi_recommended is table of wsm_lot_job_dtl_interface.recommended %type;
423: type t_wljdi_std_op_code is table of wsm_lot_job_dtl_interface.standard_operation_code %type;
424: type t_wljdi_std_op_id is table of wsm_lot_job_dtl_interface.standard_operation_id %type;
425: type t_wljdi_op_yield_enable is table of wsm_lot_job_dtl_interface.operation_yield_enabled %type;
426: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
427: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
428: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
429: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
430: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
423: type t_wljdi_std_op_code is table of wsm_lot_job_dtl_interface.standard_operation_code %type;
424: type t_wljdi_std_op_id is table of wsm_lot_job_dtl_interface.standard_operation_id %type;
425: type t_wljdi_op_yield_enable is table of wsm_lot_job_dtl_interface.operation_yield_enabled %type;
426: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
427: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
428: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
429: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
430: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
431: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
424: type t_wljdi_std_op_id is table of wsm_lot_job_dtl_interface.standard_operation_id %type;
425: type t_wljdi_op_yield_enable is table of wsm_lot_job_dtl_interface.operation_yield_enabled %type;
426: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
427: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
428: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
429: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
430: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
431: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
432: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
425: type t_wljdi_op_yield_enable is table of wsm_lot_job_dtl_interface.operation_yield_enabled %type;
426: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
427: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
428: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
429: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
430: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
431: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
432: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
433: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
426: type t_wljdi_min_trf_qty is table of wsm_lot_job_dtl_interface.minimum_transfer_quantity %type;
427: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
428: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
429: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
430: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
431: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
432: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
433: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
434: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
427: type t_wljdi_backflush_flag is table of wsm_lot_job_dtl_interface.backflush_flag %type;
428: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
429: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
430: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
431: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
432: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
433: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
434: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
435: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
428: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
429: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
430: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
431: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
432: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
433: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
434: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
435: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
436: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
429: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
430: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
431: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
432: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
433: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
434: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
435: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
436: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
437: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
430: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
431: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
432: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
433: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
434: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
435: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
436: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
437: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
438: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
431: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
432: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
433: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
434: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
435: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
436: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
437: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
438: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
439: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
432: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
433: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
434: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
435: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
436: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
437: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
438: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
439: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
440: type t_wljdi_supply_locator_id is table of wsm_lot_job_dtl_interface.supply_locator_id %type;
433: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
434: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
435: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
436: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
437: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
438: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
439: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
440: type t_wljdi_supply_locator_id is table of wsm_lot_job_dtl_interface.supply_locator_id %type;
441: type t_wljdi_applied_resource_units is table of wsm_lot_job_dtl_interface.applied_resource_units %type;
434: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
435: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
436: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
437: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
438: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
439: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
440: type t_wljdi_supply_locator_id is table of wsm_lot_job_dtl_interface.supply_locator_id %type;
441: type t_wljdi_applied_resource_units is table of wsm_lot_job_dtl_interface.applied_resource_units %type;
442: type t_desc is table of bom_standard_operations.operation_description%type index by binary_integer;
435: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
436: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
437: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
438: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
439: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
440: type t_wljdi_supply_locator_id is table of wsm_lot_job_dtl_interface.supply_locator_id %type;
441: type t_wljdi_applied_resource_units is table of wsm_lot_job_dtl_interface.applied_resource_units %type;
442: type t_desc is table of bom_standard_operations.operation_description%type index by binary_integer;
443: type t_op_code is table of bom_standard_operations.operation_code%type index by binary_integer;
436: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
437: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
438: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
439: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
440: type t_wljdi_supply_locator_id is table of wsm_lot_job_dtl_interface.supply_locator_id %type;
441: type t_wljdi_applied_resource_units is table of wsm_lot_job_dtl_interface.applied_resource_units %type;
442: type t_desc is table of bom_standard_operations.operation_description%type index by binary_integer;
443: type t_op_code is table of bom_standard_operations.operation_code%type index by binary_integer;
444:
437: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
438: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
439: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
440: type t_wljdi_supply_locator_id is table of wsm_lot_job_dtl_interface.supply_locator_id %type;
441: type t_wljdi_applied_resource_units is table of wsm_lot_job_dtl_interface.applied_resource_units %type;
442: type t_desc is table of bom_standard_operations.operation_description%type index by binary_integer;
443: type t_op_code is table of bom_standard_operations.operation_code%type index by binary_integer;
444:
445: /*Added below two types for bugfix:7248992 */
442: type t_desc is table of bom_standard_operations.operation_description%type index by binary_integer;
443: type t_op_code is table of bom_standard_operations.operation_code%type index by binary_integer;
444:
445: /*Added below two types for bugfix:7248992 */
446: type t_wljdi_cum_yield is table of wsm_lot_job_dtl_interface.cumulative_yield %type;
447: type t_wljdi_rev_cum_yield is table of wsm_lot_job_dtl_interface.reverse_cumulative_yield %type;
448: /* end */
449:
450: /* ST : Detailed scheduling : end */
443: type t_op_code is table of bom_standard_operations.operation_code%type index by binary_integer;
444:
445: /*Added below two types for bugfix:7248992 */
446: type t_wljdi_cum_yield is table of wsm_lot_job_dtl_interface.cumulative_yield %type;
447: type t_wljdi_rev_cum_yield is table of wsm_lot_job_dtl_interface.reverse_cumulative_yield %type;
448: /* end */
449:
450: /* ST : Detailed scheduling : end */
451:
590: -- instantiating the tables used to bulk bind data from wljdi to the PL/SQL tables.
591: -- ==============================================================================================
592:
593: -- BD: bug 3313463/3311695 8i compatibility
594: --type t_wljdi is table of wsm_lot_job_dtl_interface%rowtype index by binary_integer;
595: --v_wljdi t_wljdi;
596: -- ED: bug 3313463/3311695 8i compatibility
597:
598: -- ==============================================================================================
1297: inventory_item_old,
1298: wip_supply_type,
1299: cumulative_yield,/*Added for bugfix:7248992 */
1300: reverse_cumulative_yield/*Added for bugfix:7248992 */
1301: from wsm_lot_job_dtl_interface
1302: where parent_header_id = p_parent_header_id
1303: and process_status = WIP_CONSTANTS.RUNNING;
1304:
1305: cursor c_wljdi_indp is
1369: inventory_item_old,
1370: wip_supply_type,
1371: cumulative_yield,/*Added for bugfix:7248992 */
1372: reverse_cumulative_yield/*Added for bugfix:7248992 */
1373: from wsm_lot_job_dtl_interface
1374: where parent_header_id IS NULL
1375: and wip_entity_id = p_wip_entity_id
1376: and organization_id = p_org_id
1377: and process_status = WIP_CONSTANTS.RUNNING
2580: -- bulk update WLJDI
2581: ---------------------------------------
2582: l_stmt_num := 110;
2583: forall i in l_v_record_id.first..l_v_record_id.last
2584: update wsm_lot_job_dtl_interface
2585: set substitute_group_num = l_v_sub_grp_num(i),
2586: replacement_group_num = l_v_rpl_grp_num(i),
2587: resource_id_new = l_v_res_id(i),
2588: resource_seq_num = l_v_res_seq_num(i),
6293: job_name,
6294: process_status,
6295: error_code,
6296: error_msg
6297: from wsm_lot_job_dtl_interface
6298: where process_status = WIP_CONSTANTS.PENDING
6299: and parent_header_id IS NULL
6300: and NVL(group_id, -99) = NVL(p_group_id, NVL(group_id, -99))
6301: and transaction_date <= sysdate+1;
6447: -- {{ Check PENDING WLJDI records with parent_header_id = NULL
6448: -----------------------------------------------------------------
6449: if lbji_debug = 'Y' then
6450: fnd_file.put_line(fnd_file.log,
6451: 'Checking wsm_lot_job_dtl_interface..');
6452: end if;
6453:
6454: l_stmt_num := 100;
6455: open c_wljdi_no_parent;
6464: v_wljdi_err_code,
6465: v_wljdi_err_msg;
6466: if lbji_debug = 'Y' then
6467: fnd_file.put_line(fnd_file.log,
6468: 'Number of independent records in WSM_LOT_JOB_DTL_INTERFACE: '
6469: || c_wljdi_no_parent%rowcount);
6470: end if;
6471: l_d_rows := c_wljdi_no_parent%rowcount;
6472: close c_wljdi_no_parent;
6554: -- Update WLJDI for all record with parent_header_id = header_id
6555: l_h := v_wlji_header_id.first;
6556: WHILE l_h <= v_wlji_header_id.last
6557: LOOP
6558: update wsm_lot_job_dtl_interface
6559: set process_status = v_wlji_process_status(l_h),
6560: group_id = p_group_id,
6561: organization_id = v_wlji_org_id(l_h),
6562: organization_code = v_wlji_org_code(l_h),
6593:
6594: if(l_d_rows > 0) then
6595: l_stmt_num := 220;
6596: forall l_d in v_wljdi_record_id.first..v_wljdi_record_id.last
6597: update wsm_lot_job_dtl_interface
6598: set process_status = v_wljdi_process_status(l_d),
6599: organization_id = v_wljdi_org_id(l_d),
6600: organization_code = v_wljdi_org_code(l_d),
6601: wip_entity_id = v_wljdi_wip_entity_id(l_d),
6710: -- Update WLJDI for all record with parent_header_id = header_id
6711: l_h := v_wlji_header_id.first;
6712: WHILE l_h <= v_wlji_header_id.last
6713: LOOP
6714: update wsm_lot_job_dtl_interface
6715: set process_status = v_wlji_process_status(l_h),
6716: group_id = v_wlji_group_id(l_h),
6717: organization_id = v_wlji_org_id(l_h),
6718: organization_code = v_wlji_org_code(l_h),
6748:
6749: if(l_d_rows > 0) then
6750: l_stmt_num := 350;
6751: forall l_d in v_wljdi_record_id.first..v_wljdi_record_id.last
6752: update wsm_lot_job_dtl_interface
6753: set process_status = v_wljdi_process_status(l_d),
6754: group_id = v_wljdi_group_id(l_d), -- assigned gid
6755: organization_id = v_wljdi_org_id(l_d),
6756: organization_code = v_wljdi_org_code(l_d),
6956: cursor c_wljdi_jobs_no_parent is
6957: select unique
6958: wip_entity_id,
6959: organization_id
6960: from wsm_lot_job_dtl_interface
6961: where process_status = WIP_CONSTANTS.RUNNING
6962: and parent_header_id IS NULL
6963: and group_id = p_group_id
6964: and transaction_date <= sysdate+1
7337: l_h := v_wlji_header_id.first;
7338: WHILE l_h <= v_wlji_header_id.last
7339: LOOP
7340: if(v_wlji_num_of_children(l_h) > 0) then
7341: update wsm_lot_job_dtl_interface
7342: set group_id = l_batch_grp_id
7343: where parent_header_id = v_wlji_header_id(l_h);
7344: end if;
7345: l_h := v_wlji_header_id.next(l_h);
11936:
11937: l_stmt_num := 1060.1;
11938:
11939: forall i in v_wlji_process_status.first..v_wlji_process_status.last
11940: update wsm_lot_job_dtl_interface
11941: set process_status = v_wlji_process_status(i),
11942: error_code = v_wlji_err_code(i),
11943: error_msg = decode(v_wlji_process_status(i), -- BUG3600450
11944: 3, 'See header (header_id=' ||
12093: end if;
12094: end if;
12095:
12096: l_stmt_num := 1100.1;
12097: delete from wsm_lot_job_dtl_interface
12098: where parent_header_id IN (
12099: select wlji.header_id
12100: from wsm_lot_job_interface wlji
12101: where wlji.process_status = 5
12139: end if;
12140:
12141: l_stmt_num := 1100.3;
12142: -- this is for those without header
12143: delete from wsm_lot_job_dtl_interface
12144: where process_status = 5
12145: --and group_id = l_batch_grp_id
12146: and NVL(transaction_date, creation_date)
12147: <= decode(l_del_int_prof_value,
12255:
12256: l_stmt_num := 1220;
12257: if(l_d_idx_err > 1) then
12258: forall i in l_v_d_we_id_err.first..l_v_d_we_id_err.last
12259: update wsm_lot_job_dtl_interface
12260: set process_status = 3,
12261: error_code = l_v_d_ecode_err(i),
12262: error_msg = l_v_d_emsg_err(i),
12263: request_id = fnd_global.conc_request_id,
12275: end if;
12276: l_stmt_num := 1230;
12277: if(l_d_idx_ok > 1) then
12278: forall i in l_v_d_we_id_ok.first..l_v_d_we_id_ok.last
12279: delete from wsm_lot_job_dtl_interface
12280: where parent_header_id IS NULL
12281: and process_status = WIP_CONSTANTS.RUNNING
12282: and wip_entity_id = l_v_d_we_id_ok(i)
12283: and organization_id = l_v_d_org_id_ok(i);
14974: comments,
14975: applied_resource_units,
14976: cumulative_yield, /*Added for bugfix:7248992 */
14977: reverse_cumulative_yield/*Added for bugfix:7248992 */
14978: from wsm_lot_job_dtl_interface
14979: where parent_header_id = p_parent_header_id
14980: and process_status = WIP_CONSTANTS.RUNNING
14981: order by load_type,
14982: NVL(parent_resource_seq_num,0), -- Detailed Scheduling Code review remark...
15099: comments,
15100: applied_resource_units,
15101: cumulative_yield, /*Added for bugfix:7248992 */
15102: reverse_cumulative_yield/*Added for bugfix:7248992 */
15103: from wsm_lot_job_dtl_interface
15104: where parent_header_id IS NULL
15105: and wip_entity_id = p_wip_entity_id
15106: and organization_id = p_org_id
15107: and process_status = WIP_CONSTANTS.RUNNING