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_COMMITMENT_POSTING dependencies on PQH_BUDGETS

Line 12: g_budget_id pqh_budgets.budget_id%TYPE;

8: g_package varchar2(100) := 'pqh_commitment_posting.'; -- Global package name
9: --
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;

Line 15: g_budget_name pqh_budgets.budget_name%TYPE;

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;
19: --

Line 16: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;

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;
19: --
20: g_user_je_source_name gl_interface.user_je_source_name%TYPE;

Line 17: g_transfer_to_grants_flag pqh_budgets.transfer_to_grants_flag%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;
19: --
20: g_user_je_source_name gl_interface.user_je_source_name%TYPE;
21: g_user_je_category_name gl_interface.user_je_category_name%TYPE;

Line 18: g_bgt_currency_code pqh_budgets.currency_code%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;
19: --
20: g_user_je_source_name gl_interface.user_je_source_name%TYPE;
21: g_user_je_category_name gl_interface.user_je_category_name%TYPE;
22: --

Line 33: g_budget_uom1 pqh_budgets.budget_unit1_id%TYPE;

29: g_default_currency_code gl_interface.currency_code%TYPE;
30: g_currency_code1 gl_interface.currency_code%TYPE;
31: g_currency_code2 gl_interface.currency_code%TYPE;
32: g_currency_code3 gl_interface.currency_code%TYPE;
33: g_budget_uom1 pqh_budgets.budget_unit1_id%TYPE;
34: g_budget_uom2 pqh_budgets.budget_unit2_id%TYPE;
35: g_budget_uom3 pqh_budgets.budget_unit3_id%TYPE;
36: --
37: g_table_route_id_bvr number;

Line 34: g_budget_uom2 pqh_budgets.budget_unit2_id%TYPE;

30: g_currency_code1 gl_interface.currency_code%TYPE;
31: g_currency_code2 gl_interface.currency_code%TYPE;
32: g_currency_code3 gl_interface.currency_code%TYPE;
33: g_budget_uom1 pqh_budgets.budget_unit1_id%TYPE;
34: g_budget_uom2 pqh_budgets.budget_unit2_id%TYPE;
35: g_budget_uom3 pqh_budgets.budget_unit3_id%TYPE;
36: --
37: g_table_route_id_bvr number;
38: g_table_route_id_bdt number;

Line 35: g_budget_uom3 pqh_budgets.budget_unit3_id%TYPE;

31: g_currency_code2 gl_interface.currency_code%TYPE;
32: g_currency_code3 gl_interface.currency_code%TYPE;
33: g_budget_uom1 pqh_budgets.budget_unit1_id%TYPE;
34: g_budget_uom2 pqh_budgets.budget_unit2_id%TYPE;
35: g_budget_uom3 pqh_budgets.budget_unit3_id%TYPE;
36: --
37: g_table_route_id_bvr number;
38: g_table_route_id_bdt number;
39: g_table_route_id_bpr number;

Line 205: pqh_budgets bgt,

201: --
202: CURSOR csr_curr_code IS
203: SELECT bg.currency_code
204: FROM per_business_groups bg,
205: pqh_budgets bgt,
206: pqh_budget_versions bvr
207: WHERE bgt.budget_id = bvr.budget_id
208: AND bvr.budget_version_id = p_budget_version_id
209: AND bgt.business_group_id = bg.business_group_id ;

Line 213: FROM pqh_budgets bgt,

209: AND bgt.business_group_id = bg.business_group_id ;
210: --
211: CURSOR csr_bgt_curr IS
212: SELECT bgt.currency_code
213: FROM pqh_budgets bgt,
214: pqh_budget_versions bvr
215: WHERE bgt.budget_id = bvr.budget_id
216: AND bvr.budget_version_id = g_budget_version_id;
217: --

Line 310: l_budgets_rec pqh_budgets%ROWTYPE;

306: (p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE) IS
307: --
308: l_proc varchar2(72) := g_package||'fetch_global_values';
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;

Line 324: l_transfer_to_gl_flag pqh_budgets.transfer_to_gl_flag%TYPE;

320: l_version_gl_status pqh_budget_versions.gl_status%TYPE;
321: --
322: l_gl_encumbrance_type_id gl_encumbrance_types.encumbrance_type_id%TYPE;
323: --
324: l_transfer_to_gl_flag pqh_budgets.transfer_to_gl_flag%TYPE;
325: l_psb_budget_flag pqh_budgets.psb_budget_flag%TYPE;
326: l_default_currency_code gl_interface.currency_code%TYPE;
327: --
328: l_message_text pqh_process_log.message_text%TYPE;

Line 325: l_psb_budget_flag pqh_budgets.psb_budget_flag%TYPE;

321: --
322: l_gl_encumbrance_type_id gl_encumbrance_types.encumbrance_type_id%TYPE;
323: --
324: l_transfer_to_gl_flag pqh_budgets.transfer_to_gl_flag%TYPE;
325: l_psb_budget_flag pqh_budgets.psb_budget_flag%TYPE;
326: l_default_currency_code gl_interface.currency_code%TYPE;
327: --
328: l_message_text pqh_process_log.message_text%TYPE;
329: l_message_text_out fnd_new_messages.message_text%TYPE;

Line 336: l_gl_budget_name pqh_budgets.gl_budget_name%TYPE;

332: l_batch_id number;
333: l_batch_context varchar2(2000);
334: l_count number;
335: l_map_count_null number;
336: l_gl_budget_name pqh_budgets.gl_budget_name%TYPE;
337: --
338: --
339: CURSOR csr_budget_versions_rec IS
340: SELECT *

Line 346: FROM pqh_budgets

342: WHERE budget_version_id = p_budget_version_id;
343:
344: CURSOR csr_budgets_rec IS
345: SELECT *
346: FROM pqh_budgets
347: WHERE budget_id = ( SELECT budget_id
348: FROM pqh_budget_versions
349: WHERE budget_version_id = p_budget_version_id ) ;
350: --

Line 1397: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,

1393: p_job_id IN pqh_budget_details.job_id%type,
1394: p_grade_id IN pqh_budget_details.grade_id%type,
1395: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,
1396: p_budget_unit_seq IN number,
1397: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,
1398: p_effective_date IN varchar2) IS
1399: --
1400: l_period_start_date per_time_periods.start_date%type := NULL;
1401: l_period_end_date per_time_periods.end_date%type := NULL;

Line 1405: l_budget_entity pqh_budgets.budgeted_entity_cd%type := NULL;

1401: l_period_end_date per_time_periods.end_date%type := NULL;
1402: l_commitment number := NULL;
1403: l_distribution_table t_distribution_table;
1404: l_budget_ratio_table t_ratio_table;
1405: l_budget_entity pqh_budgets.budgeted_entity_cd%type := NULL;
1406: l_business_group_id pqh_budgets.business_group_id%type :=NULL;
1407: l_commt_value number;
1408: l_effective_dt date;
1409: --

Line 1406: l_business_group_id pqh_budgets.business_group_id%type :=NULL;

1402: l_commitment number := NULL;
1403: l_distribution_table t_distribution_table;
1404: l_budget_ratio_table t_ratio_table;
1405: l_budget_entity pqh_budgets.budgeted_entity_cd%type := NULL;
1406: l_business_group_id pqh_budgets.business_group_id%type :=NULL;
1407: l_commt_value number;
1408: l_effective_dt date;
1409: --
1410: Cursor csr_get_budget_entity_cd is

Line 1412: From PQH_BUDGETS BGT,

1408: l_effective_dt date;
1409: --
1410: Cursor csr_get_budget_entity_cd is
1411: Select BGT.BUDGETED_ENTITY_CD , BGT.BUSINESS_GROUP_ID
1412: From PQH_BUDGETS BGT,
1413: PQH_BUDGET_VERSIONS BVR
1414: Where BGT.BUDGET_ID = BVR.BUDGET_ID
1415: And BGT.POSITION_CONTROL_FLAG ='Y'
1416: And l_effective_dt BETWEEN BGT.BUDGET_START_DATE AND BGT.BUDGET_END_DATE

Line 1505: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,

1501: p_job_id IN pqh_budget_details.job_id%type,
1502: p_grade_id IN pqh_budget_details.grade_id%type,
1503: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,
1504: p_budget_unit_seq IN number,
1505: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,
1506: p_effective_date IN varchar2) IS
1507: --
1508: l_period_start_date per_time_periods.start_date%type := NULL;
1509: l_period_end_date per_time_periods.end_date%type := NULL;

Line 1512: l_budget_entity pqh_budgets.budgeted_entity_cd%type := NULL;

1508: l_period_start_date per_time_periods.start_date%type := NULL;
1509: l_period_end_date per_time_periods.end_date%type := NULL;
1510: --
1511: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
1512: l_budget_entity pqh_budgets.budgeted_entity_cd%type := NULL;
1513: l_business_group_id pqh_budgets.business_group_id%type := NULL;
1514: l_effective_dt date;
1515: --
1516: Cursor csr_get_budget_entity_cd is

Line 1513: l_business_group_id pqh_budgets.business_group_id%type := NULL;

1509: l_period_end_date per_time_periods.end_date%type := NULL;
1510: --
1511: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
1512: l_budget_entity pqh_budgets.budgeted_entity_cd%type := NULL;
1513: l_business_group_id pqh_budgets.business_group_id%type := NULL;
1514: l_effective_dt date;
1515: --
1516: Cursor csr_get_budget_entity_cd is
1517: Select BGT.BUDGETED_ENTITY_CD, BGT.BUSINESS_GROUP_ID

Line 1518: From PQH_BUDGETS BGT,

1514: l_effective_dt date;
1515: --
1516: Cursor csr_get_budget_entity_cd is
1517: Select BGT.BUDGETED_ENTITY_CD, BGT.BUSINESS_GROUP_ID
1518: From PQH_BUDGETS BGT,
1519: PQH_BUDGET_VERSIONS BVR
1520: Where BGT.BUDGET_ID = BVR.BUDGET_ID
1521: And BGT.POSITION_CONTROL_FLAG ='Y'
1522: And l_effective_dt BETWEEN BGT.BUDGET_START_DATE AND BGT.BUDGET_END_DATE

Line 1933: p_set_of_books_id IN pqh_budgets.gl_set_of_books_id%type,

1929: --
1930: PROCEDURE get_gl_period
1931: (
1932: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
1933: p_set_of_books_id IN pqh_budgets.gl_set_of_books_id%type,
1934: p_gl_period_statuses_rec OUT NOCOPY gl_period_statuses%ROWTYPE
1935: ) IS
1936: --
1937: -- This procedure will return the period name corresponding to start_date between

Line 2048: FROM gl_period_statuses gl, pqh_budgets bdgt

2044: hr_utility.set_location('g_set_of_books_id: '||g_set_of_books_id, 10000000);
2045: hr_utility.set_location('g_budget_id: '||g_budget_id, 10000000);
2046: l_period_name := p_post_to_period_name;
2047: SELECT gl.start_date into l_accounting_date
2048: FROM gl_period_statuses gl, pqh_budgets bdgt
2049: WHERE gl.application_id = g_application_id
2050: AND gl.closing_status = 'O'
2051: AND gl.set_of_books_id = g_set_of_books_id
2052: AND gl.period_name = p_post_to_period_name

Line 3649: From PQH_BUDGETS BGT,

3645: --
3646:
3647: Cursor csr_check_budget_is_ctrlbgt IS
3648: Select 1
3649: From PQH_BUDGETS BGT,
3650: PQH_BUDGET_VERSIONS BVR
3651: Where BGT.BUDGET_ID = BVR.BUDGET_ID
3652: And BGT.POSITION_CONTROL_FLAG ='Y'
3653: And l_effective_dt BETWEEN BGT.BUDGET_START_DATE AND BGT.BUDGET_END_DATE

Line 4185: pqh_budgets

4181: hr_general.decode_shared_type(budget_unit1_id) UOM1,
4182: hr_general.decode_shared_type(budget_unit2_id) UOM2,
4183: hr_general.decode_shared_type(budget_unit3_id) UOM3
4184: From
4185: pqh_budgets
4186: Where budget_id=g_budget_id;
4187:
4188:
4189: BEGIN

Line 4840: From pqh_budgets

4836: l_period_name NUMBER;
4837: -----------------------------------------------------------------------
4838: Cursor csr_budget_bg IS
4839: Select business_group_id
4840: From pqh_budgets
4841: Where budget_id=g_budget_id;
4842:
4843: Cursor csr_tran_srcs IS
4844: Select transaction_source

Line 4892: l_table := 'pqh_budgets';

4888: FETCH csr_budget_bg INTO l_bg_id;
4889: IF (csr_budget_bg%NOTFOUND) THEN
4890: CLOSE csr_budget_bg;
4891: l_value := 'Business Group Id';
4892: l_table := 'pqh_budgets';
4893: RAISE tran_setup_exception;
4894: else
4895: CLOSE csr_budget_bg;
4896: END IF;