[Home] [Help]
913: --
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;
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
946: AND bpr.budget_detail_id = p_budget_detail_id
964: SUM((NVL(bfs.dflt_dist_percentage,0)*0.01)*(NVL(bel.dflt_dist_percentage,0)*0.01)*NVL(bst.budget_unit3_value,0)) Amount3
965: FROM pqh_dflt_fund_srcs bfs,
966: pqh_dflt_budget_elements bel,
967: pqh_budget_sets bst,
968: pqh_budget_periods bpr
969: WHERE bpr.budget_period_id = bst.budget_period_id
970: AND bst.dflt_budget_set_id = bel.dflt_budget_set_id
971: AND bel.dflt_budget_element_id = bfs.dflt_budget_element_id
972: AND bpr.budget_detail_id = p_budget_detail_id
2066:
2067: PROCEDURE get_gl_ccid
2068: (
2069: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
2070: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
2071: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,
2072: p_code_combination_id OUT NOCOPY gl_code_combinations.code_combination_id%TYPE
2073: ) IS
2074: /*
2352:
2353:
2354: PROCEDURE get_gl_period
2355: (
2356: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
2357: p_gl_period_statuses_rec OUT NOCOPY gl_period_statuses%ROWTYPE
2358: ) IS
2359: /*
2360: This procedure will return the period name corresponding to start_date between
2373: CURSOR csr_time_period IS
2374: SELECT start_date
2375: FROM per_time_periods
2376: WHERE time_period_id = ( SELECT start_time_period_id
2377: FROM pqh_budget_periods
2378: WHERE budget_period_id = p_budget_period_id );
2379:
2380: CURSOR csr_period_name( p_start_date IN DATE ) IS
2381: SELECT *
2664: END set_bdt_log_context;
2665: --------------------------------------------------------------------------------------------------------------
2666: PROCEDURE set_bpr_log_context
2667: (
2668: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
2669: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2670: ) IS
2671: /*
2672: This procedure will set the log_context at bpr periods level
2677:
2678: */
2679:
2680: l_proc varchar2(72) := g_package||'set_bpr_log_context';
2681: l_budget_periods_rec pqh_budget_periods%ROWTYPE;
2682: l_per_time_periods per_time_periods%ROWTYPE;
2683: l_start_date per_time_periods.start_date%TYPE;
2684: l_end_date per_time_periods.end_date%TYPE;
2685:
2684: l_end_date per_time_periods.end_date%TYPE;
2685:
2686: CURSOR csr_bpr_periods_rec IS
2687: SELECT *
2688: FROM pqh_budget_periods
2689: WHERE budget_period_id = p_budget_period_id ;
2690:
2691: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
2692: SELECT *
3804: --------------------------------------------------------------------------------------------------------------
3805: PROCEDURE get_element_link_defaults
3806: (
3807: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
3808: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE
3809: ) IS
3810: /*
3811: This procedure wil check if there are any defaults for the position and element in
3812: pay_element_links if the position id is not null at budget detail level. We would get the
3824: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;
3825:
3826: CURSOR csr_cost_allocation_keyflex_id IS
3827: SELECT cost_allocation_keyflex_id
3828: FROM pqh_budget_details bdt, pqh_budget_periods bpr,
3829: pqh_budget_sets bst, pqh_budget_elements bel,
3830: pay_element_links pel
3831: WHERE bdt.budget_detail_id = bpr.budget_detail_id
3832: AND bpr.budget_period_id = bst.budget_period_id
4186: PROCEDURE get_ccid_for_commitment(
4187: p_budget_id IN pqh_budgets.budget_id%type,
4188: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%TYPE,
4189: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
4190: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
4191: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,
4192: p_code_combination_id OUT NOCOPY gl_code_combinations.code_combination_id%TYPE) IS
4193: --
4194: l_code_combination_id gl_code_combinations.code_combination_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
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
4554: Select
4555: start_time_period_id,
4556: end_time_period_id
4557: From
4558: pqh_budget_periods
4559: Where
4560: budget_period_id = p_budget_period_id;
4561:
4562: Cursor csr_time_periods(p_time_period_id NUMBER)IS
4781: THEN
4782: DELETE from pqh_gms_excess
4783: WHERE budget_period_id in (Select budget_period_id
4784: From
4785: pqh_budget_periods bpr
4786: ,pqh_budget_details bdt
4787: Where bpr.budget_detail_id = bdt.budget_detail_id AND
4788: bdt.budget_version_id=g_budget_version_id);
4789: END IF;