[Home] [Help]
35:
36: FUNCTION GET_PRD_REALLOC_RESERVED_AMT
37: (
38: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
39: p_budget_unit_id IN pqh_budgets.budget_unit1_id%TYPE,
40: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE DEFAULT 'DD',
41: p_approval_status IN varchar2,
42: p_amount_type IN varchar2 ,
43: p_entity_type IN varchar2,
142:
143: FUNCTION GET_DTL_REALLOC_RESERVED_AMT
144: (
145: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
146: p_budget_unit_id IN pqh_budgets.budget_unit1_id%TYPE,
147: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE DEFAULT 'DD',
148: p_approval_status IN varchar2,
149: p_amount_type IN varchar2,
150: p_entity_type IN varchar2,
523: End GET_TRNX_LEVEL_RESERVED_AMT;
524: --
525: FUNCTION GET_LOCATION_CODE
526: (
527: p_entity_code IN pqh_budgets.budgeted_entity_cd%TYPE,
528: p_organization_id IN pqh_budget_details.organization_id%TYPE,
529: p_business_group_id IN hr_organization_units_v.business_group_id%TYPE
530: ) RETURN VARCHAR
531: IS
880: End apply_transaction;
881:
882: FUNCTION entity_id
883: ( p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
884: p_entity_type IN pqh_budgets.budgeted_entity_cd%TYPE
885: )RETURN NUMBER
886: IS
887: l_entity_id NUMBER :=0;
888: CURSOR csr_details
1411:
1412: --Added cursor by krmahade
1413: CURSOR csr_get_bdgt_start_dt IS
1414: select bgt.budget_start_date
1415: from pqh_budgets bgt,
1416: pqh_budget_versions bvr,
1417: pqh_budget_pools fld
1418: where fld.pool_id = p_transaction_id
1419: and fld.budget_version_id = bvr.budget_version_id