APPS.PQH_COMMITMENT_POSTING dependencies on GL_SETS_OF_BOOKS

Line 14: g_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;

10: g_application_id NUMBER(15) := 101;
11: --
12: g_budget_id pqh_budgets.budget_id%TYPE;
13: g_set_of_books_id gl_interface.set_of_books_id%TYPE;
14: g_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
15: g_budget_name pqh_budgets.budget_name%TYPE;
16: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;
17: g_transfer_to_grants_flag pqh_budgets.transfer_to_grants_flag%TYPE;
18: g_bgt_currency_code pqh_budgets.currency_code%TYPE;

Line 313: l_gl_sets_of_books_rec gl_sets_of_books%ROWTYPE;

309: --
310: l_budgets_rec pqh_budgets%ROWTYPE;
311: l_budget_versions_rec pqh_budget_versions%ROWTYPE;
312: --
313: l_gl_sets_of_books_rec gl_sets_of_books%ROWTYPE;
314: l_shared_types_rec per_shared_types%ROWTYPE;
315: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;
316: l_gl_je_sources_rec gl_je_sources%ROWTYPE;
317: l_gl_je_categories_rec gl_je_categories%ROWTYPE;

Line 353: FROM gl_sets_of_books

349: WHERE budget_version_id = p_budget_version_id ) ;
350: --
351: CURSOR csr_chart_of_acc_id(p_set_of_books_id IN NUMBER) IS
352: SELECT *
353: FROM gl_sets_of_books
354: WHERE set_of_books_id = p_set_of_books_id;
355:
356: CURSOR csr_shared_types (p_shared_type_id IN number) IS
357: SELECT *

Line 788: FETCH csr_chart_of_acc_id INTO l_gl_sets_of_books_rec;

784: --
785: -- get the set of books , budgetary control flag and currency for money
786: --
787: OPEN csr_chart_of_acc_id(p_set_of_books_id => l_budgets_rec.gl_set_of_books_id );
788: FETCH csr_chart_of_acc_id INTO l_gl_sets_of_books_rec;
789: CLOSE csr_chart_of_acc_id;
790: --
791: g_chart_of_accounts_id := l_gl_sets_of_books_rec.chart_of_accounts_id;
792: g_budgetary_control_flag := l_gl_sets_of_books_rec.enable_budgetary_control_flag;

Line 791: g_chart_of_accounts_id := l_gl_sets_of_books_rec.chart_of_accounts_id;

787: OPEN csr_chart_of_acc_id(p_set_of_books_id => l_budgets_rec.gl_set_of_books_id );
788: FETCH csr_chart_of_acc_id INTO l_gl_sets_of_books_rec;
789: CLOSE csr_chart_of_acc_id;
790: --
791: g_chart_of_accounts_id := l_gl_sets_of_books_rec.chart_of_accounts_id;
792: g_budgetary_control_flag := l_gl_sets_of_books_rec.enable_budgetary_control_flag;
793: --
794: if g_default_currency_code <> l_gl_sets_of_books_rec.currency_code then
795: --

Line 792: g_budgetary_control_flag := l_gl_sets_of_books_rec.enable_budgetary_control_flag;

788: FETCH csr_chart_of_acc_id INTO l_gl_sets_of_books_rec;
789: CLOSE csr_chart_of_acc_id;
790: --
791: g_chart_of_accounts_id := l_gl_sets_of_books_rec.chart_of_accounts_id;
792: g_budgetary_control_flag := l_gl_sets_of_books_rec.enable_budgetary_control_flag;
793: --
794: if g_default_currency_code <> l_gl_sets_of_books_rec.currency_code then
795: --
796: -- currency used in Budget or Business group is different that in Set of books.

Line 794: if g_default_currency_code <> l_gl_sets_of_books_rec.currency_code then

790: --
791: g_chart_of_accounts_id := l_gl_sets_of_books_rec.chart_of_accounts_id;
792: g_budgetary_control_flag := l_gl_sets_of_books_rec.enable_budgetary_control_flag;
793: --
794: if g_default_currency_code <> l_gl_sets_of_books_rec.currency_code then
795: --
796: -- currency used in Budget or Business group is different that in Set of books.
797: -- it is an error condition.
798: null;