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 287: /* GL_SETS_OF_BOOKS */

283: /* GL_BUDGET_PERIOD_RANGES */
284: /* GL_JE_BATCHES */
285: /* GL_JE_HEADERS */
286: /* GL_JE_LINES */
287: /* GL_SETS_OF_BOOKS */
288: /* GL_CODE_COMBINATIONS */
289: /* GL_ACCOUNT_HIERARCHIES */
290: /* */
291: /* AOL Tables which are being used include : */

Line 7721: l_sob_name gl_sets_of_books.name%TYPE;

7717: l_bc_pkts_cnt number;
7718: l_tmp_bc_pkts bc_pkts_rec;
7719: l_failed_bc_pkts bc_pkts_rec;
7720: l_failed_bc_pkts_cnt number;
7721: l_sob_name gl_sets_of_books.name%TYPE;
7722: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
7723: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;
7724: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7725: l_currency_code gl_sets_of_books.currency_code%TYPE;

Line 7722: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;

7718: l_tmp_bc_pkts bc_pkts_rec;
7719: l_failed_bc_pkts bc_pkts_rec;
7720: l_failed_bc_pkts_cnt number;
7721: l_sob_name gl_sets_of_books.name%TYPE;
7722: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
7723: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;
7724: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7725: l_currency_code gl_sets_of_books.currency_code%TYPE;
7726: l_autopost_set_name gl_automatic_posting_sets.autopost_set_name%TYPE;

Line 7723: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;

7719: l_failed_bc_pkts bc_pkts_rec;
7720: l_failed_bc_pkts_cnt number;
7721: l_sob_name gl_sets_of_books.name%TYPE;
7722: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
7723: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;
7724: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7725: l_currency_code gl_sets_of_books.currency_code%TYPE;
7726: l_autopost_set_name gl_automatic_posting_sets.autopost_set_name%TYPE;
7727: l_appl_id fnd_application.application_id%TYPE;

Line 7724: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;

7720: l_failed_bc_pkts_cnt number;
7721: l_sob_name gl_sets_of_books.name%TYPE;
7722: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
7723: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;
7724: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7725: l_currency_code gl_sets_of_books.currency_code%TYPE;
7726: l_autopost_set_name gl_automatic_posting_sets.autopost_set_name%TYPE;
7727: l_appl_id fnd_application.application_id%TYPE;
7728: l_resp_id fnd_responsibility.responsibility_id%TYPE;

Line 7725: l_currency_code gl_sets_of_books.currency_code%TYPE;

7721: l_sob_name gl_sets_of_books.name%TYPE;
7722: l_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
7723: l_automatic_tax_flag gl_sets_of_books.enable_automatic_tax_flag%TYPE;
7724: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7725: l_currency_code gl_sets_of_books.currency_code%TYPE;
7726: l_autopost_set_name gl_automatic_posting_sets.autopost_set_name%TYPE;
7727: l_appl_id fnd_application.application_id%TYPE;
7728: l_resp_id fnd_responsibility.responsibility_id%TYPE;
7729: l_user_id fnd_user.user_id%TYPE;

Line 7869: gl_sets_of_books

7865: l_automatic_tax_flag,
7866: l_coa_id,
7867: l_currency_code
7868: FROM
7869: gl_sets_of_books
7870: WHERE
7871: set_of_books_id = p_ledger_id;
7872: EXCEPTION
7873: WHEN OTHERS THEN

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

7871: set_of_books_id = p_ledger_id;
7872: EXCEPTION
7873: WHEN OTHERS THEN
7874: -- =========================== FND LOG ===========================
7875: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch data from gl_sets_of_books');
7876: psa_utils.debug_other_string(g_excep_level,l_full_path,
7877: 'Funds C/R: Failed to fetch data from gl_sets_of_books');
7878: -- ========================= FND LOG =============================
7879: END;

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

7873: WHEN OTHERS THEN
7874: -- =========================== FND LOG ===========================
7875: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch data from gl_sets_of_books');
7876: psa_utils.debug_other_string(g_excep_level,l_full_path,
7877: 'Funds C/R: Failed to fetch data from gl_sets_of_books');
7878: -- ========================= FND LOG =============================
7879: END;
7880:
7881: -- =========================== FND LOG ===========================