APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_AUTOMATIC_POSTING_SETS

Line 7803: gl_automatic_posting_sets S

7799: FROM
7800: gl_je_headers H,
7801: gl_je_batches B,
7802: gl_automatic_posting_options O,
7803: gl_automatic_posting_sets S
7804: WHERE
7805: S.autopost_set_id = p_autopost_set_id
7806: AND S.autopost_set_id = O.autopost_set_id
7807: AND o.ledger_id = H.ledger_id

Line 7852: gl_automatic_posting_sets s

7848: FROM
7849: gl_je_headers h,
7850: gl_je_batches b,
7851: gl_automatic_posting_options o,
7852: gl_automatic_posting_sets s
7853: WHERE
7854: s.autopost_set_id = p_autopost_set_id
7855: AND s.autopost_set_id = o.autopost_set_id
7856: AND o.ledger_id = H.ledger_id

Line 7912: l_autopost_set_name gl_automatic_posting_sets.autopost_set_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;
7916: l_actual_flag gl_je_batches.actual_flag%TYPE;

Line 8103: gl_automatic_posting_sets

8099: autopost_set_name
8100: INTO
8101: l_autopost_set_name
8102: FROM
8103: gl_automatic_posting_sets
8104: WHERE
8105: autopost_set_id = p_autopost_set_id;
8106: EXCEPTION
8107: WHEN OTHERS THEN

Line 8110: 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');

8106: EXCEPTION
8107: WHEN OTHERS THEN
8108: -- =========================== FND LOG ===========================
8109: psa_utils.debug_other_string(g_excep_level,l_full_path,
8110: 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
8111: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
8112: -- ========================= FND LOG =============================
8113: END;
8114:

Line 8111: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');

8107: WHEN OTHERS THEN
8108: -- =========================== FND LOG ===========================
8109: psa_utils.debug_other_string(g_excep_level,l_full_path,
8110: 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
8111: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
8112: -- ========================= FND LOG =============================
8113: END;
8114:
8115: l_appl_id := 101;