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_PERIODS

Line 261: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE) IS

257: FROM pqh_worksheet_details
258: WHERE worksheet_id = p_worksheet_id
259: AND NVL(action_cd,'X') = 'B' ;
260:
261: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE) IS
262: SELECT *
263: FROM pqh_worksheet_periods
264: WHERE worksheet_detail_id = p_worksheet_detail_id;
265:

Line 263: FROM pqh_worksheet_periods

259: AND NVL(action_cd,'X') = 'B' ;
260:
261: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_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 *

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 293: l_pqh_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;

289: l_pqh_worksheets_rec pqh_worksheets%ROWTYPE;
290: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
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;

Line 373: -- open pqh_worksheet_periods_cur

369: p_worksheet_mode_cd => g_worksheet_mode_cd,
370: p_budget_detail_id_o => l_budget_detail_id
371: );
372:
373: -- open pqh_worksheet_periods_cur
374: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_rec.worksheet_detail_id);
375: LOOP -- loop 3
376: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;
377: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;

Line 374: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_rec.worksheet_detail_id);

370: p_budget_detail_id_o => l_budget_detail_id
371: );
372:
373: -- open pqh_worksheet_periods_cur
374: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_rec.worksheet_detail_id);
375: LOOP -- loop 3
376: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;
377: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;
378:

Line 376: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;

372:
373: -- open pqh_worksheet_periods_cur
374: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_rec.worksheet_detail_id);
375: LOOP -- loop 3
376: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;
377: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;
378:
379: -- get log_context
380: set_wpr_log_context

Line 377: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;

373: -- open pqh_worksheet_periods_cur
374: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_rec.worksheet_detail_id);
375: LOOP -- loop 3
376: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;
377: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;
378:
379: -- get log_context
380: set_wpr_log_context
381: (

Line 382: p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id,

378:
379: -- get log_context
380: set_wpr_log_context
381: (
382: p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id,
383: p_log_context => l_log_context
384: );
385:
386: -- set the context

Line 389: p_txn_id => l_pqh_worksheet_periods_rec.worksheet_period_id,

385:
386: -- set the context
387: pqh_process_batch_log.set_context_level
388: (
389: p_txn_id => l_pqh_worksheet_periods_rec.worksheet_period_id,
390: p_txn_table_route_id => g_table_route_id_wpr,
391: p_level => 3,
392: p_log_context => l_log_context
393: );

Line 399: p_worksheet_periods_rec => l_pqh_worksheet_periods_rec,

395:
396: -- create records in pqh_budget_periods
397: populate_budget_periods
398: (
399: p_worksheet_periods_rec => l_pqh_worksheet_periods_rec,
400: p_budget_detail_id => l_budget_detail_id,
401: p_budget_period_id_o => l_budget_period_id
402: );
403:

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 506: CLOSE pqh_worksheet_periods_cur;

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:
508: END LOOP; -- loop 2
509: CLOSE pqh_worksheet_details_cur;
510:

Line 968: p_worksheet_periods_rec IN pqh_worksheet_periods%ROWTYPE,

964:
965: --------------------------------------------------------------------------------------------------------------
966: PROCEDURE populate_budget_periods
967: (
968: p_worksheet_periods_rec IN pqh_worksheet_periods%ROWTYPE,
969: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
970: p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE
971: )
972: IS

Line 2007: -- table_route_id for pqh_worksheet_periods

2003: OPEN csr_table_route (p_table_alias => 'WDT');
2004: FETCH csr_table_route INTO g_table_route_id_wdt;
2005: CLOSE csr_table_route;
2006:
2007: -- table_route_id for pqh_worksheet_periods
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:

Line 2133: p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE,

2129: END set_wks_log_context;
2130: --------------------------------------------------------------------------------------------------------------
2131: PROCEDURE set_wpr_log_context
2132: (
2133: p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE,
2134: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2135: ) IS
2136: /*
2137: This procedure will set the log_context at wks periods level

Line 2146: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;

2142:
2143: */
2144:
2145: l_proc varchar2(72) := g_package||'set_wpr_log_context';
2146: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
2147: l_per_time_periods per_time_periods%ROWTYPE;
2148: l_start_date per_time_periods.start_date%TYPE;
2149: l_end_date per_time_periods.end_date%TYPE;
2150:

Line 2153: FROM pqh_worksheet_periods

2149: l_end_date per_time_periods.end_date%TYPE;
2150:
2151: CURSOR csr_wks_periods_rec IS
2152: SELECT *
2153: FROM pqh_worksheet_periods
2154: WHERE worksheet_period_id = p_worksheet_period_id ;
2155:
2156: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
2157: SELECT *