APPS.FV_GTAS_TBAL_TRX_PKG dependencies on GL_LEDGERS

Line 5: gbl_set_of_books_id gl_ledgers_public_v.ledger_id%TYPE;

1: PACKAGE BODY FV_GTAS_TBAL_TRX_PKG AS
2: /* $Header: FVGTATBB.pls 120.1.12020000.10 2013/02/21 21:18:49 snama noship $ */
3:
4: g_module VARCHAR2(200);
5: gbl_set_of_books_id gl_ledgers_public_v.ledger_id%TYPE;
6: gbl_period_name gl_period_statuses.period_name%TYPE;
7: gbl_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
8: gbl_error_code NUMBER;
9: gbl_error_buf VARCHAR2(300);

Line 60: FROM gl_ledgers_public_v

56:
57:
58: SELECT chart_of_accounts_id
59: INTO gbl_coa_id
60: FROM gl_ledgers_public_v
61: WHERE ledger_id = gbl_set_of_books_id;
62:
63: FV_UTILITY.LOG_MESG('COA ID: '||gbl_coa_id);
64:

Line 168: P_LEDGER_ID Gl_ledgers_public_v.ledger_id%TYPE,

164: -------------------------------------------------------------------------------
165: PROCEDURE TRIAL_BALANCE_MAIN (
166: --p_errbuf OUT NOCOPY Varchar2,
167: --p_retcode OUT NOCOPY Number,
168: P_LEDGER_ID Gl_ledgers_public_v.ledger_id%TYPE,
169: P_CHART_OF_ACCOUNTS_ID Gl_Code_Combinations.chart_of_accounts_id%TYPE,
170: P_FLEX_LOW IN VARCHAR2,
171: P_FLEX_HIGH IN VARCHAR2,
172: P_PERIOD Varchar2,

Line 460: FROM gl_ledgers

456: log(l_module, 'Begin');
457:
458: SELECT CHART_OF_ACCOUNTS_ID
459: INTO l_coa_id
460: FROM gl_ledgers
461: where ledger_id = p_sob_id;
462: --Get the flex delimiter
463: log(l_module, 'l_coa_id: '||l_coa_id);
464: l_delimiter := fnd_flex_ext.get_delimiter