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

Line 2585: p_res_type jtf_varchar2_table_2000 ;

2581:
2582:
2583:
2584: p_res_id jtf_number_table ;
2585: p_res_type jtf_varchar2_table_2000 ;
2586: p_res_name jtf_varchar2_table_2000 ;
2587: p_res_typ_name jtf_varchar2_table_2000 ;
2588: p_res_key jtf_varchar2_table_2000 ;
2589:

Line 2586: p_res_name jtf_varchar2_table_2000 ;

2582:
2583:
2584: p_res_id jtf_number_table ;
2585: p_res_type jtf_varchar2_table_2000 ;
2586: p_res_name jtf_varchar2_table_2000 ;
2587: p_res_typ_name jtf_varchar2_table_2000 ;
2588: p_res_key jtf_varchar2_table_2000 ;
2589:
2590: l_field_uom_val varchar2(30);

Line 2587: p_res_typ_name jtf_varchar2_table_2000 ;

2583:
2584: p_res_id jtf_number_table ;
2585: p_res_type jtf_varchar2_table_2000 ;
2586: p_res_name jtf_varchar2_table_2000 ;
2587: p_res_typ_name jtf_varchar2_table_2000 ;
2588: p_res_key jtf_varchar2_table_2000 ;
2589:
2590: l_field_uom_val varchar2(30);
2591: l_base_unit_uom varchar2(10);

Line 2588: p_res_key jtf_varchar2_table_2000 ;

2584: p_res_id jtf_number_table ;
2585: p_res_type jtf_varchar2_table_2000 ;
2586: p_res_name jtf_varchar2_table_2000 ;
2587: p_res_typ_name jtf_varchar2_table_2000 ;
2588: p_res_key jtf_varchar2_table_2000 ;
2589:
2590: l_field_uom_val varchar2(30);
2591: l_base_unit_uom varchar2(10);
2592: l_con_val number;

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

2751: ,SUBSTR(column_value
2752: , INSTR(column_value, ''-'', 1, 1) + 1
2753: , LENGTH(column_value)
2754: ) resource_type
2755: FROM TABLE(CAST(:p_res_key AS jtf_varchar2_table_2000))
2756: ) res_info
2757: WHERE ta.resource_id = res_info.resource_id
2758: AND ta.resource_type_code = res_info.resource_type
2759: AND ts.task_status_id = ta.assignment_status_id

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

2785: ,SUBSTR(column_value
2786: , INSTR(column_value, ''-'', 1, 1) + 1
2787: , LENGTH(column_value)
2788: ) resource_type
2789: FROM TABLE(CAST(:p_res_key AS jtf_varchar2_table_2000))
2790: ) res_info
2791: WHERE ta.resource_id = res_info.resource_id
2792: AND ta.resource_type_code = res_info.resource_type
2793: AND ts.task_status_id = ta.assignment_status_id