DBA Data[Home] [Help]

APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PQH_BUDGETS

Line 16: p_budget_unit_id IN pqh_budgets.budget_unit1_id%TYPE,

12: --
13: FUNCTION GET_PRD_REALLOC_RESERVED_AMT
14: (
15: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE Default NULL,
16: p_budget_unit_id IN pqh_budgets.budget_unit1_id%TYPE,
17: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE DEFAULT 'DD',
18: p_approval_status IN varchar2,
19: p_amount_type IN varchar2,
20: p_entity_type IN varchar2,

Line 41: p_budget_unit_id IN pqh_budgets.budget_unit1_id%TYPE,

37:
38: FUNCTION GET_DTL_REALLOC_RESERVED_AMT
39: (
40: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE default null,
41: p_budget_unit_id IN pqh_budgets.budget_unit1_id%TYPE,
42: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE DEFAULT 'DD',
43: p_approval_status IN varchar2,
44: p_amount_type IN varchar2,
45: p_entity_type IN varchar2,

Line 77: p_entity_code IN pqh_budgets.budgeted_entity_cd%TYPE,

73: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE DEFAULT 'DD'
74: ) RETURN NUMBER;
75: FUNCTION GET_LOCATION_CODE
76: (
77: p_entity_code IN pqh_budgets.budgeted_entity_cd%TYPE,
78: p_organization_id IN pqh_budget_details.organization_id%TYPE,
79: p_business_group_id IN hr_organization_units_v.business_group_id%TYPE
80: ) RETURN VARCHAR;
81:

Line 153: p_entity_type IN pqh_budgets.budgeted_entity_cd%TYPE

149: ) return varchar2;
150: --------------------------------------------------------------------------------
151: FUNCTION entity_id
152: ( p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
153: p_entity_type IN pqh_budgets.budgeted_entity_cd%TYPE
154: )RETURN NUMBER;
155: --------------------------------------------------------------------------------
156:
157: FUNCTION respond_notification( p_transaction_id in number) RETURN varchar2 ;