DBA Data[Home] [Help]

APPS.FA_DEPRN_TAX_REP_PKG dependencies on FA_RX_FLEX_PKG

Line 611: l_parm_minor := fa_rx_flex_pkg.flex_sql(140,'CAT#', cat_flex_struct,'CAT',

607:
608: /* Get Minor Category Segment */
609: /* Bug#3305764 - Enhancement to make flexfield segment flexible */
610: /* Changed hard-coded 'MINOR_CATEGORY' to h_tax_Asset_type_segment */
611: l_parm_minor := fa_rx_flex_pkg.flex_sql(140,'CAT#', cat_flex_struct,'CAT',
612: 'SELECT', h_tax_asset_type_segment);
613:
614: IF (g_print_debug) THEN
615: fa_rx_util_pkg.debug('fadptx_insert: ' || 'Tax Asset Type Category Segment: '||l_parm_minor);

Line 619: l_parm_state := fa_rx_flex_pkg.flex_sql(140,'LOC#', loc_flex_struct,'LOC',

615: fa_rx_util_pkg.debug('fadptx_insert: ' || 'Tax Asset Type Category Segment: '||l_parm_minor);
616: END IF;
617:
618: /* Get Location Segment */
619: l_parm_state := fa_rx_flex_pkg.flex_sql(140,'LOC#', loc_flex_struct,'LOC',
620: 'SELECT', 'LOC_STATE');
621:
622: IF (g_print_debug) THEN
623: fa_rx_util_pkg.debug('fadptx_insert: ' || 'State Segment: '||l_parm_state);

Line 1345: fa_rx_flex_pkg.get_description(

1341: END If;
1342:
1343: if h_minor_category is not null then
1344: h_minor_cat_desc :=
1345: fa_rx_flex_pkg.get_description(
1346: p_application_id => 140,
1347: p_id_flex_code => 'CAT#',
1348: p_id_flex_num => cat_flex_struct,
1349: -- p_qualifier => 'MINOR_CATEGORY',

Line 2675: fa_rx_flex_pkg.get_description(

2671: END LOOP;
2672:
2673: IF (l_match_found = 0) THEN
2674: l_oth_type_desc :=
2675: fa_rx_flex_pkg.get_description(
2676: p_application_id => 140,
2677: p_id_flex_code => 'CAT#',
2678: p_id_flex_num => cat_flex_struct,
2679: p_qualifier => h_tax_asset_type_segment,

Line 2690: fa_rx_flex_pkg.get_description(

2686: FOR l_local_cntr IN 1..(state_code_v.COUNT -1)
2687: LOOP
2688: /* Bug13892777: After further testing can comment the prior loop */
2689: l_oth_type_desc :=
2690: fa_rx_flex_pkg.get_description(
2691: p_application_id => 140,
2692: p_id_flex_code => 'CAT#',
2693: p_id_flex_num => cat_flex_struct,
2694: p_qualifier => h_tax_asset_type_segment,