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_GL_POSTING dependencies on PQH_BUDGET_FUND_SRCS

Line 831: -- get the table route id for pqh_budget fund srcs

827: OPEN csr_table_route(p_table_alias => 'BPR');
828: FETCH csr_table_route INTO g_table_route_id_bpr;
829: CLOSE csr_table_route;
830:
831: -- get the table route id for pqh_budget fund srcs
832: OPEN csr_table_route(p_table_alias => 'BFS');
833: FETCH csr_table_route INTO g_table_route_id_bfs;
834: CLOSE csr_table_route;
835:

Line 918: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;

914: -- local variables
915: --
916: l_proc varchar2(72) := g_package||'.populate_period_amt_tab';
917: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
918: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
919: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
920: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
921: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
922: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;

Line 919: l_project_id pqh_budget_fund_srcs.project_id%TYPE;

915: --
916: l_proc varchar2(72) := g_package||'.populate_period_amt_tab';
917: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
918: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
919: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
920: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
921: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
922: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
923: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;

Line 920: l_award_id pqh_budget_fund_srcs.award_id%TYPE;

916: l_proc varchar2(72) := g_package||'.populate_period_amt_tab';
917: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
918: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
919: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
920: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
921: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
922: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
923: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;
924: l_amount1 NUMBER;

Line 921: l_task_id pqh_budget_fund_srcs.task_id%TYPE;

917: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
918: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
919: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
920: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
921: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
922: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
923: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;
924: l_amount1 NUMBER;
925: l_amount2 NUMBER;

Line 922: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;

918: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
919: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
920: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
921: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
922: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
923: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;
924: l_amount1 NUMBER;
925: l_amount2 NUMBER;
926: l_amount3 NUMBER;

Line 923: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;

919: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
920: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
921: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
922: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
923: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;
924: l_amount1 NUMBER;
925: l_amount2 NUMBER;
926: l_amount3 NUMBER;
927: i BINARY_INTEGER :=1;

Line 941: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,

937: bfs.organization_id,
938: SUM(pqh_gl_posting.get_amt1(bfs.budget_fund_src_id)) Amount1,
939: SUM(pqh_gl_posting.get_amt2(bfs.budget_fund_src_id)) Amount2,
940: SUM(pqh_gl_posting.get_amt3(bfs.budget_fund_src_id)) Amount3
941: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,
942: pqh_budget_sets bst, pqh_budget_periods bpr
943: WHERE bpr.budget_period_id = bst.budget_period_id
944: AND bst.budget_set_id = bel.budget_set_id
945: AND bel.budget_element_id = bfs.budget_element_id

Line 2420: FUNCTION get_amt1 ( p_budget_fund_src_id IN pqh_budget_fund_srcs.budget_fund_src_id%TYPE )

2416: hr_utility.raise_error;
2417: END get_gl_period;
2418:
2419: -- ----------------------------------------------------------------------------
2420: FUNCTION get_amt1 ( p_budget_fund_src_id IN pqh_budget_fund_srcs.budget_fund_src_id%TYPE )
2421: RETURN NUMBER IS
2422: /*
2423: This function will copmute the amout1 for UOM1
2424: */

Line 2428: l_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;

2424: */
2425:
2426:
2427: l_proc varchar2(72) := g_package||'.get_amt1';
2428: l_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;
2429: l_budget_elements_rec pqh_budget_elements%ROWTYPE;
2430: l_budget_sets_rec pqh_budget_sets%ROWTYPE;
2431: l_amount1 pqh_budget_sets.budget_unit1_value%TYPE;
2432:

Line 2437: FROM pqh_budget_fund_srcs srcs,

2433: CURSOR csr_bdgt_amt IS
2434: SELECT (NVL(srcs.distribution_percentage,0) * .01) *
2435: (NVL(elem.distribution_percentage,0) * .01) *
2436: NVL(sets.budget_unit1_value,0)
2437: FROM pqh_budget_fund_srcs srcs,
2438: pqh_budget_elements elem,
2439: pqh_budget_sets sets
2440: WHERE srcs.budget_fund_src_id = p_budget_fund_src_id
2441: AND elem.budget_element_id = srcs.budget_element_id

Line 2469: FUNCTION get_amt2 ( p_budget_fund_src_id IN pqh_budget_fund_srcs.budget_fund_src_id%TYPE )

2465: hr_utility.raise_error;
2466: END get_amt1;
2467:
2468: -- ----------------------------------------------------------------------------
2469: FUNCTION get_amt2 ( p_budget_fund_src_id IN pqh_budget_fund_srcs.budget_fund_src_id%TYPE )
2470: RETURN NUMBER IS
2471: /*
2472: This function will copmute the amout1 for UOM2
2473: */

Line 2477: l_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;

2473: */
2474:
2475:
2476: l_proc varchar2(72) := g_package||'.get_amt2';
2477: l_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;
2478: l_budget_elements_rec pqh_budget_elements%ROWTYPE;
2479: l_budget_sets_rec pqh_budget_sets%ROWTYPE;
2480: l_amount2 pqh_budget_sets.budget_unit2_value%TYPE;
2481:

Line 2486: FROM pqh_budget_fund_srcs srcs,

2482: CURSOR csr_bdgt_amt IS
2483: SELECT (NVL(srcs.distribution_percentage,0) * .01) *
2484: (NVL(elem.distribution_percentage,0) * .01) *
2485: NVL(sets.budget_unit2_value,0)
2486: FROM pqh_budget_fund_srcs srcs,
2487: pqh_budget_elements elem,
2488: pqh_budget_sets sets
2489: WHERE srcs.budget_fund_src_id = p_budget_fund_src_id
2490: AND elem.budget_element_id = srcs.budget_element_id

Line 2520: FUNCTION get_amt3 ( p_budget_fund_src_id IN pqh_budget_fund_srcs.budget_fund_src_id%TYPE )

2516:
2517:
2518:
2519: -- ----------------------------------------------------------------------------
2520: FUNCTION get_amt3 ( p_budget_fund_src_id IN pqh_budget_fund_srcs.budget_fund_src_id%TYPE )
2521: RETURN NUMBER IS
2522: /*
2523: This function will copmute the amout1 for UOM3
2524: */

Line 2528: l_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;

2524: */
2525:
2526:
2527: l_proc varchar2(72) := g_package||'.get_amt3';
2528: l_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;
2529: l_budget_elements_rec pqh_budget_elements%ROWTYPE;
2530: l_budget_sets_rec pqh_budget_sets%ROWTYPE;
2531: l_amount3 pqh_budget_sets.budget_unit3_value%TYPE;
2532:

Line 2537: FROM pqh_budget_fund_srcs srcs,

2533: CURSOR csr_bdgt_amt IS
2534: SELECT (NVL(srcs.distribution_percentage,0) * .01) *
2535: (NVL(elem.distribution_percentage,0) * .01) *
2536: NVL(sets.budget_unit3_value,0)
2537: FROM pqh_budget_fund_srcs srcs,
2538: pqh_budget_elements elem,
2539: pqh_budget_sets sets
2540: WHERE srcs.budget_fund_src_id = p_budget_fund_src_id
2541: AND elem.budget_element_id = srcs.budget_element_id

Line 4374: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;

4370: This function will determine whether the budget has details or not
4371: If the budget has details return 'Y' else 'N'
4372:
4373: */
4374: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
4375: l_result varchar2(30);
4376:
4377: CURSOR csr_budget_details (p_budget_version_id IN number )IS
4378: SELECT bfs.budget_fund_src_id

Line 4379: FROM pqh_budget_details bdt, pqh_budget_periods bpr, pqh_budget_sets bst, pqh_budget_elements bel, pqh_budget_fund_srcs bfs

4375: l_result varchar2(30);
4376:
4377: CURSOR csr_budget_details (p_budget_version_id IN number )IS
4378: SELECT bfs.budget_fund_src_id
4379: FROM pqh_budget_details bdt, pqh_budget_periods bpr, pqh_budget_sets bst, pqh_budget_elements bel, pqh_budget_fund_srcs bfs
4380: WHERE bdt.budget_version_id = p_budget_version_id
4381: and bdt.budget_detail_id = bpr.budget_detail_id
4382: and bpr.budget_period_id = bst.budget_period_id
4383: and bst.budget_set_id = bel.budget_set_id