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
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');
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
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:
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');
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);
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: );
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: );
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
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);
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: );
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