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 PQH_BUDGETS

Line 13: g_budget_name pqh_budgets.budget_name%TYPE;

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;
17: g_user_je_category_name gl_interface.user_je_category_name%TYPE;

Line 14: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;

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;
17: g_user_je_category_name gl_interface.user_je_category_name%TYPE;
18: g_budget_version_id gl_interface.budget_version_id%TYPE;

Line 15: g_budget_id pqh_budgets.budget_id%TYPE;

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;
17: g_user_je_category_name gl_interface.user_je_category_name%TYPE;
18: g_budget_version_id gl_interface.budget_version_id%TYPE;
19: g_gl_budget_version_id gl_interface.budget_version_id%TYPE;

Line 36: g_psb_budget_flag pqh_budgets.psb_budget_flag%TYPE;

32: g_table_route_id_glf number;
33: g_status varchar2(10);
34: g_validate boolean;
35: g_last_posted_ver gl_interface.budget_version_id%TYPE;
36: g_psb_budget_flag pqh_budgets.psb_budget_flag%TYPE;
37: g_transfer_to_grants_flag pqh_budgets.transfer_to_grants_flag%TYPE;
38: g_bgt_currency_code pqh_budgets.currency_code%TYPE;
39:
40:

Line 37: g_transfer_to_grants_flag pqh_budgets.transfer_to_grants_flag%TYPE;

33: g_status varchar2(10);
34: g_validate boolean;
35: g_last_posted_ver gl_interface.budget_version_id%TYPE;
36: g_psb_budget_flag pqh_budgets.psb_budget_flag%TYPE;
37: g_transfer_to_grants_flag pqh_budgets.transfer_to_grants_flag%TYPE;
38: g_bgt_currency_code pqh_budgets.currency_code%TYPE;
39:
40:
41:

Line 38: g_bgt_currency_code pqh_budgets.currency_code%TYPE;

34: g_validate boolean;
35: g_last_posted_ver gl_interface.budget_version_id%TYPE;
36: g_psb_budget_flag pqh_budgets.psb_budget_flag%TYPE;
37: g_transfer_to_grants_flag pqh_budgets.transfer_to_grants_flag%TYPE;
38: g_bgt_currency_code pqh_budgets.currency_code%TYPE;
39:
40:
41:
42: -- ----------------------------------------------------------------------------

Line 368: l_budgets_rec pqh_budgets%ROWTYPE;

364: --
365: -- local variables
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;

Line 385: l_gl_budget_name pqh_budgets.GL_BUDGET_NAME%TYPE;

381: l_batch_context varchar2(2000);
382: l_count number;
383: l_map_count_null number;
384: l_budget_detail_result varchar2(1);
385: l_gl_budget_name pqh_budgets.GL_BUDGET_NAME%TYPE;
386:
387: CURSOR csr_budget_versions_rec IS
388: SELECT *
389: FROM pqh_budget_versions

Line 394: FROM pqh_budgets

390: WHERE budget_version_id = p_budget_version_id;
391:
392: CURSOR csr_budgets_rec (c_budget_id IN NUMBER) IS
393: SELECT *
394: FROM pqh_budgets
395: WHERE budget_id = c_budget_id;
396: /* ns budget_id is already available, no need to fetch again
397: ( SELECT budget_id
398: FROM pqh_budget_versions

Line 2949: p_budget_id IN pqh_budgets.budget_id%TYPE

2945:
2946: --------------------------------------------------------------------------------------------------------------
2947: PROCEDURE populate_budget_gl_map
2948: (
2949: p_budget_id IN pqh_budgets.budget_id%TYPE
2950: ) IS
2951: /*
2952: Called from Budget Charactaristics FORM
2953: This procedure will populate the pqh_budget_gl_flex_maps

Line 2962: l_budgets_rec pqh_budgets%ROWTYPE;

2958: --
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);

Line 2970: FROM pqh_budgets

2966: l_object_version_number number(9);
2967:
2968: CURSOR csr_budget_rec 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 *

Line 3541: pqh_budgets bgt,

3537:
3538: CURSOR csr_curr_code IS
3539: SELECT bg.ORG_INFORMATION10
3540: FROM HR_ORGANIZATION_INFORMATION bg,
3541: pqh_budgets bgt,
3542: pqh_budget_versions bvr
3543: WHERE bgt.budget_id = bvr.budget_id
3544: AND bvr.budget_version_id = g_budget_version_id
3545: AND bgt.business_group_id = bg.organization_id

Line 3550: FROM pqh_budgets bgt,

3546: AND bg.ORG_INFORMATION_CONTEXT = 'Business Group Information';
3547:
3548: CURSOR csr_bgt_curr IS
3549: SELECT bgt.currency_code
3550: FROM pqh_budgets bgt,
3551: pqh_budget_versions bvr
3552: WHERE bgt.budget_id = bvr.budget_id
3553: AND bvr.budget_version_id = g_budget_version_id;
3554:

Line 4187: p_budget_id IN pqh_budgets.budget_id%type,

4183: -- Added the following wrapper to get_gl_ccid function so that the code
4184: -- can be re-used in commitment gl posting
4185: --
4186: PROCEDURE get_ccid_for_commitment(
4187: p_budget_id IN pqh_budgets.budget_id%type,
4188: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%TYPE,
4189: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
4190: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
4191: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,

Line 4577: pqh_budgets

4573: hr_general.decode_shared_type(budget_unit1_id) UOM1,
4574: hr_general.decode_shared_type(budget_unit2_id) UOM2,
4575: hr_general.decode_shared_type(budget_unit3_id) UOM3
4576: From
4577: pqh_budgets
4578: Where budget_id=g_budget_id;
4579:
4580: Cursor csr_last_posted_ver IS
4581: Select budget_version_id

Line 5082: pqh_budgets

5078: hr_general.decode_shared_type(budget_unit1_id) UOM1,
5079: hr_general.decode_shared_type(budget_unit2_id) UOM2,
5080: hr_general.decode_shared_type(budget_unit3_id) UOM3
5081: From
5082: pqh_budgets
5083: Where budget_id=g_budget_id;
5084:
5085:
5086: BEGIN

Line 5807: From pqh_budgets

5803: l_period_name NUMBER;
5804: -----------------------------------------------------------------------
5805: Cursor csr_budget_bg IS
5806: Select business_group_id
5807: From pqh_budgets
5808: Where budget_id=g_budget_id;
5809:
5810: Cursor csr_tran_srcs IS
5811: Select transaction_source

Line 5859: l_table := 'pqh_budgets';

5855: FETCH csr_budget_bg INTO l_bg_id;
5856: IF (csr_budget_bg%NOTFOUND) THEN
5857: CLOSE csr_budget_bg;
5858: l_value := 'Business Group Id';
5859: l_table := 'pqh_budgets';
5860: RAISE tran_setup_exception;
5861: else
5862: CLOSE csr_budget_bg;
5863: END IF;