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.

[Home] [Help]

APPS.FARX_AD dependencies on FA_RX_FLEX_PKG

Line 221: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'BASED_CATEGORY');

217:
218: --
219: -- Get Columns for Major_category, Minor_category and Specified_category
220: --
221: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'BASED_CATEGORY');
222:
223: begin
224: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'MINOR_CATEGORY');
225: exception

Line 224: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'MINOR_CATEGORY');

220: --
221: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'BASED_CATEGORY');
222:
223: begin
224: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'MINOR_CATEGORY');
225: exception
226: when others then
227: min_select_statement := 'null';
228: end;

Line 231: spec_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', cat_seg_num);

227: min_select_statement := 'null';
228: end;
229:
230: begin
231: spec_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', cat_seg_num);
232: exception
233: when others then
234: spec_select_statement := 'null';
235: end;

Line 250: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

246: /* BUG# 2939771
247: -- Major Category --
248: IF(from_maj_cat = to_maj_cat) THEN
249: l_param_where := l_param_where || ' AND ' ||
250: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
251: 'WHERE', 'BASED_CATEGORY','=', from_maj_cat);
252: elsif (from_maj_cat is not NULL) and (to_maj_cat is not NULL) THEN
253: l_param_where := l_param_where || ' AND ' ||
254: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 254: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

250: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
251: 'WHERE', 'BASED_CATEGORY','=', from_maj_cat);
252: elsif (from_maj_cat is not NULL) and (to_maj_cat is not NULL) THEN
253: l_param_where := l_param_where || ' AND ' ||
254: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
255: 'WHERE', 'BASED_CATEGORY','BETWEEN', from_maj_cat, to_maj_cat);
256: elsif (from_maj_cat is not NULL) THEN
257: l_param_where := l_param_where || ' AND ' ||
258: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 258: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

254: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
255: 'WHERE', 'BASED_CATEGORY','BETWEEN', from_maj_cat, to_maj_cat);
256: elsif (from_maj_cat is not NULL) THEN
257: l_param_where := l_param_where || ' AND ' ||
258: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
259: 'WHERE', 'BASED_CATEGORY','>=', from_maj_cat);
260: elsif (to_maj_cat is not NULL) THEN
261: l_param_where := l_param_where || ' AND ' ||
262: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 262: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

258: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
259: 'WHERE', 'BASED_CATEGORY','>=', from_maj_cat);
260: elsif (to_maj_cat is not NULL) THEN
261: l_param_where := l_param_where || ' AND ' ||
262: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
263: 'WHERE', 'BASED_CATEGORY','<=', to_maj_cat);
264: END IF;
265: */
266:

Line 269: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

265: */
266:
267: -- Major Category --
268: l_param_where := l_param_where || ' AND (' ||
269: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
270: 'SELECT', 'BASED_CATEGORY') ||' >= :from_maj_cat or :from_maj_cat is NULL)';
271:
272: l_param_where := l_param_where || ' AND (' ||
273: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 273: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

269: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
270: 'SELECT', 'BASED_CATEGORY') ||' >= :from_maj_cat or :from_maj_cat is NULL)';
271:
272: l_param_where := l_param_where || ' AND (' ||
273: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
274: 'SELECT', 'BASED_CATEGORY') ||' <= :to_maj_cat or :to_maj_cat is NULL)';
275:
276:
277: /* BUG# 2939771

Line 281: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

277: /* BUG# 2939771
278: -- Minor Category --
279: IF (from_min_cat = to_min_cat) THEN
280: l_param_where := l_param_where || ' AND ' ||
281: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
282: 'WHERE', 'MINOR_CATEGORY','=', from_min_cat);
283: elsif (from_min_cat is not NULL) and (to_min_cat is not NULL) THEN
284: l_param_where := l_param_where || ' AND ' ||
285: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 285: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

281: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
282: 'WHERE', 'MINOR_CATEGORY','=', from_min_cat);
283: elsif (from_min_cat is not NULL) and (to_min_cat is not NULL) THEN
284: l_param_where := l_param_where || ' AND ' ||
285: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
286: 'WHERE', 'MINOR_CATEGORY','BETWEEN', from_min_cat, to_min_cat);
287: elsif (from_min_cat is not NULL) THEN
288: l_param_where := l_param_where || ' AND ' ||
289: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 289: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

285: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
286: 'WHERE', 'MINOR_CATEGORY','BETWEEN', from_min_cat, to_min_cat);
287: elsif (from_min_cat is not NULL) THEN
288: l_param_where := l_param_where || ' AND ' ||
289: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
290: 'WHERE', 'MINOR_CATEGORY','>=', from_min_cat);
291: elsif (to_min_cat is not NULL) THEN
292: l_param_where := l_param_where || ' AND ' ||
293: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 293: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

289: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
290: 'WHERE', 'MINOR_CATEGORY','>=', from_min_cat);
291: elsif (to_min_cat is not NULL) THEN
292: l_param_where := l_param_where || ' AND ' ||
293: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
294: 'WHERE', 'MINOR_CATEGORY','<=', to_min_cat);
295: END IF;
296: */
297:

Line 304: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

300: in case that flex_sql fails when from_min_cat or to_min_cat are null
301: */
302: begin
303: l_param_where := l_param_where || ' AND (' ||
304: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
305: 'SELECT', 'MINOR_CATEGORY') ||' >= :from_min_cat or :from_min_cat is NULL)';
306: exception
307: when others then
308: l_param_where := l_param_where || ' AND (:from_min_cat is NULL and :from_min_cat is NULL)';

Line 313: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

309: end;
310:
311: begin
312: l_param_where := l_param_where || ' AND (' ||
313: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
314: 'SELECT', 'MINOR_CATEGORY') ||' <= :to_min_cat or :to_min_cat is NULL)';
315: exception
316: when others then
317: l_param_where := l_param_where || ' AND (:to_min_cat is NULL and :to_min_cat is NULL)';

Line 327: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

323: IF (cat_seg_num IS NOT NULL) THEN
324: h_cat_seg_num := cat_seg_num;
325: IF (from_cat_seg_val = to_cat_seg_val) THEN
326: l_param_where := l_param_where || ' AND ' ||
327: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
328: 'WHERE',cat_seg_num ,'=', from_cat_seg_val);
329: elsif (from_cat_seg_val is not NULL) and (to_cat_seg_val is not NULL) THEN
330: l_param_where := l_param_where || ' AND ' ||
331: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 331: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

327: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
328: 'WHERE',cat_seg_num ,'=', from_cat_seg_val);
329: elsif (from_cat_seg_val is not NULL) and (to_cat_seg_val is not NULL) THEN
330: l_param_where := l_param_where || ' AND ' ||
331: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
332: 'WHERE',cat_seg_num ,'BETWEEN', from_cat_seg_val, to_cat_seg_val);
333: elsif (from_cat_seg_val is not NULL) THEN
334: l_param_where := l_param_where || ' AND ' ||
335: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 335: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

331: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
332: 'WHERE',cat_seg_num ,'BETWEEN', from_cat_seg_val, to_cat_seg_val);
333: elsif (from_cat_seg_val is not NULL) THEN
334: l_param_where := l_param_where || ' AND ' ||
335: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
336: 'WHERE',cat_seg_num ,'>=', from_cat_seg_val);
337: elsif (to_cat_seg_val is not NULL) THEN
338: l_param_where := l_param_where || ' AND ' ||
339: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 339: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

335: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
336: 'WHERE',cat_seg_num ,'>=', from_cat_seg_val);
337: elsif (to_cat_seg_val is not NULL) THEN
338: l_param_where := l_param_where || ' AND ' ||
339: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
340: 'WHERE',cat_seg_num ,'<=', to_cat_seg_val);
341: END IF;
342: END IF;
343: */

Line 349: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

345: -- Category Segment Number --
346: IF (cat_seg_num IS NOT NULL) THEN
347: h_cat_seg_num := cat_seg_num;
348: l_param_where := l_param_where || ' AND (' ||
349: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
350: 'SELECT', cat_seg_num) ||' >= :from_cat_seg_val or :from_cat_seg_val is NULL)';
351:
352: l_param_where := l_param_where || ' AND (' ||
353: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 353: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

349: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
350: 'SELECT', cat_seg_num) ||' >= :from_cat_seg_val or :from_cat_seg_val is NULL)';
351:
352: l_param_where := l_param_where || ' AND (' ||
353: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
354: 'SELECT', cat_seg_num) ||' <= :to_cat_seg_val or :to_cat_seg_val is NULL)';
355: ELSE
356: l_param_where := l_param_where || ' AND ( nvl(:from_cat_seg_val,-999) = -999 or :from_cat_seg_val is null)';
357: l_param_where := l_param_where || ' AND ( nvl(:to_cat_seg_val,-999) = -999 or :to_cat_seg_val is null)';

Line 372: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

368: /* BUG# 2939771
369: -- COST CENTER --
370: If (from_cc = to_cc) THEN
371: l_param_where := l_param_where || ' AND ' ||
372: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
373: 'WHERE', 'FA_COST_CTR','=', from_cc);
374: elsif (from_cc is not NULL) and (to_cc is not NULL) THEN
375: l_param_where := l_param_where || ' AND ' ||
376: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

Line 376: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

372: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
373: 'WHERE', 'FA_COST_CTR','=', from_cc);
374: elsif (from_cc is not NULL) and (to_cc is not NULL) THEN
375: l_param_where := l_param_where || ' AND ' ||
376: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
377: 'WHERE', 'FA_COST_CTR','BETWEEN', from_cc, to_cc);
378: elsif (from_cc is not NULL) THEN
379: l_param_where := l_param_where || ' AND ' ||
380: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

Line 380: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

376: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
377: 'WHERE', 'FA_COST_CTR','BETWEEN', from_cc, to_cc);
378: elsif (from_cc is not NULL) THEN
379: l_param_where := l_param_where || ' AND ' ||
380: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
381: 'WHERE', 'FA_COST_CTR','>=', from_cc);
382: elsif (to_cc is not NULL) THEN
383: l_param_where := l_param_where || ' AND ' ||
384: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

Line 384: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

380: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
381: 'WHERE', 'FA_COST_CTR','>=', from_cc);
382: elsif (to_cc is not NULL) THEN
383: l_param_where := l_param_where || ' AND ' ||
384: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
385: 'WHERE', 'FA_COST_CTR','<=', to_cc);
386: end if;
387: */
388:

Line 390: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

386: end if;
387: */
388:
389: l_param_where := l_param_where || ' AND (' ||
390: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
391: 'SELECT', 'FA_COST_CTR') ||' >= :from_cc or :from_cc is NULL)';
392:
393: l_param_where := l_param_where || ' AND (' ||
394: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

Line 394: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

390: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
391: 'SELECT', 'FA_COST_CTR') ||' >= :from_cc or :from_cc is NULL)';
392:
393: l_param_where := l_param_where || ' AND (' ||
394: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
395: 'SELECT', 'FA_COST_CTR') ||' <= :to_cc or :to_cc is NULL)';
396:
397: /* BUG # 2939771
398: -- Asset Number --

Line 1091: fa_rx_flex_pkg.get_description(

1087:
1088: h_life_year_month_num := fnd_number.canonical_to_number(h_life_year_month);
1089:
1090: /* h_account_desc :=
1091: fa_rx_flex_pkg.get_description(
1092: p_application_id => 101,
1093: p_id_flex_code => 'GL#',
1094: p_id_flex_num => h_chart_of_accounts_id,
1095: p_qualifier => 'GL_ACCOUNT',

Line 1100: fa_rx_flex_pkg.get_description(

1096: p_data => h_acct_segs(h_acct_seg));
1097: */
1098:
1099: h_account_desc :=
1100: fa_rx_flex_pkg.get_description(
1101: p_application_id => 101,
1102: p_id_flex_code => 'GL#',
1103: p_id_flex_num => h_chart_of_accounts_id,
1104: p_qualifier => 'GL_ACCOUNT',

Line 1108: fa_rx_flex_pkg.get_description(

1104: p_qualifier => 'GL_ACCOUNT',
1105: p_data => h_cost_acct);
1106:
1107: h_cost_center_desc :=
1108: fa_rx_flex_pkg.get_description(
1109: p_application_id => 101,
1110: p_id_flex_code => 'GL#',
1111: p_id_flex_num => h_chart_of_accounts_id,
1112: p_qualifier => 'FA_COST_CTR',

Line 1124: fa_rx_flex_pkg.get_value(

1120: END IF;
1121:
1122: /*
1123: h_maj_cat :=
1124: fa_rx_flex_pkg.get_value(
1125: p_application_id => 140,
1126: p_id_flex_code => 'CAT#',
1127: p_id_flex_num => h_assetkey_flex_structure,
1128: p_qualifier => 'BASED_CATEGORY',

Line 1133: fa_rx_flex_pkg.get_description(

1129: p_ccid => h_category_id);
1130: */
1131: begin
1132: h_maj_cat_desc :=
1133: fa_rx_flex_pkg.get_description(
1134: p_application_id => 140,
1135: p_id_flex_code => 'CAT#',
1136: p_id_flex_num => h_assetkey_flex_structure,
1137: p_qualifier => 'BASED_CATEGORY',

Line 1147: fa_rx_flex_pkg.get_value(

1143:
1144: /*
1145: BEGIN
1146: h_min_cat :=
1147: fa_rx_flex_pkg.get_value(
1148: p_application_id => 140,
1149: p_id_flex_code => 'CAT#',
1150: p_id_flex_num => h_assetkey_flex_structure,
1151: p_qualifier => 'MINOR_CATEGORY',

Line 1160: fa_rx_flex_pkg.get_description(

1156: end;
1157: */
1158: begin
1159: h_min_cat_desc :=
1160: fa_rx_flex_pkg.get_description(
1161: p_application_id => 140,
1162: p_id_flex_code => 'CAT#',
1163: p_id_flex_num => h_assetkey_flex_structure,
1164: p_qualifier => 'MINOR_CATEGORY',

Line 1173: fa_rx_flex_pkg.get_value(

1169: end;
1170: /*
1171: BEGIN
1172: h_specified_cat :=
1173: fa_rx_flex_pkg.get_value(
1174: p_application_id => 140,
1175: p_id_flex_code => 'CAT#',
1176: p_id_flex_num => h_assetkey_flex_structure,
1177: p_qualifier => h_cat_seg_num,

Line 1186: fa_rx_flex_pkg.get_description(

1182: end;
1183: */
1184: begin
1185: h_specified_cat_desc :=
1186: fa_rx_flex_pkg.get_description(
1187: p_application_id => 140,
1188: p_id_flex_code => 'CAT#',
1189: p_id_flex_num => h_assetkey_flex_structure,
1190: p_qualifier => h_cat_seg_num,

Line 2454: maj_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',h_cat_flex_struct,'CAT','SELECT','BASED_CATEGORY');

2450:
2451: maj_select_column := null;
2452: min_select_column := null;
2453:
2454: maj_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',h_cat_flex_struct,'CAT','SELECT','BASED_CATEGORY');
2455: maj_select_column := maj_select_column || ' MAJOR_CATEGORY';
2456:
2457: begin
2458: min_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',h_cat_flex_struct,'CAT','SELECT','MINOR_CATEGORY');

Line 2458: min_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',h_cat_flex_struct,'CAT','SELECT','MINOR_CATEGORY');

2454: maj_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',h_cat_flex_struct,'CAT','SELECT','BASED_CATEGORY');
2455: maj_select_column := maj_select_column || ' MAJOR_CATEGORY';
2456:
2457: begin
2458: min_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',h_cat_flex_struct,'CAT','SELECT','MINOR_CATEGORY');
2459: min_select_column := min_select_column || ' MINOR_CATEGORY';
2460: exception
2461: when others then
2462: min_select_column := 'NULL';

Line 2480: fa_rx_flex_pkg.get_description(

2476:
2477: mesg := 'getting_major_category_desc';
2478:
2479: h_major_cat_desc :=
2480: fa_rx_flex_pkg.get_description(
2481: p_application_id => 140,
2482: p_id_flex_code => 'CAT#',
2483: p_id_flex_num => h_cat_flex_struct,
2484: p_qualifier => 'BASED_CATEGORY',

Line 2490: fa_rx_flex_pkg.get_description(

2486:
2487:
2488: mesg := 'getting_minor_category_desc';
2489: h_minor_cat_desc :=
2490: fa_rx_flex_pkg.get_description(
2491: p_application_id => 140,
2492: p_id_flex_code => 'CAT#',
2493: p_id_flex_num => h_cat_flex_struct,
2494: p_qualifier => 'MINOR_CATEGORY',