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.CSF_PLANBOARD_TASKS dependencies on JTF_NUMBER_TABLE

Line 158: task_id jtf_number_table;

154: l_depend_flag varchar2(2);
155: l_notes_flag varchar2(2);
156:
157:
158: task_id jtf_number_table;
159: real_task_id jtf_number_table;
160: task_number jtf_varchar2_table_100;
161: task_type_id jtf_number_table;
162: trip_task_indicator jtf_number_table;

Line 159: real_task_id jtf_number_table;

155: l_notes_flag varchar2(2);
156:
157:
158: task_id jtf_number_table;
159: real_task_id jtf_number_table;
160: task_number jtf_varchar2_table_100;
161: task_type_id jtf_number_table;
162: trip_task_indicator jtf_number_table;
163: task_priority_id jtf_number_table;

Line 161: task_type_id jtf_number_table;

157:
158: task_id jtf_number_table;
159: real_task_id jtf_number_table;
160: task_number jtf_varchar2_table_100;
161: task_type_id jtf_number_table;
162: trip_task_indicator jtf_number_table;
163: task_priority_id jtf_number_table;
164: source_object_type_code jtf_varchar2_table_100;
165: source_object_name jtf_varchar2_table_100;

Line 162: trip_task_indicator jtf_number_table;

158: task_id jtf_number_table;
159: real_task_id jtf_number_table;
160: task_number jtf_varchar2_table_100;
161: task_type_id jtf_number_table;
162: trip_task_indicator jtf_number_table;
163: task_priority_id jtf_number_table;
164: source_object_type_code jtf_varchar2_table_100;
165: source_object_name jtf_varchar2_table_100;
166: source_object_id jtf_number_table;

Line 163: task_priority_id jtf_number_table;

159: real_task_id jtf_number_table;
160: task_number jtf_varchar2_table_100;
161: task_type_id jtf_number_table;
162: trip_task_indicator jtf_number_table;
163: task_priority_id jtf_number_table;
164: source_object_type_code jtf_varchar2_table_100;
165: source_object_name jtf_varchar2_table_100;
166: source_object_id jtf_number_table;
167: planned_start_date jtf_date_table;

Line 166: source_object_id jtf_number_table;

162: trip_task_indicator jtf_number_table;
163: task_priority_id jtf_number_table;
164: source_object_type_code jtf_varchar2_table_100;
165: source_object_name jtf_varchar2_table_100;
166: source_object_id jtf_number_table;
167: planned_start_date jtf_date_table;
168: planned_end_date jtf_date_table;
169: scheduled_start_date jtf_date_table;
170: scheduled_end_date jtf_date_table;

Line 172: parent_task_id jtf_number_table;

168: planned_end_date jtf_date_table;
169: scheduled_start_date jtf_date_table;
170: scheduled_end_date jtf_date_table;
171: task_confirmation_status jtf_varchar2_table_100;
172: parent_task_id jtf_number_table;
173: task_split_flag jtf_varchar2_table_100;
174: assignment_status_id jtf_number_table;
175: actual_start_date jtf_date_table;
176: actual_end_date jtf_date_table;

Line 174: assignment_status_id jtf_number_table;

170: scheduled_end_date jtf_date_table;
171: task_confirmation_status jtf_varchar2_table_100;
172: parent_task_id jtf_number_table;
173: task_split_flag jtf_varchar2_table_100;
174: assignment_status_id jtf_number_table;
175: actual_start_date jtf_date_table;
176: actual_end_date jtf_date_table;
177: city jtf_varchar2_table_2000;
178: customer jtf_varchar2_table_400;

Line 182: escalated jtf_number_table;

178: customer jtf_varchar2_table_400;
179: contract jtf_varchar2_table_400;
180: type_name jtf_varchar2_table_100;
181: assignment_status jtf_varchar2_table_100;
182: escalated jtf_number_table;
183: actual_effort jtf_number_table;
184: planned_effort jtf_number_table;
185: resource_id jtf_number_table;
186: resource_type jtf_varchar2_table_100;

Line 183: actual_effort jtf_number_table;

179: contract jtf_varchar2_table_400;
180: type_name jtf_varchar2_table_100;
181: assignment_status jtf_varchar2_table_100;
182: escalated jtf_number_table;
183: actual_effort jtf_number_table;
184: planned_effort jtf_number_table;
185: resource_id jtf_number_table;
186: resource_type jtf_varchar2_table_100;
187: resource_name jtf_varchar2_table_2000;

Line 184: planned_effort jtf_number_table;

180: type_name jtf_varchar2_table_100;
181: assignment_status jtf_varchar2_table_100;
182: escalated jtf_number_table;
183: actual_effort jtf_number_table;
184: planned_effort jtf_number_table;
185: resource_id jtf_number_table;
186: resource_type jtf_varchar2_table_100;
187: resource_name jtf_varchar2_table_2000;
188: status_schedulable_flag jtf_varchar2_table_100;

Line 185: resource_id jtf_number_table;

181: assignment_status jtf_varchar2_table_100;
182: escalated jtf_number_table;
183: actual_effort jtf_number_table;
184: planned_effort jtf_number_table;
185: resource_id jtf_number_table;
186: resource_type jtf_varchar2_table_100;
187: resource_name jtf_varchar2_table_2000;
188: status_schedulable_flag jtf_varchar2_table_100;
189: type_schedulable_flag jtf_varchar2_table_100;

Line 190: trip_id jtf_number_table;

186: resource_type jtf_varchar2_table_100;
187: resource_name jtf_varchar2_table_2000;
188: status_schedulable_flag jtf_varchar2_table_100;
189: type_schedulable_flag jtf_varchar2_table_100;
190: trip_id jtf_number_table;
191: l_avail_type jtf_varchar2_table_100;
192: l_assign_id jtf_number_table;
193:
194: l_prev_resource_id NUMBER;

Line 192: l_assign_id jtf_number_table;

188: status_schedulable_flag jtf_varchar2_table_100;
189: type_schedulable_flag jtf_varchar2_table_100;
190: trip_id jtf_number_table;
191: l_avail_type jtf_varchar2_table_100;
192: l_assign_id jtf_number_table;
193:
194: l_prev_resource_id NUMBER;
195: l_prev_resource_type VARCHAR2(30);
196: l_type_name VARCHAR2(100);

Line 624: FROM TABLE(CAST(trip_id AS jtf_NUMBER_table))

620: CURSOR c_trip_status IS
621: SELECT object_capacity_id,status
622: FROM cac_sr_object_capacity
623: WHERE object_capacity_id in (select DISTINCT column_value
624: FROM TABLE(CAST(trip_id AS jtf_NUMBER_table))
625: where column_value <> 0);
626: i BINARY_INTEGER := 0;
627: BEGIN
628: IF g_trip_tbl.COUNT = 0

Line 647: FROM TABLE(CAST(real_task_id AS jtf_NUMBER_table))

643: , NVL(accesshour_required, 'N') access_flag
644: , NVL(after_hours_flag, 'N') after_flag
645: FROM csf_access_hours_b
646: WHERE task_id in (select DISTINCT column_value
647: FROM TABLE(CAST(real_task_id AS jtf_NUMBER_table))
648: where column_value <> 0);
649: i BINARY_INTEGER := 0;
650: BEGIN
651: IF g_access_tbl.COUNT = 0

Line 669: FROM TABLE(CAST(real_task_id AS jtf_NUMBER_table))

665: CURSOR c_parts_status IS
666: SELECT task_id
667: FROM csp_requirement_headers
668: WHERE task_id in (select DISTINCT column_value
669: FROM TABLE(CAST(real_task_id AS jtf_NUMBER_table))
670: where column_value <> 0);
671: i BINARY_INTEGER := 0;
672: BEGIN
673: IF g_parts_tbl.COUNT = 0

Line 749: task_id := jtf_number_table();

745: l_real_task_cnt := 0;
746: l_task_custom_color := 'N';
747: k :=0;
748: m :=0;
749: task_id := jtf_number_table();
750: real_task_id := jtf_number_table();
751: task_number := jtf_varchar2_table_100();
752: task_type_id := jtf_number_table();
753: trip_task_indicator := jtf_number_table();

Line 750: real_task_id := jtf_number_table();

746: l_task_custom_color := 'N';
747: k :=0;
748: m :=0;
749: task_id := jtf_number_table();
750: real_task_id := jtf_number_table();
751: task_number := jtf_varchar2_table_100();
752: task_type_id := jtf_number_table();
753: trip_task_indicator := jtf_number_table();
754: task_priority_id := jtf_number_table();

Line 752: task_type_id := jtf_number_table();

748: m :=0;
749: task_id := jtf_number_table();
750: real_task_id := jtf_number_table();
751: task_number := jtf_varchar2_table_100();
752: task_type_id := jtf_number_table();
753: trip_task_indicator := jtf_number_table();
754: task_priority_id := jtf_number_table();
755: source_object_type_code := jtf_varchar2_table_100();
756: source_object_name := jtf_varchar2_table_100();

Line 753: trip_task_indicator := jtf_number_table();

749: task_id := jtf_number_table();
750: real_task_id := jtf_number_table();
751: task_number := jtf_varchar2_table_100();
752: task_type_id := jtf_number_table();
753: trip_task_indicator := jtf_number_table();
754: task_priority_id := jtf_number_table();
755: source_object_type_code := jtf_varchar2_table_100();
756: source_object_name := jtf_varchar2_table_100();
757: source_object_id := jtf_number_table();

Line 754: task_priority_id := jtf_number_table();

750: real_task_id := jtf_number_table();
751: task_number := jtf_varchar2_table_100();
752: task_type_id := jtf_number_table();
753: trip_task_indicator := jtf_number_table();
754: task_priority_id := jtf_number_table();
755: source_object_type_code := jtf_varchar2_table_100();
756: source_object_name := jtf_varchar2_table_100();
757: source_object_id := jtf_number_table();
758: planned_start_date := jtf_date_table();

Line 757: source_object_id := jtf_number_table();

753: trip_task_indicator := jtf_number_table();
754: task_priority_id := jtf_number_table();
755: source_object_type_code := jtf_varchar2_table_100();
756: source_object_name := jtf_varchar2_table_100();
757: source_object_id := jtf_number_table();
758: planned_start_date := jtf_date_table();
759: planned_end_date := jtf_date_table();
760: scheduled_start_date := jtf_date_table();
761: scheduled_end_date := jtf_date_table();

Line 763: parent_task_id := jtf_number_table();

759: planned_end_date := jtf_date_table();
760: scheduled_start_date := jtf_date_table();
761: scheduled_end_date := jtf_date_table();
762: task_confirmation_status := jtf_varchar2_table_100();
763: parent_task_id := jtf_number_table();
764: task_split_flag := jtf_varchar2_table_100();
765: assignment_status_id := jtf_number_table();
766: actual_start_date := jtf_date_table();
767: actual_end_date := jtf_date_table();

Line 765: assignment_status_id := jtf_number_table();

761: scheduled_end_date := jtf_date_table();
762: task_confirmation_status := jtf_varchar2_table_100();
763: parent_task_id := jtf_number_table();
764: task_split_flag := jtf_varchar2_table_100();
765: assignment_status_id := jtf_number_table();
766: actual_start_date := jtf_date_table();
767: actual_end_date := jtf_date_table();
768: city := jtf_varchar2_table_2000();
769: customer := jtf_varchar2_table_400();

Line 773: escalated := jtf_number_table();

769: customer := jtf_varchar2_table_400();
770: contract := jtf_varchar2_table_400();
771: type_name := jtf_varchar2_table_100();
772: assignment_status := jtf_varchar2_table_100();
773: escalated := jtf_number_table();
774: actual_effort := jtf_number_table();
775: planned_effort := jtf_number_table();
776: resource_id := jtf_number_table();
777: resource_type := jtf_varchar2_table_100();

Line 774: actual_effort := jtf_number_table();

770: contract := jtf_varchar2_table_400();
771: type_name := jtf_varchar2_table_100();
772: assignment_status := jtf_varchar2_table_100();
773: escalated := jtf_number_table();
774: actual_effort := jtf_number_table();
775: planned_effort := jtf_number_table();
776: resource_id := jtf_number_table();
777: resource_type := jtf_varchar2_table_100();
778: resource_name := jtf_varchar2_table_2000();

Line 775: planned_effort := jtf_number_table();

771: type_name := jtf_varchar2_table_100();
772: assignment_status := jtf_varchar2_table_100();
773: escalated := jtf_number_table();
774: actual_effort := jtf_number_table();
775: planned_effort := jtf_number_table();
776: resource_id := jtf_number_table();
777: resource_type := jtf_varchar2_table_100();
778: resource_name := jtf_varchar2_table_2000();
779: status_schedulable_flag := jtf_varchar2_table_100();

Line 776: resource_id := jtf_number_table();

772: assignment_status := jtf_varchar2_table_100();
773: escalated := jtf_number_table();
774: actual_effort := jtf_number_table();
775: planned_effort := jtf_number_table();
776: resource_id := jtf_number_table();
777: resource_type := jtf_varchar2_table_100();
778: resource_name := jtf_varchar2_table_2000();
779: status_schedulable_flag := jtf_varchar2_table_100();
780: type_schedulable_flag := jtf_varchar2_table_100();

Line 781: trip_id := jtf_number_table();

777: resource_type := jtf_varchar2_table_100();
778: resource_name := jtf_varchar2_table_2000();
779: status_schedulable_flag := jtf_varchar2_table_100();
780: type_schedulable_flag := jtf_varchar2_table_100();
781: trip_id := jtf_number_table();
782: l_avail_type := jtf_varchar2_table_100();
783: l_assign_id := jtf_number_table();
784:
785:

Line 783: l_assign_id := jtf_number_table();

779: status_schedulable_flag := jtf_varchar2_table_100();
780: type_schedulable_flag := jtf_varchar2_table_100();
781: trip_id := jtf_number_table();
782: l_avail_type := jtf_varchar2_table_100();
783: l_assign_id := jtf_number_table();
784:
785:
786: -- fetch resources
787: IF NVL(FND_PROFILE.value('CSF_DC_DISPLAY_ONLY_TECHNICIANS'), 'N') = 'Y' THEN

Line 815: resource_id := jtf_number_table();

811: l_pr.resource_name := resource_name(i);
812: x_pb_tbl(k) := l_pr;
813: l_res_id_map_tbl(l_pr.resource_id||l_pr.resource_type) := k;
814: END LOOP;
815: resource_id := jtf_number_table();
816: resource_type := jtf_varchar2_table_100();
817: resource_name := jtf_varchar2_table_2000();
818:
819: --if p_shift_reg is null and p_shift_std is null