eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BRE_DEL dependencies on PQH_BRE_SHD

Line 52: (p_rec in pqh_bre_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in pqh_bre_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 60: pqh_bre_shd.g_api_dml := true; -- Set the api dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: pqh_bre_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pqh_bdgt_pool_realloctions row.
63: --
64: delete from pqh_bdgt_pool_realloctions

Line 67: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from pqh_bdgt_pool_realloctions
65: where reallocation_id = p_rec.reallocation_id;
66: --
67: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

Line 74: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status

70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
75: pqh_bre_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status

Line 75: pqh_bre_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
75: pqh_bre_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;

Line 78: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status

74: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
75: pqh_bre_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

Line 114: Procedure pre_delete(p_rec in pqh_bre_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in pqh_bre_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in pqh_bre_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in pqh_bre_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => pqh_bre_shd.g_old_rec.position_id

164: pqh_bre_rkd.after_delete
165: (p_reallocation_id
166: => p_rec.reallocation_id
167: ,p_position_id_o
168: => pqh_bre_shd.g_old_rec.position_id
169: ,p_pool_id_o
170: => pqh_bre_shd.g_old_rec.pool_id
171: ,p_reallocation_amt_o
172: => pqh_bre_shd.g_old_rec.reallocation_amt

Line 170: => pqh_bre_shd.g_old_rec.pool_id

166: => p_rec.reallocation_id
167: ,p_position_id_o
168: => pqh_bre_shd.g_old_rec.position_id
169: ,p_pool_id_o
170: => pqh_bre_shd.g_old_rec.pool_id
171: ,p_reallocation_amt_o
172: => pqh_bre_shd.g_old_rec.reallocation_amt
173: ,p_reserved_amt_o
174: => pqh_bre_shd.g_old_rec.reserved_amt

Line 172: => pqh_bre_shd.g_old_rec.reallocation_amt

168: => pqh_bre_shd.g_old_rec.position_id
169: ,p_pool_id_o
170: => pqh_bre_shd.g_old_rec.pool_id
171: ,p_reallocation_amt_o
172: => pqh_bre_shd.g_old_rec.reallocation_amt
173: ,p_reserved_amt_o
174: => pqh_bre_shd.g_old_rec.reserved_amt
175: ,p_object_version_number_o
176: => pqh_bre_shd.g_old_rec.object_version_number

Line 174: => pqh_bre_shd.g_old_rec.reserved_amt

170: => pqh_bre_shd.g_old_rec.pool_id
171: ,p_reallocation_amt_o
172: => pqh_bre_shd.g_old_rec.reallocation_amt
173: ,p_reserved_amt_o
174: => pqh_bre_shd.g_old_rec.reserved_amt
175: ,p_object_version_number_o
176: => pqh_bre_shd.g_old_rec.object_version_number
177: ,p_txn_detail_id_o
178: => pqh_bre_shd.g_old_rec.txn_detail_id

Line 176: => pqh_bre_shd.g_old_rec.object_version_number

172: => pqh_bre_shd.g_old_rec.reallocation_amt
173: ,p_reserved_amt_o
174: => pqh_bre_shd.g_old_rec.reserved_amt
175: ,p_object_version_number_o
176: => pqh_bre_shd.g_old_rec.object_version_number
177: ,p_txn_detail_id_o
178: => pqh_bre_shd.g_old_rec.txn_detail_id
179: ,p_transaction_type_o
180: => pqh_bre_shd.g_old_rec.transaction_type

Line 178: => pqh_bre_shd.g_old_rec.txn_detail_id

174: => pqh_bre_shd.g_old_rec.reserved_amt
175: ,p_object_version_number_o
176: => pqh_bre_shd.g_old_rec.object_version_number
177: ,p_txn_detail_id_o
178: => pqh_bre_shd.g_old_rec.txn_detail_id
179: ,p_transaction_type_o
180: => pqh_bre_shd.g_old_rec.transaction_type
181: ,p_budget_detail_id_o
182: => pqh_bre_shd.g_old_rec.budget_detail_id

Line 180: => pqh_bre_shd.g_old_rec.transaction_type

176: => pqh_bre_shd.g_old_rec.object_version_number
177: ,p_txn_detail_id_o
178: => pqh_bre_shd.g_old_rec.txn_detail_id
179: ,p_transaction_type_o
180: => pqh_bre_shd.g_old_rec.transaction_type
181: ,p_budget_detail_id_o
182: => pqh_bre_shd.g_old_rec.budget_detail_id
183: ,p_budget_period_id_o
184: => pqh_bre_shd.g_old_rec.budget_period_id

Line 182: => pqh_bre_shd.g_old_rec.budget_detail_id

178: => pqh_bre_shd.g_old_rec.txn_detail_id
179: ,p_transaction_type_o
180: => pqh_bre_shd.g_old_rec.transaction_type
181: ,p_budget_detail_id_o
182: => pqh_bre_shd.g_old_rec.budget_detail_id
183: ,p_budget_period_id_o
184: => pqh_bre_shd.g_old_rec.budget_period_id
185: ,p_entity_id_o
186: => pqh_bre_shd.g_old_rec.entity_id

Line 184: => pqh_bre_shd.g_old_rec.budget_period_id

180: => pqh_bre_shd.g_old_rec.transaction_type
181: ,p_budget_detail_id_o
182: => pqh_bre_shd.g_old_rec.budget_detail_id
183: ,p_budget_period_id_o
184: => pqh_bre_shd.g_old_rec.budget_period_id
185: ,p_entity_id_o
186: => pqh_bre_shd.g_old_rec.entity_id
187: ,p_start_date_o
188: => pqh_bre_shd.g_old_rec.start_date

Line 186: => pqh_bre_shd.g_old_rec.entity_id

182: => pqh_bre_shd.g_old_rec.budget_detail_id
183: ,p_budget_period_id_o
184: => pqh_bre_shd.g_old_rec.budget_period_id
185: ,p_entity_id_o
186: => pqh_bre_shd.g_old_rec.entity_id
187: ,p_start_date_o
188: => pqh_bre_shd.g_old_rec.start_date
189: ,p_end_date_o
190: => pqh_bre_shd.g_old_rec.end_date

Line 188: => pqh_bre_shd.g_old_rec.start_date

184: => pqh_bre_shd.g_old_rec.budget_period_id
185: ,p_entity_id_o
186: => pqh_bre_shd.g_old_rec.entity_id
187: ,p_start_date_o
188: => pqh_bre_shd.g_old_rec.start_date
189: ,p_end_date_o
190: => pqh_bre_shd.g_old_rec.end_date
191: );
192: --

Line 190: => pqh_bre_shd.g_old_rec.end_date

186: => pqh_bre_shd.g_old_rec.entity_id
187: ,p_start_date_o
188: => pqh_bre_shd.g_old_rec.start_date
189: ,p_end_date_o
190: => pqh_bre_shd.g_old_rec.end_date
191: );
192: --
193: exception
194: --

Line 210: (p_rec in pqh_bre_shd.g_rec_type

206: -- ----------------------------------------------------------------------------
207: -- |---------------------------------< del >----------------------------------|
208: -- ----------------------------------------------------------------------------
209: Procedure del
210: (p_rec in pqh_bre_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'del';
214: --

Line 220: pqh_bre_shd.lck

216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: -- We must lock the row which we need to delete.
219: --
220: pqh_bre_shd.lck
221: (p_rec.reallocation_id
222: ,p_rec.object_version_number
223: );
224: --

Line 257: l_rec pqh_bre_shd.g_rec_type;

253: (p_reallocation_id in number
254: ,p_object_version_number in number
255: ) is
256: --
257: l_rec pqh_bre_shd.g_rec_type;
258: l_proc varchar2(72) := g_package||'del';
259: --
260: Begin
261: hr_utility.set_location('Entering:'||l_proc, 5);