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.WSMPLBJI dependencies on WSM_LOT_JOB_INTERFACE

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

17:
18: -- ==============================================================================================
19: -- nested table types used to bulk bind data from wlji to the PL/SQL tables.
20: -- ==============================================================================================
21: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;
22: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
23: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
24: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
25: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;

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

18: -- ==============================================================================================
19: -- nested table types used to bulk bind data from wlji to the PL/SQL tables.
20: -- ==============================================================================================
21: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;
22: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
23: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
24: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
25: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
26: type t_wlji_program_application_id is table of wsm_lot_job_interface.program_application_id%type;

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

19: -- nested table types used to bulk bind data from wlji to the PL/SQL tables.
20: -- ==============================================================================================
21: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;
22: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
23: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
24: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
25: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
26: type t_wlji_program_application_id is table of wsm_lot_job_interface.program_application_id%type;
27: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;

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

20: -- ==============================================================================================
21: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;
22: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
23: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
24: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
25: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
26: type t_wlji_program_application_id is table of wsm_lot_job_interface.program_application_id%type;
27: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
28: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;

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

21: type t_wlji_err_code is table of wsm_lot_job_interface.error_code%type;
22: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
23: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
24: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
25: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
26: type t_wlji_program_application_id is table of wsm_lot_job_interface.program_application_id%type;
27: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
28: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
29: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;

Line 26: type t_wlji_program_application_id is table of wsm_lot_job_interface.program_application_id%type;

22: type t_wlji_err_msg is table of wsm_lot_job_interface.error_msg%type;
23: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
24: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
25: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
26: type t_wlji_program_application_id is table of wsm_lot_job_interface.program_application_id%type;
27: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
28: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
29: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
30: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;

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

23: type t_wlji_last_updt_date is table of wsm_lot_job_interface.last_update_date%type;
24: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
25: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
26: type t_wlji_program_application_id is table of wsm_lot_job_interface.program_application_id%type;
27: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
28: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
29: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
30: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
31: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;

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

24: type t_wlji_request_id is table of wsm_lot_job_interface.request_id%type;
25: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
26: type t_wlji_program_application_id is table of wsm_lot_job_interface.program_application_id%type;
27: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
28: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
29: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
30: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
31: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
32: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;

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

25: type t_wlji_program_id is table of wsm_lot_job_interface.program_id%type;
26: type t_wlji_program_application_id is table of wsm_lot_job_interface.program_application_id%type;
27: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
28: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
29: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
30: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
31: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
32: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
33: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;

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

26: type t_wlji_program_application_id is table of wsm_lot_job_interface.program_application_id%type;
27: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
28: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
29: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
30: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
31: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
32: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
33: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
34: type t_wlji_org is table of wsm_lot_job_interface.organization_id%type;

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

27: type t_wlji_last_updt_by is table of wsm_lot_job_interface.last_updated_by%type;
28: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
29: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
30: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
31: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
32: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
33: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
34: type t_wlji_org is table of wsm_lot_job_interface.organization_id%type;
35: type t_wlji_item is table of wsm_lot_job_interface.primary_item_id%type;

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

28: type t_wlji_creation_date is table of wsm_lot_job_interface.creation_date%type;
29: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
30: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
31: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
32: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
33: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
34: type t_wlji_org is table of wsm_lot_job_interface.organization_id%type;
35: type t_wlji_item is table of wsm_lot_job_interface.primary_item_id%type;
36: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;

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

29: type t_wlji_created_by is table of wsm_lot_job_interface.created_by%type;
30: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
31: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
32: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
33: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
34: type t_wlji_org is table of wsm_lot_job_interface.organization_id%type;
35: type t_wlji_item is table of wsm_lot_job_interface.primary_item_id%type;
36: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
37: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;

Line 34: type t_wlji_org is table of wsm_lot_job_interface.organization_id%type;

30: type t_wlji_last_updt_login is table of wsm_lot_job_interface.last_update_login%type;
31: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
32: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
33: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
34: type t_wlji_org is table of wsm_lot_job_interface.organization_id%type;
35: type t_wlji_item is table of wsm_lot_job_interface.primary_item_id%type;
36: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
37: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
38: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;

Line 35: type t_wlji_item is table of wsm_lot_job_interface.primary_item_id%type;

31: type t_wlji_prog_updt_date is table of wsm_lot_job_interface.program_update_date%type;
32: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
33: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
34: type t_wlji_org is table of wsm_lot_job_interface.organization_id%type;
35: type t_wlji_item is table of wsm_lot_job_interface.primary_item_id%type;
36: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
37: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
38: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
39: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;

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

32: type t_wlji_last_updt_by_name is table of wsm_lot_job_interface.last_updated_by_name%type;
33: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
34: type t_wlji_org is table of wsm_lot_job_interface.organization_id%type;
35: type t_wlji_item is table of wsm_lot_job_interface.primary_item_id%type;
36: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
37: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
38: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
39: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
40: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;

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

33: type t_wlji_created_by_name is table of wsm_lot_job_interface.created_by_name%type;
34: type t_wlji_org is table of wsm_lot_job_interface.organization_id%type;
35: type t_wlji_item is table of wsm_lot_job_interface.primary_item_id%type;
36: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
37: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
38: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
39: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
40: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
41: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;

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

34: type t_wlji_org is table of wsm_lot_job_interface.organization_id%type;
35: type t_wlji_item is table of wsm_lot_job_interface.primary_item_id%type;
36: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
37: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
38: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
39: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
40: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
41: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
42: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;

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

35: type t_wlji_item is table of wsm_lot_job_interface.primary_item_id%type;
36: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
37: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
38: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
39: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
40: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
41: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
42: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
43: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;

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

36: type t_wlji_header_id is table of wsm_lot_job_interface.header_id%type;
37: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
38: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
39: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
40: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
41: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
42: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
43: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
44: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;

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

37: type t_wlji_process_status is table of wsm_lot_job_interface.process_status%type;
38: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
39: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
40: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
41: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
42: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
43: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
44: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
45: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;

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

38: type t_wlji_routing_reference_id is table of wsm_lot_job_interface.routing_reference_id%type;
39: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
40: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
41: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
42: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
43: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
44: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
45: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
46: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;

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

39: type t_wlji_completion_subinventory is table of wsm_lot_job_interface.completion_subinventory%type;
40: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
41: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
42: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
43: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
44: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
45: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
46: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
47: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;

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

40: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
41: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
42: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
43: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
44: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
45: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
46: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
47: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
48: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;

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

41: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
42: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
43: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
44: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
45: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
46: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
47: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
48: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
49: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;

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

42: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
43: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
44: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
45: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
46: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
47: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
48: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
49: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
50: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;

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

43: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
44: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
45: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
46: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
47: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
48: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
49: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
50: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
51: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;

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

44: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
45: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
46: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
47: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
48: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
49: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
50: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
51: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
52: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;

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

45: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
46: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
47: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
48: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
49: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
50: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
51: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
52: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
53: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;

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

46: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
47: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
48: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
49: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
50: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
51: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
52: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
53: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
54: type t_wlji_description is table of wsm_lot_job_interface.description%type;

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

47: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
48: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
49: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
50: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
51: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
52: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
53: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
54: type t_wlji_description is table of wsm_lot_job_interface.description%type;
55: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;

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

48: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
49: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
50: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
51: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
52: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
53: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
54: type t_wlji_description is table of wsm_lot_job_interface.description%type;
55: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
56: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;

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

49: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;
50: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
51: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
52: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
53: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
54: type t_wlji_description is table of wsm_lot_job_interface.description%type;
55: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
56: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
57: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;

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

50: type t_wlji_wip_supply_type is table of wsm_lot_job_interface.wip_supply_type%type;
51: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
52: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
53: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
54: type t_wlji_description is table of wsm_lot_job_interface.description%type;
55: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
56: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
57: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
58: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;

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

51: type t_wlji_class_code is table of wsm_lot_job_interface.class_code%type;
52: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
53: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
54: type t_wlji_description is table of wsm_lot_job_interface.description%type;
55: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
56: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
57: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
58: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
59: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;

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

52: type t_wlji_lot_number is table of wsm_lot_job_interface.lot_number%type;
53: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
54: type t_wlji_description is table of wsm_lot_job_interface.description%type;
55: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
56: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
57: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
58: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
59: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
60: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;

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

53: type t_wlji_job_name is table of wsm_lot_job_interface.job_name%type;
54: type t_wlji_description is table of wsm_lot_job_interface.description%type;
55: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
56: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
57: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
58: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
59: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
60: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
61: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;

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

54: type t_wlji_description is table of wsm_lot_job_interface.description%type;
55: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
56: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
57: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
58: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
59: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
60: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
61: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
62: type t_wlji_error is table of wsm_lot_job_interface.error%type;

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

55: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
56: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
57: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
58: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
59: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
60: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
61: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
62: type t_wlji_error is table of wsm_lot_job_interface.error%type;
63: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;

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

56: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
57: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
58: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
59: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
60: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
61: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
62: type t_wlji_error is table of wsm_lot_job_interface.error%type;
63: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
64: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;

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

57: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
58: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
59: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
60: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
61: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
62: type t_wlji_error is table of wsm_lot_job_interface.error%type;
63: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
64: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
65: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;

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

58: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
59: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
60: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
61: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
62: type t_wlji_error is table of wsm_lot_job_interface.error%type;
63: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
64: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
65: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
66: type t_wlji_last_unit_start_date is table of wsm_lot_job_interface.last_unit_start_date%type;

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

59: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
60: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
61: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
62: type t_wlji_error is table of wsm_lot_job_interface.error%type;
63: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
64: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
65: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
66: type t_wlji_last_unit_start_date is table of wsm_lot_job_interface.last_unit_start_date%type;
67: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;

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

60: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
61: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
62: type t_wlji_error is table of wsm_lot_job_interface.error%type;
63: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
64: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
65: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
66: type t_wlji_last_unit_start_date is table of wsm_lot_job_interface.last_unit_start_date%type;
67: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
68: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;

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

61: type t_wlji_wip_entity_id is table of wsm_lot_job_interface.wip_entity_id%type;
62: type t_wlji_error is table of wsm_lot_job_interface.error%type;
63: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
64: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
65: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
66: type t_wlji_last_unit_start_date is table of wsm_lot_job_interface.last_unit_start_date%type;
67: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
68: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
69: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;

Line 66: type t_wlji_last_unit_start_date is table of wsm_lot_job_interface.last_unit_start_date%type;

62: type t_wlji_error is table of wsm_lot_job_interface.error%type;
63: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
64: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
65: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
66: type t_wlji_last_unit_start_date is table of wsm_lot_job_interface.last_unit_start_date%type;
67: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
68: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
69: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
70: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;

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

63: type t_wlji_process_phase is table of wsm_lot_job_interface.process_phase%type;
64: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
65: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
66: type t_wlji_last_unit_start_date is table of wsm_lot_job_interface.last_unit_start_date%type;
67: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
68: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
69: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
70: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
71: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;

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

64: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
65: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
66: type t_wlji_last_unit_start_date is table of wsm_lot_job_interface.last_unit_start_date%type;
67: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
68: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
69: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
70: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
71: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
72: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;

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

65: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
66: type t_wlji_last_unit_start_date is table of wsm_lot_job_interface.last_unit_start_date%type;
67: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
68: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
69: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
70: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
71: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
72: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
73: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;

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

66: type t_wlji_last_unit_start_date is table of wsm_lot_job_interface.last_unit_start_date%type;
67: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
68: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
69: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
70: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
71: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
72: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
73: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
74: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;

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

67: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
68: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
69: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
70: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
71: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
72: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
73: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
74: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
75: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;

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

68: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
69: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
70: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
71: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
72: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
73: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
74: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
75: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
76: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;

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

69: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
70: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
71: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
72: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
73: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
74: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
75: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
76: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
77: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;

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

70: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
71: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
72: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
73: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
74: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
75: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
76: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
77: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
78: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;

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

71: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
72: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
73: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
74: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
75: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
76: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
77: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
78: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
79: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;

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

72: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
73: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
74: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
75: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
76: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
77: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
78: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
79: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
80: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;

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

73: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
74: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
75: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
76: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
77: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
78: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
79: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
80: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
81: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;

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

74: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
75: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
76: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
77: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
78: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
79: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
80: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
81: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
82: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;

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

75: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
76: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
77: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
78: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
79: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
80: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
81: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
82: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
83: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;

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

76: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
77: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
78: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
79: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
80: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
81: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
82: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
83: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
84: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;

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

77: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
78: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
79: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
80: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
81: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
82: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
83: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
84: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
85: type t_wlji_desc_flx_sgmts is table of wsm_lot_job_interface.descriptive_flex_segments%type;

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

78: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
79: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
80: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
81: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
82: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
83: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
84: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
85: type t_wlji_desc_flx_sgmts is table of wsm_lot_job_interface.descriptive_flex_segments%type;
86: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;

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

79: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
80: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
81: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
82: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
83: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
84: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
85: type t_wlji_desc_flx_sgmts is table of wsm_lot_job_interface.descriptive_flex_segments%type;
86: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
87: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;

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

80: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
81: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
82: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
83: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
84: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
85: type t_wlji_desc_flx_sgmts is table of wsm_lot_job_interface.descriptive_flex_segments%type;
86: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
87: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
88: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;

Line 85: type t_wlji_desc_flx_sgmts is table of wsm_lot_job_interface.descriptive_flex_segments%type;

81: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
82: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
83: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
84: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
85: type t_wlji_desc_flx_sgmts is table of wsm_lot_job_interface.descriptive_flex_segments%type;
86: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
87: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
88: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
89: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;

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

82: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
83: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
84: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
85: type t_wlji_desc_flx_sgmts is table of wsm_lot_job_interface.descriptive_flex_segments%type;
86: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
87: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
88: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
89: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
90: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;

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

83: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
84: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
85: type t_wlji_desc_flx_sgmts is table of wsm_lot_job_interface.descriptive_flex_segments%type;
86: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
87: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
88: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
89: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
90: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
91: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;

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

84: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;
85: type t_wlji_desc_flx_sgmts is table of wsm_lot_job_interface.descriptive_flex_segments%type;
86: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
87: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
88: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
89: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
90: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
91: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
92: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;

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

85: type t_wlji_desc_flx_sgmts is table of wsm_lot_job_interface.descriptive_flex_segments%type;
86: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
87: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
88: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
89: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
90: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
91: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
92: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
93: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;

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

86: type t_wlji_project_number is table of wsm_lot_job_interface.project_number%type;
87: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
88: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
89: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
90: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
91: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
92: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
93: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
94: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;

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

87: type t_wlji_task_number is table of wsm_lot_job_interface.task_number%type;
88: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
89: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
90: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
91: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
92: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
93: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
94: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
95: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;

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

88: type t_wlji_project_costed is table of wsm_lot_job_interface.project_costed%type;
89: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
90: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
91: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
92: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
93: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
94: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
95: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
96: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;

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

89: type t_wlji_end_item_unit_number is table of wsm_lot_job_interface.end_item_unit_number%type;
90: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
91: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
92: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
93: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
94: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
95: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
96: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
97: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;

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

90: type t_wlji_overcompl_tol_type is table of wsm_lot_job_interface.overcompletion_tolerance_type%type;
91: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
92: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
93: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
94: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
95: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
96: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
97: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
98: type t_wlji_compl_locator_segments is table of wsm_lot_job_interface.completion_locator_segments%type;

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

91: type t_wlji_overcompl_tol_value is table of wsm_lot_job_interface.overcompletion_tolerance_value%type;
92: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
93: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
94: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
95: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
96: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
97: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
98: type t_wlji_compl_locator_segments is table of wsm_lot_job_interface.completion_locator_segments%type;
99: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;

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

92: type t_wlji_kanban_card_id is table of wsm_lot_job_interface.kanban_card_id%type;
93: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
94: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
95: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
96: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
97: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
98: type t_wlji_compl_locator_segments is table of wsm_lot_job_interface.completion_locator_segments%type;
99: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
100: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;

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

93: type t_wlji_priority is table of wsm_lot_job_interface.priority%type;
94: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
95: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
96: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
97: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
98: type t_wlji_compl_locator_segments is table of wsm_lot_job_interface.completion_locator_segments%type;
99: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
100: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
101: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;

Line 98: type t_wlji_compl_locator_segments is table of wsm_lot_job_interface.completion_locator_segments%type;

94: type t_wlji_due_date is table of wsm_lot_job_interface.due_date%type;
95: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
96: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
97: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
98: type t_wlji_compl_locator_segments is table of wsm_lot_job_interface.completion_locator_segments%type;
99: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
100: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
101: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
102: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;

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

95: type t_wlji_task_name is table of wsm_lot_job_interface.task_name%type;
96: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
97: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
98: type t_wlji_compl_locator_segments is table of wsm_lot_job_interface.completion_locator_segments%type;
99: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
100: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
101: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
102: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
103: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;

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

96: type t_wlji_process_type is table of wsm_lot_job_interface.process_type%type;
97: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
98: type t_wlji_compl_locator_segments is table of wsm_lot_job_interface.completion_locator_segments%type;
99: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
100: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
101: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
102: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
103: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
104: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;

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

97: type t_wlji_processing_work_days is table of wsm_lot_job_interface.processing_work_days%type;
98: type t_wlji_compl_locator_segments is table of wsm_lot_job_interface.completion_locator_segments%type;
99: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
100: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
101: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
102: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
103: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
104: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
105: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;

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

98: type t_wlji_compl_locator_segments is table of wsm_lot_job_interface.completion_locator_segments%type;
99: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
100: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
101: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
102: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
103: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
104: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
105: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
106: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;

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

99: type t_wlji_daily_production_rate is table of wsm_lot_job_interface.daily_production_rate%type;
100: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
101: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
102: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
103: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
104: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
105: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
106: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
107: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;

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

100: type t_wlji_line_id is table of wsm_lot_job_interface.line_id%type;
101: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
102: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
103: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
104: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
105: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
106: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
107: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
108: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;

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

101: type t_wlji_lot_control_code is table of wsm_lot_job_interface.lot_control_code%type;
102: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
103: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
104: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
105: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
106: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
107: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
108: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
109: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;

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

102: type t_wlji_repetitive_schedule_id is table of wsm_lot_job_interface.repetitive_schedule_id%type;
103: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
104: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
105: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
106: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
107: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
108: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
109: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
110: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;

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

103: type t_wlji_parent_group_id is table of wsm_lot_job_interface.parent_group_id%type;
104: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
105: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
106: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
107: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
108: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
109: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
110: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
111: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;

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

104: type t_wlji_attribute_category is table of wsm_lot_job_interface.attribute_category%type;
105: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
106: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
107: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
108: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
109: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
110: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
111: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
112: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;

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

105: type t_wlji_attribute1 is table of wsm_lot_job_interface.attribute1%type;
106: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
107: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
108: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
109: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
110: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
111: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
112: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
113: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;

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

106: type t_wlji_attribute2 is table of wsm_lot_job_interface.attribute2%type;
107: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
108: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
109: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
110: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
111: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
112: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
113: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
114: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;

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

107: type t_wlji_attribute3 is table of wsm_lot_job_interface.attribute3%type;
108: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
109: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
110: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
111: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
112: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
113: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
114: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
115: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;

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

108: type t_wlji_attribute4 is table of wsm_lot_job_interface.attribute4%type;
109: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
110: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
111: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
112: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
113: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
114: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
115: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
116: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;

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

109: type t_wlji_attribute5 is table of wsm_lot_job_interface.attribute5%type;
110: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
111: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
112: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
113: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
114: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
115: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
116: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
117: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;

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

110: type t_wlji_attribute6 is table of wsm_lot_job_interface.attribute6%type;
111: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
112: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
113: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
114: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
115: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
116: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
117: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
118: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;

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

111: type t_wlji_attribute7 is table of wsm_lot_job_interface.attribute7%type;
112: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
113: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
114: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
115: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
116: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
117: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
118: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
119: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;

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

112: type t_wlji_attribute8 is table of wsm_lot_job_interface.attribute8%type;
113: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
114: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
115: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
116: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
117: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
118: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
119: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
120: type t_wlji_organization_code is table of wsm_lot_job_interface.organization_code%type;

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

113: type t_wlji_attribute9 is table of wsm_lot_job_interface.attribute9%type;
114: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
115: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
116: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
117: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
118: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
119: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
120: type t_wlji_organization_code is table of wsm_lot_job_interface.organization_code%type;
121: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;

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

114: type t_wlji_attribute10 is table of wsm_lot_job_interface.attribute10%type;
115: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
116: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
117: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
118: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
119: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
120: type t_wlji_organization_code is table of wsm_lot_job_interface.organization_code%type;
121: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
122: type t_wlji_primary_item_segments is table of wsm_lot_job_interface.primary_item_segments%type;

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

115: type t_wlji_attribute11 is table of wsm_lot_job_interface.attribute11%type;
116: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
117: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
118: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
119: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
120: type t_wlji_organization_code is table of wsm_lot_job_interface.organization_code%type;
121: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
122: type t_wlji_primary_item_segments is table of wsm_lot_job_interface.primary_item_segments%type;
123: type t_wlji_bom_reference_segments is table of wsm_lot_job_interface.bom_reference_segments%type;

Line 120: type t_wlji_organization_code is table of wsm_lot_job_interface.organization_code%type;

116: type t_wlji_attribute12 is table of wsm_lot_job_interface.attribute12%type;
117: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
118: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
119: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
120: type t_wlji_organization_code is table of wsm_lot_job_interface.organization_code%type;
121: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
122: type t_wlji_primary_item_segments is table of wsm_lot_job_interface.primary_item_segments%type;
123: type t_wlji_bom_reference_segments is table of wsm_lot_job_interface.bom_reference_segments%type;
124: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;

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

117: type t_wlji_attribute13 is table of wsm_lot_job_interface.attribute13%type;
118: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
119: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
120: type t_wlji_organization_code is table of wsm_lot_job_interface.organization_code%type;
121: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
122: type t_wlji_primary_item_segments is table of wsm_lot_job_interface.primary_item_segments%type;
123: type t_wlji_bom_reference_segments is table of wsm_lot_job_interface.bom_reference_segments%type;
124: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
125: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type; --bugfix 2697295

Line 122: type t_wlji_primary_item_segments is table of wsm_lot_job_interface.primary_item_segments%type;

118: type t_wlji_attribute14 is table of wsm_lot_job_interface.attribute14%type;
119: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
120: type t_wlji_organization_code is table of wsm_lot_job_interface.organization_code%type;
121: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
122: type t_wlji_primary_item_segments is table of wsm_lot_job_interface.primary_item_segments%type;
123: type t_wlji_bom_reference_segments is table of wsm_lot_job_interface.bom_reference_segments%type;
124: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
125: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type; --bugfix 2697295
126:

Line 123: type t_wlji_bom_reference_segments is table of wsm_lot_job_interface.bom_reference_segments%type;

119: type t_wlji_attribute15 is table of wsm_lot_job_interface.attribute15%type;
120: type t_wlji_organization_code is table of wsm_lot_job_interface.organization_code%type;
121: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
122: type t_wlji_primary_item_segments is table of wsm_lot_job_interface.primary_item_segments%type;
123: type t_wlji_bom_reference_segments is table of wsm_lot_job_interface.bom_reference_segments%type;
124: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
125: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type; --bugfix 2697295
126:
127:

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

120: type t_wlji_organization_code is table of wsm_lot_job_interface.organization_code%type;
121: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
122: type t_wlji_primary_item_segments is table of wsm_lot_job_interface.primary_item_segments%type;
123: type t_wlji_bom_reference_segments is table of wsm_lot_job_interface.bom_reference_segments%type;
124: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
125: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type; --bugfix 2697295
126:
127:
128: -- ==============================================================================================

Line 125: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type; --bugfix 2697295

121: type t_wlji_line_code is table of wsm_lot_job_interface.line_code%type;
122: type t_wlji_primary_item_segments is table of wsm_lot_job_interface.primary_item_segments%type;
123: type t_wlji_bom_reference_segments is table of wsm_lot_job_interface.bom_reference_segments%type;
124: type t_wlji_rtg_ref_segs is table of wsm_lot_job_interface.routing_reference_segments%type;
125: type t_wlji_date_released is table of wsm_lot_job_interface.date_released%type; --bugfix 2697295
126:
127:
128: -- ==============================================================================================
129: -- instantiating the tables used to bulk bind data from wlji to the PL/SQL tables.

Line 314: from wsm_lot_job_interface

310:
311: cursor c_org is
312: select organization_id,
313: organization_code
314: from wsm_lot_job_interface
315: where process_status = p_status
316: and NVL(transaction_date, creation_date) <= sysdate+1
317: and NVL(group_id, -99) = NVL(p_group_id, NVL(group_id, -99))
318: and load_type in (5, 6)

Line 1509: wsm_lot_job_interface wlji,

1505: wsli.created_by,
1506: msi.primary_uom_code,
1507: wsli.component_issue_quantity
1508: from wsm_starting_lots_interface wsli,
1509: wsm_lot_job_interface wlji,
1510: mtl_system_items msi
1511: where wsli.header_id = wlji.source_line_id
1512: and wlji.group_id = l_group_id
1513: and wlji.process_status = 2 -- WIP_CONSTANTS.running

Line 1593: wsm_lot_job_interface wlji

1589: wsli.header_id,
1590: wlji.header_id
1591: from mtl_material_transactions_temp mmtt,
1592: wsm_starting_lots_interface wsli,
1593: wsm_lot_job_interface wlji
1594: where mmtt.transaction_header_id = p_header_id
1595: and mmtt.source_line_id = wsli.header_id
1596: and wsli.header_id = wlji.source_line_id ;
1597: BEGIN

Line 1610: update wsm_lot_job_interface wljia

1606: l_wlji_header_id ;
1607:
1608: exit when recs%notfound ;
1609:
1610: update wsm_lot_job_interface wljia
1611: set wljia.process_status = 4,
1612: wljia.error_code = -2,
1613: wljia.error_msg = substr(l_err_explanation,1,240)
1614: where wljia.header_id = l_wlji_header_id ;

Line 2616: from wsm_lot_job_interface

2612: p_group_id IN NUMBER) IS
2613:
2614: cursor c_pir is
2615: select header_id
2616: from wsm_lot_job_interface
2617: where process_status = wip_constants.pending
2618: -- and group_id is null
2619: and creation_date <= sysdate+1
2620: and load_type in (5,6)

Line 2653: from wsm_lot_job_interface

2649: if p_group_id is null then
2650:
2651: select count(*)
2652: into total_no_rows
2653: from wsm_lot_job_interface
2654: where process_status = wip_constants.pending
2655: --and group_id is null
2656: and creation_date <= sysdate+1
2657: and load_type in (5,6);

Line 2674: select wsm_lot_job_interface_s.NEXTVAL

2670: fnd_file.put_line(fnd_file.log, 'Number of Workers = '||no_of_workers);
2671: fnd_file.put_line(fnd_file.log, 'Batch Size = '||batch_size);
2672: fnd_file.put_line(fnd_file.log, 'Number of Rows per worker = '||no_rows_per_worker);
2673:
2674: select wsm_lot_job_interface_s.NEXTVAL
2675: into l_group_id
2676: from dual;
2677:
2678: open c_pir;

Line 2686: update wsm_lot_job_interface wlji

2682:
2683: if c_pir%notfound and (c_pir%rowcount - row_count) = 0 then exit; end if;
2684:
2685: if not c_pir%notfound then
2686: update wsm_lot_job_interface wlji
2687: set wlji.group_id = l_group_id,
2688: wlji.process_status = wip_constants.running
2689: where header_id = x_header;
2690: end if;

Line 2714: select wsm_lot_job_interface_s.NEXTVAL

2710:
2711: if c_pir%notfound then exit; end if;
2712:
2713: if not c_pir%notfound then
2714: select wsm_lot_job_interface_s.NEXTVAL
2715: into l_group_id
2716: from dual;
2717: end if;
2718:

Line 2731: from wsm_lot_job_interface

2727: -- job program to process rows with a specific group id unless the number of such rows is very small.
2728:
2729: select count(*)
2730: into total_no_rows
2731: from wsm_lot_job_interface
2732: where process_status = wip_constants.pending
2733: and group_id = p_group_id
2734: and creation_date <= sysdate+1
2735: and load_type in (5,6);

Line 2739: update wsm_lot_job_interface wlji

2735: and load_type in (5,6);
2736:
2737: if total_no_rows > 0 then
2738:
2739: update wsm_lot_job_interface wlji
2740: set wlji.process_status = wip_constants.running
2741: where group_id = p_group_id;
2742:
2743: l_reqid := FND_REQUEST.SUBMIT_REQUEST (

Line 2898: from wsm_lot_job_interface

2894: due_date,
2895: task_name,
2896: job_type,
2897: date_released --bugfix 2697295
2898: from wsm_lot_job_interface
2899: where group_id = l_group_id
2900: and process_status = 2 -- WIP_CONSTANTS.running;
2901: order by organization_id,
2902: priority,

Line 3252: select wsm_lot_job_interface_s.NEXTVAL

3248: -- help when I select corresponding rows from wsli.
3249: -- ==============================================================================================
3250: l_stmt_num := 78;
3251:
3252: select wsm_lot_job_interface_s.NEXTVAL
3253: into batch_group_id
3254: from dual;
3255:
3256: forall indx in v_wlji_header_id.first..v_wlji_header_id.last

Line 3257: update wsm_lot_job_interface

3253: into batch_group_id
3254: from dual;
3255:
3256: forall indx in v_wlji_header_id.first..v_wlji_header_id.last
3257: update wsm_lot_job_interface
3258: set group_id = batch_group_id
3259: where header_id = v_wlji_header_id(indx);
3260:
3261: fnd_file.put_line(fnd_file.output, ' ---- Lot Based Job Creation ---- ');

Line 7621: -- * bulk update wsm_lot_job_interface *

7617: fnd_file.put_line(fnd_file.log,errbuf);
7618: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7619: end if;
7620:
7621: -- *** bulk update wsm_lot_job_interface ***
7622: forall i in v_wlji_process_status.first..v_wlji_process_status.last
7623: update wsm_lot_job_interface
7624: set process_status = v_wlji_process_status(i),
7625: error_code = v_wlji_err_code(i),

Line 7623: update wsm_lot_job_interface

7619: end if;
7620:
7621: -- *** bulk update wsm_lot_job_interface ***
7622: forall i in v_wlji_process_status.first..v_wlji_process_status.last
7623: update wsm_lot_job_interface
7624: set process_status = v_wlji_process_status(i),
7625: error_code = v_wlji_err_code(i),
7626: error_msg = v_wlji_err_msg(i),
7627: request_id = v_wlji_request_id(i),

Line 7653: update wsm_lot_job_interface

7649: errbuf:= 'WSMPLBJI. Inventory worker returned failure '||
7650: '(Transaction_header_id=' ||txn_header_id||') : '|| SUBSTRB(SQLERRM,1,1000);
7651: fnd_file.put_line(fnd_file.log,errbuf);
7652: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7653: update wsm_lot_job_interface
7654: set process_status = 4,
7655: error_code = -2,
7656: error_msg = l_error_msg
7657: where mode_flag = 2;

Line 7710: from wsm_lot_job_interface wlji

7706: if l_atleast_one_row_in_mmtt <> 0 then
7707: delete from wsm_starting_lots_interface
7708: where header_id IN
7709: (select wlji.source_line_id
7710: from wsm_lot_job_interface wlji
7711: where wlji.process_status = 5
7712: --and wlji.group_id = batch_group_id
7713: and NVL(transaction_date, creation_date)
7714: <= decode(l_del_int_prof_value,

Line 7725: delete from wsm_lot_job_interface

7721: fnd_file.put_line(fnd_file.log, 'Deleted '||SQL%ROWCOUNT||' rows from wsli');
7722: end if;
7723: end if;
7724:
7725: delete from wsm_lot_job_interface
7726: where process_status = 5
7727: --and group_id = batch_group_id
7728: and NVL(transaction_date, creation_date)
7729: <= decode(l_del_int_prof_value,