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_AUTO_COMMIT_PVT dependencies on JTF_VARCHAR2_TABLE_2000

Line 76: p_res_type jtf_varchar2_table_2000 ;

72: l_first_task_id number;
73: l_last_task_id number;
74:
75: p_res_id jtf_number_table ;
76: p_res_type jtf_varchar2_table_2000 ;
77: p_res_name jtf_varchar2_table_2000 ;
78: p_res_typ_name jtf_varchar2_table_2000 ;
79: p_res_key jtf_varchar2_table_2000 ;
80: l_task_id_tbl jtf_number_table;

Line 77: p_res_name jtf_varchar2_table_2000 ;

73: l_last_task_id number;
74:
75: p_res_id jtf_number_table ;
76: p_res_type jtf_varchar2_table_2000 ;
77: p_res_name jtf_varchar2_table_2000 ;
78: p_res_typ_name jtf_varchar2_table_2000 ;
79: p_res_key jtf_varchar2_table_2000 ;
80: l_task_id_tbl jtf_number_table;
81: l_query VARCHAR2(2000);

Line 78: p_res_typ_name jtf_varchar2_table_2000 ;

74:
75: p_res_id jtf_number_table ;
76: p_res_type jtf_varchar2_table_2000 ;
77: p_res_name jtf_varchar2_table_2000 ;
78: p_res_typ_name jtf_varchar2_table_2000 ;
79: p_res_key jtf_varchar2_table_2000 ;
80: l_task_id_tbl jtf_number_table;
81: l_query VARCHAR2(2000);
82:

Line 79: p_res_key jtf_varchar2_table_2000 ;

75: p_res_id jtf_number_table ;
76: p_res_type jtf_varchar2_table_2000 ;
77: p_res_name jtf_varchar2_table_2000 ;
78: p_res_typ_name jtf_varchar2_table_2000 ;
79: p_res_key jtf_varchar2_table_2000 ;
80: l_task_id_tbl jtf_number_table;
81: l_query VARCHAR2(2000);
82:
83: CURSOR C_Terr_Resource

Line 231: FROM TABLE(CAST(:p_res_key AS jtf_varchar2_table_2000))

227: ,SUBSTR(column_value
228: , INSTR(column_value, ''-'', 1, 1) + 1
229: , LENGTH(column_value)
230: ) resource_type
231: FROM TABLE(CAST(:p_res_key AS jtf_varchar2_table_2000))
232: ) res_info
233: WHERE ta.resource_id = res_info.resource_id
234: AND ta.resource_type_code = res_info.resource_type
235: AND ts.task_status_id = ta.assignment_status_id

Line 263: FROM TABLE(CAST(:1 AS jtf_varchar2_table_2000))

259: ,SUBSTR(column_value
260: , INSTR(column_value, ''-'', 1, 1) + 1
261: , LENGTH(column_value)
262: ) resource_type
263: FROM TABLE(CAST(:1 AS jtf_varchar2_table_2000))
264: ) res_info
265: WHERE ta.resource_id = res_info.resource_id
266: AND ta.resource_type_code = res_info.resource_type
267: AND ts.task_status_id = ta.assignment_status_id