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_BDGT_ELMNTS

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 122: FROM pqh_worksheet_bdgt_elmnts

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:
125: CURSOR pqh_worksheet_fund_srcs_cur (p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE) IS
126: SELECT *

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

121: SELECT *
122: FROM pqh_worksheet_bdgt_elmnts
123: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
124:
125: CURSOR pqh_worksheet_fund_srcs_cur (p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE) IS
126: SELECT *
127: FROM pqh_worksheet_fund_srcs
128: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
129:

Line 141: l_pqh_worksheet_bdgt_elmnt_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;

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;
145: l_message_number_out fnd_new_messages.message_number%TYPE;

Line 373: -- open pqh_worksheet_bdgt_elmnts_cur

369: );
370:
371: -- For all elements current level = g_curr_wks_dtl_level + 3
372:
373: -- open pqh_worksheet_bdgt_elmnts_cur
374: OPEN pqh_worksheet_bdgt_elmnts_cur(p_worksheet_budget_set_id => l_pqh_worksheet_budget_set_rec.worksheet_budget_set_id);
375: LOOP -- loop 4
376: FETCH pqh_worksheet_bdgt_elmnts_cur INTO l_pqh_worksheet_bdgt_elmnt_rec;
377: EXIT WHEN pqh_worksheet_bdgt_elmnts_cur%NOTFOUND;

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

370:
371: -- For all elements current level = g_curr_wks_dtl_level + 3
372:
373: -- open pqh_worksheet_bdgt_elmnts_cur
374: OPEN pqh_worksheet_bdgt_elmnts_cur(p_worksheet_budget_set_id => l_pqh_worksheet_budget_set_rec.worksheet_budget_set_id);
375: LOOP -- loop 4
376: FETCH pqh_worksheet_bdgt_elmnts_cur INTO l_pqh_worksheet_bdgt_elmnt_rec;
377: EXIT WHEN pqh_worksheet_bdgt_elmnts_cur%NOTFOUND;
378:

Line 376: FETCH pqh_worksheet_bdgt_elmnts_cur INTO l_pqh_worksheet_bdgt_elmnt_rec;

372:
373: -- open pqh_worksheet_bdgt_elmnts_cur
374: OPEN pqh_worksheet_bdgt_elmnts_cur(p_worksheet_budget_set_id => l_pqh_worksheet_budget_set_rec.worksheet_budget_set_id);
375: LOOP -- loop 4
376: FETCH pqh_worksheet_bdgt_elmnts_cur INTO l_pqh_worksheet_bdgt_elmnt_rec;
377: EXIT WHEN pqh_worksheet_bdgt_elmnts_cur%NOTFOUND;
378:
379: -- get log_context
380: set_wel_log_context

Line 377: EXIT WHEN pqh_worksheet_bdgt_elmnts_cur%NOTFOUND;

373: -- open pqh_worksheet_bdgt_elmnts_cur
374: OPEN pqh_worksheet_bdgt_elmnts_cur(p_worksheet_budget_set_id => l_pqh_worksheet_budget_set_rec.worksheet_budget_set_id);
375: LOOP -- loop 4
376: FETCH pqh_worksheet_bdgt_elmnts_cur INTO l_pqh_worksheet_bdgt_elmnt_rec;
377: EXIT WHEN pqh_worksheet_bdgt_elmnts_cur%NOTFOUND;
378:
379: -- get log_context
380: set_wel_log_context
381: (

Line 437: CLOSE pqh_worksheet_bdgt_elmnts_cur;

433: END LOOP; -- loop 5
434: CLOSE pqh_worksheet_fund_srcs_cur;
435:
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:

Line 608: -- table_route_id for pqh_worksheet_bdgt_elmnts

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:
608: -- table_route_id for pqh_worksheet_bdgt_elmnts
609: OPEN csr_table_route (p_table_alias => 'WEL');
610: FETCH csr_table_route INTO g_table_route_id_wel;
611: CLOSE csr_table_route;
612:

Line 1693: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;

1689: and report all the errors
1690: */
1691:
1692: l_proc varchar2(72) := g_package||'check_wks_budget_elements';
1693: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
1694: l_message_text pqh_process_log.message_text%TYPE;
1695: l_message_text_out fnd_new_messages.message_text%TYPE;
1696: l_percentage_sum NUMBER;
1697: l_error_flag varchar2(10) := 'N';

Line 1705: FROM pqh_worksheet_bdgt_elmnts

1701:
1702:
1703: CURSOR csr_wks_budget_elements IS
1704: SELECT *
1705: FROM pqh_worksheet_bdgt_elmnts
1706: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
1707:
1708: CURSOR csr_wks_budget_elements_sum IS
1709: SELECT SUM(distribution_percentage)

Line 1710: FROM pqh_worksheet_bdgt_elmnts

1706: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
1707:
1708: CURSOR csr_wks_budget_elements_sum IS
1709: SELECT SUM(distribution_percentage)
1710: FROM pqh_worksheet_bdgt_elmnts
1711: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
1712:
1713:
1714: BEGIN

Line 2368: p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE,

2364:
2365:
2366: PROCEDURE set_wel_log_context
2367: (
2368: p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE,
2369: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2370: ) IS
2371:
2372: /*

Line 2385: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;

2381:
2382: */
2383:
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;

Line 2395: FROM pqh_worksheet_bdgt_elmnts

2391:
2392:
2393: CURSOR csr_wks_bdgt_elmnts_rec IS
2394: SELECT *
2395: FROM pqh_worksheet_bdgt_elmnts
2396: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
2397:
2398: CURSOR csr_pay_element_types_rec ( p_element_type_id IN number) IS
2399: SELECT *

Line 2484: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;

2480: l_proc varchar2(72) := g_package||'set_wfs_log_context';
2481: l_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
2482: l_pay_cost_allocation_kf_rec pay_cost_allocation_keyflex%ROWTYPE;
2483:
2484: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
2485: l_pay_element_types_rec pay_element_types%ROWTYPE;
2486:
2487:
2488:

Line 2501: FROM pqh_worksheet_bdgt_elmnts

2497: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
2498:
2499: CURSOR csr_wks_bdgt_elmnts_rec(p_worksheet_bdgt_elmnt_id IN number) IS
2500: SELECT *
2501: FROM pqh_worksheet_bdgt_elmnts
2502: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
2503:
2504: CURSOR csr_pay_element_types_rec ( p_element_type_id IN number) IS
2505: SELECT *