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

Line 12: g_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;

8: g_package varchar2(33) := ' pqh_gl_posting'; -- Global package name
9: --
10: g_application_id NUMBER(15) := 101;
11: g_set_of_books_id gl_interface.set_of_books_id%TYPE;
12: g_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
13: g_budget_name pqh_budgets.budget_name%TYPE;
14: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;
15: g_budget_id pqh_budgets.budget_id%TYPE;
16: g_user_je_source_name gl_interface.user_je_source_name%TYPE;

Line 370: l_gl_sets_of_books_rec gl_sets_of_books%ROWTYPE;

366: --
367: l_proc varchar2(72) := g_package||'.populate_globals';
368: l_budgets_rec pqh_budgets%ROWTYPE;
369: l_budget_versions_rec pqh_budget_versions%ROWTYPE;
370: l_gl_sets_of_books_rec gl_sets_of_books%ROWTYPE;
371: l_shared_types_rec per_shared_types%ROWTYPE;
372: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;
373: l_gl_je_sources_rec gl_je_sources%ROWTYPE;
374: l_gl_je_categories_rec gl_je_categories%ROWTYPE;

Line 410: FROM gl_sets_of_books

406: AND bg.ORG_INFORMATION_CONTEXT = 'Business Group Information';
407:
408: CURSOR csr_chart_of_acc_id(p_set_of_books_id IN NUMBER) IS
409: SELECT *
410: FROM gl_sets_of_books
411: WHERE set_of_books_id = p_set_of_books_id;
412:
413: CURSOR csr_shared_types (p_shared_type_id IN number) IS
414: SELECT *

Line 679: FETCH csr_chart_of_acc_id INTO l_gl_sets_of_books_rec;

675:
676:
677: -- get the set of books , budgetary control flag and currency for money
678: OPEN csr_chart_of_acc_id(p_set_of_books_id => g_set_of_books_id );
679: FETCH csr_chart_of_acc_id INTO l_gl_sets_of_books_rec;
680: CLOSE csr_chart_of_acc_id;
681:
682: g_chart_of_accounts_id := l_gl_sets_of_books_rec.chart_of_accounts_id;
683: g_budgetary_control_flag := l_gl_sets_of_books_rec.enable_budgetary_control_flag;

Line 682: g_chart_of_accounts_id := l_gl_sets_of_books_rec.chart_of_accounts_id;

678: OPEN csr_chart_of_acc_id(p_set_of_books_id => g_set_of_books_id );
679: FETCH csr_chart_of_acc_id INTO l_gl_sets_of_books_rec;
680: CLOSE csr_chart_of_acc_id;
681:
682: g_chart_of_accounts_id := l_gl_sets_of_books_rec.chart_of_accounts_id;
683: g_budgetary_control_flag := l_gl_sets_of_books_rec.enable_budgetary_control_flag;
684: g_currency_code := l_gl_sets_of_books_rec.currency_code;
685:
686: /*

Line 683: g_budgetary_control_flag := l_gl_sets_of_books_rec.enable_budgetary_control_flag;

679: FETCH csr_chart_of_acc_id INTO l_gl_sets_of_books_rec;
680: CLOSE csr_chart_of_acc_id;
681:
682: g_chart_of_accounts_id := l_gl_sets_of_books_rec.chart_of_accounts_id;
683: g_budgetary_control_flag := l_gl_sets_of_books_rec.enable_budgetary_control_flag;
684: g_currency_code := l_gl_sets_of_books_rec.currency_code;
685:
686: /*
687: call the get_default_currency to get business group currency code

Line 684: g_currency_code := l_gl_sets_of_books_rec.currency_code;

680: CLOSE csr_chart_of_acc_id;
681:
682: g_chart_of_accounts_id := l_gl_sets_of_books_rec.chart_of_accounts_id;
683: g_budgetary_control_flag := l_gl_sets_of_books_rec.enable_budgetary_control_flag;
684: g_currency_code := l_gl_sets_of_books_rec.currency_code;
685:
686: /*
687: call the get_default_currency to get business group currency code
688: this procedure will check if there is a default currency associated with the business_group

Line 689: if yes it will override the gl_sets_of_books currency code

685:
686: /*
687: call the get_default_currency to get business group currency code
688: this procedure will check if there is a default currency associated with the business_group
689: if yes it will override the gl_sets_of_books currency code
690: */
691: get_default_currency;
692:
693: -- get the je_source

Line 2963: l_sets_of_books_rec gl_sets_of_books%ROWTYPE;

2959: -- local variables
2960: --
2961: l_proc varchar2(72) := g_package||'populate_budget_gl_map';
2962: l_budgets_rec pqh_budgets%ROWTYPE;
2963: l_sets_of_books_rec gl_sets_of_books%ROWTYPE;
2964: l_fnd_id_flex_segments fnd_id_flex_segments%ROWTYPE;
2965: l_budget_gl_flex_map_id number(15);
2966: l_object_version_number number(9);
2967:

Line 2973: CURSOR csr_gl_sets_of_books_rec(p_set_of_books_id IN number)IS

2969: SELECT *
2970: FROM pqh_budgets
2971: WHERE budget_id = p_budget_id;
2972:
2973: CURSOR csr_gl_sets_of_books_rec(p_set_of_books_id IN number)IS
2974: SELECT *
2975: FROM gl_sets_of_books
2976: WHERE set_of_books_id = p_set_of_books_id;
2977:

Line 2975: FROM gl_sets_of_books

2971: WHERE budget_id = p_budget_id;
2972:
2973: CURSOR csr_gl_sets_of_books_rec(p_set_of_books_id IN number)IS
2974: SELECT *
2975: FROM gl_sets_of_books
2976: WHERE set_of_books_id = p_set_of_books_id;
2977:
2978: CURSOR csr_flex_segments (p_id_flex_num IN number)IS
2979: SELECT *

Line 3000: OPEN csr_gl_sets_of_books_rec(p_set_of_books_id => l_budgets_rec.gl_set_of_books_id);

2996:
2997: hr_utility.set_location('Set Of Books ID : '||l_budgets_rec.gl_set_of_books_id,10);
2998:
2999: -- get the structure number of the GL ACCOUNT
3000: OPEN csr_gl_sets_of_books_rec(p_set_of_books_id => l_budgets_rec.gl_set_of_books_id);
3001: FETCH csr_gl_sets_of_books_rec INTO l_sets_of_books_rec;
3002: CLOSE csr_gl_sets_of_books_rec;
3003:
3004: hr_utility.set_location('Chart of Account ID : '||l_sets_of_books_rec.chart_of_accounts_id,100);

Line 3001: FETCH csr_gl_sets_of_books_rec INTO l_sets_of_books_rec;

2997: hr_utility.set_location('Set Of Books ID : '||l_budgets_rec.gl_set_of_books_id,10);
2998:
2999: -- get the structure number of the GL ACCOUNT
3000: OPEN csr_gl_sets_of_books_rec(p_set_of_books_id => l_budgets_rec.gl_set_of_books_id);
3001: FETCH csr_gl_sets_of_books_rec INTO l_sets_of_books_rec;
3002: CLOSE csr_gl_sets_of_books_rec;
3003:
3004: hr_utility.set_location('Chart of Account ID : '||l_sets_of_books_rec.chart_of_accounts_id,100);
3005:

Line 3002: CLOSE csr_gl_sets_of_books_rec;

2998:
2999: -- get the structure number of the GL ACCOUNT
3000: OPEN csr_gl_sets_of_books_rec(p_set_of_books_id => l_budgets_rec.gl_set_of_books_id);
3001: FETCH csr_gl_sets_of_books_rec INTO l_sets_of_books_rec;
3002: CLOSE csr_gl_sets_of_books_rec;
3003:
3004: hr_utility.set_location('Chart of Account ID : '||l_sets_of_books_rec.chart_of_accounts_id,100);
3005:
3006: -- populate the pqh_budget_gl_flex_maps with the segments