APPS.IGIRX_IAC_PROJ dependencies on FA_RX_FLEX_PKG

Line 254: l_rxi_proj_rec.major_category(l_count) := fa_rx_flex_pkg.get_value(

250: l_rxi_proj_rec.category_id(l_count) := l_proj_data.category_id;
251: l_rxi_proj_rec.category_desc(l_count) := l_proj_data.cat_desc;
252:
253: -- get the major category and minor category values
254: l_rxi_proj_rec.major_category(l_count) := fa_rx_flex_pkg.get_value(
255: p_application_id => 140,
256: p_id_flex_code => 'CAT#',
257: p_id_flex_num => l_assetkey_struct,
258: p_qualifier => 'BASED_CATEGORY',

Line 262: /* l_min_cat:= fa_rx_flex_pkg.get_value(

258: p_qualifier => 'BASED_CATEGORY',
259: p_ccid => l_proj_data.category_id);
260: -- change the way the minor category is retrieved
261: -- get only the first qualified segment
262: /* l_min_cat:= fa_rx_flex_pkg.get_value(
263: p_application_id => 140,
264: p_id_flex_code => 'CAT#',
265: p_id_flex_num => l_assetkey_struct,
266: p_qualifier => 'MINOR_CATEGORY',

Line 272: l_min_cat := fa_rx_flex_pkg.flex_sql(140,

268:
269: l_rxi_proj_rec.minor_category(l_count) := substr(l_min_cat, 0, instr(l_min_cat, 1, 1)-1);
270: */
271: begin
272: l_min_cat := fa_rx_flex_pkg.flex_sql(140,
273: 'CAT#',
274: l_assetkey_struct,
275: 'CAT',
276: 'SELECT',