APPS.PQH_BUDGET_POOLS_SWI dependencies on PQH_BDGT_POOL_REALLOCTIONS

Line 24: from pqh_bdgt_pool_realloctions

20:
21: */
22: cursor csr_bdgt_trnx_amt is
23: select reallocation_id, object_version_number
24: from pqh_bdgt_pool_realloctions
25: where reallocation_id = p_bdgt_trnx_amount_id
26: and transaction_type = p_transaction_type;
27:
28: cursor csr_receiver_prd_count is

Line 30: from pqh_bdgt_pool_realloctions

26: and transaction_type = p_transaction_type;
27:
28: cursor csr_receiver_prd_count is
29: select nvl(count(reallocation_id),0)
30: from pqh_bdgt_pool_realloctions
31: where txn_detail_id in (select txn_detail_id
32: from pqh_bdgt_pool_realloctions
33: where reallocation_id = p_bdgt_trnx_amount_id
34: and transaction_type = 'RD');

Line 32: from pqh_bdgt_pool_realloctions

28: cursor csr_receiver_prd_count is
29: select nvl(count(reallocation_id),0)
30: from pqh_bdgt_pool_realloctions
31: where txn_detail_id in (select txn_detail_id
32: from pqh_bdgt_pool_realloctions
33: where reallocation_id = p_bdgt_trnx_amount_id
34: and transaction_type = 'RD');
35: /* Modified by mvanakda
36: Bug No : 2924364

Line 44: from pqh_bdgt_pool_realloctions

40: */
41: /* mvankada
42: cursor csr_receiver_id is
43: select txn_detail_id, object_version_number
44: from pqh_bdgt_pool_realloctions
45: where reallocation_id = p_bdgt_trnx_amount_id
46: and transaction_type = 'RD';
47: */
48:

Line 51: from pqh_bdgt_pool_realloctions

47: */
48:
49: cursor csr_receiver_id is
50: select reallocation_id, object_version_number
51: from pqh_bdgt_pool_realloctions
52: where reallocation_id in ( select TXN_DETAIL_ID
53: from pqh_bdgt_pool_realloctions
54: where reallocation_id = p_bdgt_trnx_amount_id
55: and transaction_type = 'RD');

Line 53: from pqh_bdgt_pool_realloctions

49: cursor csr_receiver_id is
50: select reallocation_id, object_version_number
51: from pqh_bdgt_pool_realloctions
52: where reallocation_id in ( select TXN_DETAIL_ID
53: from pqh_bdgt_pool_realloctions
54: where reallocation_id = p_bdgt_trnx_amount_id
55: and transaction_type = 'RD');
56:
57: l_ovn number(15);

Line 91: pqh_bdgt_pool_realloctions_api.delete_realloc_txn_period

87: --
88: -- Added IF condition to call delete API only when there is a row for the ID passed
89: --
90: IF l_bdgt_trnx_amount_id IS NOT NULL THEN
91: pqh_bdgt_pool_realloctions_api.delete_realloc_txn_period
92: (p_validate => false
93: ,p_reallocation_period_id => l_bdgt_trnx_amount_id
94: ,p_object_version_number => l_ovn
95: );

Line 98: pqh_bdgt_pool_realloctions_api.delete_realloc_txn_dtl

94: ,p_object_version_number => l_ovn
95: );
96: END IF;
97: If (p_transaction_type = 'RD') and (l_count = 1) then
98: pqh_bdgt_pool_realloctions_api.delete_realloc_txn_dtl
99: ( p_validate => false
100: ,p_txn_detail_id => l_receiver_id
101: ,p_object_version_number => l_receiver_ovn
102: );

Line 120: from pqh_bdgt_pool_realloctions

116: */
117:
118: cursor csr_donor_receiver_details is
119: select reallocation_id,transaction_type
120: from pqh_bdgt_pool_realloctions
121: where txn_detail_id = p_bdgt_trnx_detail_id;
122:
123: cursor csr_bdgt_trnx_dtl is
124: select reallocation_id,object_version_number

Line 125: from pqh_bdgt_pool_realloctions

121: where txn_detail_id = p_bdgt_trnx_detail_id;
122:
123: cursor csr_bdgt_trnx_dtl is
124: select reallocation_id,object_version_number
125: from pqh_bdgt_pool_realloctions
126: where reallocation_id = p_bdgt_trnx_detail_id
127: and transaction_type = p_transaction_type;
128:
129: l_ovn number(15);

Line 161: pqh_bdgt_pool_realloctions_api.delete_realloc_txn_dtl

157: close csr_bdgt_trnx_dtl;
158: hr_utility.set_location(' l_bdgt_trnx_detail_id :' || l_bdgt_trnx_detail_id ,25);
159: if l_bdgt_trnx_detail_id is not null then
160:
161: pqh_bdgt_pool_realloctions_api.delete_realloc_txn_dtl
162: ( p_validate => false
163: ,p_txn_detail_id => l_bdgt_trnx_detail_id
164: ,p_object_version_number => l_ovn
165: );

Line 181: from pqh_bdgt_pool_realloctions

177: */
178:
179: cursor csr_bdgt_trnx_details is
180: select reallocation_id ,transaction_type
181: from pqh_bdgt_pool_realloctions
182: where pool_id = p_transaction_id;
183:
184: cursor csr_bdgt_transaction is
185: select pool_id,object_version_number