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.

APPS.FUN_RECON_RPT_PKG dependencies on FUN_RECON_RPT_PKG

Line 1: PACKAGE BODY FUN_RECON_RPT_PKG AS

1: PACKAGE BODY FUN_RECON_RPT_PKG AS
2: /* $Header: funrecrptb.pls 120.31.12020000.5 2013/03/27 10:55:17 srampure ship $ */
3:
4: --=============================================================================
5: -- **************** declaraions ********************

Line 96: ,fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

92: ';
93:
94: C_ADD_CURRENCY_COLS CONSTANT VARCHAR2(30000) :=
95: ' ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
96: ,fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
97: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AR_BEGIN_BALANCE_DR_ADD_CURR
98:
99: ,LTRIM(TO_CHAR (gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
100: ,fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

Line 100: ,fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

96: ,fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
97: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AR_BEGIN_BALANCE_DR_ADD_CURR
98:
99: ,LTRIM(TO_CHAR (gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
100: ,fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
101: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AR_BEGIN_BALANCE_CR_ADD_CURR
102:
103: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
104: ,fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

Line 104: ,fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

100: ,fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
101: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AR_BEGIN_BALANCE_CR_ADD_CURR
102:
103: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
104: ,fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
105: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AP_BEGIN_BALANCE_DR_ADD_CURR
106:
107: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
108: ,fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

Line 108: ,fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

104: ,fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
105: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AP_BEGIN_BALANCE_DR_ADD_CURR
106:
107: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
108: ,fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
109: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AP_BEGIN_BALANCE_CR_ADD_CURR
110:
111: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
112: ,fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

Line 112: ,fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

108: ,fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
109: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AP_BEGIN_BALANCE_CR_ADD_CURR
110:
111: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
112: ,fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
113: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AR_PERIOD_NET_DR_ADD_CURR
114:
115: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
116: ,fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

Line 116: ,fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

112: ,fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
113: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AR_PERIOD_NET_DR_ADD_CURR
114:
115: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
116: ,fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
117: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AR_PERIOD_NET_CR_ADD_CURR
118:
119: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
120: ,fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

Line 120: ,fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

116: ,fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
117: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AR_PERIOD_NET_CR_ADD_CURR
118:
119: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
120: ,fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
121: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AP_PERIOD_NET_DR_ADD_CURR
122:
123: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
124: ,fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

Line 124: ,fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

120: ,fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
121: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AP_PERIOD_NET_DR_ADD_CURR
122:
123: ,LTRIM(TO_CHAR(gl_currency_api.convert_amount_sql (TRANSACTION_CURRENCY, :TO_CURR, fnd_date.canonical_to_date(:TO_DATE), :TYPE
124: ,fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
125: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY)),''999999999999999999999.999999999999'')) AP_PERIOD_NET_CR_ADD_CURR
126: ';
127:
128:

Line 142: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

138: ,TRADING_PARTNER_LEDGER
139: ,TRANSACTION_CURRENCY
140: ,TRANSACTING_PERIOD_NAME
141: ,TRADING_PERIOD_NAME
142: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
143: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_BEGIN_BALANCE_DR
144:
145: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
146: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_BEGIN_BALANCE_CR

Line 145: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

141: ,TRADING_PERIOD_NAME
142: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
143: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_BEGIN_BALANCE_DR
144:
145: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
146: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_BEGIN_BALANCE_CR
147:
148: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
149: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_BEGIN_BALANCE_DR

Line 148: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

144:
145: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
146: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_BEGIN_BALANCE_CR
147:
148: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
149: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_BEGIN_BALANCE_DR
150:
151: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
152: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_BEGIN_BALANCE_CR

Line 151: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

147:
148: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
149: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_BEGIN_BALANCE_DR
150:
151: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
152: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_BEGIN_BALANCE_CR
153:
154: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
155: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_PERIOD_NET_DR

Line 154: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

150:
151: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''BEGIN_BALANCE_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
152: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_BEGIN_BALANCE_CR
153:
154: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
155: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_PERIOD_NET_DR
156:
157: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
158: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_PERIOD_NET_CR

Line 157: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

153:
154: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
155: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_PERIOD_NET_DR
156:
157: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
158: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_PERIOD_NET_CR
159:
160: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
161: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_PERIOD_NET_DR

Line 160: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

156:
157: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''R'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
158: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AR_PERIOD_NET_CR
159:
160: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
161: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_PERIOD_NET_DR
162:
163: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
164: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_PERIOD_NET_CR

Line 163: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME

159:
160: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_DR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
161: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_PERIOD_NET_DR
162:
163: ,LTRIM(TO_CHAR(fun_recon_rpt_pkg.get_balance(''P'', ''PERIOD_NET_CR'', TRANSACTING_LEDGER_ID, TRANSACTING_LE_ID, TRANSACTING_PERIOD_NAME
164: ,TRADING_PARTNER_LEDGER_ID, TRADING_PARTNER_LE_ID, TRADING_PERIOD_NAME, TRANSACTION_CURRENCY),''999999999999999999999.999999999999'')) AP_PERIOD_NET_CR
165:
166: $additional_currency_columns$
167:

Line 331: ,fun_recon_rpt_pkg.get_legal_entity(fia.to_le_Id) TRAD_LE

327: 'SELECT /*+ leading(fia, ael) cardinality(fia,1) opt_param(''_optimizer_cost_based_transformation'',''off'' ) */
328: glv.legal_entity_id TRANS_LE_ID
329: ,glv.LEGAL_ENTITY_NAME TRANS_LE
330: ,fia.to_le_id TRAD_LE_ID
331: ,fun_recon_rpt_pkg.get_legal_entity(fia.to_le_Id) TRAD_LE
332: ,glv.ledger_name TRANSACTING_LEDGER
333: ,glv.ledger_id LEDGER_ID
334: ,''SLA'' SOURCE
335: ,fia.type ACCOUNT_TYPE

Line 546: ,fun_recon_rpt_pkg.get_legal_entity(fia.to_le_Id) SRC_TRAD_LE

542:
543: SELECT glv.legal_entity_id SRC_TRANS_LE_ID
544: ,glv.LEGAL_ENTITY_NAME SRC_TRANS_LE
545: ,fia.to_le_id SRC_TRAD_LE_ID
546: ,fun_recon_rpt_pkg.get_legal_entity(fia.to_le_Id) SRC_TRAD_LE
547: ,fia.ledger_id SRC_TRANS_LEDGER_ID
548: ,glv.ledger_name SRC_TRANS_LEDGER
549: ,gjct.user_je_category_name JOURNAL_CATEGORY
550: ,gjst.user_je_source_name JOURNAL_SOURCE

Line 597: ,fun_recon_rpt_pkg.get_legal_entity(fia.to_le_Id) SRC_TRAD_LE

593:
594: SELECT glv.legal_entity_id SRC_TRANS_LE_ID
595: ,glv.LEGAL_ENTITY_NAME SRC_TRANS_LE
596: ,fia.to_le_id SRC_TRAD_LE_ID
597: ,fun_recon_rpt_pkg.get_legal_entity(fia.to_le_Id) SRC_TRAD_LE
598: ,fia.ledger_id SRC_TRANS_LEDGER_ID
599: ,glv.ledger_name SRC_TRANS_LEDGER
600: ,gjct.user_je_category_name JOURNAL_CATEGORY
601: ,gjst.user_je_source_name JOURNAL_SOURCE

Line 756: ,fun_recon_rpt_pkg.get_legal_entity(fia.to_le_Id) TRAD_LE

752: C_GL_UNMATCHED_QUERY CONSTANT VARCHAR2(30000) :=
753: 'SELECT glv.legal_entity_id TRANS_LE_ID
754: ,glv.LEGAL_ENTITY_NAME TRANS_LE
755: ,fia.to_le_id TRAD_LE_ID
756: ,fun_recon_rpt_pkg.get_legal_entity(fia.to_le_Id) TRAD_LE
757: ,glv.ledger_name TRANSACTING_LEDGER
758: ,glv.ledger_id LEDGER_ID
759: ,''GL'' SOURCE
760: ,fia.type ACCOUNT_TYPE

Line 900: C_DEFAULT_MODULE CONSTANT VARCHAR2(240):= 'fun.plsql.fun_recon_rpt_pkg';

896: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
897: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
898:
899: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
900: C_DEFAULT_MODULE CONSTANT VARCHAR2(240):= 'fun.plsql.fun_recon_rpt_pkg';
901:
902: g_log_level NUMBER;
903: g_log_enabled BOOLEAN;
904:

Line 1214: fun_recon_rpt_pkg.clob_to_file

1210: fnd_file.put_line(fnd_file.output, '');
1211: END IF;
1212: END IF;
1213:
1214: fun_recon_rpt_pkg.clob_to_file
1215: (p_xml_clob => l_xml_clob);
1216: END LOOP;
1217:
1218: fnd_file.put_line(fnd_file.output, '');

Line 1557: l_add_where_clause1 := ' AND FUN_RECON_RPT_PKG.match_ap_ar_invoice(fia.from_le_id, fia.ledger_id, glp.period_name, fia.to_le_id, '

1553:
1554:
1555: IF P_TP_GL_PERIOD IS NULL
1556: THEN
1557: l_add_where_clause1 := ' AND FUN_RECON_RPT_PKG.match_ap_ar_invoice(fia.from_le_id, fia.ledger_id, glp.period_name, fia.to_le_id, '
1558: || nvl(to_char(p_tp_ledger_id), 'null') || ', null , ' ||
1559: ' fia.type, ent.entity_code, ent.source_id_int_1) = ''UNMATCHED'' ';
1560: ELSE
1561: l_add_where_clause1 := ' AND FUN_RECON_RPT_PKG.match_ap_ar_invoice(fia.from_le_id, fia.ledger_id, glp.period_name, fia.to_le_id, ' ||

Line 1561: l_add_where_clause1 := ' AND FUN_RECON_RPT_PKG.match_ap_ar_invoice(fia.from_le_id, fia.ledger_id, glp.period_name, fia.to_le_id, ' ||

1557: l_add_where_clause1 := ' AND FUN_RECON_RPT_PKG.match_ap_ar_invoice(fia.from_le_id, fia.ledger_id, glp.period_name, fia.to_le_id, '
1558: || nvl(to_char(p_tp_ledger_id), 'null') || ', null , ' ||
1559: ' fia.type, ent.entity_code, ent.source_id_int_1) = ''UNMATCHED'' ';
1560: ELSE
1561: l_add_where_clause1 := ' AND FUN_RECON_RPT_PKG.match_ap_ar_invoice(fia.from_le_id, fia.ledger_id, glp.period_name, fia.to_le_id, ' ||
1562: nvl(to_char(p_tp_ledger_id), 'null') || ', '''||P_TP_GL_PERIOD ||''' , ' ||
1563: ' fia.type, ent.entity_code, ent.source_id_int_1) = ''UNMATCHED'' ';
1564: END IF;
1565:

Line 1766: l_add_where_clause1 := ' AND FUN_RECON_RPT_PKG.match_ap_ar_invoice(fia.from_le_id, fia.ledger_id, glp.period_name, fia.to_le_id, ' ||

1762: '$sub_query$',
1763: l_gl_balances_query_rev);
1764:
1765:
1766: l_add_where_clause1 := ' AND FUN_RECON_RPT_PKG.match_ap_ar_invoice(fia.from_le_id, fia.ledger_id, glp.period_name, fia.to_le_id, ' ||
1767: nvl(to_char(p_trans_ledger_id), 'null') || ', ''' || p_trans_gl_period||''' , ' ||
1768: ' fia.type, ent.entity_code, ent.source_id_int_1) = ''UNMATCHED'' ';
1769:
1770: l_sum_unmatched_query_rev := REPLACE(l_sum_unmatched_query_rev, '$where_clause1$', l_add_where_clause1);

Line 2435: END FUN_RECON_RPT_PKG;

2431: IF NOT g_log_enabled THEN
2432: g_log_level := C_LEVEL_LOG_DISABLED;
2433: END IF;
2434:
2435: END FUN_RECON_RPT_PKG;