DBA Data[Home] [Help]

APPS.FA_CUA_ASSET_WB_APIS_PKG dependencies on FA_CATEGORIES_B_KFV

Line 146: from fa_categories_b_kfv

142:
143: Function get_category_id (x_concatenated_segments in varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return number is
144: cursor c is
145: select category_id
146: from fa_categories_b_kfv
147: where concatenated_segments = x_concatenated_segments;
148:
149: v_category_id number;
150: begin

Line 160: from fa_categories_b_kfv

156:
157: Function get_category_name (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
158: cursor c is
159: select concatenated_segments
160: from fa_categories_b_kfv
161: where category_id = x_id;
162:
163: v_concatenated_segments fa_categories_b_kfv.concatenated_segments%type;
164: begin

Line 163: v_concatenated_segments fa_categories_b_kfv.concatenated_segments%type;

159: select concatenated_segments
160: from fa_categories_b_kfv
161: where category_id = x_id;
162:
163: v_concatenated_segments fa_categories_b_kfv.concatenated_segments%type;
164: begin
165: open c;
166: fetch c into v_concatenated_segments;
167: close c;