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.PSA_FUNDS_CHECKER_PKG dependencies on GL_SETS_OF_BOOKS

Line 298: /* GL_SETS_OF_BOOKS */

294: /* GL_BUDGET_PERIOD_RANGES */
295: /* GL_JE_BATCHES */
296: /* GL_JE_HEADERS */
297: /* GL_JE_LINES */
298: /* GL_SETS_OF_BOOKS */
299: /* GL_CODE_COMBINATIONS */
300: /* GL_ACCOUNT_HIERARCHIES */
301: /* */
302: /* AOL Tables which are being used include : */

Line 7907: l_sob_name gl_sets_of_books.name%TYPE;

7903: l_bc_pkts_cnt number;
7904: l_tmp_bc_pkts bc_pkts_rec;
7905: l_failed_bc_pkts bc_pkts_rec;
7906: l_failed_bc_pkts_cnt number;
7907: l_sob_name gl_sets_of_books.name%TYPE;
7908: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
7909: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;
7910: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7911: l_currency_code gl_sets_of_books.currency_code%TYPE;

Line 7908: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;

7904: l_tmp_bc_pkts bc_pkts_rec;
7905: l_failed_bc_pkts bc_pkts_rec;
7906: l_failed_bc_pkts_cnt number;
7907: l_sob_name gl_sets_of_books.name%TYPE;
7908: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
7909: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;
7910: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7911: l_currency_code gl_sets_of_books.currency_code%TYPE;
7912: l_autopost_set_name gl_automatic_posting_sets.autopost_set_name%TYPE;

Line 7909: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;

7905: l_failed_bc_pkts bc_pkts_rec;
7906: l_failed_bc_pkts_cnt number;
7907: l_sob_name gl_sets_of_books.name%TYPE;
7908: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
7909: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;
7910: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7911: l_currency_code gl_sets_of_books.currency_code%TYPE;
7912: l_autopost_set_name gl_automatic_posting_sets.autopost_set_name%TYPE;
7913: l_appl_id fnd_application.application_id%TYPE;

Line 7910: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;

7906: l_failed_bc_pkts_cnt number;
7907: l_sob_name gl_sets_of_books.name%TYPE;
7908: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
7909: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;
7910: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7911: l_currency_code gl_sets_of_books.currency_code%TYPE;
7912: l_autopost_set_name gl_automatic_posting_sets.autopost_set_name%TYPE;
7913: l_appl_id fnd_application.application_id%TYPE;
7914: l_resp_id fnd_responsibility.responsibility_id%TYPE;

Line 7911: l_currency_code gl_sets_of_books.currency_code%TYPE;

7907: l_sob_name gl_sets_of_books.name%TYPE;
7908: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
7909: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;
7910: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7911: l_currency_code gl_sets_of_books.currency_code%TYPE;
7912: l_autopost_set_name gl_automatic_posting_sets.autopost_set_name%TYPE;
7913: l_appl_id fnd_application.application_id%TYPE;
7914: l_resp_id fnd_responsibility.responsibility_id%TYPE;
7915: l_user_id fnd_user.user_id%TYPE;

Line 8055: gl_sets_of_books

8051: l_automatic_tax_flag,
8052: l_coa_id,
8053: l_currency_code
8054: FROM
8055: gl_sets_of_books
8056: WHERE
8057: set_of_books_id = p_ledger_id;
8058: EXCEPTION
8059: WHEN OTHERS THEN

Line 8061: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch data from gl_sets_of_books');

8057: set_of_books_id = p_ledger_id;
8058: EXCEPTION
8059: WHEN OTHERS THEN
8060: -- =========================== FND LOG ===========================
8061: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch data from gl_sets_of_books');
8062: psa_utils.debug_other_string(g_excep_level,l_full_path,
8063: 'Funds C/R: Failed to fetch data from gl_sets_of_books');
8064: -- ========================= FND LOG =============================
8065: END;

Line 8063: 'Funds C/R: Failed to fetch data from gl_sets_of_books');

8059: WHEN OTHERS THEN
8060: -- =========================== FND LOG ===========================
8061: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch data from gl_sets_of_books');
8062: psa_utils.debug_other_string(g_excep_level,l_full_path,
8063: 'Funds C/R: Failed to fetch data from gl_sets_of_books');
8064: -- ========================= FND LOG =============================
8065: END;
8066:
8067: -- =========================== FND LOG ===========================