[Home] [Help]
2117:
2118: function fetch_ws1_ref_cursor (p_assignment_action_id Number,
2119: p_record_num out nocopy NUmber) return ref_cursor_typ
2120: is
2121: -- per_gb_xfdftableType is explicitly created type
2122: -- only modification needed is it could be of type blob
2123: -- i tried thta but could not access the blob valus in java routine.
2124: -- can be sorted later
2125: l_xfdf_str_tab per_gb_xfdftableType := per_gb_xfdftableType( );
2121: -- per_gb_xfdftableType is explicitly created type
2122: -- only modification needed is it could be of type blob
2123: -- i tried thta but could not access the blob valus in java routine.
2124: -- can be sorted later
2125: l_xfdf_str_tab per_gb_xfdftableType := per_gb_xfdftableType( );
2126: l_xfdf_str varchar2(32000);
2127: l_ret_ref_cursor ref_cursor_typ;
2128: l_offset integer;
2129: l_varchar_buffer varchar2(32000);
2279: end loop;
2280: end loop;
2281: open l_ret_ref_cursor for
2282: select *
2283: from table (cast(l_xfdf_str_tab as per_gb_xfdftableType));
2284: p_record_num := l_loop_count;
2285: return l_ret_ref_cursor;
2286: end ;
2287:
2519: --------------------------------------------------------------------------------------------
2520: function fetch_ws2_ref_cursor (p_assignment_action_id Number,
2521: p_record_num out nocopy NUmber) return ref_cursor_typ
2522: is
2523: -- per_gb_xfdftableType is explicitly created type
2524: -- only modification needed is it could be of type blob
2525: -- i tried thta but could not access the blob valus in java routine.
2526: -- can be sorted later
2527: l_xfdf_str_tab per_gb_xfdftableType := per_gb_xfdftableType( );
2523: -- per_gb_xfdftableType is explicitly created type
2524: -- only modification needed is it could be of type blob
2525: -- i tried thta but could not access the blob valus in java routine.
2526: -- can be sorted later
2527: l_xfdf_str_tab per_gb_xfdftableType := per_gb_xfdftableType( );
2528: l_xfdf_str varchar2(32000);
2529: l_ret_ref_cursor ref_cursor_typ;
2530: l_offset integer;
2531: l_varchar_buffer varchar2(32000);
3417: end loop;
3418: end if;
3419: open l_ret_ref_cursor for
3420: select *
3421: from table (cast(l_xfdf_str_tab as per_gb_xfdftableType));
3422: p_record_num := l_loop_count;
3423: return l_ret_ref_cursor;
3424: end ;
3425:
3425:
3426: function fetch_ws3_ref_cursor (p_assignment_action_id Number,
3427: p_record_num out nocopy NUmber) return ref_cursor_typ
3428: is
3429: -- per_gb_xfdftableType is explicitly created type
3430: -- only modification needed is it could be of type blob
3431: -- i tried thta but could not access the blob valus in java routine.
3432: -- can be sorted later
3433: l_xfdf_str_tab per_gb_xfdftableType := per_gb_xfdftableType( );
3429: -- per_gb_xfdftableType is explicitly created type
3430: -- only modification needed is it could be of type blob
3431: -- i tried thta but could not access the blob valus in java routine.
3432: -- can be sorted later
3433: l_xfdf_str_tab per_gb_xfdftableType := per_gb_xfdftableType( );
3434: l_xfdf_str varchar2(32000);
3435: l_ret_ref_cursor ref_cursor_typ;
3436:
3437: cursor csr_vans_entries(p_pactid Number,
4018:
4019: hr_utility.trace('10');
4020: open l_ret_ref_cursor for
4021: select *
4022: from table (cast(l_xfdf_str_tab as per_gb_xfdftableType));
4023: p_record_num := l_loop_count;
4024: return l_ret_ref_cursor;
4025: end ;
4026:
4026:
4027: function fetch_ws4_ref_cursor (p_assignment_action_id Number,
4028: p_record_num out nocopy NUmber) return ref_cursor_typ
4029: is
4030: -- per_gb_xfdftableType is explicitly created type
4031: -- only modification needed is it could be of type blob
4032: -- i tried thta but could not access the blob valus in java routine.
4033: -- can be sorted later
4034: l_xfdf_str_tab per_gb_xfdftableType := per_gb_xfdftableType( );
4030: -- per_gb_xfdftableType is explicitly created type
4031: -- only modification needed is it could be of type blob
4032: -- i tried thta but could not access the blob valus in java routine.
4033: -- can be sorted later
4034: l_xfdf_str_tab per_gb_xfdftableType := per_gb_xfdftableType( );
4035: l_xfdf_str varchar2(32000);
4036: l_ret_ref_cursor ref_cursor_typ;
4037: cursor csr_int_entries (p_pactid Number,
4038: p_person_id Number,
4207: l_xfdf_str_tab(l_tab_index) := l_xfdf_str_tab(l_tab_index) || ' ';
4208: end if;
4209: open l_ret_ref_cursor for
4210: select *
4211: from table (cast(l_xfdf_str_tab as per_gb_xfdftableType));
4212: p_record_num := l_tab_index;
4213: return l_ret_ref_cursor;
4214: end ;
4215:
4354:
4355: function fetch_ws6_ref_cursor (p_assignment_action_id Number,
4356: p_record_num out nocopy NUmber) return ref_cursor_typ
4357: is
4358: -- per_gb_xfdftableType is explicitly created type
4359: -- only modification needed is it could be of type blob
4360: -- i tried thta but could not access the blob valus in java routine.
4361: -- can be sorted later
4362: l_xfdf_str_tab per_gb_xfdftableType := per_gb_xfdftableType( );
4358: -- per_gb_xfdftableType is explicitly created type
4359: -- only modification needed is it could be of type blob
4360: -- i tried thta but could not access the blob valus in java routine.
4361: -- can be sorted later
4362: l_xfdf_str_tab per_gb_xfdftableType := per_gb_xfdftableType( );
4363: l_xfdf_str varchar2(32000);
4364: l_ret_ref_cursor ref_cursor_typ;
4365: l_offset integer;
4366: l_varchar_buffer varchar2(32000);
4617: ' ';
4618: end loop;
4619: open l_ret_ref_cursor for
4620: select *
4621: from table (cast(l_xfdf_str_tab as per_gb_xfdftableType));
4622: p_record_num := l_loop_count;
4623: return l_ret_ref_cursor;
4624: end ;
4625: