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.

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on JTF_CUSTOM_GRID_COLS

Line 24: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;

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;

Line 25: g_assembly_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;

Line 26: g_carrier_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;

Line 27: g_cartonization_lpn_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;

Line 28: g_container_item_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;

Line 29: g_content_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;
33: g_line_visible jtf_custom_grid_cols.visible_flag%TYPE;

Line 30: g_customer_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;

Line 31: g_delivery_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;

Line 32: g_department_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;

Line 33: g_line_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;

Line 34: g_line_number_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;

Line 35: g_machine_resource_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;

Line 36: g_person_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;

Line 37: g_person_resource_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;

Line 38: g_ship_method_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;

Line 39: g_ship_to_country_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;

Line 40: g_ship_to_postal_code_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;

Line 41: g_ship_to_state_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;

Line 42: g_source_header_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;

Line 43: g_status_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;

Line 44: g_task_type_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;

Line 45: g_to_locator_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;

Line 46: g_to_lpn_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;

Line 47: g_to_organization_code_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;

Line 48: g_transaction_action_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;

Line 49: g_txn_source_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;
53: --bug: 4510849

Line 50: g_operation_plan_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
54: g_picked_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;

Line 51: g_user_task_type_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;

Line 52: g_num_of_child_tasks_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;

Line 54: g_picked_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;

Line 55: g_loaded_lpn_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;

Line 56: g_drop_lpn_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

Line 58: g_op_plan_instance_id_visible jtf_custom_grid_cols.visible_flag%TYPE;

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:

Line 59: g_operation_sequence_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:
63: g_project_enabled_organization VARCHAR2 (1);

Line 61: g_from_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);
64: g_rows_marked BOOLEAN := FALSE;
65: g_final_query VARCHAR2 (10000);

Line 164: TYPE visible_columns_type IS TABLE OF jtf_custom_grid_cols.visible_flag%TYPE;

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

Line 173: FROM jtf_grid_cols_b jgc, jtf_custom_grid_cols jcgc

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