eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_LEDGERS_PKG dependencies on GL_LEDGERS_PKG

Line 1: PACKAGE BODY GL_LEDGERS_PKG AS

1: PACKAGE BODY GL_LEDGERS_PKG AS
2: /* $Header: glistldb.pls 120.99.12010000.3 2008/11/27 06:43:34 phmullap ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'GL_LEDGERS_PKG';
4:
5: --

Line 3: g_pkg_name CONSTANT VARCHAR2(30) := 'GL_LEDGERS_PKG';

1: PACKAGE BODY GL_LEDGERS_PKG AS
2: /* $Header: glistldb.pls 120.99.12010000.3 2008/11/27 06:43:34 phmullap ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'GL_LEDGERS_PKG';
4:
5: --
6: -- PUBLIC FUNCTIONS
7: --

Line 357: gl_ledgers_pkg.get_bal_mgt_seg_info(x_bal_seg_column_name,

353: x_creation_date => x_creation_date,
354: x_description => x_description); */
355:
356: -- get the balance segment infor and mgt segment infor
357: gl_ledgers_pkg.get_bal_mgt_seg_info(x_bal_seg_column_name,
358: x_bal_seg_value_set_id,
359: x_mgt_seg_column_name,
360: x_mgt_seg_value_set_id,
361: x_chart_of_accounts_id);

Line 624: gl_ledgers_pkg.enable_manual_je_approval;

620:
621: -- Check whether journal_approval_flag is to be set to Y for
622: -- the Manual source.
623: IF (x_set_manual_flag = 'Y') THEN
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);

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 629: gl_ledgers_pkg.insert_gl_net_income_accounts(x_ledger_id,

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,
633: x_net_income_ccid,

Line 950: IF (GL_LEDGERS_PKG.Check_Avg_Translation(x_ledger_Id)) THEN

946: -- Updating average balances translation options
947: IF ((recinfo.translate_eod_flag <> x_translate_eod_flag) OR
948: (recinfo.translate_qatd_flag <> x_translate_qatd_flag) OR
949: (recinfo.translate_yatd_flag <> x_translate_yatd_flag)) THEN
950: IF (GL_LEDGERS_PKG.Check_Avg_Translation(x_ledger_Id)) THEN
951: fnd_message.set_name('SQLGL', 'GL_LEDGER_TRANSLATION_FLAGS');
952: app_exception.raise_exception;
953: END IF;
954: END IF;

Line 1559: gl_ledgers_pkg.enable_manual_je_approval;

1555:
1556: -- Check whether journal_approval_flag is to be set to Y for
1557: -- the Manual source.
1558: IF (x_set_manual_flag = 'Y') THEN
1559: gl_ledgers_pkg.enable_manual_je_approval;
1560: END IF;
1561:
1562: -- Update gl_system_usage and insert the net income account
1563: IF (recinfo.enable_average_balances_flag = 'N' AND x_enable_avgbal_flag = 'Y') THEN

Line 1565: gl_ledgers_pkg.get_bal_mgt_seg_info(x_bal_seg_column_name,

1561:
1562: -- Update gl_system_usage and insert the net income account
1563: IF (recinfo.enable_average_balances_flag = 'N' AND x_enable_avgbal_flag = 'Y') THEN
1564: -- get the balance segment infor and mgt segment infor
1565: gl_ledgers_pkg.get_bal_mgt_seg_info(x_bal_seg_column_name,
1566: x_bal_seg_value_set_id,
1567: x_mgt_seg_column_name,
1568: x_mgt_seg_value_set_id,
1569: x_chart_of_accounts_id);

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 1588: gl_ledgers_pkg.insert_gl_net_income_accounts(x_ledger_id,

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,
1592: x_last_update_date,

Line 1617: gl_ledgers_pkg.led_update_other_tables(x_ledger_id,

1613: -- IF ( (x_suspense_allowed_flag = 'Y')
1614: -- AND (x_suspense_ccid_temp IS NOT NULL)) THEN
1615: -- Update suspense account for this ledger
1616: -- bug fix 2826511
1617: gl_ledgers_pkg.led_update_other_tables(x_ledger_id,
1618: x_last_update_date,
1619: x_last_updated_by,
1620: x_suspense_ccid_temp);
1621:

Line 1627: gl_ledgers_pkg.led_update_other_tables(v_alc.target_ledger_id,

1623: -- suspense account, default it same as source's
1624: FOR v_alc IN c_alc_ledgers LOOP
1625: -- IF ( NOT gl_suspense_accounts_pkg.is_ledger_suspense_exist(v_alc.ledger_id)
1626: -- AND x_suspense_ccid_temp IS NOT NULL) THEN
1627: gl_ledgers_pkg.led_update_other_tables(v_alc.target_ledger_id,
1628: x_last_update_date,
1629: x_last_updated_by,
1630: x_suspense_ccid_temp);
1631: -- gl_suspense_accounts_pkg.insert_ledger_suspense

Line 1722: 'GL_LEDGERS_PKG.check_unique_name');

1718: RAISE;
1719: WHEN OTHERS THEN
1720: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1721: fnd_message.set_token('PROCEDURE',
1722: 'GL_LEDGERS_PKG.check_unique_name');
1723: RAISE;
1724: END check_unique_name;
1725:
1726: -- **********************************************************************

Line 1757: 'GL_LEDGERS_PKG.check_unique_short_name');

1753: RAISE;
1754: WHEN OTHERS THEN
1755: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1756: fnd_message.set_token('PROCEDURE',
1757: 'GL_LEDGERS_PKG.check_unique_short_name');
1758: RAISE;
1759: END check_unique_short_name;
1760:
1761: -- **********************************************************************

Line 1791: fnd_message.set_token('PROCEDURE', 'GL_LEDGERS_PKG.get_unique_id');

1787: WHEN app_exceptions.application_exception THEN
1788: RAISE;
1789: WHEN OTHERS THEN
1790: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1791: fnd_message.set_token('PROCEDURE', 'GL_LEDGERS_PKG.get_unique_id');
1792: RAISE;
1793: END get_unique_id;
1794:
1795: -- **********************************************************************

Line 1828: fnd_message.set_token('PROCEDURE', 'GL_LEDGERS_PKG.is_coa_frozen');

1824: WHEN app_exceptions.application_exception THEN
1825: RAISE;
1826: WHEN OTHERS THEN
1827: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1828: fnd_message.set_token('PROCEDURE', 'GL_LEDGERS_PKG.is_coa_frozen');
1829: RAISE;
1830: END is_coa_frozen;
1831:
1832: -- **********************************************************************

Line 1904: 'GL_LEDGERS_PKG.get_bal_mgt_seg_info');

1900: RAISE;
1901: WHEN OTHERS THEN
1902: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1903: fnd_message.set_token('PROCEDURE',
1904: 'GL_LEDGERS_PKG.get_bal_mgt_seg_info');
1905: RAISE;
1906: END get_bal_mgt_seg_info;
1907:
1908: -- **********************************************************************

Line 2134: gl_ledgers_pkg.enable_manual_je_approval;

2130:
2131: -- Check whether journal_approval_flag is to be set to Y for
2132: -- the Manual source.
2133: IF (x_set_manual_flag = 'Y') THEN
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);

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 2139: gl_ledgers_pkg.insert_gl_net_income_accounts(x_ledger_id,

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,
2143: x_created_by,

Line 2573: gl_ledgers_pkg.enable_manual_je_approval;

2569:
2570: -- Check whether journal_approval_flag is to be set to Y for
2571: -- the Manual source.
2572: IF (x_set_manual_flag = 'Y') THEN
2573: gl_ledgers_pkg.enable_manual_je_approval;
2574: END IF;
2575:
2576: gl_ledgers_pkg.led_update_other_tables(x_ledger_id, x_last_update_date,
2577: x_last_updated_by,

Line 2576: gl_ledgers_pkg.led_update_other_tables(x_ledger_id, x_last_update_date,

2572: IF (x_set_manual_flag = 'Y') THEN
2573: gl_ledgers_pkg.enable_manual_je_approval;
2574: END IF;
2575:
2576: gl_ledgers_pkg.led_update_other_tables(x_ledger_id, x_last_update_date,
2577: x_last_updated_by,
2578: x_suspense_ccid);
2579: END update_row;
2580:

Line 2772: gl_ledgers_pkg.get_bal_mgt_seg_info(l_bal_seg_column_name,

2768: FROM gl_ledgers
2769: WHERE NAME = x_name;
2770: BEGIN
2771: l_chart_of_accounts_id := x_chart_of_accounts_id;
2772: gl_ledgers_pkg.get_bal_mgt_seg_info(l_bal_seg_column_name,
2773: l_bal_seg_value_set_id,
2774: l_mgt_seg_column_name,
2775: l_mgt_seg_value_set_id,
2776: l_chart_of_accounts_id);

Line 3234: fnd_message.set_token('PROCEDURE', 'GL_LEDGERS_PKG.Get_CCID');

3230:
3231: EXCEPTION
3232: WHEN OTHERS THEN
3233: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
3234: fnd_message.set_token('PROCEDURE', 'GL_LEDGERS_PKG.Get_CCID');
3235: RAISE;
3236: END Get_CCID;
3237:
3238: -- *********************************************************************

Line 3275: gl_ledgers_pkg.get_bal_mgt_seg_info(l_bal_seg_column_name,

3271: l_chart_of_accounts_id NUMBER(15);
3272: l_access_set_id NUMBER(15);
3273: BEGIN
3274: l_chart_of_accounts_id := x_chart_of_accounts_id;
3275: gl_ledgers_pkg.get_bal_mgt_seg_info(l_bal_seg_column_name,
3276: l_bal_seg_value_set_id,
3277: l_mgt_seg_column_name,
3278: l_mgt_seg_value_set_id,
3279: l_chart_of_accounts_id);

Line 4037: END gl_ledgers_pkg;

4033: END IF;
4034:
4035: END get_short_name ;
4036: -- ***********************************************************************
4037: END gl_ledgers_pkg;