DBA Data[Home] [Help]

APPS.ZX_AR_POPULATE_PKG dependencies on FA_RX_FLEX_PKG

Line 948: l_balancing_segment := fa_rx_flex_pkg.flex_sql(

944: -- Accounting Flex Field Information --
945: -- Determine which segment is balancing segment for the given
946: -- chart of accounts (Set of books)
947:
948: l_balancing_segment := fa_rx_flex_pkg.flex_sql(
949: p_application_id =>101,
950: p_id_flex_code => 'GL#',
951: p_id_flex_num => P_TRL_GLOBAL_VARIABLES_REC.chart_of_accounts_id,
952: p_table_alias => '',

Line 956: l_accounting_segment := fa_rx_flex_pkg.flex_sql(

952: p_table_alias => '',
953: p_mode => 'SELECT',
954: p_qualifier => 'GL_BALANCING');
955:
956: l_accounting_segment := fa_rx_flex_pkg.flex_sql(
957: p_application_id =>101,
958: p_id_flex_code => 'GL#',
959: p_id_flex_num => P_TRL_GLOBAL_VARIABLES_REC.chart_of_accounts_id,
960: p_table_alias => '',

Line 2132: L_BAL_SEG_DESC := FA_RX_FLEX_PKG.GET_DESCRIPTION(

2128: EXECUTE IMMEDIATE L_SQL_STATEMENT2 INTO L_ACCT_SEG_VAL
2129: USING l_ccid;
2130:
2131: IF L_BAL_SEG_VAL IS NOT NULL THEN
2132: L_BAL_SEG_DESC := FA_RX_FLEX_PKG.GET_DESCRIPTION(
2133: P_APPLICATION_ID => 101,
2134: P_ID_FLEX_CODE => 'GL#',
2135: P_ID_FLEX_NUM => g_coa_id,
2136: P_QUALIFIER => 'GL_BALANCING',

Line 2155: L_ACCT_SEG_DESC := FA_RX_FLEX_PKG.GET_DESCRIPTION(

2151: END IF;
2152:
2153: --Bug 5650415 : Get the description for the natural Segnemt of the taxable line ccid
2154: IF L_ACCT_SEG_VAL IS NOT NULL THEN
2155: L_ACCT_SEG_DESC := FA_RX_FLEX_PKG.GET_DESCRIPTION(
2156: P_APPLICATION_ID => 101,
2157: P_ID_FLEX_CODE => 'GL#',
2158: P_ID_FLEX_NUM => g_coa_id,
2159: P_QUALIFIER => 'GL_ACCOUNT',

Line 2232: GT_ACCOUNT_FLEXFIELD(j) := FA_RX_FLEX_PKG.GET_VALUE(

2228: ----------------------------------------------------------------------
2229:
2230: IF l_tax_dist_ccid IS NOT NULL THEN
2231:
2232: GT_ACCOUNT_FLEXFIELD(j) := FA_RX_FLEX_PKG.GET_VALUE(
2233: P_APPLICATION_ID => 101,
2234: P_ID_FLEX_CODE => 'GL#',
2235: P_ID_FLEX_NUM => g_coa_id,
2236: P_QUALIFIER => 'ALL',

Line 2244: GT_ACCOUNT_DESCRIPTION(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(

2240: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2241: 'Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2242: END IF;
2243:
2244: GT_ACCOUNT_DESCRIPTION(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(
2245: P_APPLICATION_ID => 101,
2246: P_ID_FLEX_CODE => 'GL#',
2247: P_ID_FLEX_NUM => g_coa_id,
2248: P_QUALIFIER => 'ALL',

Line 2262: GT_TRX_CONTROL_ACCFLEXFIELD(j) := FA_RX_FLEX_PKG.GET_VALUE(

2258: --Bug 5510907 : To get the accounting Flexfield for the Taxable Line
2259:
2260: IF l_trx_dist_ccid IS NOT NULL THEN
2261:
2262: GT_TRX_CONTROL_ACCFLEXFIELD(j) := FA_RX_FLEX_PKG.GET_VALUE(
2263: P_APPLICATION_ID => 101,
2264: P_ID_FLEX_CODE => 'GL#',
2265: P_ID_FLEX_NUM => g_coa_id,
2266: P_QUALIFIER => 'ALL',

Line 2275: GT_TRX_TAXABLE_ACCOUNT_DESC(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(

2271: 'inv_segment_info : Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2272: END IF;
2273:
2274: --Bug 5650415
2275: GT_TRX_TAXABLE_ACCOUNT_DESC(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(
2276: P_APPLICATION_ID => 101,
2277: P_ID_FLEX_CODE => 'GL#',
2278: P_ID_FLEX_NUM => g_coa_id,
2279: P_QUALIFIER => 'ALL',

Line 2849: L_BAL_SEG_DESC := FA_RX_FLEX_PKG.GET_DESCRIPTION(

2845: EXECUTE IMMEDIATE L_SQL_STATEMENT2 INTO L_ACCT_SEG_VAL
2846: USING l_ccid;
2847:
2848: IF L_BAL_SEG_VAL IS NOT NULL THEN
2849: L_BAL_SEG_DESC := FA_RX_FLEX_PKG.GET_DESCRIPTION(
2850: P_APPLICATION_ID => 101,
2851: P_ID_FLEX_CODE => 'GL#',
2852: P_ID_FLEX_NUM => g_coa_id,
2853: P_QUALIFIER => 'GL_BALANCING',

Line 2947: L_BAL_SEG_DESC := FA_RX_FLEX_PKG.GET_DESCRIPTION(

2943: END IF;
2944:
2945:
2946: IF L_BAL_SEG_VAL IS NOT NULL THEN
2947: L_BAL_SEG_DESC := FA_RX_FLEX_PKG.GET_DESCRIPTION(
2948: P_APPLICATION_ID => 101,
2949: P_ID_FLEX_CODE => 'GL#',
2950: P_ID_FLEX_NUM => g_coa_id,
2951: P_QUALIFIER => 'GL_BALANCING',

Line 3007: L_BAL_SEG_DESC := FA_RX_FLEX_PKG.GET_DESCRIPTION(

3003: ||'-'||to_char(P_TRX_LINE_ID)||'-'||to_char(l_ccid)||'-'||L_BAL_SEG_VAL);
3004: END IF;
3005:
3006: IF L_BAL_SEG_VAL IS NOT NULL THEN
3007: L_BAL_SEG_DESC := FA_RX_FLEX_PKG.GET_DESCRIPTION(
3008: P_APPLICATION_ID => 101,
3009: P_ID_FLEX_CODE => 'GL#',
3010: P_ID_FLEX_NUM => g_coa_id,
3011: P_QUALIFIER => 'GL_BALANCING',

Line 3054: GT_ACCOUNT_FLEXFIELD(j) := FA_RX_FLEX_PKG.GET_VALUE(

3050: ----------------------------------------------------------------------
3051:
3052: IF l_tax_dist_ccid IS NOT NULL THEN
3053:
3054: GT_ACCOUNT_FLEXFIELD(j) := FA_RX_FLEX_PKG.GET_VALUE(
3055: P_APPLICATION_ID => 101,
3056: P_ID_FLEX_CODE => 'GL#',
3057: P_ID_FLEX_NUM => g_coa_id,
3058: P_QUALIFIER => 'ALL',

Line 3066: GT_ACCOUNT_DESCRIPTION(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(

3062: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3063: 'Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
3064: END IF;
3065:
3066: GT_ACCOUNT_DESCRIPTION(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(
3067: P_APPLICATION_ID => 101,
3068: P_ID_FLEX_CODE => 'GL#',
3069: P_ID_FLEX_NUM => g_coa_id,
3070: P_QUALIFIER => 'ALL',

Line 3084: GT_TRX_CONTROL_ACCFLEXFIELD(j) := FA_RX_FLEX_PKG.GET_VALUE(

3080: --Bug 5510907 : To get the accounting Flexfield for the Taxable Line
3081:
3082: IF l_trx_dist_ccid IS NOT NULL THEN
3083:
3084: GT_TRX_CONTROL_ACCFLEXFIELD(j) := FA_RX_FLEX_PKG.GET_VALUE(
3085: P_APPLICATION_ID => 101,
3086: P_ID_FLEX_CODE => 'GL#',
3087: P_ID_FLEX_NUM => g_coa_id,
3088: P_QUALIFIER => 'ALL',