APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PQH_BUDGET_POOLS

Line 10: p_entity_type IN pqh_budget_pools.entity_type%TYPE

6: -- ----------------------------------------------------------------------------
7: FUNCTION get_entity_name
8: (
9: p_entity_id IN pqh_bdgt_pool_realloctions.entity_id%TYPE,
10: p_entity_type IN pqh_budget_pools.entity_type%TYPE
11: ) RETURN VARCHAR;
12: --
13: FUNCTION GET_PRD_REALLOC_RESERVED_AMT
14: (

Line 35: p_folder_id IN pqh_budget_pools.pool_id%TYPE

31: ) RETURN NUMBER;
32:
33: FUNCTION GET_FOLDER_LEVEL_TRANS_AMT
34: (
35: p_folder_id IN pqh_budget_pools.pool_id%TYPE
36: ) RETURN NUMBER;
37:
38: FUNCTION GET_DTL_REALLOC_RESERVED_AMT
39: (

Line 66: p_budget_version_id IN pqh_budget_pools.budget_version_id%TYPE,

62: p_detail_id OUT NOCOPY pqh_bdgt_pool_realloctions.reallocation_id%TYPE
63: );
64: FUNCTION CHK_APPROVED_FOLDER
65: (
66: p_budget_version_id IN pqh_budget_pools.budget_version_id%TYPE,
67: p_budget_unit_id IN pqh_budget_pools.budget_unit_id%TYPE,
68: p_entity_type IN pqh_budget_pools.entity_type%TYPE,
69: p_approval_status IN pqh_budget_pools.approval_status%Type) RETURN NUMBER;
70: FUNCTION GET_TRNX_LEVEL_RESERVED_AMT

Line 67: p_budget_unit_id IN pqh_budget_pools.budget_unit_id%TYPE,

63: );
64: FUNCTION CHK_APPROVED_FOLDER
65: (
66: p_budget_version_id IN pqh_budget_pools.budget_version_id%TYPE,
67: p_budget_unit_id IN pqh_budget_pools.budget_unit_id%TYPE,
68: p_entity_type IN pqh_budget_pools.entity_type%TYPE,
69: p_approval_status IN pqh_budget_pools.approval_status%Type) RETURN NUMBER;
70: FUNCTION GET_TRNX_LEVEL_RESERVED_AMT
71: (

Line 68: p_entity_type IN pqh_budget_pools.entity_type%TYPE,

64: FUNCTION CHK_APPROVED_FOLDER
65: (
66: p_budget_version_id IN pqh_budget_pools.budget_version_id%TYPE,
67: p_budget_unit_id IN pqh_budget_pools.budget_unit_id%TYPE,
68: p_entity_type IN pqh_budget_pools.entity_type%TYPE,
69: p_approval_status IN pqh_budget_pools.approval_status%Type) RETURN NUMBER;
70: FUNCTION GET_TRNX_LEVEL_RESERVED_AMT
71: (
72: p_transaction_id IN pqh_bdgt_pool_realloctions.reallocation_id%TYPE,

Line 69: p_approval_status IN pqh_budget_pools.approval_status%Type) RETURN NUMBER;

65: (
66: p_budget_version_id IN pqh_budget_pools.budget_version_id%TYPE,
67: p_budget_unit_id IN pqh_budget_pools.budget_unit_id%TYPE,
68: p_entity_type IN pqh_budget_pools.entity_type%TYPE,
69: p_approval_status IN pqh_budget_pools.approval_status%Type) RETURN NUMBER;
70: FUNCTION GET_TRNX_LEVEL_RESERVED_AMT
71: (
72: p_transaction_id IN pqh_bdgt_pool_realloctions.reallocation_id%TYPE,
73: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE DEFAULT 'DD'