DBA Data[Home] [Help]

APPS.GL_LEDGERS_PKG dependencies on GL_SYSTEM_USAGES

Line 631: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);

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

Line 1594: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);

1590: ELSE
1591: v_balancing_segment := x_balancing_segment;
1592: END IF;
1593:
1594: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);
1595: gl_ledgers_pkg.insert_gl_net_income_accounts(x_ledger_id,
1596: v_balancing_segment,
1597: --x_balancing_segment,
1598: x_net_income_ccid,

Line 2147: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);

2143: gl_ledgers_pkg.enable_manual_je_approval;
2144: END IF;
2145:
2146: IF (x_enable_avgbal_flag = 'Y') THEN
2147: gl_ledgers_pkg.update_gl_system_usages(x_consolidation_ledger_flag);
2148: gl_ledgers_pkg.insert_gl_net_income_accounts(x_ledger_id,
2149: x_balancing_segment,
2150: x_net_income_ccid,
2151: x_creation_date,

Line 2612: PROCEDURE update_gl_system_usages(

2608: x_name := recinfo.NAME;
2609: END select_columns;
2610:
2611: -- **********************************************************************
2612: PROCEDURE update_gl_system_usages(
2613: cons_lgr_flag VARCHAR2) IS
2614: BEGIN
2615: UPDATE gl_system_usages
2616: SET average_balances_flag = 'Y',

Line 2615: UPDATE gl_system_usages

2611: -- **********************************************************************
2612: PROCEDURE update_gl_system_usages(
2613: cons_lgr_flag VARCHAR2) IS
2614: BEGIN
2615: UPDATE gl_system_usages
2616: SET average_balances_flag = 'Y',
2617: consolidation_ledger_flag =
2618: DECODE(cons_lgr_flag,
2619: 'Y', 'Y',

Line 2623: FROM gl_system_usages

2619: 'Y', 'Y',
2620: consolidation_ledger_flag)
2621: WHERE EXISTS(
2622: SELECT '1'
2623: FROM gl_system_usages
2624: WHERE average_balances_flag = 'N'
2625: OR ( (cons_lgr_flag = 'Y')
2626: AND consolidation_ledger_flag = 'N'));
2627: END update_gl_system_usages;

Line 2627: END update_gl_system_usages;

2623: FROM gl_system_usages
2624: WHERE average_balances_flag = 'N'
2625: OR ( (cons_lgr_flag = 'Y')
2626: AND consolidation_ledger_flag = 'N'));
2627: END update_gl_system_usages;
2628:
2629: -- **********************************************************************
2630: PROCEDURE insert_gl_net_income_accounts(
2631: x_ledger_id NUMBER,