20: g_wt_uom_error wms_waveplan_tasks_temp.error%TYPE;
21: g_no_item_wt wms_waveplan_tasks_temp.error%TYPE;
22: g_plan_cancelled wms_waveplan_tasks_temp.error%TYPE;
23: -- Global variables to determine if a column is visible or not
24: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
25: g_assembly_visible jtf_custom_grid_cols.visible_flag%TYPE;
26: g_carrier_visible jtf_custom_grid_cols.visible_flag%TYPE;
27: g_cartonization_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
28: g_container_item_visible jtf_custom_grid_cols.visible_flag%TYPE;
21: g_no_item_wt wms_waveplan_tasks_temp.error%TYPE;
22: g_plan_cancelled wms_waveplan_tasks_temp.error%TYPE;
23: -- Global variables to determine if a column is visible or not
24: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
25: g_assembly_visible jtf_custom_grid_cols.visible_flag%TYPE;
26: g_carrier_visible jtf_custom_grid_cols.visible_flag%TYPE;
27: g_cartonization_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
28: g_container_item_visible jtf_custom_grid_cols.visible_flag%TYPE;
29: g_content_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
22: g_plan_cancelled wms_waveplan_tasks_temp.error%TYPE;
23: -- Global variables to determine if a column is visible or not
24: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
25: g_assembly_visible jtf_custom_grid_cols.visible_flag%TYPE;
26: g_carrier_visible jtf_custom_grid_cols.visible_flag%TYPE;
27: g_cartonization_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
28: g_container_item_visible jtf_custom_grid_cols.visible_flag%TYPE;
29: g_content_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
30: g_customer_visible jtf_custom_grid_cols.visible_flag%TYPE;
23: -- Global variables to determine if a column is visible or not
24: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
25: g_assembly_visible jtf_custom_grid_cols.visible_flag%TYPE;
26: g_carrier_visible jtf_custom_grid_cols.visible_flag%TYPE;
27: g_cartonization_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
28: g_container_item_visible jtf_custom_grid_cols.visible_flag%TYPE;
29: g_content_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
30: g_customer_visible jtf_custom_grid_cols.visible_flag%TYPE;
31: g_delivery_visible jtf_custom_grid_cols.visible_flag%TYPE;
24: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
25: g_assembly_visible jtf_custom_grid_cols.visible_flag%TYPE;
26: g_carrier_visible jtf_custom_grid_cols.visible_flag%TYPE;
27: g_cartonization_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
28: g_container_item_visible jtf_custom_grid_cols.visible_flag%TYPE;
29: g_content_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
30: g_customer_visible jtf_custom_grid_cols.visible_flag%TYPE;
31: g_delivery_visible jtf_custom_grid_cols.visible_flag%TYPE;
32: g_department_visible jtf_custom_grid_cols.visible_flag%TYPE;
25: g_assembly_visible jtf_custom_grid_cols.visible_flag%TYPE;
26: g_carrier_visible jtf_custom_grid_cols.visible_flag%TYPE;
27: g_cartonization_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
28: g_container_item_visible jtf_custom_grid_cols.visible_flag%TYPE;
29: g_content_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
30: g_customer_visible jtf_custom_grid_cols.visible_flag%TYPE;
31: g_delivery_visible jtf_custom_grid_cols.visible_flag%TYPE;
32: g_department_visible jtf_custom_grid_cols.visible_flag%TYPE;
33: g_line_visible jtf_custom_grid_cols.visible_flag%TYPE;
26: g_carrier_visible jtf_custom_grid_cols.visible_flag%TYPE;
27: g_cartonization_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
28: g_container_item_visible jtf_custom_grid_cols.visible_flag%TYPE;
29: g_content_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
30: g_customer_visible jtf_custom_grid_cols.visible_flag%TYPE;
31: g_delivery_visible jtf_custom_grid_cols.visible_flag%TYPE;
32: g_department_visible jtf_custom_grid_cols.visible_flag%TYPE;
33: g_line_visible jtf_custom_grid_cols.visible_flag%TYPE;
34: g_line_number_visible jtf_custom_grid_cols.visible_flag%TYPE;
27: g_cartonization_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
28: g_container_item_visible jtf_custom_grid_cols.visible_flag%TYPE;
29: g_content_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
30: g_customer_visible jtf_custom_grid_cols.visible_flag%TYPE;
31: g_delivery_visible jtf_custom_grid_cols.visible_flag%TYPE;
32: g_department_visible jtf_custom_grid_cols.visible_flag%TYPE;
33: g_line_visible jtf_custom_grid_cols.visible_flag%TYPE;
34: g_line_number_visible jtf_custom_grid_cols.visible_flag%TYPE;
35: g_machine_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
28: g_container_item_visible jtf_custom_grid_cols.visible_flag%TYPE;
29: g_content_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
30: g_customer_visible jtf_custom_grid_cols.visible_flag%TYPE;
31: g_delivery_visible jtf_custom_grid_cols.visible_flag%TYPE;
32: g_department_visible jtf_custom_grid_cols.visible_flag%TYPE;
33: g_line_visible jtf_custom_grid_cols.visible_flag%TYPE;
34: g_line_number_visible jtf_custom_grid_cols.visible_flag%TYPE;
35: g_machine_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
36: g_person_visible jtf_custom_grid_cols.visible_flag%TYPE;
29: g_content_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
30: g_customer_visible jtf_custom_grid_cols.visible_flag%TYPE;
31: g_delivery_visible jtf_custom_grid_cols.visible_flag%TYPE;
32: g_department_visible jtf_custom_grid_cols.visible_flag%TYPE;
33: g_line_visible jtf_custom_grid_cols.visible_flag%TYPE;
34: g_line_number_visible jtf_custom_grid_cols.visible_flag%TYPE;
35: g_machine_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
36: g_person_visible jtf_custom_grid_cols.visible_flag%TYPE;
37: g_person_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
30: g_customer_visible jtf_custom_grid_cols.visible_flag%TYPE;
31: g_delivery_visible jtf_custom_grid_cols.visible_flag%TYPE;
32: g_department_visible jtf_custom_grid_cols.visible_flag%TYPE;
33: g_line_visible jtf_custom_grid_cols.visible_flag%TYPE;
34: g_line_number_visible jtf_custom_grid_cols.visible_flag%TYPE;
35: g_machine_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
36: g_person_visible jtf_custom_grid_cols.visible_flag%TYPE;
37: g_person_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
38: g_ship_method_visible jtf_custom_grid_cols.visible_flag%TYPE;
31: g_delivery_visible jtf_custom_grid_cols.visible_flag%TYPE;
32: g_department_visible jtf_custom_grid_cols.visible_flag%TYPE;
33: g_line_visible jtf_custom_grid_cols.visible_flag%TYPE;
34: g_line_number_visible jtf_custom_grid_cols.visible_flag%TYPE;
35: g_machine_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
36: g_person_visible jtf_custom_grid_cols.visible_flag%TYPE;
37: g_person_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
38: g_ship_method_visible jtf_custom_grid_cols.visible_flag%TYPE;
39: g_ship_to_country_visible jtf_custom_grid_cols.visible_flag%TYPE;
32: g_department_visible jtf_custom_grid_cols.visible_flag%TYPE;
33: g_line_visible jtf_custom_grid_cols.visible_flag%TYPE;
34: g_line_number_visible jtf_custom_grid_cols.visible_flag%TYPE;
35: g_machine_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
36: g_person_visible jtf_custom_grid_cols.visible_flag%TYPE;
37: g_person_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
38: g_ship_method_visible jtf_custom_grid_cols.visible_flag%TYPE;
39: g_ship_to_country_visible jtf_custom_grid_cols.visible_flag%TYPE;
40: g_ship_to_postal_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
33: g_line_visible jtf_custom_grid_cols.visible_flag%TYPE;
34: g_line_number_visible jtf_custom_grid_cols.visible_flag%TYPE;
35: g_machine_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
36: g_person_visible jtf_custom_grid_cols.visible_flag%TYPE;
37: g_person_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
38: g_ship_method_visible jtf_custom_grid_cols.visible_flag%TYPE;
39: g_ship_to_country_visible jtf_custom_grid_cols.visible_flag%TYPE;
40: g_ship_to_postal_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
41: g_ship_to_state_visible jtf_custom_grid_cols.visible_flag%TYPE;
34: g_line_number_visible jtf_custom_grid_cols.visible_flag%TYPE;
35: g_machine_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
36: g_person_visible jtf_custom_grid_cols.visible_flag%TYPE;
37: g_person_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
38: g_ship_method_visible jtf_custom_grid_cols.visible_flag%TYPE;
39: g_ship_to_country_visible jtf_custom_grid_cols.visible_flag%TYPE;
40: g_ship_to_postal_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
41: g_ship_to_state_visible jtf_custom_grid_cols.visible_flag%TYPE;
42: g_source_header_visible jtf_custom_grid_cols.visible_flag%TYPE;
35: g_machine_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
36: g_person_visible jtf_custom_grid_cols.visible_flag%TYPE;
37: g_person_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
38: g_ship_method_visible jtf_custom_grid_cols.visible_flag%TYPE;
39: g_ship_to_country_visible jtf_custom_grid_cols.visible_flag%TYPE;
40: g_ship_to_postal_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
41: g_ship_to_state_visible jtf_custom_grid_cols.visible_flag%TYPE;
42: g_source_header_visible jtf_custom_grid_cols.visible_flag%TYPE;
43: g_status_visible jtf_custom_grid_cols.visible_flag%TYPE;
36: g_person_visible jtf_custom_grid_cols.visible_flag%TYPE;
37: g_person_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
38: g_ship_method_visible jtf_custom_grid_cols.visible_flag%TYPE;
39: g_ship_to_country_visible jtf_custom_grid_cols.visible_flag%TYPE;
40: g_ship_to_postal_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
41: g_ship_to_state_visible jtf_custom_grid_cols.visible_flag%TYPE;
42: g_source_header_visible jtf_custom_grid_cols.visible_flag%TYPE;
43: g_status_visible jtf_custom_grid_cols.visible_flag%TYPE;
44: g_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
37: g_person_resource_visible jtf_custom_grid_cols.visible_flag%TYPE;
38: g_ship_method_visible jtf_custom_grid_cols.visible_flag%TYPE;
39: g_ship_to_country_visible jtf_custom_grid_cols.visible_flag%TYPE;
40: g_ship_to_postal_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
41: g_ship_to_state_visible jtf_custom_grid_cols.visible_flag%TYPE;
42: g_source_header_visible jtf_custom_grid_cols.visible_flag%TYPE;
43: g_status_visible jtf_custom_grid_cols.visible_flag%TYPE;
44: g_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
45: g_to_locator_visible jtf_custom_grid_cols.visible_flag%TYPE;
38: g_ship_method_visible jtf_custom_grid_cols.visible_flag%TYPE;
39: g_ship_to_country_visible jtf_custom_grid_cols.visible_flag%TYPE;
40: g_ship_to_postal_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
41: g_ship_to_state_visible jtf_custom_grid_cols.visible_flag%TYPE;
42: g_source_header_visible jtf_custom_grid_cols.visible_flag%TYPE;
43: g_status_visible jtf_custom_grid_cols.visible_flag%TYPE;
44: g_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
45: g_to_locator_visible jtf_custom_grid_cols.visible_flag%TYPE;
46: g_to_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
39: g_ship_to_country_visible jtf_custom_grid_cols.visible_flag%TYPE;
40: g_ship_to_postal_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
41: g_ship_to_state_visible jtf_custom_grid_cols.visible_flag%TYPE;
42: g_source_header_visible jtf_custom_grid_cols.visible_flag%TYPE;
43: g_status_visible jtf_custom_grid_cols.visible_flag%TYPE;
44: g_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
45: g_to_locator_visible jtf_custom_grid_cols.visible_flag%TYPE;
46: g_to_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
47: g_to_organization_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
40: g_ship_to_postal_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
41: g_ship_to_state_visible jtf_custom_grid_cols.visible_flag%TYPE;
42: g_source_header_visible jtf_custom_grid_cols.visible_flag%TYPE;
43: g_status_visible jtf_custom_grid_cols.visible_flag%TYPE;
44: g_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
45: g_to_locator_visible jtf_custom_grid_cols.visible_flag%TYPE;
46: g_to_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
47: g_to_organization_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
48: g_transaction_action_visible jtf_custom_grid_cols.visible_flag%TYPE;
41: g_ship_to_state_visible jtf_custom_grid_cols.visible_flag%TYPE;
42: g_source_header_visible jtf_custom_grid_cols.visible_flag%TYPE;
43: g_status_visible jtf_custom_grid_cols.visible_flag%TYPE;
44: g_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
45: g_to_locator_visible jtf_custom_grid_cols.visible_flag%TYPE;
46: g_to_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
47: g_to_organization_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
48: g_transaction_action_visible jtf_custom_grid_cols.visible_flag%TYPE;
49: g_txn_source_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
42: g_source_header_visible jtf_custom_grid_cols.visible_flag%TYPE;
43: g_status_visible jtf_custom_grid_cols.visible_flag%TYPE;
44: g_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
45: g_to_locator_visible jtf_custom_grid_cols.visible_flag%TYPE;
46: g_to_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
47: g_to_organization_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
48: g_transaction_action_visible jtf_custom_grid_cols.visible_flag%TYPE;
49: g_txn_source_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
50: g_operation_plan_visible jtf_custom_grid_cols.visible_flag%TYPE;
43: g_status_visible jtf_custom_grid_cols.visible_flag%TYPE;
44: g_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
45: g_to_locator_visible jtf_custom_grid_cols.visible_flag%TYPE;
46: g_to_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
47: g_to_organization_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
48: g_transaction_action_visible jtf_custom_grid_cols.visible_flag%TYPE;
49: g_txn_source_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
50: g_operation_plan_visible jtf_custom_grid_cols.visible_flag%TYPE;
51: g_user_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
44: g_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
45: g_to_locator_visible jtf_custom_grid_cols.visible_flag%TYPE;
46: g_to_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
47: g_to_organization_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
48: g_transaction_action_visible jtf_custom_grid_cols.visible_flag%TYPE;
49: g_txn_source_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
50: g_operation_plan_visible jtf_custom_grid_cols.visible_flag%TYPE;
51: g_user_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
52: g_num_of_child_tasks_visible jtf_custom_grid_cols.visible_flag%TYPE;
45: g_to_locator_visible jtf_custom_grid_cols.visible_flag%TYPE;
46: g_to_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
47: g_to_organization_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
48: g_transaction_action_visible jtf_custom_grid_cols.visible_flag%TYPE;
49: g_txn_source_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
50: g_operation_plan_visible jtf_custom_grid_cols.visible_flag%TYPE;
51: g_user_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
52: g_num_of_child_tasks_visible jtf_custom_grid_cols.visible_flag%TYPE;
53: --bug: 4510849
46: g_to_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
47: g_to_organization_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
48: g_transaction_action_visible jtf_custom_grid_cols.visible_flag%TYPE;
49: g_txn_source_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
50: g_operation_plan_visible jtf_custom_grid_cols.visible_flag%TYPE;
51: g_user_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
52: g_num_of_child_tasks_visible jtf_custom_grid_cols.visible_flag%TYPE;
53: --bug: 4510849
54: g_picked_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
47: g_to_organization_code_visible jtf_custom_grid_cols.visible_flag%TYPE;
48: g_transaction_action_visible jtf_custom_grid_cols.visible_flag%TYPE;
49: g_txn_source_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
50: g_operation_plan_visible jtf_custom_grid_cols.visible_flag%TYPE;
51: g_user_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
52: g_num_of_child_tasks_visible jtf_custom_grid_cols.visible_flag%TYPE;
53: --bug: 4510849
54: g_picked_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
55: g_loaded_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
48: g_transaction_action_visible jtf_custom_grid_cols.visible_flag%TYPE;
49: g_txn_source_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
50: g_operation_plan_visible jtf_custom_grid_cols.visible_flag%TYPE;
51: g_user_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
52: g_num_of_child_tasks_visible jtf_custom_grid_cols.visible_flag%TYPE;
53: --bug: 4510849
54: g_picked_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
55: g_loaded_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
56: g_drop_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
50: g_operation_plan_visible jtf_custom_grid_cols.visible_flag%TYPE;
51: g_user_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
52: g_num_of_child_tasks_visible jtf_custom_grid_cols.visible_flag%TYPE;
53: --bug: 4510849
54: g_picked_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
55: g_loaded_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
56: g_drop_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
57: --Changed
58: g_op_plan_instance_id_visible jtf_custom_grid_cols.visible_flag%TYPE;
51: g_user_task_type_visible jtf_custom_grid_cols.visible_flag%TYPE;
52: g_num_of_child_tasks_visible jtf_custom_grid_cols.visible_flag%TYPE;
53: --bug: 4510849
54: g_picked_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
55: g_loaded_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
56: g_drop_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
57: --Changed
58: g_op_plan_instance_id_visible jtf_custom_grid_cols.visible_flag%TYPE;
59: g_operation_sequence_visible jtf_custom_grid_cols.visible_flag%TYPE;
52: g_num_of_child_tasks_visible jtf_custom_grid_cols.visible_flag%TYPE;
53: --bug: 4510849
54: g_picked_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
55: g_loaded_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
56: g_drop_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
57: --Changed
58: g_op_plan_instance_id_visible jtf_custom_grid_cols.visible_flag%TYPE;
59: g_operation_sequence_visible jtf_custom_grid_cols.visible_flag%TYPE;
60: --end of change
54: g_picked_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
55: g_loaded_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
56: g_drop_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
57: --Changed
58: g_op_plan_instance_id_visible jtf_custom_grid_cols.visible_flag%TYPE;
59: g_operation_sequence_visible jtf_custom_grid_cols.visible_flag%TYPE;
60: --end of change
61: g_from_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
62:
55: g_loaded_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
56: g_drop_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
57: --Changed
58: g_op_plan_instance_id_visible jtf_custom_grid_cols.visible_flag%TYPE;
59: g_operation_sequence_visible jtf_custom_grid_cols.visible_flag%TYPE;
60: --end of change
61: g_from_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
62:
63: g_project_enabled_organization VARCHAR2 (1);
57: --Changed
58: g_op_plan_instance_id_visible jtf_custom_grid_cols.visible_flag%TYPE;
59: g_operation_sequence_visible jtf_custom_grid_cols.visible_flag%TYPE;
60: --end of change
61: g_from_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
62:
63: g_project_enabled_organization VARCHAR2 (1);
64: g_rows_marked BOOLEAN := FALSE;
65: g_final_query VARCHAR2 (10000);
160: -- We will use these globals to determine if certain columns that are not
161: -- populated by the base query need to be populated by subsequent queries
162: PROCEDURE find_visible_columns
163: IS
164: TYPE visible_columns_type IS TABLE OF jtf_custom_grid_cols.visible_flag%TYPE;
165:
166: visible_columns visible_columns_type;
167: l_user_id NUMBER;
168: BEGIN
169: fnd_profile.get ('USER_ID', l_user_id);
170:
171: SELECT NVL (jcgc.visible_flag, jgc.visible_flag)
172: BULK COLLECT INTO visible_columns
173: FROM jtf_grid_cols_b jgc, jtf_custom_grid_cols jcgc
174: WHERE jgc.grid_datasource_name = jcgc.grid_datasource_name(+)
175: AND jgc.grid_col_alias = jcgc.grid_col_alias(+)
176: AND jgc.grid_datasource_name = 'WMS_WAVEPLAN_TASKS'
177: AND jcgc.created_by(+) = l_user_id