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_WORKSHEET_BDGT_ELMNTS

Line 271: CURSOR pqh_worksheet_bdgt_elmnts_cur (p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE) IS

267: SELECT *
268: FROM pqh_worksheet_budget_sets
269: WHERE worksheet_period_id = p_worksheet_period_id;
270:
271: CURSOR pqh_worksheet_bdgt_elmnts_cur (p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE) IS
272: SELECT *
273: FROM pqh_worksheet_bdgt_elmnts
274: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
275:

Line 273: FROM pqh_worksheet_bdgt_elmnts

269: WHERE worksheet_period_id = p_worksheet_period_id;
270:
271: CURSOR pqh_worksheet_bdgt_elmnts_cur (p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE) IS
272: SELECT *
273: FROM pqh_worksheet_bdgt_elmnts
274: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
275:
276: CURSOR pqh_worksheet_fund_srcs_cur (p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE) IS
277: SELECT *

Line 276: CURSOR pqh_worksheet_fund_srcs_cur (p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE) IS

272: SELECT *
273: FROM pqh_worksheet_bdgt_elmnts
274: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
275:
276: CURSOR pqh_worksheet_fund_srcs_cur (p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE) IS
277: SELECT *
278: FROM pqh_worksheet_fund_srcs
279: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
280:

Line 297: l_pqh_worksheet_bdgt_elmnt_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;

293: l_pqh_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
294: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
295: l_pqh_worksheet_budget_set_rec pqh_worksheet_budget_sets%ROWTYPE;
296: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
297: l_pqh_worksheet_bdgt_elmnt_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
298: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;
299: l_pqh_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
300: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
301: l_curr_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

Line 435: -- open pqh_worksheet_bdgt_elmnts_cur

431: p_budget_period_id => l_budget_period_id,
432: p_budget_set_id_o => l_budget_set_id
433: );
434:
435: -- open pqh_worksheet_bdgt_elmnts_cur
436: OPEN pqh_worksheet_bdgt_elmnts_cur(p_worksheet_budget_set_id => l_pqh_worksheet_budget_set_rec.worksheet_budget_set_id);
437: LOOP -- loop 5
438: FETCH pqh_worksheet_bdgt_elmnts_cur INTO l_pqh_worksheet_bdgt_elmnt_rec;
439: EXIT WHEN pqh_worksheet_bdgt_elmnts_cur%NOTFOUND;

Line 436: OPEN pqh_worksheet_bdgt_elmnts_cur(p_worksheet_budget_set_id => l_pqh_worksheet_budget_set_rec.worksheet_budget_set_id);

432: p_budget_set_id_o => l_budget_set_id
433: );
434:
435: -- open pqh_worksheet_bdgt_elmnts_cur
436: OPEN pqh_worksheet_bdgt_elmnts_cur(p_worksheet_budget_set_id => l_pqh_worksheet_budget_set_rec.worksheet_budget_set_id);
437: LOOP -- loop 5
438: FETCH pqh_worksheet_bdgt_elmnts_cur INTO l_pqh_worksheet_bdgt_elmnt_rec;
439: EXIT WHEN pqh_worksheet_bdgt_elmnts_cur%NOTFOUND;
440:

Line 438: FETCH pqh_worksheet_bdgt_elmnts_cur INTO l_pqh_worksheet_bdgt_elmnt_rec;

434:
435: -- open pqh_worksheet_bdgt_elmnts_cur
436: OPEN pqh_worksheet_bdgt_elmnts_cur(p_worksheet_budget_set_id => l_pqh_worksheet_budget_set_rec.worksheet_budget_set_id);
437: LOOP -- loop 5
438: FETCH pqh_worksheet_bdgt_elmnts_cur INTO l_pqh_worksheet_bdgt_elmnt_rec;
439: EXIT WHEN pqh_worksheet_bdgt_elmnts_cur%NOTFOUND;
440:
441: -- get log_context
442: set_wel_log_context

Line 439: EXIT WHEN pqh_worksheet_bdgt_elmnts_cur%NOTFOUND;

435: -- open pqh_worksheet_bdgt_elmnts_cur
436: OPEN pqh_worksheet_bdgt_elmnts_cur(p_worksheet_budget_set_id => l_pqh_worksheet_budget_set_rec.worksheet_budget_set_id);
437: LOOP -- loop 5
438: FETCH pqh_worksheet_bdgt_elmnts_cur INTO l_pqh_worksheet_bdgt_elmnt_rec;
439: EXIT WHEN pqh_worksheet_bdgt_elmnts_cur%NOTFOUND;
440:
441: -- get log_context
442: set_wel_log_context
443: (

Line 500: CLOSE pqh_worksheet_bdgt_elmnts_cur;

496: END LOOP; -- loop 6
497: CLOSE pqh_worksheet_fund_srcs_cur;
498:
499: END LOOP; -- loop 5
500: CLOSE pqh_worksheet_bdgt_elmnts_cur;
501:
502: END LOOP; -- loop 4
503: CLOSE pqh_worksheet_budget_sets_cur;
504:

Line 1091: p_worksheet_bdgt_elmnts_rec IN pqh_worksheet_bdgt_elmnts%ROWTYPE,

1087:
1088: --------------------------------------------------------------------------------------------------------------
1089: PROCEDURE populate_budget_elements
1090: (
1091: p_worksheet_bdgt_elmnts_rec IN pqh_worksheet_bdgt_elmnts%ROWTYPE,
1092: p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,
1093: p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE
1094: )
1095: IS

Line 2017: -- table_route_id for pqh_worksheet_bdgt_elmnts

2013: OPEN csr_table_route (p_table_alias => 'WST');
2014: FETCH csr_table_route INTO g_table_route_id_wst;
2015: CLOSE csr_table_route;
2016:
2017: -- table_route_id for pqh_worksheet_bdgt_elmnts
2018: OPEN csr_table_route (p_table_alias => 'WEL');
2019: FETCH csr_table_route INTO g_table_route_id_wel;
2020: CLOSE csr_table_route;
2021:

Line 2263: p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE,

2259:
2260: --------------------------------------------------------------------------------------------------------------
2261: PROCEDURE set_wel_log_context
2262: (
2263: p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE,
2264: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2265: ) IS
2266:
2267: /*

Line 2279: FROM pqh_worksheet_bdgt_elmnts

2275: l_proc varchar2(72) := g_package||'set_wel_log_context';
2276:
2277: CURSOR csr_wks_bdgt_elmnts_rec IS
2278: SELECT *
2279: FROM pqh_worksheet_bdgt_elmnts
2280: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
2281:
2282: CURSOR csr_pay_element_types_rec ( p_element_type_id IN number) IS
2283: SELECT element_name

Line 2288: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;

2284: FROM pay_element_types_f_tl
2285: WHERE element_type_id = p_element_type_id
2286: and language = userenv('LANG');
2287:
2288: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
2289: l_pay_element_types_rec csr_pay_element_types_rec%ROWTYPE;
2290:
2291: BEGIN
2292: