APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_AUTOMATIC_POSTING_SETS

Line 7617: gl_automatic_posting_sets S

7613: FROM
7614: gl_je_headers H,
7615: gl_je_batches B,
7616: gl_automatic_posting_options O,
7617: gl_automatic_posting_sets S
7618: WHERE
7619: S.autopost_set_id = p_autopost_set_id
7620: AND S.autopost_set_id = O.autopost_set_id
7621: AND o.ledger_id = H.ledger_id

Line 7666: gl_automatic_posting_sets s

7662: FROM
7663: gl_je_headers h,
7664: gl_je_batches b,
7665: gl_automatic_posting_options o,
7666: gl_automatic_posting_sets s
7667: WHERE
7668: s.autopost_set_id = p_autopost_set_id
7669: AND s.autopost_set_id = o.autopost_set_id
7670: AND o.ledger_id = H.ledger_id

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

Line 7917: gl_automatic_posting_sets

7913: autopost_set_name
7914: INTO
7915: l_autopost_set_name
7916: FROM
7917: gl_automatic_posting_sets
7918: WHERE
7919: autopost_set_id = p_autopost_set_id;
7920: EXCEPTION
7921: WHEN OTHERS THEN

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

7920: EXCEPTION
7921: WHEN OTHERS THEN
7922: -- =========================== FND LOG ===========================
7923: psa_utils.debug_other_string(g_excep_level,l_full_path,
7924: 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
7925: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
7926: -- ========================= FND LOG =============================
7927: END;
7928:

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

7921: WHEN OTHERS THEN
7922: -- =========================== FND LOG ===========================
7923: psa_utils.debug_other_string(g_excep_level,l_full_path,
7924: 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
7925: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
7926: -- ========================= FND LOG =============================
7927: END;
7928:
7929: l_appl_id := 101;