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_WKS_ERROR_CHK dependencies on PQH_WORKSHEET_BUDGET_SETS

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

111: SELECT *
112: FROM pqh_worksheet_periods
113: WHERE worksheet_detail_id = p_worksheet_detail_id;
114:
115: CURSOR pqh_worksheet_budget_sets_cur (p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE) IS
116: SELECT *
117: FROM pqh_worksheet_budget_sets
118: WHERE worksheet_period_id = p_worksheet_period_id;
119:

Line 117: FROM pqh_worksheet_budget_sets

113: WHERE worksheet_detail_id = p_worksheet_detail_id;
114:
115: CURSOR pqh_worksheet_budget_sets_cur (p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE) IS
116: SELECT *
117: FROM pqh_worksheet_budget_sets
118: WHERE worksheet_period_id = p_worksheet_period_id;
119:
120: CURSOR pqh_worksheet_bdgt_elmnts_cur (p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE) IS
121: SELECT *

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

116: SELECT *
117: FROM pqh_worksheet_budget_sets
118: WHERE worksheet_period_id = p_worksheet_period_id;
119:
120: CURSOR pqh_worksheet_bdgt_elmnts_cur (p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE) IS
121: SELECT *
122: FROM pqh_worksheet_bdgt_elmnts
123: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
124:

Line 140: l_pqh_worksheet_budget_set_rec pqh_worksheet_budget_sets%ROWTYPE;

136: l_proc varchar2(72) := g_package||'check_wks_errors';
137: l_pqh_worksheets_rec pqh_worksheets%ROWTYPE;
138: l_pqh_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
139: l_pqh_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
140: l_pqh_worksheet_budget_set_rec pqh_worksheet_budget_sets%ROWTYPE;
141: l_pqh_worksheet_bdgt_elmnt_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
142: l_pqh_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
143: l_message_text pqh_process_log.message_text%TYPE;
144: l_message_text_out fnd_new_messages.message_text%TYPE;

Line 343: -- open pqh_worksheet_budget_sets_cur

339: );
340:
341: -- For all budget sets , current level = g_curr_wks_dtl_level + 2
342:
343: -- open pqh_worksheet_budget_sets_cur
344: OPEN pqh_worksheet_budget_sets_cur(p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id);
345: LOOP -- loop 3
346: FETCH pqh_worksheet_budget_sets_cur INTO l_pqh_worksheet_budget_set_rec;
347: EXIT WHEN pqh_worksheet_budget_sets_cur%NOTFOUND;

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

340:
341: -- For all budget sets , current level = g_curr_wks_dtl_level + 2
342:
343: -- open pqh_worksheet_budget_sets_cur
344: OPEN pqh_worksheet_budget_sets_cur(p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id);
345: LOOP -- loop 3
346: FETCH pqh_worksheet_budget_sets_cur INTO l_pqh_worksheet_budget_set_rec;
347: EXIT WHEN pqh_worksheet_budget_sets_cur%NOTFOUND;
348:

Line 346: FETCH pqh_worksheet_budget_sets_cur INTO l_pqh_worksheet_budget_set_rec;

342:
343: -- open pqh_worksheet_budget_sets_cur
344: OPEN pqh_worksheet_budget_sets_cur(p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id);
345: LOOP -- loop 3
346: FETCH pqh_worksheet_budget_sets_cur INTO l_pqh_worksheet_budget_set_rec;
347: EXIT WHEN pqh_worksheet_budget_sets_cur%NOTFOUND;
348:
349: -- get log_context
350: set_wst_log_context

Line 347: EXIT WHEN pqh_worksheet_budget_sets_cur%NOTFOUND;

343: -- open pqh_worksheet_budget_sets_cur
344: OPEN pqh_worksheet_budget_sets_cur(p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id);
345: LOOP -- loop 3
346: FETCH pqh_worksheet_budget_sets_cur INTO l_pqh_worksheet_budget_set_rec;
347: EXIT WHEN pqh_worksheet_budget_sets_cur%NOTFOUND;
348:
349: -- get log_context
350: set_wst_log_context
351: (

Line 440: CLOSE pqh_worksheet_budget_sets_cur;

436: END LOOP; -- loop 4
437: CLOSE pqh_worksheet_bdgt_elmnts_cur;
438:
439: END LOOP; -- loop 3
440: CLOSE pqh_worksheet_budget_sets_cur;
441:
442: END LOOP; -- loop 2
443: CLOSE pqh_worksheet_periods_cur;
444:

Line 603: -- table_route_id for pqh_worksheet_budget_sets

599: OPEN csr_table_route (p_table_alias => 'WPR');
600: FETCH csr_table_route INTO g_table_route_id_wpr;
601: CLOSE csr_table_route;
602:
603: -- table_route_id for pqh_worksheet_budget_sets
604: OPEN csr_table_route (p_table_alias => 'WST');
605: FETCH csr_table_route INTO g_table_route_id_wst;
606: CLOSE csr_table_route;
607:

Line 1256: FROM pqh_worksheet_budget_sets

1252: WHERE worksheet_detail_id = p_worksheet_detail_id;
1253:
1254: CURSOR csr_wks_bset_count IS
1255: SELECT COUNT(*)
1256: FROM pqh_worksheet_budget_sets
1257: WHERE worksheet_period_id = p_worksheet_period_id;
1258:
1259:
1260: BEGIN

Line 1420: p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE

1416:
1417: PROCEDURE check_wks_budget_sets
1418: (
1419: p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE,
1420: p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE
1421: ) IS
1422:
1423: /*
1424: This procedure will be called ONLY for Budgeted Worksheet records

Line 1432: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;

1428: its sum in the budget sets must be more then zero
1429: */
1430:
1431: l_proc varchar2(72) := g_package||'check_wks_budget_sets';
1432: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;
1433: l_message_text pqh_process_log.message_text%TYPE;
1434: l_message_text_out fnd_new_messages.message_text%TYPE;
1435: l_unit1_sum NUMBER;
1436: l_unit2_sum NUMBER;

Line 1450: FROM pqh_worksheet_budget_sets

1446: CURSOR csr_wks_budget_sets_value IS
1447: SELECT SUM(budget_unit1_value),
1448: SUM(budget_unit2_value),
1449: SUM(budget_unit3_value)
1450: FROM pqh_worksheet_budget_sets
1451: WHERE worksheet_period_id = p_worksheet_period_id;
1452:
1453: CURSOR csr_wks_worksheet_periods IS
1454: SELECT *

Line 1682: p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE,

1678:
1679:
1680: PROCEDURE check_wks_budget_elements
1681: (
1682: p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE,
1683: p_worksheet_bdgt_elmnt_id IN pqh_worksheet_fund_srcs.worksheet_bdgt_elmnt_id%TYPE
1684: ) IS
1685:
1686: /*

Line 2303: p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE,

2299:
2300:
2301: PROCEDURE set_wst_log_context
2302: (
2303: p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE,
2304: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2305: ) IS
2306:
2307: /*

Line 2316: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;

2312:
2313: */
2314:
2315: l_proc varchar2(72) := g_package||'set_wst_log_context';
2316: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;
2317: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;
2318:
2319:
2320: CURSOR csr_wks_budget_sets_rec IS

Line 2322: FROM pqh_worksheet_budget_sets

2318:
2319:
2320: CURSOR csr_wks_budget_sets_rec IS
2321: SELECT *
2322: FROM pqh_worksheet_budget_sets
2323: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
2324:
2325: CURSOR csr_dflt_budget_sets_rec ( p_dflt_budget_set_id IN number) IS
2326: SELECT *

Line 2388: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;

2384: l_proc varchar2(72) := g_package||'set_wel_log_context';
2385: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
2386: l_pay_element_types_rec pay_element_types%ROWTYPE;
2387:
2388: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;
2389: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;
2390:
2391:
2392:

Line 2405: FROM pqh_worksheet_budget_sets

2401: WHERE element_type_id = p_element_type_id;
2402:
2403: CURSOR csr_wks_budget_sets_rec(p_worksheet_budget_set_id IN number) IS
2404: SELECT *
2405: FROM pqh_worksheet_budget_sets
2406: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
2407:
2408: CURSOR csr_dflt_budget_sets_rec ( p_dflt_budget_set_id IN number) IS
2409: SELECT *