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_FUND_SRCS

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

272: SELECT *
273: FROM pqh_worksheet_bdgt_elmnts
274: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
275:
276: CURSOR pqh_worksheet_fund_srcs_cur (p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE) IS
277: SELECT *
278: FROM pqh_worksheet_fund_srcs
279: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
280:

Line 278: FROM pqh_worksheet_fund_srcs

274: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
275:
276: CURSOR pqh_worksheet_fund_srcs_cur (p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE) IS
277: SELECT *
278: FROM pqh_worksheet_fund_srcs
279: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
280:
281: CURSOR current_version_cur (p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE ) IS
282: SELECT bvr.budget_version_id

Line 299: l_pqh_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;

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;
298: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;
299: l_pqh_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
300: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
301: l_curr_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
302: l_log_context pqh_process_log.log_context%TYPE;
303:

Line 465: -- open pqh_worksheet_fund_srcs_cur

461: p_budget_set_id => l_budget_set_id,
462: p_budget_element_id_o => l_budget_element_id
463: );
464:
465: -- open pqh_worksheet_fund_srcs_cur
466: OPEN pqh_worksheet_fund_srcs_cur(p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_bdgt_elmnt_rec.worksheet_bdgt_elmnt_id);
467: LOOP -- loop 6
468: FETCH pqh_worksheet_fund_srcs_cur INTO l_pqh_worksheet_fund_srcs_rec;
469: EXIT WHEN pqh_worksheet_fund_srcs_cur%NOTFOUND;

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

462: p_budget_element_id_o => l_budget_element_id
463: );
464:
465: -- open pqh_worksheet_fund_srcs_cur
466: OPEN pqh_worksheet_fund_srcs_cur(p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_bdgt_elmnt_rec.worksheet_bdgt_elmnt_id);
467: LOOP -- loop 6
468: FETCH pqh_worksheet_fund_srcs_cur INTO l_pqh_worksheet_fund_srcs_rec;
469: EXIT WHEN pqh_worksheet_fund_srcs_cur%NOTFOUND;
470:

Line 468: FETCH pqh_worksheet_fund_srcs_cur INTO l_pqh_worksheet_fund_srcs_rec;

464:
465: -- open pqh_worksheet_fund_srcs_cur
466: OPEN pqh_worksheet_fund_srcs_cur(p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_bdgt_elmnt_rec.worksheet_bdgt_elmnt_id);
467: LOOP -- loop 6
468: FETCH pqh_worksheet_fund_srcs_cur INTO l_pqh_worksheet_fund_srcs_rec;
469: EXIT WHEN pqh_worksheet_fund_srcs_cur%NOTFOUND;
470:
471: -- get log_context
472: set_wfs_log_context

Line 469: EXIT WHEN pqh_worksheet_fund_srcs_cur%NOTFOUND;

465: -- open pqh_worksheet_fund_srcs_cur
466: OPEN pqh_worksheet_fund_srcs_cur(p_worksheet_bdgt_elmnt_id => l_pqh_worksheet_bdgt_elmnt_rec.worksheet_bdgt_elmnt_id);
467: LOOP -- loop 6
468: FETCH pqh_worksheet_fund_srcs_cur INTO l_pqh_worksheet_fund_srcs_rec;
469: EXIT WHEN pqh_worksheet_fund_srcs_cur%NOTFOUND;
470:
471: -- get log_context
472: set_wfs_log_context
473: (

Line 474: p_worksheet_fund_src_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id,

470:
471: -- get log_context
472: set_wfs_log_context
473: (
474: p_worksheet_fund_src_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id,
475: p_log_context => l_log_context
476: );
477:
478: -- set the context

Line 481: p_txn_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id,

477:
478: -- set the context
479: pqh_process_batch_log.set_context_level
480: (
481: p_txn_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id,
482: p_txn_table_route_id => g_table_route_id_wfs,
483: p_level => 6,
484: p_log_context => l_log_context
485: );

Line 490: p_worksheet_fund_srcs_rec => l_pqh_worksheet_fund_srcs_rec,

486:
487: -- create records in pah_budget_fund_srcs
488: populate_budget_fund_srcs
489: (
490: p_worksheet_fund_srcs_rec => l_pqh_worksheet_fund_srcs_rec,
491: p_budget_element_id => l_budget_element_id,
492: p_budget_fund_src_id_o => l_budget_fund_src_id
493: );
494:

Line 497: CLOSE pqh_worksheet_fund_srcs_cur;

493: );
494:
495:
496: END LOOP; -- loop 6
497: CLOSE pqh_worksheet_fund_srcs_cur;
498:
499: END LOOP; -- loop 5
500: CLOSE pqh_worksheet_bdgt_elmnts_cur;
501:

Line 1139: p_worksheet_fund_srcs_rec IN pqh_worksheet_fund_srcs%ROWTYPE,

1135:
1136: --------------------------------------------------------------------------------------------------------------
1137: PROCEDURE populate_budget_fund_srcs
1138: (
1139: p_worksheet_fund_srcs_rec IN pqh_worksheet_fund_srcs%ROWTYPE,
1140: p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE,
1141: p_budget_fund_src_id_o OUT NOCOPY pqh_budget_fund_srcs.budget_fund_src_id%TYPE
1142: )
1143: IS

Line 2022: -- table_route_id for pqh_worksheet_fund_srcs

2018: OPEN csr_table_route (p_table_alias => 'WEL');
2019: FETCH csr_table_route INTO g_table_route_id_wel;
2020: CLOSE csr_table_route;
2021:
2022: -- table_route_id for pqh_worksheet_fund_srcs
2023: OPEN csr_table_route (p_table_alias => 'WFS');
2024: FETCH csr_table_route INTO g_table_route_id_wfs;
2025: CLOSE csr_table_route;
2026:

Line 2322: p_worksheet_fund_src_id IN pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE,

2318:
2319: --------------------------------------------------------------------------------------------------------------
2320: PROCEDURE set_wfs_log_context
2321: (
2322: p_worksheet_fund_src_id IN pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE,
2323: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2324: ) IS
2325:
2326: /*

Line 2335: l_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;

2331:
2332: */
2333:
2334: l_proc varchar2(72) := g_package||'set_wfs_log_context';
2335: l_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
2336: l_pay_cost_allocation_kf_rec pay_cost_allocation_keyflex%ROWTYPE;
2337:
2338:
2339: CURSOR csr_wks_bdgt_fund_srcs_rec IS

Line 2341: FROM pqh_worksheet_fund_srcs

2337:
2338:
2339: CURSOR csr_wks_bdgt_fund_srcs_rec IS
2340: SELECT *
2341: FROM pqh_worksheet_fund_srcs
2342: WHERE worksheet_fund_src_id = p_worksheet_fund_src_id;
2343:
2344: CURSOR csr_pay_cost_allocation_kf_rec ( p_cost_allocation_keyflex_id IN number) IS
2345: SELECT *