eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_LOT_JOB_INTERFACE

Line 12: -- WSM_LOT_JOB_INTERFACE and WSM_LOT_JOB_DTL_INTERFACE

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: -- **********************************************************************************************

Line 44: type t_errmsg is table of wsm_lot_job_interface.error_msg%type

40: -- ==============================================================================================
41: type t_number is table of number index by binary_integer;
42: type t_date is table of date index by binary_integer;
43: type t_recoflag is table of varchar2(1) index by binary_integer;
44: type t_errmsg is table of wsm_lot_job_interface.error_msg%type
45: index by binary_integer;
46: type t_serial is table of VARCHAR2(30) index by binary_integer;
47:
48:

Line 49: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;

45: index by binary_integer;
46: type t_serial is table of VARCHAR2(30) index by binary_integer;
47:
48:
49: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;
50: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
51: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
52: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
53: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;

Line 50: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;

46: type t_serial is table of VARCHAR2(30) index by binary_integer;
47:
48:
49: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;
50: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
51: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
52: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
53: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
54: type t_wlji_program_appl_id is table of wsm_lot_job_interface.program_application_id%type;

Line 51: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;

47:
48:
49: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;
50: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
51: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
52: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
53: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
54: type t_wlji_program_appl_id is table of wsm_lot_job_interface.program_application_id%type;
55: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;

Line 52: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;

48:
49: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;
50: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
51: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
52: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
53: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
54: type t_wlji_program_appl_id is table of wsm_lot_job_interface.program_application_id%type;
55: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
56: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;

Line 53: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;

49: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;
50: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
51: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
52: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
53: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
54: type t_wlji_program_appl_id is table of wsm_lot_job_interface.program_application_id%type;
55: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
56: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
57: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;

Line 54: type t_wlji_program_appl_id is table of wsm_lot_job_interface.program_application_id%type;

50: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
51: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
52: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
53: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
54: type t_wlji_program_appl_id is table of wsm_lot_job_interface.program_application_id%type;
55: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
56: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
57: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
58: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;

Line 55: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;

51: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
52: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
53: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
54: type t_wlji_program_appl_id is table of wsm_lot_job_interface.program_application_id%type;
55: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
56: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
57: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
58: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
59: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;

Line 56: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;

52: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
53: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
54: type t_wlji_program_appl_id is table of wsm_lot_job_interface.program_application_id%type;
55: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
56: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
57: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
58: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
59: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
60: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;

Line 57: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;

53: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
54: type t_wlji_program_appl_id is table of wsm_lot_job_interface.program_application_id%type;
55: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
56: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
57: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
58: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
59: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
60: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
61: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;

Line 58: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;

54: type t_wlji_program_appl_id is table of wsm_lot_job_interface.program_application_id%type;
55: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
56: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
57: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
58: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
59: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
60: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
61: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
62: type t_wlji_org_id is table of wsm_lot_job_interface.organization_id%type;

Line 59: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;

55: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
56: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
57: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
58: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
59: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
60: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
61: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
62: type t_wlji_org_id is table of wsm_lot_job_interface.organization_id%type;
63: type t_wlji_org_code is table of wsm_lot_job_interface.organization_code%type;

Line 60: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;

56: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
57: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
58: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
59: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
60: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
61: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
62: type t_wlji_org_id is table of wsm_lot_job_interface.organization_id%type;
63: type t_wlji_org_code is table of wsm_lot_job_interface.organization_code%type;
64: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;

Line 61: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;

57: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
58: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
59: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
60: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
61: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
62: type t_wlji_org_id is table of wsm_lot_job_interface.organization_id%type;
63: type t_wlji_org_code is table of wsm_lot_job_interface.organization_code%type;
64: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
65: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;

Line 62: type t_wlji_org_id is table of wsm_lot_job_interface.organization_id%type;

58: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
59: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
60: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
61: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
62: type t_wlji_org_id is table of wsm_lot_job_interface.organization_id%type;
63: type t_wlji_org_code is table of wsm_lot_job_interface.organization_code%type;
64: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
65: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
66: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;

Line 63: type t_wlji_org_code is table of wsm_lot_job_interface.organization_code%type;

59: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
60: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
61: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
62: type t_wlji_org_id is table of wsm_lot_job_interface.organization_id%type;
63: type t_wlji_org_code is table of wsm_lot_job_interface.organization_code%type;
64: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
65: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
66: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
67: type t_wlji_item_id is table of wsm_lot_job_interface.primary_item_id%type;

Line 64: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;

60: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
61: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
62: type t_wlji_org_id is table of wsm_lot_job_interface.organization_id%type;
63: type t_wlji_org_code is table of wsm_lot_job_interface.organization_code%type;
64: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
65: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
66: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
67: type t_wlji_item_id is table of wsm_lot_job_interface.primary_item_id%type;
68: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;

Line 65: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;

61: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
62: type t_wlji_org_id is table of wsm_lot_job_interface.organization_id%type;
63: type t_wlji_org_code is table of wsm_lot_job_interface.organization_code%type;
64: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
65: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
66: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
67: type t_wlji_item_id is table of wsm_lot_job_interface.primary_item_id%type;
68: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
69: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;

Line 66: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;

62: type t_wlji_org_id is table of wsm_lot_job_interface.organization_id%type;
63: type t_wlji_org_code is table of wsm_lot_job_interface.organization_code%type;
64: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
65: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
66: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
67: type t_wlji_item_id is table of wsm_lot_job_interface.primary_item_id%type;
68: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
69: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
70: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;

Line 67: type t_wlji_item_id is table of wsm_lot_job_interface.primary_item_id%type;

63: type t_wlji_org_code is table of wsm_lot_job_interface.organization_code%type;
64: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
65: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
66: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
67: type t_wlji_item_id is table of wsm_lot_job_interface.primary_item_id%type;
68: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
69: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
70: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
71: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;

Line 68: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;

64: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
65: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
66: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
67: type t_wlji_item_id is table of wsm_lot_job_interface.primary_item_id%type;
68: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
69: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
70: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
71: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
72: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;

Line 69: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;

65: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
66: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
67: type t_wlji_item_id is table of wsm_lot_job_interface.primary_item_id%type;
68: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
69: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
70: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
71: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
72: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;

Line 70: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;

66: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
67: type t_wlji_item_id is table of wsm_lot_job_interface.primary_item_id%type;
68: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
69: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
70: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
71: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
72: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;

Line 71: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;

67: type t_wlji_item_id is table of wsm_lot_job_interface.primary_item_id%type;
68: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
69: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
70: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
71: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
72: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;

Line 72: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;

68: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
69: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
70: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
71: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
72: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;

Line 73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;

69: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
70: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
71: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
72: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;

Line 74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;

70: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
71: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
72: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;

Line 75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;

71: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
72: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;

Line 76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;

72: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;

Line 77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;

73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;

Line 78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;

74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
82: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;

Line 79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;

75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
82: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
83: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;

Line 80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;

76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
82: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
83: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
84: type t_wlji_description is table of wsm_lot_job_interface.description%type;

Line 81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;

77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
82: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
83: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
84: type t_wlji_description is table of wsm_lot_job_interface.description%type;
85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;

Line 82: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;

78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
82: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
83: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
84: type t_wlji_description is table of wsm_lot_job_interface.description%type;
85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;

Line 83: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;

79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
82: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
83: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
84: type t_wlji_description is table of wsm_lot_job_interface.description%type;
85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;

Line 84: type t_wlji_description is table of wsm_lot_job_interface.description%type;

80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
82: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
83: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
84: type t_wlji_description is table of wsm_lot_job_interface.description%type;
85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;

Line 85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;

81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
82: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
83: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
84: type t_wlji_description is table of wsm_lot_job_interface.description%type;
85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;

Line 86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;

82: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
83: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
84: type t_wlji_description is table of wsm_lot_job_interface.description%type;
85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;

Line 87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;

83: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
84: type t_wlji_description is table of wsm_lot_job_interface.description%type;
85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
91: type t_wlji_error is table of wsm_lot_job_interface.error%type;

Line 88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;

84: type t_wlji_description is table of wsm_lot_job_interface.description%type;
85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
91: type t_wlji_error is table of wsm_lot_job_interface.error%type;
92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;

Line 89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;

85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
91: type t_wlji_error is table of wsm_lot_job_interface.error%type;
92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;

Line 90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;

86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
91: type t_wlji_error is table of wsm_lot_job_interface.error%type;
92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;

Line 91: type t_wlji_error is table of wsm_lot_job_interface.error%type;

87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
91: type t_wlji_error is table of wsm_lot_job_interface.error%type;
92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;
95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;

Line 92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;

88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
91: type t_wlji_error is table of wsm_lot_job_interface.error%type;
92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;
95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;

Line 93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;

89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
91: type t_wlji_error is table of wsm_lot_job_interface.error%type;
92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;
95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;

Line 94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;

90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
91: type t_wlji_error is table of wsm_lot_job_interface.error%type;
92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;
95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;

Line 95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;

91: type t_wlji_error is table of wsm_lot_job_interface.error%type;
92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;
95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;

Line 96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;

92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;
95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;

Line 97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;

93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;
95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;

Line 98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;

94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;
95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;

Line 99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;

95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;

Line 100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;

96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;

Line 101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;

97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;

Line 102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;

98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;

Line 103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;

99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;

Line 104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;

100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;

Line 105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;

101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;

Line 106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;

102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;

Line 107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;

103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;

Line 108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;

104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;

Line 109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;

105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;

Line 110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;

106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
114: type t_wlji_desc_flx_segs is table of wsm_lot_job_interface.descriptive_flex_segments%type;

Line 111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;

107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
114: type t_wlji_desc_flx_segs is table of wsm_lot_job_interface.descriptive_flex_segments%type;
115: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;

Line 112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;

108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
114: type t_wlji_desc_flx_segs is table of wsm_lot_job_interface.descriptive_flex_segments%type;
115: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
116: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;

Line 113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;

109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
114: type t_wlji_desc_flx_segs is table of wsm_lot_job_interface.descriptive_flex_segments%type;
115: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
116: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
117: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;

Line 114: type t_wlji_desc_flx_segs is table of wsm_lot_job_interface.descriptive_flex_segments%type;

110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
114: type t_wlji_desc_flx_segs is table of wsm_lot_job_interface.descriptive_flex_segments%type;
115: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
116: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
117: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
118: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;

Line 115: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;

111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
114: type t_wlji_desc_flx_segs is table of wsm_lot_job_interface.descriptive_flex_segments%type;
115: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
116: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
117: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
118: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
119: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;

Line 116: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;

112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
114: type t_wlji_desc_flx_segs is table of wsm_lot_job_interface.descriptive_flex_segments%type;
115: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
116: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
117: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
118: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
119: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
120: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;

Line 117: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;

113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
114: type t_wlji_desc_flx_segs is table of wsm_lot_job_interface.descriptive_flex_segments%type;
115: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
116: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
117: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
118: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
119: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
120: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
121: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;

Line 118: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;

114: type t_wlji_desc_flx_segs is table of wsm_lot_job_interface.descriptive_flex_segments%type;
115: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
116: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
117: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
118: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
119: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
120: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
121: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
122: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;

Line 119: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;

115: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
116: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
117: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
118: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
119: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
120: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
121: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
122: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
123: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;

Line 120: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;

116: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
117: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
118: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
119: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
120: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
121: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
122: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
123: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
124: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;

Line 121: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;

117: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
118: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
119: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
120: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
121: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
122: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
123: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
124: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
125: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;

Line 122: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;

118: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
119: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
120: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
121: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
122: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
123: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
124: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
125: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
126: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;

Line 123: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;

119: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
120: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
121: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
122: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
123: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
124: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
125: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
126: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
127: type t_wlji_compl_loc_segs is table of wsm_lot_job_interface.completion_locator_segments%type;

Line 124: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;

120: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
121: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
122: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
123: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
124: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
125: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
126: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
127: type t_wlji_compl_loc_segs is table of wsm_lot_job_interface.completion_locator_segments%type;
128: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;

Line 125: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;

121: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
122: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
123: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
124: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
125: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
126: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
127: type t_wlji_compl_loc_segs is table of wsm_lot_job_interface.completion_locator_segments%type;
128: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
129: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;

Line 126: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;

122: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
123: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
124: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
125: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
126: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
127: type t_wlji_compl_loc_segs is table of wsm_lot_job_interface.completion_locator_segments%type;
128: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
129: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
130: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;

Line 127: type t_wlji_compl_loc_segs is table of wsm_lot_job_interface.completion_locator_segments%type;

123: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
124: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
125: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
126: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
127: type t_wlji_compl_loc_segs is table of wsm_lot_job_interface.completion_locator_segments%type;
128: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
129: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
130: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
131: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;

Line 128: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;

124: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
125: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
126: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
127: type t_wlji_compl_loc_segs is table of wsm_lot_job_interface.completion_locator_segments%type;
128: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
129: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
130: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
131: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
132: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;

Line 129: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;

125: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
126: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
127: type t_wlji_compl_loc_segs is table of wsm_lot_job_interface.completion_locator_segments%type;
128: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
129: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
130: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
131: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
132: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
133: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;

Line 130: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;

126: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
127: type t_wlji_compl_loc_segs is table of wsm_lot_job_interface.completion_locator_segments%type;
128: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
129: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
130: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
131: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
132: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
133: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
134: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;

Line 131: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;

127: type t_wlji_compl_loc_segs is table of wsm_lot_job_interface.completion_locator_segments%type;
128: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
129: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
130: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
131: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
132: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
133: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
134: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
135: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;

Line 132: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;

128: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
129: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
130: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
131: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
132: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
133: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
134: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
135: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
136: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;

Line 133: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;

129: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
130: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
131: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
132: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
133: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
134: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
135: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
136: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
137: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;

Line 134: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;

130: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
131: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
132: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
133: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
134: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
135: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
136: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
137: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
138: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;

Line 135: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;

131: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
132: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
133: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
134: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
135: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
136: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
137: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
138: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
139: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;

Line 136: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;

132: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
133: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
134: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
135: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
136: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
137: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
138: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
139: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
140: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;

Line 137: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;

133: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
134: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
135: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
136: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
137: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
138: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
139: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
140: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
141: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;

Line 138: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;

134: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
135: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
136: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
137: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
138: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
139: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
140: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
141: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
142: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;

Line 139: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;

135: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
136: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
137: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
138: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
139: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
140: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
141: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
142: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
143: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;

Line 140: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;

136: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
137: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
138: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
139: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
140: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
141: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
142: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
143: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
144: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;

Line 141: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;

137: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
138: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
139: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
140: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
141: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
142: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
143: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
144: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
145: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;

Line 142: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;

138: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
139: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
140: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
141: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
142: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
143: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
144: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
145: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
146: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;

Line 143: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;

139: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
140: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
141: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
142: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
143: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
144: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
145: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
146: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
147: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;

Line 144: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;

140: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
141: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
142: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
143: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
144: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
145: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
146: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
147: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
148: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;

Line 145: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;

141: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
142: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
143: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
144: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
145: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
146: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
147: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
148: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
149: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;

Line 146: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;

142: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
143: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
144: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
145: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
146: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
147: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
148: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
149: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
150: type t_wlji_primary_item_segs is table of wsm_lot_job_interface.primary_item_segments%type;

Line 147: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;

143: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
144: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
145: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
146: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
147: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
148: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
149: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
150: type t_wlji_primary_item_segs is table of wsm_lot_job_interface.primary_item_segments%type;
151: type t_wlji_bom_ref_segs is table of wsm_lot_job_interface.bom_reference_segments%type;

Line 148: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;

144: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
145: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
146: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
147: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
148: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
149: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
150: type t_wlji_primary_item_segs is table of wsm_lot_job_interface.primary_item_segments%type;
151: type t_wlji_bom_ref_segs is table of wsm_lot_job_interface.bom_reference_segments%type;
152: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;

Line 149: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;

145: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
146: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
147: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
148: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
149: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
150: type t_wlji_primary_item_segs is table of wsm_lot_job_interface.primary_item_segments%type;
151: type t_wlji_bom_ref_segs is table of wsm_lot_job_interface.bom_reference_segments%type;
152: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
153: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type;

Line 150: type t_wlji_primary_item_segs is table of wsm_lot_job_interface.primary_item_segments%type;

146: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
147: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
148: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
149: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
150: type t_wlji_primary_item_segs is table of wsm_lot_job_interface.primary_item_segments%type;
151: type t_wlji_bom_ref_segs is table of wsm_lot_job_interface.bom_reference_segments%type;
152: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
153: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type;
154: type t_wlji_transaction_date is table of wsm_lot_job_interface.transaction_date%type;

Line 151: type t_wlji_bom_ref_segs is table of wsm_lot_job_interface.bom_reference_segments%type;

147: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
148: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
149: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
150: type t_wlji_primary_item_segs is table of wsm_lot_job_interface.primary_item_segments%type;
151: type t_wlji_bom_ref_segs is table of wsm_lot_job_interface.bom_reference_segments%type;
152: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
153: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type;
154: type t_wlji_transaction_date is table of wsm_lot_job_interface.transaction_date%type;
155: type t_wlji_num_of_children is table of wsm_lot_job_interface.num_of_children%type;

Line 152: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;

148: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
149: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
150: type t_wlji_primary_item_segs is table of wsm_lot_job_interface.primary_item_segments%type;
151: type t_wlji_bom_ref_segs is table of wsm_lot_job_interface.bom_reference_segments%type;
152: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
153: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type;
154: type t_wlji_transaction_date is table of wsm_lot_job_interface.transaction_date%type;
155: type t_wlji_num_of_children is table of wsm_lot_job_interface.num_of_children%type;
156: --type t_wlji_inf_schedule_flag is table of wsm_lot_job_interface.infinite_schedule_flag%type;

Line 153: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type;

149: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
150: type t_wlji_primary_item_segs is table of wsm_lot_job_interface.primary_item_segments%type;
151: type t_wlji_bom_ref_segs is table of wsm_lot_job_interface.bom_reference_segments%type;
152: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
153: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type;
154: type t_wlji_transaction_date is table of wsm_lot_job_interface.transaction_date%type;
155: type t_wlji_num_of_children is table of wsm_lot_job_interface.num_of_children%type;
156: --type t_wlji_inf_schedule_flag is table of wsm_lot_job_interface.infinite_schedule_flag%type;
157:

Line 154: type t_wlji_transaction_date is table of wsm_lot_job_interface.transaction_date%type;

150: type t_wlji_primary_item_segs is table of wsm_lot_job_interface.primary_item_segments%type;
151: type t_wlji_bom_ref_segs is table of wsm_lot_job_interface.bom_reference_segments%type;
152: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
153: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type;
154: type t_wlji_transaction_date is table of wsm_lot_job_interface.transaction_date%type;
155: type t_wlji_num_of_children is table of wsm_lot_job_interface.num_of_children%type;
156: --type t_wlji_inf_schedule_flag is table of wsm_lot_job_interface.infinite_schedule_flag%type;
157:
158: -- ==============================================================================================

Line 155: type t_wlji_num_of_children is table of wsm_lot_job_interface.num_of_children%type;

151: type t_wlji_bom_ref_segs is table of wsm_lot_job_interface.bom_reference_segments%type;
152: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
153: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type;
154: type t_wlji_transaction_date is table of wsm_lot_job_interface.transaction_date%type;
155: type t_wlji_num_of_children is table of wsm_lot_job_interface.num_of_children%type;
156: --type t_wlji_inf_schedule_flag is table of wsm_lot_job_interface.infinite_schedule_flag%type;
157:
158: -- ==============================================================================================
159: -- instantiating the tables used to bulk bind data from wlji to the PL/SQL tables.

Line 156: --type t_wlji_inf_schedule_flag is table of wsm_lot_job_interface.infinite_schedule_flag%type;

152: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
153: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type;
154: type t_wlji_transaction_date is table of wsm_lot_job_interface.transaction_date%type;
155: type t_wlji_num_of_children is table of wsm_lot_job_interface.num_of_children%type;
156: --type t_wlji_inf_schedule_flag is table of wsm_lot_job_interface.infinite_schedule_flag%type;
157:
158: -- ==============================================================================================
159: -- instantiating the tables used to bulk bind data from wlji to the PL/SQL tables.
160: -- ==============================================================================================

Line 1046: l_old_job_name wsm_lot_job_interface.job_name%type; --fix for bug5990761

1042: l_temp_num number;
1043: l_xst boolean;
1044: l_stmt_num number;
1045: l_job_name_hash number;
1046: l_old_job_name wsm_lot_job_interface.job_name%type; --fix for bug5990761
1047: BEGIN
1048:
1049: x_error_code := 0;
1050: x_error_msg := '';

Line 6280: from wsm_lot_job_interface

6276: process_status,
6277: error_code,
6278: error_msg,
6279: num_of_children
6280: from wsm_lot_job_interface
6281: where process_status = WIP_CONSTANTS.PENDING
6282: and NVL(transaction_date, creation_date) <= sysdate+1
6283: and NVL(group_id, -99) = NVL(p_group_id, NVL(group_id, -99))
6284: and load_type in (5,6)

Line 6376: 'Number of records in WSM_LOT_JOB_INTERFACE: ' || c_wlji%rowcount);

6372: v_wlji_err_msg,
6373: v_wlji_num_of_children;
6374: if lbji_debug = 'Y' then
6375: fnd_file.put_line(fnd_file.log,
6376: 'Number of records in WSM_LOT_JOB_INTERFACE: ' || c_wlji%rowcount);
6377: end if;
6378: l_h_rows := c_wlji%rowcount;
6379: close c_wlji;
6380:

Line 6577: -- bulk update wsm_lot_job_interface

6573: l_h := v_wlji_header_id.next(l_h);
6574: END LOOP;
6575:
6576: l_stmt_num := 210;
6577: -- bulk update wsm_lot_job_interface
6578: forall l_h in v_wlji_header_id.first..v_wlji_header_id.last
6579: update wsm_lot_job_interface
6580: set process_status = v_wlji_process_status(l_h),
6581: organization_id = v_wlji_org_id(l_h),

Line 6579: update wsm_lot_job_interface

6575:
6576: l_stmt_num := 210;
6577: -- bulk update wsm_lot_job_interface
6578: forall l_h in v_wlji_header_id.first..v_wlji_header_id.last
6579: update wsm_lot_job_interface
6580: set process_status = v_wlji_process_status(l_h),
6581: organization_id = v_wlji_org_id(l_h),
6582: organization_code = v_wlji_org_code(l_h),
6583: wip_entity_id = v_wlji_wip_entity_id(l_h),

Line 6660: select wsm_lot_job_interface_s.NEXTVAL

6656: if not l_v_job_gid.exists(l_job_name_hash) then -- one new job name
6657: if mod(l_job_cnt, l_num_jobs_per) = 0 then
6658: l_wrk_cnt := l_wrk_cnt + 1; -- one more worker
6659: -- get a new group id
6660: select wsm_lot_job_interface_s.NEXTVAL
6661: into l_group_id
6662: from dual;
6663: l_v_group_id(l_wrk_cnt) := l_group_id;
6664: l_v_group_no(l_wrk_cnt) := 0;

Line 6688: select wsm_lot_job_interface_s.NEXTVAL

6684: 37, 1073741824);
6685: if not l_v_job_gid.exists(l_job_name_hash) then -- a new job
6686: if mod(l_job_cnt, l_num_jobs_per) = 0 then
6687: l_wrk_cnt := l_wrk_cnt +1; -- one more worker
6688: select wsm_lot_job_interface_s.NEXTVAL
6689: into l_group_id
6690: from dual;
6691: l_v_group_id(l_wrk_cnt) := l_group_id;
6692: l_v_group_no(l_wrk_cnt) := 0;

Line 6731: -- bulk update wsm_lot_job_interface

6727: l_h := v_wlji_header_id.next(l_h);
6728: END LOOP;
6729:
6730: l_stmt_num := 340;
6731: -- bulk update wsm_lot_job_interface
6732: forall l_h in v_wlji_header_id.first..v_wlji_header_id.last
6733: update wsm_lot_job_interface
6734: set process_status = v_wlji_process_status(l_h),
6735: group_id = v_wlji_group_id(l_h), -- assigned gid

Line 6733: update wsm_lot_job_interface

6729:
6730: l_stmt_num := 340;
6731: -- bulk update wsm_lot_job_interface
6732: forall l_h in v_wlji_header_id.first..v_wlji_header_id.last
6733: update wsm_lot_job_interface
6734: set process_status = v_wlji_process_status(l_h),
6735: group_id = v_wlji_group_id(l_h), -- assigned gid
6736: organization_id = v_wlji_org_id(l_h),
6737: organization_code = v_wlji_org_code(l_h),

Line 6947: from wsm_lot_job_interface

6943: date_released,
6944: transaction_date,
6945: num_of_children
6946: --, NVL(infinite_schedule_flag, 'N')
6947: from wsm_lot_job_interface
6948: where group_id = p_group_id
6949: and process_status = 2 -- WIP_CONSTANTS.RUNNING;
6950: order by organization_id,
6951: load_type,

Line 7326: select wsm_lot_job_interface_s.NEXTVAL

7322: l_stmt_num := 60;
7323: -- updating the group_id column of wlji with a number unique for this particular batch.
7324: -- This'll help when I select corresponding rows from wsli.
7325:
7326: select wsm_lot_job_interface_s.NEXTVAL
7327: into l_batch_grp_id
7328: from dual;
7329:
7330: l_stmt_num := 60.1;

Line 7332: update wsm_lot_job_interface

7328: from dual;
7329:
7330: l_stmt_num := 60.1;
7331: forall indx in v_wlji_header_id.first..v_wlji_header_id.last
7332: update wsm_lot_job_interface
7333: set group_id = l_batch_grp_id
7334: where header_id = v_wlji_header_id(indx);
7335:
7336: l_stmt_num := 60.2;

Line 11914: -- bulk update wsm_lot_job_interface

11910: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
11911: end if;
11912:
11913: l_stmt_num := 1060;
11914: -- bulk update wsm_lot_job_interface
11915: forall i in v_wlji_process_status.first..v_wlji_process_status.last
11916: update wsm_lot_job_interface
11917: set process_status = v_wlji_process_status(i),
11918: error_code = v_wlji_err_code(i),

Line 11916: update wsm_lot_job_interface

11912:
11913: l_stmt_num := 1060;
11914: -- bulk update wsm_lot_job_interface
11915: forall i in v_wlji_process_status.first..v_wlji_process_status.last
11916: update wsm_lot_job_interface
11917: set process_status = v_wlji_process_status(i),
11918: error_code = v_wlji_err_code(i),
11919: error_msg = v_wlji_err_msg(i),
11920: request_id = v_wlji_request_id(i),

Line 11980: update wsm_lot_job_interface

11976: '(Transaction_header_id=' ||l_mmtt_txn_hdr_id||') : '
11977: || SUBSTRB(SQLERRM,1,1000);
11978: fnd_file.put_line(fnd_file.log,errbuf);
11979: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
11980: update wsm_lot_job_interface
11981: set process_status = 4,
11982: error_code = -2,
11983: error_msg = l_error_msg
11984: where mode_flag = 2;

Line 12081: from wsm_lot_job_interface wlji

12077: l_stmt_num := 1100;
12078: delete from wsm_starting_lots_interface
12079: where header_id IN (
12080: select wlji.source_line_id
12081: from wsm_lot_job_interface wlji
12082: where wlji.process_status = 5
12083: --and wlji.group_id = l_batch_grp_id
12084: and NVL(transaction_date, creation_date)
12085: <= decode(l_del_int_prof_value,

Line 12100: from wsm_lot_job_interface wlji

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
12102: --and wlji.group_id = l_batch_grp_id
12103: and NVL(transaction_date, creation_date)
12104: <= decode(l_del_int_prof_value,

Line 12116: from wsm_lot_job_interface wlji

12112: -- Delete successful rows from WSM_SERIAL_TXN_INTERFACE
12113: delete from WSM_SERIAL_TXN_INTERFACE
12114: where header_id IN
12115: (select wlji.header_id
12116: from wsm_lot_job_interface wlji
12117: where wlji.process_status = 5
12118: and NVL(transaction_date, creation_date)
12119: <= decode(l_del_int_prof_value,
12120: null,

Line 12128: delete from wsm_lot_job_interface

12124: -- ST : Serial Support Project ...........................----------------------------------------------
12125:
12126: l_stmt_num := 1100.25;
12127:
12128: delete from wsm_lot_job_interface
12129: where process_status = 5
12130: --and group_id = l_batch_grp_id
12131: and NVL(transaction_date, creation_date)
12132: <= decode(l_del_int_prof_value,

Line 20110: wsm_lot_job_interface wlji,

20106: wsli.created_by,
20107: msi.primary_uom_code,
20108: wsli.component_issue_quantity
20109: from wsm_starting_lots_interface wsli,
20110: wsm_lot_job_interface wlji,
20111: mtl_system_items msi
20112: where wsli.header_id = wlji.source_line_id
20113: and wlji.group_id = p_group_id
20114: and wlji.process_status = 2 -- WIP_CONSTANTS.running

Line 20190: wsm_lot_job_interface wlji

20186: wsli.header_id,
20187: wlji.header_id
20188: from mtl_material_transactions_temp mmtt,
20189: wsm_starting_lots_interface wsli,
20190: wsm_lot_job_interface wlji
20191: where mmtt.transaction_header_id = p_header_id
20192: and mmtt.source_line_id = wsli.header_id
20193: and wsli.header_id = wlji.source_line_id;
20194: BEGIN

Line 20207: update wsm_lot_job_interface wljia

20203: l_wlji_header_id;
20204:
20205: exit when recs%notfound;
20206:
20207: update wsm_lot_job_interface wljia
20208: set wljia.process_status = 4,
20209: wljia.error_code = -2,
20210: wljia.error_msg = substr(l_err_explanation,1,240)
20211: where wljia.header_id = l_wlji_header_id;