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_BUDGET_SETS

Line 266: CURSOR pqh_worksheet_budget_sets_cur (p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE) IS

262: SELECT *
263: FROM pqh_worksheet_periods
264: WHERE worksheet_detail_id = p_worksheet_detail_id;
265:
266: CURSOR pqh_worksheet_budget_sets_cur (p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE) IS
267: SELECT *
268: FROM pqh_worksheet_budget_sets
269: WHERE worksheet_period_id = p_worksheet_period_id;
270:

Line 268: FROM pqh_worksheet_budget_sets

264: WHERE worksheet_detail_id = p_worksheet_detail_id;
265:
266: CURSOR pqh_worksheet_budget_sets_cur (p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_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 *

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 295: l_pqh_worksheet_budget_set_rec pqh_worksheet_budget_sets%ROWTYPE;

291: l_pqh_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
292: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
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;

Line 404: -- open pqh_worksheet_budget_sets_cur

400: p_budget_detail_id => l_budget_detail_id,
401: p_budget_period_id_o => l_budget_period_id
402: );
403:
404: -- open pqh_worksheet_budget_sets_cur
405: OPEN pqh_worksheet_budget_sets_cur(p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id);
406: LOOP -- loop 4
407: FETCH pqh_worksheet_budget_sets_cur INTO l_pqh_worksheet_budget_set_rec;
408: EXIT WHEN pqh_worksheet_budget_sets_cur%NOTFOUND;

Line 405: OPEN pqh_worksheet_budget_sets_cur(p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id);

401: p_budget_period_id_o => l_budget_period_id
402: );
403:
404: -- open pqh_worksheet_budget_sets_cur
405: OPEN pqh_worksheet_budget_sets_cur(p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id);
406: LOOP -- loop 4
407: FETCH pqh_worksheet_budget_sets_cur INTO l_pqh_worksheet_budget_set_rec;
408: EXIT WHEN pqh_worksheet_budget_sets_cur%NOTFOUND;
409:

Line 407: FETCH pqh_worksheet_budget_sets_cur INTO l_pqh_worksheet_budget_set_rec;

403:
404: -- open pqh_worksheet_budget_sets_cur
405: OPEN pqh_worksheet_budget_sets_cur(p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id);
406: LOOP -- loop 4
407: FETCH pqh_worksheet_budget_sets_cur INTO l_pqh_worksheet_budget_set_rec;
408: EXIT WHEN pqh_worksheet_budget_sets_cur%NOTFOUND;
409:
410: -- get log_context
411: set_wst_log_context

Line 408: EXIT WHEN pqh_worksheet_budget_sets_cur%NOTFOUND;

404: -- open pqh_worksheet_budget_sets_cur
405: OPEN pqh_worksheet_budget_sets_cur(p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id);
406: LOOP -- loop 4
407: FETCH pqh_worksheet_budget_sets_cur INTO l_pqh_worksheet_budget_set_rec;
408: EXIT WHEN pqh_worksheet_budget_sets_cur%NOTFOUND;
409:
410: -- get log_context
411: set_wst_log_context
412: (

Line 503: CLOSE pqh_worksheet_budget_sets_cur;

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:
505: END LOOP; -- loop 3
506: CLOSE pqh_worksheet_periods_cur;
507:

Line 1030: p_worksheet_budget_sets_rec IN pqh_worksheet_budget_sets%ROWTYPE,

1026: --------------------------------------------------------------------------------------------------------------
1027:
1028: PROCEDURE populate_budget_sets
1029: (
1030: p_worksheet_budget_sets_rec IN pqh_worksheet_budget_sets%ROWTYPE,
1031: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
1032: p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE
1033: )
1034: IS

Line 2012: -- table_route_id for pqh_worksheet_budget_sets

2008: OPEN csr_table_route (p_table_alias => 'WPR');
2009: FETCH csr_table_route INTO g_table_route_id_wpr;
2010: CLOSE csr_table_route;
2011:
2012: -- table_route_id for pqh_worksheet_budget_sets
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:

Line 2206: p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE,

2202:
2203: --------------------------------------------------------------------------------------------------------------
2204: PROCEDURE set_wst_log_context
2205: (
2206: p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE,
2207: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2208: ) IS
2209:
2210: /*

Line 2219: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;

2215:
2216: */
2217:
2218: l_proc varchar2(72) := g_package||'set_wst_log_context';
2219: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;
2220: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;
2221:
2222:
2223: CURSOR csr_wks_budget_sets_rec IS

Line 2225: FROM pqh_worksheet_budget_sets

2221:
2222:
2223: CURSOR csr_wks_budget_sets_rec IS
2224: SELECT *
2225: FROM pqh_worksheet_budget_sets
2226: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
2227:
2228: CURSOR csr_dflt_budget_sets_rec ( p_dflt_budget_set_id IN number) IS
2229: SELECT *