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: ----The below defined plsql tables are used for updating the DFF attributes.

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: ----The below defined plsql tables are used for updating the DFF attributes.
159:

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: ----The below defined plsql tables are used for updating the DFF attributes.
159:
160: type t_attribute_category is table of VARCHAR2(30) index by binary_integer;

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

1047: l_temp_num number;
1048: l_xst boolean;
1049: l_stmt_num number;
1050: l_job_name_hash number;
1051: l_old_job_name wsm_lot_job_interface.job_name%type; --fix for bug5990761
1052: BEGIN
1053:
1054: x_error_code := 0;
1055: x_error_msg := '';

Line 6296: from wsm_lot_job_interface

6292: process_status,
6293: error_code,
6294: error_msg,
6295: num_of_children
6296: from wsm_lot_job_interface
6297: where process_status = WIP_CONSTANTS.PENDING
6298: and NVL(transaction_date, creation_date) <= sysdate+1
6299: and NVL(group_id, -99) = NVL(p_group_id, NVL(group_id, -99))
6300: and load_type in (5,6)

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

6388: v_wlji_err_msg,
6389: v_wlji_num_of_children;
6390: if lbji_debug = 'Y' then
6391: fnd_file.put_line(fnd_file.log,
6392: 'Number of records in WSM_LOT_JOB_INTERFACE: ' || c_wlji%rowcount);
6393: end if;
6394: l_h_rows := c_wlji%rowcount;
6395: close c_wlji;
6396:

Line 6593: -- bulk update wsm_lot_job_interface

6589: l_h := v_wlji_header_id.next(l_h);
6590: END LOOP;
6591:
6592: l_stmt_num := 210;
6593: -- bulk update wsm_lot_job_interface
6594: forall l_h in v_wlji_header_id.first..v_wlji_header_id.last
6595: update wsm_lot_job_interface
6596: set process_status = v_wlji_process_status(l_h),
6597: organization_id = v_wlji_org_id(l_h),

Line 6595: update wsm_lot_job_interface

6591:
6592: l_stmt_num := 210;
6593: -- bulk update wsm_lot_job_interface
6594: forall l_h in v_wlji_header_id.first..v_wlji_header_id.last
6595: update wsm_lot_job_interface
6596: set process_status = v_wlji_process_status(l_h),
6597: organization_id = v_wlji_org_id(l_h),
6598: organization_code = v_wlji_org_code(l_h),
6599: wip_entity_id = v_wlji_wip_entity_id(l_h),

Line 6676: select wsm_lot_job_interface_s.NEXTVAL

6672: if not l_v_job_gid.exists(l_job_name_hash) then -- one new job name
6673: if mod(l_job_cnt, l_num_jobs_per) = 0 then
6674: l_wrk_cnt := l_wrk_cnt + 1; -- one more worker
6675: -- get a new group id
6676: select wsm_lot_job_interface_s.NEXTVAL
6677: into l_group_id
6678: from dual;
6679: l_v_group_id(l_wrk_cnt) := l_group_id;
6680: l_v_group_no(l_wrk_cnt) := 0;

Line 6704: select wsm_lot_job_interface_s.NEXTVAL

6700: 37, 1073741824);
6701: if not l_v_job_gid.exists(l_job_name_hash) then -- a new job
6702: if mod(l_job_cnt, l_num_jobs_per) = 0 then
6703: l_wrk_cnt := l_wrk_cnt +1; -- one more worker
6704: select wsm_lot_job_interface_s.NEXTVAL
6705: into l_group_id
6706: from dual;
6707: l_v_group_id(l_wrk_cnt) := l_group_id;
6708: l_v_group_no(l_wrk_cnt) := 0;

Line 6747: -- bulk update wsm_lot_job_interface

6743: l_h := v_wlji_header_id.next(l_h);
6744: END LOOP;
6745:
6746: l_stmt_num := 340;
6747: -- bulk update wsm_lot_job_interface
6748: forall l_h in v_wlji_header_id.first..v_wlji_header_id.last
6749: update wsm_lot_job_interface
6750: set process_status = v_wlji_process_status(l_h),
6751: group_id = v_wlji_group_id(l_h), -- assigned gid

Line 6749: update wsm_lot_job_interface

6745:
6746: l_stmt_num := 340;
6747: -- bulk update wsm_lot_job_interface
6748: forall l_h in v_wlji_header_id.first..v_wlji_header_id.last
6749: update wsm_lot_job_interface
6750: set process_status = v_wlji_process_status(l_h),
6751: group_id = v_wlji_group_id(l_h), -- assigned gid
6752: organization_id = v_wlji_org_id(l_h),
6753: organization_code = v_wlji_org_code(l_h),

Line 6963: from wsm_lot_job_interface

6959: date_released,
6960: transaction_date,
6961: num_of_children
6962: --, NVL(infinite_schedule_flag, 'N')
6963: from wsm_lot_job_interface
6964: where group_id = p_group_id
6965: and process_status = 2 -- WIP_CONSTANTS.RUNNING;
6966: order by organization_id,
6967: load_type,

Line 7342: select wsm_lot_job_interface_s.NEXTVAL

7338: l_stmt_num := 60;
7339: -- updating the group_id column of wlji with a number unique for this particular batch.
7340: -- This'll help when I select corresponding rows from wsli.
7341:
7342: select wsm_lot_job_interface_s.NEXTVAL
7343: into l_batch_grp_id
7344: from dual;
7345:
7346: l_stmt_num := 60.1;

Line 7348: update wsm_lot_job_interface

7344: from dual;
7345:
7346: l_stmt_num := 60.1;
7347: forall indx in v_wlji_header_id.first..v_wlji_header_id.last
7348: update wsm_lot_job_interface
7349: set group_id = l_batch_grp_id
7350: where header_id = v_wlji_header_id(indx);
7351:
7352: l_stmt_num := 60.2;

Line 12018: -- bulk update wsm_lot_job_interface

12014: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12015: end if;
12016:
12017: l_stmt_num := 1060;
12018: -- bulk update wsm_lot_job_interface
12019: forall i in v_wlji_process_status.first..v_wlji_process_status.last
12020: update wsm_lot_job_interface
12021: set process_status = v_wlji_process_status(i),
12022: error_code = v_wlji_err_code(i),

Line 12020: update wsm_lot_job_interface

12016:
12017: l_stmt_num := 1060;
12018: -- bulk update wsm_lot_job_interface
12019: forall i in v_wlji_process_status.first..v_wlji_process_status.last
12020: update wsm_lot_job_interface
12021: set process_status = v_wlji_process_status(i),
12022: error_code = v_wlji_err_code(i),
12023: error_msg = v_wlji_err_msg(i),
12024: request_id = v_wlji_request_id(i),

Line 12084: update wsm_lot_job_interface

12080: '(Transaction_header_id=' ||l_mmtt_txn_hdr_id||') : '
12081: || SUBSTRB(SQLERRM,1,1000);
12082: fnd_file.put_line(fnd_file.log,errbuf);
12083: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12084: update wsm_lot_job_interface
12085: set process_status = 4,
12086: error_code = -2,
12087: error_msg = l_error_msg
12088: where mode_flag = 2;

Line 12185: from wsm_lot_job_interface wlji

12181: l_stmt_num := 1100;
12182: delete from wsm_starting_lots_interface
12183: where header_id IN (
12184: select wlji.source_line_id
12185: from wsm_lot_job_interface wlji
12186: where wlji.process_status = 5
12187: --and wlji.group_id = l_batch_grp_id
12188: and NVL(transaction_date, creation_date)
12189: <= decode(l_del_int_prof_value,

Line 12204: from wsm_lot_job_interface wlji

12200: l_stmt_num := 1100.1;
12201: delete from wsm_lot_job_dtl_interface
12202: where parent_header_id IN (
12203: select wlji.header_id
12204: from wsm_lot_job_interface wlji
12205: where wlji.process_status = 5
12206: --and wlji.group_id = l_batch_grp_id
12207: and NVL(transaction_date, creation_date)
12208: <= decode(l_del_int_prof_value,

Line 12220: from wsm_lot_job_interface wlji

12216: -- Delete successful rows from WSM_SERIAL_TXN_INTERFACE
12217: delete from WSM_SERIAL_TXN_INTERFACE
12218: where header_id IN
12219: (select wlji.header_id
12220: from wsm_lot_job_interface wlji
12221: where wlji.process_status = 5
12222: and NVL(transaction_date, creation_date)
12223: <= decode(l_del_int_prof_value,
12224: null,

Line 12232: delete from wsm_lot_job_interface

12228: -- ST : Serial Support Project ...........................----------------------------------------------
12229:
12230: l_stmt_num := 1100.25;
12231:
12232: delete from wsm_lot_job_interface
12233: where process_status = 5
12234: --and group_id = l_batch_grp_id
12235: and NVL(transaction_date, creation_date)
12236: <= decode(l_del_int_prof_value,

Line 20766: wsm_lot_job_interface wlji,

20762: wsli.created_by,
20763: msi.primary_uom_code,
20764: wsli.component_issue_quantity
20765: from wsm_starting_lots_interface wsli,
20766: wsm_lot_job_interface wlji,
20767: mtl_system_items msi
20768: where wsli.header_id = wlji.source_line_id
20769: and wlji.group_id = p_group_id
20770: and wlji.process_status = 2 -- WIP_CONSTANTS.running

Line 20846: wsm_lot_job_interface wlji

20842: wsli.header_id,
20843: wlji.header_id
20844: from mtl_material_transactions_temp mmtt,
20845: wsm_starting_lots_interface wsli,
20846: wsm_lot_job_interface wlji
20847: where mmtt.transaction_header_id = p_header_id
20848: and mmtt.source_line_id = wsli.header_id
20849: and wsli.header_id = wlji.source_line_id;
20850: BEGIN

Line 20863: update wsm_lot_job_interface wljia

20859: l_wlji_header_id;
20860:
20861: exit when recs%notfound;
20862:
20863: update wsm_lot_job_interface wljia
20864: set wljia.process_status = 4,
20865: wljia.error_code = -2,
20866: wljia.error_msg = substr(l_err_explanation,1,240)
20867: where wljia.header_id = l_wlji_header_id;