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: -- **********************************************************************************************
329:
330: -- ==============================================================================================
331: -- nested table types used to bulk bind data from wljdi to the PL/SQL tables.
332: -- ==============================================================================================
333: type t_wljdi_record_id is table of wsm_lot_job_dtl_interface.record_id %type;
334: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
335: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
336: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
337: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
330: -- ==============================================================================================
331: -- nested table types used to bulk bind data from wljdi to the PL/SQL tables.
332: -- ==============================================================================================
333: type t_wljdi_record_id is table of wsm_lot_job_dtl_interface.record_id %type;
334: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
335: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
336: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
337: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
338: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
331: -- nested table types used to bulk bind data from wljdi to the PL/SQL tables.
332: -- ==============================================================================================
333: type t_wljdi_record_id is table of wsm_lot_job_dtl_interface.record_id %type;
334: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
335: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
336: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
337: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
338: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
339: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
332: -- ==============================================================================================
333: type t_wljdi_record_id is table of wsm_lot_job_dtl_interface.record_id %type;
334: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
335: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
336: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
337: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
338: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
339: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
340: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
333: type t_wljdi_record_id is table of wsm_lot_job_dtl_interface.record_id %type;
334: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
335: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
336: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
337: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
338: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
339: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
340: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
341: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
334: type t_wljdi_parent_header_id is table of wsm_lot_job_dtl_interface.parent_header_id %type;
335: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
336: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
337: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
338: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
339: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
340: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
341: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
342: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
335: type t_wljdi_group_id is table of wsm_lot_job_dtl_interface.group_id %type;
336: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
337: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
338: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
339: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
340: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
341: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
342: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
343: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
336: type t_wljdi_org_id is table of wsm_lot_job_dtl_interface.organization_id %type;
337: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
338: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
339: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
340: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
341: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
342: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
343: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
344: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
337: type t_wljdi_org_code is table of wsm_lot_job_dtl_interface.organization_code %type;
338: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
339: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
340: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
341: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
342: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
343: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
344: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
345: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
338: type t_wljdi_wip_entity_id is table of wsm_lot_job_dtl_interface.wip_entity_id %type;
339: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
340: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
341: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
342: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
343: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
344: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
345: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
346: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
339: type t_wljdi_job_name is table of wsm_lot_job_dtl_interface.job_name %type;
340: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
341: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
342: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
343: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
344: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
345: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
346: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
347: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
340: type t_wljdi_err_code is table of wsm_lot_job_dtl_interface.error_code %type;
341: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
342: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
343: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
344: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
345: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
346: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
347: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
348: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
341: type t_wljdi_err_msg is table of wsm_lot_job_dtl_interface.error_msg %type;
342: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
343: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
344: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
345: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
346: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
347: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
348: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
349: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
342: type t_wljdi_request_id is table of wsm_lot_job_dtl_interface.request_id %type;
343: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
344: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
345: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
346: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
347: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
348: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
349: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
350:
343: type t_wljdi_program_id is table of wsm_lot_job_dtl_interface.program_id %type;
344: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
345: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
346: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
347: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
348: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
349: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
350:
351:
344: type t_wljdi_program_appl_id is table of wsm_lot_job_dtl_interface.program_application_id %type;
345: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
346: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
347: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
348: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
349: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
350:
351:
352: -- BA: bug 3313463/3311695 8i compatibility
345: type t_wljdi_last_updt_by is table of wsm_lot_job_dtl_interface.last_updated_by %type;
346: type t_wljdi_last_updt_login is table of wsm_lot_job_dtl_interface.last_update_login %type;
347: type t_wljdi_last_updt_date is table of wsm_lot_job_dtl_interface.last_update_date %type;
348: type t_wljdi_prog_updt_date is table of wsm_lot_job_dtl_interface.program_update_date %type;
349: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
350:
351:
352: -- BA: bug 3313463/3311695 8i compatibility
353: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
349: type t_wljdi_process_status is table of wsm_lot_job_dtl_interface.process_status %type;
350:
351:
352: -- BA: bug 3313463/3311695 8i compatibility
353: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
354: type t_wljdi_substitution_type is table of wsm_lot_job_dtl_interface.substitution_type %type;
355: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
356: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
357: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
350:
351:
352: -- BA: bug 3313463/3311695 8i compatibility
353: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
354: type t_wljdi_substitution_type is table of wsm_lot_job_dtl_interface.substitution_type %type;
355: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
356: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
357: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
358:
351:
352: -- BA: bug 3313463/3311695 8i compatibility
353: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
354: type t_wljdi_substitution_type is table of wsm_lot_job_dtl_interface.substitution_type %type;
355: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
356: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
357: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
358:
359: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
352: -- BA: bug 3313463/3311695 8i compatibility
353: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
354: type t_wljdi_substitution_type is table of wsm_lot_job_dtl_interface.substitution_type %type;
355: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
356: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
357: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
358:
359: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
360: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
353: type t_wljdi_load_type is table of wsm_lot_job_dtl_interface.load_type %type;
354: type t_wljdi_substitution_type is table of wsm_lot_job_dtl_interface.substitution_type %type;
355: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
356: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
357: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
358:
359: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
360: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
361: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
355: type t_wljdi_job_op_seq_num is table of wsm_lot_job_dtl_interface.job_op_seq_num %type;
356: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
357: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
358:
359: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
360: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
361: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
362: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
363: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
356: type t_wljdi_routing_op_seq_num is table of wsm_lot_job_dtl_interface.routing_op_seq_num %type;
357: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
358:
359: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
360: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
361: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
362: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
363: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
364: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
357: type t_wljdi_next_rtg_op_seq_num is table of wsm_lot_job_dtl_interface.next_routing_op_seq_num %type;
358:
359: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
360: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
361: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
362: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
363: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
364: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
365: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
358:
359: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
360: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
361: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
362: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
363: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
364: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
365: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
366: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
359: type t_wljdi_inventory_item_id_new is table of wsm_lot_job_dtl_interface.inventory_item_id_new %type;
360: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
361: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
362: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
363: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
364: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
365: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
366: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
367: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
360: type t_wljdi_inventory_item_new is table of wsm_lot_job_dtl_interface.inventory_item_new %type;
361: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
362: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
363: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
364: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
365: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
366: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
367: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
368: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
361: type t_wljdi_primary_item is table of wsm_lot_job_dtl_interface.primary_item %type;
362: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
363: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
364: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
365: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
366: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
367: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
368: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
369: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
362: type t_wljdi_primary_item_id is table of wsm_lot_job_dtl_interface.primary_item_id %type;
363: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
364: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
365: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
366: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
367: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
368: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
369: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
370: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
363: type t_wljdi_src_phantom_item is table of wsm_lot_job_dtl_interface.src_phantom_item %type;
364: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
365: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
366: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
367: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
368: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
369: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
370: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
371: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
364: type t_wljdi_src_phantom_item_id is table of wsm_lot_job_dtl_interface.src_phantom_item_id %type;
365: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
366: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
367: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
368: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
369: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
370: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
371: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
372: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
365: type t_wljdi_component_sequence_id is table of wsm_lot_job_dtl_interface.component_sequence_id %type;
366: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
367: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
368: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
369: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
370: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
371: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
372: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
373: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
366: type t_wljdi_date_required is table of wsm_lot_job_dtl_interface.date_required %type;
367: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
368: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
369: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
370: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
371: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
372: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
373: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
374: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
367: type t_wljdi_scheduled_quantity is table of wsm_lot_job_dtl_interface.scheduled_quantity %type;
368: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
369: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
370: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
371: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
372: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
373: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
374: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
375: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
368: type t_wljdi_required_quantity is table of wsm_lot_job_dtl_interface.required_quantity %type;
369: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
370: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
371: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
372: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
373: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
374: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
375: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
376: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
369: type t_wljdi_batch_id is table of wsm_lot_job_dtl_interface.batch_id %type;
370: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
371: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
372: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
373: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
374: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
375: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
376: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
377: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
370: type t_wljdi_assigned_units is table of wsm_lot_job_dtl_interface.assigned_units %type;
371: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
372: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
373: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
374: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
375: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
376: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
377: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
378: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
371: type t_wljdi_instance_id_new is table of wsm_lot_job_dtl_interface.instance_id_new %type;
372: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
373: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
374: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
375: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
376: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
377: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
378: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
379: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
372: type t_wljdi_op_completion_date is table of wsm_lot_job_dtl_interface.operation_completion_date %type;
373: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
374: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
375: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
376: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
377: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
378: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
379: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
380: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
373: type t_wljdi_op_start_date is table of wsm_lot_job_dtl_interface.operation_start_date %type;
374: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
375: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
376: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
377: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
378: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
379: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
380: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
381: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
374: type t_wljdi_op_yield is table of wsm_lot_job_dtl_interface.operation_yield %type;
375: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
376: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
377: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
378: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
379: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
380: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
381: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
382: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
375: type t_wljdi_resource_code_new is table of wsm_lot_job_dtl_interface.resource_code_new %type;
376: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
377: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
378: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
379: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
380: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
381: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
382: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
383: -- EA: bug 3313463/3311695 8i compatibility
376: type t_wljdi_resource_id_new is table of wsm_lot_job_dtl_interface.resource_id_new %type;
377: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
378: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
379: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
380: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
381: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
382: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
383: -- EA: bug 3313463/3311695 8i compatibility
384:
377: type t_wljdi_resource_seq_num is table of wsm_lot_job_dtl_interface.resource_seq_num %type;
378: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
379: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
380: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
381: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
382: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
383: -- EA: bug 3313463/3311695 8i compatibility
384:
385: /* ST : Detailed scheduling : start */
378: type t_wljdi_substitute_group_num is table of wsm_lot_job_dtl_interface.substitute_group_num %type;
379: type t_wljdi_replacement_group_num is table of wsm_lot_job_dtl_interface.replacement_group_num %type;
380: type t_wljdi_serial_number_new is table of wsm_lot_job_dtl_interface.serial_number_new %type;
381: type t_wljdi_start_date is table of wsm_lot_job_dtl_interface.start_date %type;
382: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
383: -- EA: bug 3313463/3311695 8i compatibility
384:
385: /* ST : Detailed scheduling : start */
386: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
382: type t_wljdi_completion_date is table of wsm_lot_job_dtl_interface.completion_date %type;
383: -- EA: bug 3313463/3311695 8i compatibility
384:
385: /* ST : Detailed scheduling : start */
386: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
387: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
388: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
389: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
390: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
383: -- EA: bug 3313463/3311695 8i compatibility
384:
385: /* ST : Detailed scheduling : start */
386: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
387: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
388: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
389: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
390: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
391: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
384:
385: /* ST : Detailed scheduling : start */
386: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
387: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
388: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
389: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
390: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
391: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
392: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
385: /* ST : Detailed scheduling : start */
386: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
387: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
388: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
389: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
390: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
391: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
392: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
393: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
386: type t_wljdi_resource_hours is table of wsm_lot_job_dtl_interface.resource_hours %type;
387: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
388: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
389: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
390: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
391: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
392: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
393: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
394:
387: type t_wljdi_firm_type is table of wsm_lot_job_dtl_interface.firm_type %type;
388: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
389: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
390: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
391: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
392: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
393: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
394:
395: /* Start : fields added to add resource */
388: type t_wljdi_setup_id is table of wsm_lot_job_dtl_interface.setup_id %type;
389: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
390: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
391: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
392: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
393: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
394:
395: /* Start : fields added to add resource */
396: type t_wljdi_department_id is table of wsm_lot_job_dtl_interface.department_id %type;
389: type t_wljdi_setup_code is table of wsm_lot_job_dtl_interface.setup_code %type;
390: type t_wljdi_grp_seq_id is table of wsm_lot_job_dtl_interface.group_sequence_id %type;
391: type t_wljdi_grp_seq_num is table of wsm_lot_job_dtl_interface.group_sequence_num %type;
392: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
393: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
394:
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;
392: type t_wljdi_max_assg_units is table of wsm_lot_job_dtl_interface.max_assigned_units %type;
393: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
394:
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;
393: type t_wljdi_parent_seq_num is table of wsm_lot_job_dtl_interface.parent_resource_seq_num %type;
394:
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:
394:
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;
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;
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;
404: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %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;
404: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
405:
406: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %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;
404: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
405:
406: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
407: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %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;
404: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
405:
406: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
407: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
408:
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;
404: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
405:
406: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
407: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
408:
409: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
410: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
403: type t_wljdi_uom_code is table of wsm_lot_job_dtl_interface.uom_code %type;
404: type t_wljdi_scheduled_flag is table of wsm_lot_job_dtl_interface.scheduled_flag %type;
405:
406: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
407: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
408:
409: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
410: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
411: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
405:
406: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
407: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
408:
409: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
410: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
411: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
412: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
413: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
406: type t_wljdi_res_autocharge_type is table of wsm_lot_job_dtl_interface.autocharge_type %type;
407: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
408:
409: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
410: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
411: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
412: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
413: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
414: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
407: type t_wljdi_schedule_seq_num is table of wsm_lot_job_dtl_interface.schedule_seq_num %type;
408:
409: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
410: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
411: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
412: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
413: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
414: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
415: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
408:
409: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
410: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
411: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
412: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
413: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
414: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
415: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
416: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
409: type t_wljdi_attribute_category is table of wsm_lot_job_dtl_interface.attribute_category %type;
410: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
411: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
412: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
413: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
414: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
415: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
416: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
417: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
410: type t_wljdi_attribute1 is table of wsm_lot_job_dtl_interface.attribute1 %type;
411: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
412: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
413: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
414: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
415: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
416: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
417: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
418: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
411: type t_wljdi_attribute2 is table of wsm_lot_job_dtl_interface.attribute2 %type;
412: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
413: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
414: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
415: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
416: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
417: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
418: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
419: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
412: type t_wljdi_attribute3 is table of wsm_lot_job_dtl_interface.attribute3 %type;
413: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
414: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
415: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
416: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
417: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
418: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
419: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
420: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
413: type t_wljdi_attribute4 is table of wsm_lot_job_dtl_interface.attribute4 %type;
414: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
415: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
416: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
417: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
418: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
419: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
420: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
421: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
414: type t_wljdi_attribute5 is table of wsm_lot_job_dtl_interface.attribute5 %type;
415: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
416: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
417: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
418: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
419: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
420: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
421: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
422: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
415: type t_wljdi_attribute6 is table of wsm_lot_job_dtl_interface.attribute6 %type;
416: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
417: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
418: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
419: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
420: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
421: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
422: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
423: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
416: type t_wljdi_attribute7 is table of wsm_lot_job_dtl_interface.attribute7 %type;
417: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
418: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
419: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
420: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
421: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
422: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
423: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
424: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
417: type t_wljdi_attribute8 is table of wsm_lot_job_dtl_interface.attribute8 %type;
418: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
419: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
420: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
421: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
422: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
423: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
424: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
425:
418: type t_wljdi_attribute9 is table of wsm_lot_job_dtl_interface.attribute9 %type;
419: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
420: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
421: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
422: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
423: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %type;
424: type t_wljdi_attribute15 is table of wsm_lot_job_dtl_interface.attribute15 %type;
425:
426: -- Added For LBJ Interface Alcoa Enhancement
419: type t_wljdi_attribute10 is table of wsm_lot_job_dtl_interface.attribute10 %type;
420: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
421: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
422: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
423: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %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;
420: type t_wljdi_attribute11 is table of wsm_lot_job_dtl_interface.attribute11 %type;
421: type t_wljdi_attribute12 is table of wsm_lot_job_dtl_interface.attribute12 %type;
422: type t_wljdi_attribute13 is table of wsm_lot_job_dtl_interface.attribute13 %type;
423: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %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;
423: type t_wljdi_attribute14 is table of wsm_lot_job_dtl_interface.attribute14 %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;
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;
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;
434: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
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;
434: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
435: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %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;
434: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
435: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
436: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %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;
434: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
435: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
436: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
437: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %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;
434: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
435: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
436: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
437: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
438: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %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;
434: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
435: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
436: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
437: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
438: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
439: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %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;
434: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
435: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
436: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
437: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
438: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
439: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
440: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
433: type t_wljdi_count_point_type is table of wsm_lot_job_dtl_interface.count_point_type %type;
434: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
435: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
436: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
437: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
438: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
439: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
440: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
441: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
434: type t_wljdi_description is table of wsm_lot_job_dtl_interface.description %type;
435: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
436: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
437: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
438: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
439: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
440: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
441: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
442: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
435: type t_wljdi_inc_in_rollup is table of wsm_lot_job_dtl_interface.include_in_rollup %type;
436: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
437: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
438: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
439: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
440: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
441: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
442: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_type %type;
443: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
436: type t_wljdi_option_dep_flag is table of wsm_lot_job_dtl_interface.option_dependent_flag %type;
437: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
438: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
439: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
440: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
441: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
442: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_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;
437: type t_wljdi_mrp_net_flag is table of wsm_lot_job_dtl_interface.mrp_net_flag %type;
438: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
439: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
440: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
441: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
442: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_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;
438: type t_wljdi_auto_request_material is table of wsm_lot_job_dtl_interface.auto_request_material %type;
439: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
440: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
441: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
442: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_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;
439: type t_wljdi_comments is table of wsm_lot_job_dtl_interface.comments %type;
440: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
441: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
442: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_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;
440: type t_wljdi_inventory_item_id_old is table of wsm_lot_job_dtl_interface.inventory_item_id_old %type;
441: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
442: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_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;
441: type t_wljdi_inventory_item_old is table of wsm_lot_job_dtl_interface.inventory_item_old %type;
442: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_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:
442: type t_wljdi_wip_supply_type is table of wsm_lot_job_dtl_interface.wip_supply_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 */
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;
453: /* end */
454:
455: /* ST : Detailed scheduling : end */
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;
453: /* end */
454:
455: /* ST : Detailed scheduling : end */
456:
595: -- instantiating the tables used to bulk bind data from wljdi to the PL/SQL tables.
596: -- ==============================================================================================
597:
598: -- BD: bug 3313463/3311695 8i compatibility
599: --type t_wljdi is table of wsm_lot_job_dtl_interface%rowtype index by binary_integer;
600: --v_wljdi t_wljdi;
601: -- ED: bug 3313463/3311695 8i compatibility
602:
603: -- ==============================================================================================
1302: inventory_item_old,
1303: wip_supply_type,
1304: cumulative_yield,/*Added for bugfix:7248992 */
1305: reverse_cumulative_yield/*Added for bugfix:7248992 */
1306: from wsm_lot_job_dtl_interface
1307: where parent_header_id = p_parent_header_id
1308: and process_status = WIP_CONSTANTS.RUNNING;
1309:
1310: cursor c_wljdi_indp is
1374: inventory_item_old,
1375: wip_supply_type,
1376: cumulative_yield,/*Added for bugfix:7248992 */
1377: reverse_cumulative_yield/*Added for bugfix:7248992 */
1378: from wsm_lot_job_dtl_interface
1379: where parent_header_id IS NULL
1380: and wip_entity_id = p_wip_entity_id
1381: and organization_id = p_org_id
1382: and process_status = WIP_CONSTANTS.RUNNING
2585: -- bulk update WLJDI
2586: ---------------------------------------
2587: l_stmt_num := 110;
2588: forall i in l_v_record_id.first..l_v_record_id.last
2589: update wsm_lot_job_dtl_interface
2590: set substitute_group_num = l_v_sub_grp_num(i),
2591: replacement_group_num = l_v_rpl_grp_num(i),
2592: resource_id_new = l_v_res_id(i),
2593: resource_seq_num = l_v_res_seq_num(i),
6309: job_name,
6310: process_status,
6311: error_code,
6312: error_msg
6313: from wsm_lot_job_dtl_interface
6314: where process_status = WIP_CONSTANTS.PENDING
6315: and parent_header_id IS NULL
6316: and NVL(group_id, -99) = NVL(p_group_id, NVL(group_id, -99))
6317: and transaction_date <= sysdate+1;
6463: -- {{ Check PENDING WLJDI records with parent_header_id = NULL
6464: -----------------------------------------------------------------
6465: if lbji_debug = 'Y' then
6466: fnd_file.put_line(fnd_file.log,
6467: 'Checking wsm_lot_job_dtl_interface..');
6468: end if;
6469:
6470: l_stmt_num := 100;
6471: open c_wljdi_no_parent;
6480: v_wljdi_err_code,
6481: v_wljdi_err_msg;
6482: if lbji_debug = 'Y' then
6483: fnd_file.put_line(fnd_file.log,
6484: 'Number of independent records in WSM_LOT_JOB_DTL_INTERFACE: '
6485: || c_wljdi_no_parent%rowcount);
6486: end if;
6487: l_d_rows := c_wljdi_no_parent%rowcount;
6488: close c_wljdi_no_parent;
6570: -- Update WLJDI for all record with parent_header_id = header_id
6571: l_h := v_wlji_header_id.first;
6572: WHILE l_h <= v_wlji_header_id.last
6573: LOOP
6574: update wsm_lot_job_dtl_interface
6575: set process_status = v_wlji_process_status(l_h),
6576: group_id = p_group_id,
6577: organization_id = v_wlji_org_id(l_h),
6578: organization_code = v_wlji_org_code(l_h),
6609:
6610: if(l_d_rows > 0) then
6611: l_stmt_num := 220;
6612: forall l_d in v_wljdi_record_id.first..v_wljdi_record_id.last
6613: update wsm_lot_job_dtl_interface
6614: set process_status = v_wljdi_process_status(l_d),
6615: organization_id = v_wljdi_org_id(l_d),
6616: organization_code = v_wljdi_org_code(l_d),
6617: wip_entity_id = v_wljdi_wip_entity_id(l_d),
6726: -- Update WLJDI for all record with parent_header_id = header_id
6727: l_h := v_wlji_header_id.first;
6728: WHILE l_h <= v_wlji_header_id.last
6729: LOOP
6730: update wsm_lot_job_dtl_interface
6731: set process_status = v_wlji_process_status(l_h),
6732: group_id = v_wlji_group_id(l_h),
6733: organization_id = v_wlji_org_id(l_h),
6734: organization_code = v_wlji_org_code(l_h),
6764:
6765: if(l_d_rows > 0) then
6766: l_stmt_num := 350;
6767: forall l_d in v_wljdi_record_id.first..v_wljdi_record_id.last
6768: update wsm_lot_job_dtl_interface
6769: set process_status = v_wljdi_process_status(l_d),
6770: group_id = v_wljdi_group_id(l_d), -- assigned gid
6771: organization_id = v_wljdi_org_id(l_d),
6772: organization_code = v_wljdi_org_code(l_d),
6972: cursor c_wljdi_jobs_no_parent is
6973: select unique
6974: wip_entity_id,
6975: organization_id
6976: from wsm_lot_job_dtl_interface
6977: where process_status = WIP_CONSTANTS.RUNNING
6978: and parent_header_id IS NULL
6979: and group_id = p_group_id
6980: and transaction_date <= sysdate+1
7353: l_h := v_wlji_header_id.first;
7354: WHILE l_h <= v_wlji_header_id.last
7355: LOOP
7356: if(v_wlji_num_of_children(l_h) > 0) then
7357: update wsm_lot_job_dtl_interface
7358: set group_id = l_batch_grp_id
7359: where parent_header_id = v_wlji_header_id(l_h);
7360: end if;
7361: l_h := v_wlji_header_id.next(l_h);
12040:
12041: l_stmt_num := 1060.1;
12042:
12043: forall i in v_wlji_process_status.first..v_wlji_process_status.last
12044: update wsm_lot_job_dtl_interface
12045: set process_status = v_wlji_process_status(i),
12046: error_code = v_wlji_err_code(i),
12047: error_msg = decode(v_wlji_process_status(i), -- BUG3600450
12048: 3, 'See header (header_id=' ||
12197: end if;
12198: end if;
12199:
12200: l_stmt_num := 1100.1;
12201: delete from wsm_lot_job_dtl_interface
12202: where parent_header_id IN (
12203: select wlji.header_id
12204: from wsm_lot_job_interface wlji
12205: where wlji.process_status = 5
12243: end if;
12244:
12245: l_stmt_num := 1100.3;
12246: -- this is for those without header
12247: delete from wsm_lot_job_dtl_interface
12248: where process_status = 5
12249: --and group_id = l_batch_grp_id
12250: and NVL(transaction_date, creation_date)
12251: <= decode(l_del_int_prof_value,
12359:
12360: l_stmt_num := 1220;
12361: if(l_d_idx_err > 1) then
12362: forall i in l_v_d_we_id_err.first..l_v_d_we_id_err.last
12363: update wsm_lot_job_dtl_interface
12364: set process_status = 3,
12365: error_code = l_v_d_ecode_err(i),
12366: error_msg = l_v_d_emsg_err(i),
12367: request_id = fnd_global.conc_request_id,
12379: end if;
12380: l_stmt_num := 1230;
12381: if(l_d_idx_ok > 1) then
12382: forall i in l_v_d_we_id_ok.first..l_v_d_we_id_ok.last
12383: delete from wsm_lot_job_dtl_interface
12384: where parent_header_id IS NULL
12385: and process_status = WIP_CONSTANTS.RUNNING
12386: and wip_entity_id = l_v_d_we_id_ok(i)
12387: and organization_id = l_v_d_org_id_ok(i);
15094: comments,
15095: applied_resource_units,
15096: cumulative_yield, /*Added for bugfix:7248992 */
15097: reverse_cumulative_yield/*Added for bugfix:7248992 */
15098: from wsm_lot_job_dtl_interface
15099: where parent_header_id = p_parent_header_id
15100: and process_status = WIP_CONSTANTS.RUNNING
15101: order by load_type,
15102: NVL(parent_resource_seq_num,0), -- Detailed Scheduling Code review remark...
15220: comments,
15221: applied_resource_units,
15222: cumulative_yield, /*Added for bugfix:7248992 */
15223: reverse_cumulative_yield/*Added for bugfix:7248992 */
15224: from wsm_lot_job_dtl_interface
15225: where parent_header_id IS NULL
15226: and wip_entity_id = p_wip_entity_id
15227: and organization_id = p_org_id
15228: and process_status = WIP_CONSTANTS.RUNNING
15385:
15386: /*For Unreleased jobs insert records for changes in wip tables */
15387: BEGIN
15388:
15389: insert into wsm_lot_job_dtl_interface (
15390: record_id,
15391: interface_id,
15392: group_id,
15393: parent_header_id,
15622: operation_yield_enabled,
15623: include_in_rollup,
15624: option_dependent_flag,
15625: recommended
15626: from wsm_lot_job_dtl_interface
15627: where ((parent_header_id = p_parent_header_id)
15628: or (parent_header_id IS NULL and wip_entity_id = p_wip_entity_id and organization_id = p_org_id and NVL(group_id, -1) = NVL(p_group_id, -1)))
15629: and process_status = WIP_CONSTANTS.RUNNING
15630: and (job_op_seq_num=g_op_seq_incr and routing_op_seq_num=l_start_op_seq_num)