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_FUND_SRCS

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 127: FROM pqh_worksheet_fund_srcs

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:
130: CURSOR wks_detail_id_input_cur IS
131: SELECT *

Line 142: l_pqh_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%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;
146: l_log_context pqh_process_log.log_context%TYPE;

Line 403: -- open pqh_worksheet_fund_srcs_cur

399: );
400:
401: -- For all funding srcs current level = g_curr_wks_dtl_level + 4
402:
403: -- open pqh_worksheet_fund_srcs_cur
404: OPEN pqh_worksheet_fund_srcs_cur(p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_bdgt_elmnt_rec.worksheet_bdgt_elmnt_id);
405: LOOP -- loop 5
406: FETCH pqh_worksheet_fund_srcs_cur INTO l_pqh_worksheet_fund_srcs_rec;
407: EXIT WHEN pqh_worksheet_fund_srcs_cur%NOTFOUND;

Line 404: OPEN pqh_worksheet_fund_srcs_cur(p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_bdgt_elmnt_rec.worksheet_bdgt_elmnt_id);

400:
401: -- For all funding srcs current level = g_curr_wks_dtl_level + 4
402:
403: -- open pqh_worksheet_fund_srcs_cur
404: OPEN pqh_worksheet_fund_srcs_cur(p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_bdgt_elmnt_rec.worksheet_bdgt_elmnt_id);
405: LOOP -- loop 5
406: FETCH pqh_worksheet_fund_srcs_cur INTO l_pqh_worksheet_fund_srcs_rec;
407: EXIT WHEN pqh_worksheet_fund_srcs_cur%NOTFOUND;
408:

Line 406: FETCH pqh_worksheet_fund_srcs_cur INTO l_pqh_worksheet_fund_srcs_rec;

402:
403: -- open pqh_worksheet_fund_srcs_cur
404: OPEN pqh_worksheet_fund_srcs_cur(p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_bdgt_elmnt_rec.worksheet_bdgt_elmnt_id);
405: LOOP -- loop 5
406: FETCH pqh_worksheet_fund_srcs_cur INTO l_pqh_worksheet_fund_srcs_rec;
407: EXIT WHEN pqh_worksheet_fund_srcs_cur%NOTFOUND;
408:
409: -- get log_context
410: set_wfs_log_context

Line 407: EXIT WHEN pqh_worksheet_fund_srcs_cur%NOTFOUND;

403: -- open pqh_worksheet_fund_srcs_cur
404: OPEN pqh_worksheet_fund_srcs_cur(p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_bdgt_elmnt_rec.worksheet_bdgt_elmnt_id);
405: LOOP -- loop 5
406: FETCH pqh_worksheet_fund_srcs_cur INTO l_pqh_worksheet_fund_srcs_rec;
407: EXIT WHEN pqh_worksheet_fund_srcs_cur%NOTFOUND;
408:
409: -- get log_context
410: set_wfs_log_context
411: (

Line 412: p_worksheet_fund_src_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id,

408:
409: -- get log_context
410: set_wfs_log_context
411: (
412: p_worksheet_fund_src_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id,
413: p_log_context => l_log_context
414: );
415:
416:

Line 420: p_txn_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id,

416:
417: -- set the context
418: pqh_process_batch_log.set_context_level
419: (
420: p_txn_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id,
421: p_txn_table_route_id => g_table_route_id_wfs,
422: p_level => g_curr_wks_dtl_level + 4,
423: p_log_context => l_log_context
424: );

Line 428: p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_fund_srcs_rec.worksheet_bdgt_elmnt_id,

424: );
425:
426: check_wks_fund_srcs
427: (
428: p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_fund_srcs_rec.worksheet_bdgt_elmnt_id,
429: p_worksheet_fund_src_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id
430: );
431:
432:

Line 429: p_worksheet_fund_src_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id

425:
426: check_wks_fund_srcs
427: (
428: p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_fund_srcs_rec.worksheet_bdgt_elmnt_id,
429: p_worksheet_fund_src_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id
430: );
431:
432:
433: END LOOP; -- loop 5

Line 434: CLOSE pqh_worksheet_fund_srcs_cur;

430: );
431:
432:
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:

Line 613: -- table_route_id for pqh_worksheet_fund_srcs

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:
613: -- table_route_id for pqh_worksheet_fund_srcs
614: OPEN csr_table_route (p_table_alias => 'WFS');
615: FETCH csr_table_route INTO g_table_route_id_wfs;
616: CLOSE csr_table_route;
617:

Line 1683: p_worksheet_bdgt_elmnt_id IN pqh_worksheet_fund_srcs.worksheet_bdgt_elmnt_id%TYPE

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: /*
1687: This procedure will be called ONLY for Budgeted Worksheet records

Line 1903: p_worksheet_bdgt_elmnt_id IN pqh_worksheet_fund_srcs.worksheet_bdgt_elmnt_id%TYPE,

1899:
1900:
1901: PROCEDURE check_wks_fund_srcs
1902: (
1903: p_worksheet_bdgt_elmnt_id IN pqh_worksheet_fund_srcs.worksheet_bdgt_elmnt_id%TYPE,
1904: p_worksheet_fund_src_id IN pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE
1905: ) IS
1906:
1907: /*

Line 1904: p_worksheet_fund_src_id IN pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE

1900:
1901: PROCEDURE check_wks_fund_srcs
1902: (
1903: p_worksheet_bdgt_elmnt_id IN pqh_worksheet_fund_srcs.worksheet_bdgt_elmnt_id%TYPE,
1904: p_worksheet_fund_src_id IN pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE
1905: ) IS
1906:
1907: /*
1908: This procedure will be called ONLY for Budgeted Worksheet records

Line 1914: l_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;

1910: and report all the errors
1911: */
1912:
1913: l_proc varchar2(72) := g_package||'check_wks_fund_srcs';
1914: l_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
1915: l_message_text pqh_process_log.message_text%TYPE;
1916: l_message_text_out fnd_new_messages.message_text%TYPE;
1917: l_percentage_sum NUMBER;
1918: l_error_flag varchar2(10) := 'N';

Line 1925: FROM pqh_worksheet_fund_srcs

1921:
1922:
1923: CURSOR csr_wks_fund_srcs IS
1924: SELECT *
1925: FROM pqh_worksheet_fund_srcs
1926: WHERE worksheet_fund_src_id = p_worksheet_fund_src_id;
1927:
1928: CURSOR csr_wks_fund_srcs_sum IS
1929: SELECT SUM(distribution_percentage)

Line 1930: FROM pqh_worksheet_fund_srcs

1926: WHERE worksheet_fund_src_id = p_worksheet_fund_src_id;
1927:
1928: CURSOR csr_wks_fund_srcs_sum IS
1929: SELECT SUM(distribution_percentage)
1930: FROM pqh_worksheet_fund_srcs
1931: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
1932:
1933:
1934: BEGIN

Line 2465: p_worksheet_fund_src_id IN pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE,

2461:
2462:
2463: PROCEDURE set_wfs_log_context
2464: (
2465: p_worksheet_fund_src_id IN pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE,
2466: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2467: ) IS
2468:
2469: /*

Line 2481: l_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;

2477:
2478: */
2479:
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;

Line 2491: FROM pqh_worksheet_fund_srcs

2487:
2488:
2489: CURSOR csr_wks_bdgt_fund_srcs_rec IS
2490: SELECT *
2491: FROM pqh_worksheet_fund_srcs
2492: WHERE worksheet_fund_src_id = p_worksheet_fund_src_id;
2493:
2494: CURSOR csr_pay_cost_allocation_kf_rec ( p_cost_allocation_keyflex_id IN number) IS
2495: SELECT *