APPS.FV_FACTS1_PKG dependencies on GL_LEDGERS_PUBLIC_V

Line 5: gbl_set_of_books_id gl_ledgers_public_v.ledger_id%TYPE;

1: PACKAGE BODY FV_FACTS1_PKG AS
2: /* $Header: FVFCFIPB.pls 120.2.12000000.5 2007/07/31 14:21:45 sasukuma ship $ */
3: --------------------------------------------------------------------------------
4: g_module_name 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 432: FROM gl_ledgers_public_v

428:
429:
430: SELECT chart_of_accounts_id
431: INTO gbl_coa_id
432: FROM gl_ledgers_public_v
433: WHERE ledger_id = gbl_set_of_books_id;
434:
435: FV_UTILITY.LOG_MESG('COA ID: '||gbl_coa_id);
436:

Line 653: FROM gl_ledgers_public_v

649:
650: l_temp_mesg := ' getting currency code. ';
651: SELECT currency_code
652: INTO gbl_currency_code
653: FROM gl_ledgers_public_v
654: WHERE ledger_id = gbl_set_of_books_id;
655:
656: IF gbl_currency_code IS NULL THEN
657: RAISE NO_DATA_FOUND;

Line 1800: p_sob Gl_ledgers_public_v.ledger_id%TYPE,

1796:
1797: --------------------------------------------------------------------------------------------------------
1798: PROCEDURE TRIAL_BALANCE_MAIN (p_errbuf OUT NOCOPY Varchar2,
1799: p_retcode OUT NOCOPY Number,
1800: p_sob Gl_ledgers_public_v.ledger_id%TYPE,
1801: p_coa Gl_Code_Combinations.chart_of_accounts_id%TYPE,
1802: p_fund_range_low Fv_Fund_Parameters.fund_value%TYPE,
1803: p_fund_range_high Fv_Fund_Parameters.fund_value%TYPE,
1804: p_currency_code Varchar2,

Line 2317: FROM gl_ledgers_public_v

2313:
2314:
2315: SELECT currency_code
2316: INTO gbl_currency_code
2317: FROM gl_ledgers_public_v
2318: WHERE ledger_id = gbl_set_of_books_id;
2319: FV_UTILITY.LOG_MESG('Currency Code: '||gbl_currency_code);
2320:
2321: l_acct_type_condition := ' AND glc.account_type NOT IN ('||''''||'D'||''''||', '||''''||'C'||''''||')';

Line 3061: FROM gl_ledgers_public_v

3057:
3058:
3059: SELECT currency_code
3060: INTO gbl_currency_code
3061: FROM gl_ledgers_public_v
3062: WHERE ledger_id = gbl_set_of_books_id;
3063:
3064: if l_posted_date is not null then
3065: