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_PERIODS

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

106: FROM pqh_worksheet_details wdt
107: START WITH worksheet_detail_id = p_worksheet_detail_id
108: CONNECT BY prior worksheet_detail_id = parent_worksheet_detail_id ;
109:
110: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE) IS
111: SELECT *
112: FROM pqh_worksheet_periods
113: WHERE worksheet_detail_id = p_worksheet_detail_id;
114:

Line 112: FROM pqh_worksheet_periods

108: CONNECT BY prior worksheet_detail_id = parent_worksheet_detail_id ;
109:
110: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_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 *

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

135:
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;

Line 313: -- open pqh_worksheet_periods_cur

309: g_context_organization_id := get_organization_id(p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id);
310: -- For app periods level = g_curr_wks_dtl_level + 1
311:
312:
313: -- open pqh_worksheet_periods_cur
314: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id);
315: LOOP -- loop 2
316: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;
317: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;

Line 314: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id);

310: -- For app periods level = g_curr_wks_dtl_level + 1
311:
312:
313: -- open pqh_worksheet_periods_cur
314: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id);
315: LOOP -- loop 2
316: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;
317: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;
318:

Line 316: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;

312:
313: -- open pqh_worksheet_periods_cur
314: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id);
315: LOOP -- loop 2
316: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;
317: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;
318:
319: -- get log_context
320: set_wpr_log_context

Line 317: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;

313: -- open pqh_worksheet_periods_cur
314: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_c_rec.worksheet_detail_id);
315: LOOP -- loop 2
316: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;
317: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;
318:
319: -- get log_context
320: set_wpr_log_context
321: (

Line 322: p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id,

318:
319: -- get log_context
320: set_wpr_log_context
321: (
322: p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id,
323: p_log_context => l_log_context
324: );
325:
326: -- set the context

Line 329: p_txn_id => l_pqh_worksheet_periods_rec.worksheet_period_id,

325:
326: -- set the context
327: pqh_process_batch_log.set_context_level
328: (
329: p_txn_id => l_pqh_worksheet_periods_rec.worksheet_period_id,
330: p_txn_table_route_id => g_table_route_id_wpr,
331: p_level => g_curr_wks_dtl_level + 1,
332: p_log_context => l_log_context
333: );

Line 337: p_worksheet_detail_id => l_pqh_worksheet_periods_rec.worksheet_detail_id,

333: );
334:
335: check_wks_periods
336: (
337: p_worksheet_detail_id => l_pqh_worksheet_periods_rec.worksheet_detail_id,
338: p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id
339: );
340:
341: -- For all budget sets , current level = g_curr_wks_dtl_level + 2

Line 338: p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id

334:
335: check_wks_periods
336: (
337: p_worksheet_detail_id => l_pqh_worksheet_periods_rec.worksheet_detail_id,
338: p_worksheet_period_id => l_pqh_worksheet_periods_rec.worksheet_period_id
339: );
340:
341: -- For all budget sets , current level = g_curr_wks_dtl_level + 2
342:

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

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:
445: END LOOP; -- loop 1
446: CLOSE pqh_worksheet_details_cur;
447:

Line 598: -- table_route_id for pqh_worksheet_periods

594: OPEN csr_table_route (p_table_alias => 'WDT');
595: FETCH csr_table_route INTO g_table_route_id_wdt;
596: CLOSE csr_table_route;
597:
598: -- table_route_id for pqh_worksheet_periods
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:

Line 892: FROM pqh_worksheet_periods

888: WHERE worksheet_detail_id = p_worksheet_detail_id;
889:
890: CURSOR csr_wks_periods_count IS
891: SELECT COUNT(*)
892: FROM pqh_worksheet_periods
893: WHERE worksheet_detail_id = p_worksheet_detail_id;
894:
895: CURSOR csr_pos_availability(p_position_id l_worksheet_details_rec.position_id%type,
896: p_worksheet_id l_worksheet_details_rec.worksheet_id%type) IS

Line 1225: p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE

1221:
1222: PROCEDURE check_wks_periods
1223: (
1224: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,
1225: p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE
1226: ) IS
1227:
1228: /*
1229: This procedure will be called ONLY for Budgeted Worksheet records

Line 1235: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;

1231: and report all the errors
1232: */
1233:
1234: l_proc varchar2(72) := g_package||'check_wks_periods';
1235: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
1236: l_message_text pqh_process_log.message_text%TYPE;
1237: l_message_text_out fnd_new_messages.message_text%TYPE;
1238: l_count NUMBER;
1239: l_error_flag varchar2(10) := 'N';

Line 1246: FROM pqh_worksheet_periods

1242:
1243:
1244: CURSOR csr_wks_periods IS
1245: SELECT *
1246: FROM pqh_worksheet_periods
1247: WHERE worksheet_period_id = p_worksheet_period_id;
1248:
1249: CURSOR csr_wks_periods_count IS
1250: SELECT COUNT(*)

Line 1251: FROM pqh_worksheet_periods

1247: WHERE worksheet_period_id = p_worksheet_period_id;
1248:
1249: CURSOR csr_wks_periods_count IS
1250: SELECT COUNT(*)
1251: FROM pqh_worksheet_periods
1252: WHERE worksheet_detail_id = p_worksheet_detail_id;
1253:
1254: CURSOR csr_wks_bset_count IS
1255: SELECT COUNT(*)

Line 1419: p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE,

1415:
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: /*

Line 1438: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;

1434: l_message_text_out fnd_new_messages.message_text%TYPE;
1435: l_unit1_sum NUMBER;
1436: l_unit2_sum NUMBER;
1437: l_unit3_sum NUMBER;
1438: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
1439: l_message_type varchar2(10) := 'E';
1440: l_warnings_rec pqh_utility.warnings_rec;
1441:
1442:

Line 1455: FROM pqh_worksheet_periods

1451: WHERE worksheet_period_id = p_worksheet_period_id;
1452:
1453: CURSOR csr_wks_worksheet_periods IS
1454: SELECT *
1455: FROM pqh_worksheet_periods
1456: WHERE worksheet_period_id = p_worksheet_period_id;
1457:
1458:
1459: BEGIN

Line 2222: p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE,

2218:
2219:
2220: PROCEDURE set_wpr_log_context
2221: (
2222: p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE,
2223: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2224: ) IS
2225: /*
2226: This procedure will set the log_context at wks periods level

Line 2235: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;

2231:
2232: */
2233:
2234: l_proc varchar2(72) := g_package||'set_wpr_log_context';
2235: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
2236: l_per_time_periods per_time_periods%ROWTYPE;
2237: l_start_date per_time_periods.start_date%TYPE;
2238: l_end_date per_time_periods.end_date%TYPE;
2239:

Line 2242: FROM pqh_worksheet_periods

2238: l_end_date per_time_periods.end_date%TYPE;
2239:
2240: CURSOR csr_wks_periods_rec IS
2241: SELECT *
2242: FROM pqh_worksheet_periods
2243: WHERE worksheet_period_id = p_worksheet_period_id ;
2244:
2245: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
2246: SELECT *

Line 2592: FROM pqh_worksheet_periods

2588: WHERE worksheet_detail_id = p_worksheet_detail_id;
2589:
2590: CURSOR csr_wks_periods_count IS
2591: SELECT COUNT(*)
2592: FROM pqh_worksheet_periods
2593: WHERE worksheet_detail_id = p_worksheet_detail_id;
2594:
2595: CURSOR csr_budget_count IS
2596: SELECT COUNT(*)