APPS.CSF_UTIL_PVT dependencies on JTF_NUMBER_TABLE

Line 212: l_terr_table jtf_number_table;

208: */
209: FUNCTION get_selected_terr( p_user_id NUMBER DEFAULT NULL ) RETURN VARCHAR2
210: IS
211: l_selected_terr VARCHAR2(4000);
212: l_terr_table jtf_number_table;
213: BEGIN
214: l_terr_table := get_selected_terr_table(p_user_id);
215:
216: FOR i IN 1..l_terr_table.COUNT LOOP

Line 233: RETURN jtf_number_table

229: *
230: * @param p_user_id User ID of the user to get the list of User's Territories
231: */
232: FUNCTION get_selected_terr_table( p_user_id NUMBER DEFAULT NULL )
233: RETURN jtf_number_table
234: IS
235: l_selected_terr VARCHAR2(4000);
236: l_terr_table jtf_number_table;
237: i PLS_INTEGER;

Line 236: l_terr_table jtf_number_table;

232: FUNCTION get_selected_terr_table( p_user_id NUMBER DEFAULT NULL )
233: RETURN jtf_number_table
234: IS
235: l_selected_terr VARCHAR2(4000);
236: l_terr_table jtf_number_table;
237: i PLS_INTEGER;
238: l_user_id NUMBER DEFAULT NULL;
239:
240: CURSOR c_selected_terr( b_user_id NUMBER ) IS

Line 260: l_terr_table := jtf_number_table();

256: , jtf_terr_qtype_usgs_all tq
257: WHERE q.source_id = -1002
258: AND tq.qual_type_usg_id = q.qual_type_usg_id;
259: BEGIN
260: l_terr_table := jtf_number_table();
261:
262: -- Use the logged in user's ID if no USER ID is passed to this function
263: IF p_user_id IS NULL THEN
264: l_user_id := fnd_global.user_id;