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

Line 12: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;

8: g_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
9: g_worksheet_mode_cd pqh_worksheets.worksheet_mode_cd%TYPE;
10: g_budget_id pqh_worksheets.budget_id%TYPE;
11:
12: g_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%TYPE;
13: g_table_route_id_wks NUMBER;
14: g_table_route_id_wdt NUMBER;
15: g_table_route_id_wpr NUMBER;
16: g_table_route_id_wst NUMBER;

Line 204: -- update the status in pqh_budgets to FROZEN

200: p_status => 'APPLIED'
201: );
202: hr_utility.set_location('wkd updated with Applied'||l_proc, 9);
203:
204: -- update the status in pqh_budgets to FROZEN
205:
206:
207: updt_budget_status
208: (

Line 617: p_budget_id IN pqh_budgets.budget_id%TYPE,

613:
614: PROCEDURE populate_budget_versions
615: (
616: p_worksheets_rec IN pqh_worksheets%ROWTYPE,
617: p_budget_id IN pqh_budgets.budget_id%TYPE,
618: p_worksheet_mode_cd IN pqh_worksheets.worksheet_mode_cd%TYPE,
619: p_budget_version_id_o OUT NOCOPY pqh_budget_versions.budget_version_id%TYPE
620: )
621: IS

Line 1944: l_budgets_rec pqh_budgets%ROWTYPE;

1940: This procedure will populate all the global variables.
1941: */
1942:
1943: l_proc varchar2(72) := g_package||'populate_globals';
1944: l_budgets_rec pqh_budgets%ROWTYPE;
1945: l_worksheets_rec pqh_worksheets%ROWTYPE;
1946:
1947: CURSOR csr_budget_rec IS
1948: SELECT *

Line 1949: FROM pqh_budgets

1945: l_worksheets_rec pqh_worksheets%ROWTYPE;
1946:
1947: CURSOR csr_budget_rec IS
1948: SELECT *
1949: FROM pqh_budgets
1950: WHERE budget_id =
1951: (
1952: SELECT b.budget_id
1953: FROM pqh_budgets b, pqh_worksheets wks

Line 1953: FROM pqh_budgets b, pqh_worksheets wks

1949: FROM pqh_budgets
1950: WHERE budget_id =
1951: (
1952: SELECT b.budget_id
1953: FROM pqh_budgets b, pqh_worksheets wks
1954: WHERE wks.worksheet_id = p_worksheet_id
1955: AND wks.budget_id = b.budget_id
1956: );
1957:

Line 2407: l_budget_id pqh_budgets.budget_id%TYPE;

2403: l_status varchar2(30);
2404: l_wks_detail_rec pqh_worksheet_details%ROWTYPE;
2405: l_return varchar2(30) := 'SUCCESS' ;
2406: l_worksheet_id pqh_worksheet_details.worksheet_id%TYPE;
2407: l_budget_id pqh_budgets.budget_id%TYPE;
2408: l_budget_rec pqh_budgets%ROWTYPE;
2409: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2410: l_gl_validation varchar2(30);
2411: l_req number(9);

Line 2408: l_budget_rec pqh_budgets%ROWTYPE;

2404: l_wks_detail_rec pqh_worksheet_details%ROWTYPE;
2405: l_return varchar2(30) := 'SUCCESS' ;
2406: l_worksheet_id pqh_worksheet_details.worksheet_id%TYPE;
2407: l_budget_id pqh_budgets.budget_id%TYPE;
2408: l_budget_rec pqh_budgets%ROWTYPE;
2409: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2410: l_gl_validation varchar2(30);
2411: l_req number(9);
2412: l_transaction_category_id number;

Line 2435: FROM pqh_budgets

2431: WHERE worksheet_id = p_worksheet_id;
2432:
2433: CURSOR csr_budget_rec(p_budget_id IN NUMBER ) IS
2434: SELECT *
2435: FROM pqh_budgets
2436: WHERE budget_id = p_budget_id;
2437:
2438: cursor c1(p_transaction_id in number) is
2439: select wf_transaction_category_id

Line 2741: p_budget_id IN pqh_budgets.budget_id%TYPE

2737: --------------------------------------------------------------------------------------------------------------
2738:
2739: PROCEDURE updt_budget_status
2740: (
2741: p_budget_id IN pqh_budgets.budget_id%TYPE
2742: ) IS
2743: /*
2744: This procedure will update the budget status to FROZEN once the budgte is successfully
2745: applied

Line 2752: FROM pqh_budgets

2748: l_proc varchar2(72) := g_package||'updt_budget_status';
2749:
2750: CURSOR csr_budget IS
2751: SELECT *
2752: FROM pqh_budgets
2753: WHERE budget_id = p_budget_id
2754: AND NVL(status,'X') <> 'FROZEN';
2755:
2756: l_budget_rec pqh_budgets%ROWTYPE;

Line 2756: l_budget_rec pqh_budgets%ROWTYPE;

2752: FROM pqh_budgets
2753: WHERE budget_id = p_budget_id
2754: AND NVL(status,'X') <> 'FROZEN';
2755:
2756: l_budget_rec pqh_budgets%ROWTYPE;
2757: l_object_version_number pqh_budgets.object_version_number%TYPE;
2758:
2759: BEGIN
2760: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2757: l_object_version_number pqh_budgets.object_version_number%TYPE;

2753: WHERE budget_id = p_budget_id
2754: AND NVL(status,'X') <> 'FROZEN';
2755:
2756: l_budget_rec pqh_budgets%ROWTYPE;
2757: l_object_version_number pqh_budgets.object_version_number%TYPE;
2758:
2759: BEGIN
2760: hr_utility.set_location('Entering:'||l_proc, 5);
2761:

Line 2770: pqh_budgets_api.update_budget

2766:
2767: l_object_version_number := l_budget_rec.object_version_number;
2768:
2769: -- call the update API here
2770: pqh_budgets_api.update_budget
2771: (
2772: p_validate => false
2773: ,p_budget_id => p_budget_id
2774: ,p_object_version_number => l_object_version_number

Line 3091: from pqh_budgets

3087: cursor c1 is select budget_id,worksheet_name,version_number,worksheet_mode_cd,date_from,date_to,wf_transaction_category_id
3088: from pqh_worksheets
3089: where worksheet_id = l_worksheet_id;
3090: cursor c2 is select budget_name,budgeted_entity_cd,budget_style_cd,budget_start_date,budget_end_date
3091: from pqh_budgets
3092: where budget_id = l_budget_id;
3093: cursor c3 is select name from pqh_transaction_categories
3094: where transaction_category_id = l_tran_cat_id;
3095: cursor c4 is select name from hr_all_organization_units_tl