[Home] [Help]
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;
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;
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;
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;
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;
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;
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;
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;
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:
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