DBA Data[Home] [Help]

APPS.ZX_AP_POPULATE_PKG dependencies on FA_RX_FLEX_PKG

Line 652: l_balancing_segment := fa_rx_flex_pkg.flex_sql(

648: END IF;
649:
650: -- bug 13607557 moved the code out of the loop
651: G_CHART_OF_ACCOUNTS_ID := p_trl_global_variables_rec.chart_of_accounts_id;
652: l_balancing_segment := fa_rx_flex_pkg.flex_sql(
653: p_application_id =>101,
654: p_id_flex_code => 'GL#',
655: p_id_flex_num => g_chart_of_accounts_id,
656: p_table_alias => '',

Line 659: l_accounting_segment := fa_rx_flex_pkg.flex_sql(

655: p_id_flex_num => g_chart_of_accounts_id,
656: p_table_alias => '',
657: p_mode => 'SELECT',
658: p_qualifier => 'GL_BALANCING');
659: l_accounting_segment := fa_rx_flex_pkg.flex_sql(
660: p_application_id =>101,
661: p_id_flex_code => 'GL#',
662: p_id_flex_num => g_chart_of_accounts_id,
663: p_table_alias => '',

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

1985: 'From Cache :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
1986: END IF;
1987: ELSE
1988:
1989: GT_ACCOUNT_FLEXFIELD(j) := FA_RX_FLEX_PKG.GET_VALUE(
1990: P_APPLICATION_ID => 101,
1991: P_ID_FLEX_CODE => 'GL#',
1992: P_ID_FLEX_NUM => g_chart_of_accounts_id,
1993: P_QUALIFIER => 'ALL',

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

1992: P_ID_FLEX_NUM => g_chart_of_accounts_id,
1993: P_QUALIFIER => 'ALL',
1994: P_CCID => l_tax_dist_ccid);
1995:
1996: GT_ACCOUNT_DESCRIPTION(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(
1997: P_APPLICATION_ID => 101,
1998: P_ID_FLEX_CODE => 'GL#',
1999: P_ID_FLEX_NUM => g_chart_of_accounts_id,
2000: P_QUALIFIER => 'ALL',

Line 2013: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);

2009: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_VAL := NULL;
2010:
2011: IF (g_level_procedure >= g_current_runtime_level ) THEN
2012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2013: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2015: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2017: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));

Line 2015: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));

2011: IF (g_level_procedure >= g_current_runtime_level ) THEN
2012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2013: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2015: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2017: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
2018: END IF;
2019: END IF; --Cache Exists Check

Line 2017: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));

2013: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2015: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2017: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
2018: END IF;
2019: END IF; --Cache Exists Check
2020: END IF; --TAX CCID Null Check
2021:

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

2043: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2044: END IF;
2045: ELSE
2046:
2047: GT_TRX_CONTROL_ACCFLEXFIELD(j) := FA_RX_FLEX_PKG.GET_VALUE(
2048: P_APPLICATION_ID => 101,
2049: P_ID_FLEX_CODE => 'GL#',
2050: P_ID_FLEX_NUM => g_chart_of_accounts_id,
2051: P_QUALIFIER => 'ALL',

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

2051: P_QUALIFIER => 'ALL',
2052: P_CCID => l_trx_dist_ccid);
2053:
2054:
2055: GT_TRX_TAXABLE_ACCOUNT_DESC(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(
2056: P_APPLICATION_ID => 101,
2057: P_ID_FLEX_CODE => 'GL#',
2058: P_ID_FLEX_NUM => g_chart_of_accounts_id,
2059: P_QUALIFIER => 'ALL',

Line 2063: l_balancing_seg_val := FA_RX_FLEX_PKG.GET_VALUE(

2059: P_QUALIFIER => 'ALL',
2060: P_DATA => GT_TRX_CONTROL_ACCFLEXFIELD(j));
2061:
2062:
2063: l_balancing_seg_val := FA_RX_FLEX_PKG.GET_VALUE(
2064: P_APPLICATION_ID => 101,
2065: P_ID_FLEX_CODE => 'GL#',
2066: P_ID_FLEX_NUM => g_chart_of_accounts_id,
2067: P_QUALIFIER => 'GL_BALANCING',

Line 2072: GT_TRX_TAXABLE_BALSEG_DESC(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(

2068: P_CCID => l_trx_dist_ccid);
2069:
2070:
2071: IF ( l_balancing_seg_val IS NOT NULL ) THEN
2072: GT_TRX_TAXABLE_BALSEG_DESC(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(
2073: P_APPLICATION_ID => 101,
2074: P_ID_FLEX_CODE => 'GL#',
2075: P_ID_FLEX_NUM => g_chart_of_accounts_id,
2076: P_QUALIFIER => 'GL_BALANCING',

Line 2082: l_natural_acct_val := FA_RX_FLEX_PKG.GET_VALUE(

2078:
2079: END IF ;
2080:
2081: --Populate the Natural Account desccription after fetching its value
2082: l_natural_acct_val := FA_RX_FLEX_PKG.GET_VALUE(
2083: P_APPLICATION_ID => 101,
2084: P_ID_FLEX_CODE => 'GL#',
2085: P_ID_FLEX_NUM => g_chart_of_accounts_id,
2086: P_QUALIFIER => 'GL_ACCOUNT',

Line 2090: GT_TRX_TAXABLE_NATACCT_DESC(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(

2086: P_QUALIFIER => 'GL_ACCOUNT',
2087: P_CCID => l_trx_dist_ccid);
2088:
2089: IF ( l_balancing_seg_val IS NOT NULL ) THEN
2090: GT_TRX_TAXABLE_NATACCT_DESC(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(
2091: P_APPLICATION_ID => 101,
2092: P_ID_FLEX_CODE => 'GL#',
2093: P_ID_FLEX_NUM => g_chart_of_accounts_id,
2094: P_QUALIFIER => 'GL_ACCOUNT',

Line 2108: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);

2104: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_VAL := NULL;
2105:
2106: IF (g_level_procedure >= g_current_runtime_level ) THEN
2107: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2108: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2110: 'From FA_RX_FLEX_PKG :: Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2112: 'From FA_RX_FLEX_PKG :: Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));

Line 2110: 'From FA_RX_FLEX_PKG :: Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));

2106: IF (g_level_procedure >= g_current_runtime_level ) THEN
2107: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2108: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2110: 'From FA_RX_FLEX_PKG :: Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2112: 'From FA_RX_FLEX_PKG :: Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2114: 'From FA_RX_FLEX_PKG :: l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);

Line 2112: 'From FA_RX_FLEX_PKG :: Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));

2108: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2110: 'From FA_RX_FLEX_PKG :: Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2112: 'From FA_RX_FLEX_PKG :: Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2114: 'From FA_RX_FLEX_PKG :: l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);
2115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2116: 'From FA_RX_FLEX_PKG :: Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));

Line 2114: 'From FA_RX_FLEX_PKG :: l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);

2110: 'From FA_RX_FLEX_PKG :: Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2112: 'From FA_RX_FLEX_PKG :: Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2114: 'From FA_RX_FLEX_PKG :: l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);
2115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2116: 'From FA_RX_FLEX_PKG :: Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2118: 'From FA_RX_FLEX_PKG :: l_natural_acct_val for TaxableLine = '||l_natural_acct_val);

Line 2116: 'From FA_RX_FLEX_PKG :: Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));

2112: 'From FA_RX_FLEX_PKG :: Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2114: 'From FA_RX_FLEX_PKG :: l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);
2115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2116: 'From FA_RX_FLEX_PKG :: Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2118: 'From FA_RX_FLEX_PKG :: l_natural_acct_val for TaxableLine = '||l_natural_acct_val);
2119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2120: 'From FA_RX_FLEX_PKG :: Natural Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_NATACCT_DESC(j));

Line 2118: 'From FA_RX_FLEX_PKG :: l_natural_acct_val for TaxableLine = '||l_natural_acct_val);

2114: 'From FA_RX_FLEX_PKG :: l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);
2115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2116: 'From FA_RX_FLEX_PKG :: Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2118: 'From FA_RX_FLEX_PKG :: l_natural_acct_val for TaxableLine = '||l_natural_acct_val);
2119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2120: 'From FA_RX_FLEX_PKG :: Natural Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2121: END IF;
2122: END IF; -- Cache Exists Check

Line 2120: 'From FA_RX_FLEX_PKG :: Natural Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_NATACCT_DESC(j));

2116: 'From FA_RX_FLEX_PKG :: Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2118: 'From FA_RX_FLEX_PKG :: l_natural_acct_val for TaxableLine = '||l_natural_acct_val);
2119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2120: 'From FA_RX_FLEX_PKG :: Natural Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2121: END IF;
2122: END IF; -- Cache Exists Check
2123: END IF ; -- TRX CCID Null Check
2124: