105: /*Bug 3627575:Added variable to change the where clause in get_generic_where*/
106: g_from_inbound BOOLEAN DEFAULT FALSE;
107:
108: g_plans_tasks_record_count NUMBER;
109: g_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
110: g_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
111: g_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
112: g_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
113: g_plan_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
106: g_from_inbound BOOLEAN DEFAULT FALSE;
107:
108: g_plans_tasks_record_count NUMBER;
109: g_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
110: g_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
111: g_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
112: g_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
113: g_plan_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
114: g_plan_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
107:
108: g_plans_tasks_record_count NUMBER;
109: g_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
110: g_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
111: g_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
112: g_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
113: g_plan_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
114: g_plan_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
115: g_plan_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
108: g_plans_tasks_record_count NUMBER;
109: g_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
110: g_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
111: g_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
112: g_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
113: g_plan_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
114: g_plan_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
115: g_plan_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
116: g_plan_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
109: g_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
110: g_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
111: g_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
112: g_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
113: g_plan_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
114: g_plan_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
115: g_plan_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
116: g_plan_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
117:
110: g_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
111: g_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
112: g_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
113: g_plan_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
114: g_plan_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
115: g_plan_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
116: g_plan_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
117:
118: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
111: g_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
112: g_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
113: g_plan_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
114: g_plan_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
115: g_plan_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
116: g_plan_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
117:
118: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
119: g_assembly_visible jtf_custom_grid_cols.visible_flag%TYPE;
112: g_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
113: g_plan_task_types wms_waveplan_tasks_pvt.lookup_meaning_table;
114: g_plan_task_types_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
115: g_plan_status_codes wms_waveplan_tasks_pvt.lookup_meaning_table;
116: g_plan_status_codes_orig wms_waveplan_tasks_pvt.lookup_meaning_table;
117:
118: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
119: g_assembly_visible jtf_custom_grid_cols.visible_flag%TYPE;
120: g_carrier_visible jtf_custom_grid_cols.visible_flag%TYPE;