APPS.FV_FACTS1_PKG dependencies on GL_LEDGERS

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.14 2011/05/13 06:26:52 yanasing 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 1537: l_ledger_name gl_ledgers_public_v.name%TYPE;

1533: l_module_name VARCHAR2(200);
1534: l_debit_amount number;
1535: l_credit_amount number;
1536: l_edit_check_passed varchar2(1);
1537: l_ledger_name gl_ledgers_public_v.name%TYPE;
1538:
1539: CURSOR edit_check_c IS
1540: SELECT fund_group, dept_id, bureau_id,
1541: SUM(DECODE(d_c_indicator, 'D', 0, NVL(amount, 0))) credit_amount,

Line 1558: from gl_ledgers_public_v where ledger_id=p_set_of_books_id;

1554: FV_UTILITY.LOG_MESG('In '||l_module_name);
1555:
1556: BEGIN
1557: select name into l_ledger_name
1558: from gl_ledgers_public_v where ledger_id=p_set_of_books_id;
1559: EXCEPTION
1560: WHEN OTHERS THEN
1561: l_ledger_name:= FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');
1562:

Line 1841: p_sob Gl_ledgers_public_v.ledger_id%TYPE,

1837:
1838: --------------------------------------------------------------------------------------------------------
1839: PROCEDURE TRIAL_BALANCE_MAIN (p_errbuf OUT NOCOPY Varchar2,
1840: p_retcode OUT NOCOPY Number,
1841: p_sob Gl_ledgers_public_v.ledger_id%TYPE,
1842: p_coa Gl_Code_Combinations.chart_of_accounts_id%TYPE,
1843: p_fund_range_low Fv_Fund_Parameters.fund_value%TYPE,
1844: p_fund_range_high Fv_Fund_Parameters.fund_value%TYPE,
1845: p_currency_code Varchar2,

Line 1860: l_sob_name gl_ledgers.name%TYPE;

1856: l_req_id Number;
1857: l_jrnl_exists Varchar2(1);
1858: l_errbuf varchar2(500);
1859: l_retcode varchar2(50);
1860: l_sob_name gl_ledgers.name%TYPE;
1861: BEGIN
1862: p_errbuf := NULL;
1863: p_retcode := 0;
1864: gbl_error_code := 0;

Line 1990: FROM gl_ledgers

1986: --since teh profile was getting a different
1987: --sob name.
1988: SELECT name
1989: INTO l_sob_name
1990: FROM gl_ledgers
1991: WHERE ledger_id = gbl_set_of_books_id
1992: AND currency_code = 'USD';
1993:
1994: l_print_option := FND_REQUEST.SET_PRINT_OPTIONS (printer => l_printer_name,

Line 2371: FROM gl_ledgers_public_v

2367:
2368:
2369: SELECT currency_code
2370: INTO gbl_currency_code
2371: FROM gl_ledgers_public_v
2372: WHERE ledger_id = gbl_set_of_books_id;
2373: FV_UTILITY.LOG_MESG('Currency Code: '||gbl_currency_code);
2374:
2375: l_acct_type_condition := ' AND glc.account_type NOT IN ('||''''||'D'||''''||', '||''''||'C'||''''||')';

Line 3139: FROM gl_ledgers_public_v

3135:
3136:
3137: SELECT currency_code
3138: INTO gbl_currency_code
3139: FROM gl_ledgers_public_v
3140: WHERE ledger_id = gbl_set_of_books_id;
3141:
3142: if l_posted_date is not null then
3143: