APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PQH_BDGT_POOL_REALLOCTIONS

Line 9: p_entity_id IN pqh_bdgt_pool_realloctions.entity_id%TYPE,

5: -- | Global Record Type Specification |
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

Line 17: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE DEFAULT 'DD',

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,
21: p_entity_id IN number DEFAULT NULL,

Line 29: p_transaction_id IN pqh_bdgt_pool_realloctions.reallocation_id%TYPE,

25: ) RETURN NUMBER;
26:
27: FUNCTION GET_TRNX_LEVEL_TRANS_AMT
28: (
29: p_transaction_id IN pqh_bdgt_pool_realloctions.reallocation_id%TYPE,
30: p_txn_amt_balance_flag IN varchar2
31: ) RETURN NUMBER;
32:
33: FUNCTION GET_FOLDER_LEVEL_TRANS_AMT

Line 42: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE DEFAULT 'DD',

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,
46: p_entity_id IN number default null,

Line 55: p_transaction_id IN pqh_bdgt_pool_realloctions.reallocation_id%TYPE,

51: RETURN NUMBER;
52:
53: FUNCTION GET_TRNX_DNR_REVR_COUNT
54: (
55: p_transaction_id IN pqh_bdgt_pool_realloctions.reallocation_id%TYPE,
56: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE
57: ) RETURN NUMBER;
58: PROCEDURE CHK_RECV_EXISTS
59: (

Line 56: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE

52:
53: FUNCTION GET_TRNX_DNR_REVR_COUNT
54: (
55: p_transaction_id IN pqh_bdgt_pool_realloctions.reallocation_id%TYPE,
56: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE
57: ) RETURN NUMBER;
58: PROCEDURE CHK_RECV_EXISTS
59: (
60: p_trans_id IN pqh_bdgt_pool_realloctions.pool_id%TYPE,

Line 60: p_trans_id IN pqh_bdgt_pool_realloctions.pool_id%TYPE,

56: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE
57: ) RETURN NUMBER;
58: PROCEDURE CHK_RECV_EXISTS
59: (
60: p_trans_id IN pqh_bdgt_pool_realloctions.pool_id%TYPE,
61: p_entity_id IN pqh_bdgt_pool_realloctions.entity_id%TYPE,
62: p_detail_id OUT NOCOPY pqh_bdgt_pool_realloctions.reallocation_id%TYPE
63: );
64: FUNCTION CHK_APPROVED_FOLDER

Line 61: p_entity_id IN pqh_bdgt_pool_realloctions.entity_id%TYPE,

57: ) RETURN NUMBER;
58: PROCEDURE CHK_RECV_EXISTS
59: (
60: p_trans_id IN pqh_bdgt_pool_realloctions.pool_id%TYPE,
61: p_entity_id IN pqh_bdgt_pool_realloctions.entity_id%TYPE,
62: p_detail_id OUT NOCOPY pqh_bdgt_pool_realloctions.reallocation_id%TYPE
63: );
64: FUNCTION CHK_APPROVED_FOLDER
65: (

Line 62: p_detail_id OUT NOCOPY pqh_bdgt_pool_realloctions.reallocation_id%TYPE

58: PROCEDURE CHK_RECV_EXISTS
59: (
60: p_trans_id IN pqh_bdgt_pool_realloctions.pool_id%TYPE,
61: p_entity_id IN pqh_bdgt_pool_realloctions.entity_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,

Line 72: p_transaction_id IN pqh_bdgt_pool_realloctions.reallocation_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'
74: ) RETURN NUMBER;
75: FUNCTION GET_LOCATION_CODE
76: (

Line 73: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE DEFAULT 'DD'

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'
74: ) RETURN NUMBER;
75: FUNCTION GET_LOCATION_CODE
76: (
77: p_entity_code IN pqh_budgets.budgeted_entity_cd%TYPE,