DBA Data[Home] [Help]

APPS.GL_LEDGERS_PKG dependencies on GL_SYSTEM_USAGES

Line 628: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);

624: gl_ledgers_pkg.enable_manual_je_approval;
625: END IF;
626:
627: IF (x_enable_avgbal_flag = 'Y') THEN
628: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);
629: gl_ledgers_pkg.insert_gl_net_income_accounts(x_ledger_id,
630: v_balancing_segment,
631:
632: --x_balancing_segment,

Line 1587: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);

1583: ELSE
1584: v_balancing_segment := x_balancing_segment;
1585: END IF;
1586:
1587: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);
1588: gl_ledgers_pkg.insert_gl_net_income_accounts(x_ledger_id,
1589: v_balancing_segment,
1590: --x_balancing_segment,
1591: x_net_income_ccid,

Line 2138: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);

2134: gl_ledgers_pkg.enable_manual_je_approval;
2135: END IF;
2136:
2137: IF (x_enable_avgbal_flag = 'Y') THEN
2138: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);
2139: gl_ledgers_pkg.insert_gl_net_income_accounts(x_ledger_id,
2140: x_balancing_segment,
2141: x_net_income_ccid,
2142: x_creation_date,

Line 2603: PROCEDURE update_gl_system_usages(

2599: x_name := recinfo.NAME;
2600: END select_columns;
2601:
2602: -- **********************************************************************
2603: PROCEDURE update_gl_system_usages(
2604: cons_lgr_flag VARCHAR2) IS
2605: BEGIN
2606: UPDATE gl_system_usages
2607: SET average_balances_flag = 'Y',

Line 2606: UPDATE gl_system_usages

2602: -- **********************************************************************
2603: PROCEDURE update_gl_system_usages(
2604: cons_lgr_flag VARCHAR2) IS
2605: BEGIN
2606: UPDATE gl_system_usages
2607: SET average_balances_flag = 'Y',
2608: consolidation_ledger_flag =
2609: DECODE(cons_lgr_flag,
2610: 'Y', 'Y',

Line 2614: FROM gl_system_usages

2610: 'Y', 'Y',
2611: consolidation_ledger_flag)
2612: WHERE EXISTS(
2613: SELECT '1'
2614: FROM gl_system_usages
2615: WHERE average_balances_flag = 'N'
2616: OR ( (cons_lgr_flag = 'Y')
2617: AND consolidation_ledger_flag = 'N'));
2618: END update_gl_system_usages;

Line 2618: END update_gl_system_usages;

2614: FROM gl_system_usages
2615: WHERE average_balances_flag = 'N'
2616: OR ( (cons_lgr_flag = 'Y')
2617: AND consolidation_ledger_flag = 'N'));
2618: END update_gl_system_usages;
2619:
2620: -- **********************************************************************
2621: PROCEDURE insert_gl_net_income_accounts(
2622: x_ledger_id NUMBER,