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_BPL_DEL dependencies on PQH_BPL_SHD

Line 52: (p_rec in pqh_bpl_shd.g_rec_type

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

Line 60: pqh_bpl_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_bpl_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pqh_budget_pools row.
63: --
64: delete from pqh_budget_pools

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

63: --
64: delete from pqh_budget_pools
65: where pool_id = p_rec.pool_id;
66: --
67: pqh_bpl_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_bpl_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_bpl_shd.g_api_dml := false; -- Unset the api dml status
75: pqh_bpl_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status

Line 75: pqh_bpl_shd.constraint_error

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

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

74: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
75: pqh_bpl_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pqh_bpl_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_bpl_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_bpl_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_bpl_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_bpl_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => pqh_bpl_shd.g_old_rec.name

164: pqh_bpl_rkd.after_delete
165: (p_pool_id
166: => p_rec.pool_id
167: ,p_name_o
168: => pqh_bpl_shd.g_old_rec.name
169: ,p_budget_version_id_o
170: => pqh_bpl_shd.g_old_rec.budget_version_id
171: ,p_budget_unit_id_o
172: => pqh_bpl_shd.g_old_rec.budget_unit_id

Line 170: => pqh_bpl_shd.g_old_rec.budget_version_id

166: => p_rec.pool_id
167: ,p_name_o
168: => pqh_bpl_shd.g_old_rec.name
169: ,p_budget_version_id_o
170: => pqh_bpl_shd.g_old_rec.budget_version_id
171: ,p_budget_unit_id_o
172: => pqh_bpl_shd.g_old_rec.budget_unit_id
173: ,p_object_version_number_o
174: => pqh_bpl_shd.g_old_rec.object_version_number

Line 172: => pqh_bpl_shd.g_old_rec.budget_unit_id

168: => pqh_bpl_shd.g_old_rec.name
169: ,p_budget_version_id_o
170: => pqh_bpl_shd.g_old_rec.budget_version_id
171: ,p_budget_unit_id_o
172: => pqh_bpl_shd.g_old_rec.budget_unit_id
173: ,p_object_version_number_o
174: => pqh_bpl_shd.g_old_rec.object_version_number
175: ,p_entity_type_o
176: => pqh_bpl_shd.g_old_rec.entity_type

Line 174: => pqh_bpl_shd.g_old_rec.object_version_number

170: => pqh_bpl_shd.g_old_rec.budget_version_id
171: ,p_budget_unit_id_o
172: => pqh_bpl_shd.g_old_rec.budget_unit_id
173: ,p_object_version_number_o
174: => pqh_bpl_shd.g_old_rec.object_version_number
175: ,p_entity_type_o
176: => pqh_bpl_shd.g_old_rec.entity_type
177: ,p_parent_pool_id_o
178: => pqh_bpl_shd.g_old_rec.parent_pool_id

Line 176: => pqh_bpl_shd.g_old_rec.entity_type

172: => pqh_bpl_shd.g_old_rec.budget_unit_id
173: ,p_object_version_number_o
174: => pqh_bpl_shd.g_old_rec.object_version_number
175: ,p_entity_type_o
176: => pqh_bpl_shd.g_old_rec.entity_type
177: ,p_parent_pool_id_o
178: => pqh_bpl_shd.g_old_rec.parent_pool_id
179: ,p_business_group_id_o
180: => pqh_bpl_shd.g_old_rec.business_group_id

Line 178: => pqh_bpl_shd.g_old_rec.parent_pool_id

174: => pqh_bpl_shd.g_old_rec.object_version_number
175: ,p_entity_type_o
176: => pqh_bpl_shd.g_old_rec.entity_type
177: ,p_parent_pool_id_o
178: => pqh_bpl_shd.g_old_rec.parent_pool_id
179: ,p_business_group_id_o
180: => pqh_bpl_shd.g_old_rec.business_group_id
181: ,p_approval_status_o
182: => pqh_bpl_shd.g_old_rec.approval_status

Line 180: => pqh_bpl_shd.g_old_rec.business_group_id

176: => pqh_bpl_shd.g_old_rec.entity_type
177: ,p_parent_pool_id_o
178: => pqh_bpl_shd.g_old_rec.parent_pool_id
179: ,p_business_group_id_o
180: => pqh_bpl_shd.g_old_rec.business_group_id
181: ,p_approval_status_o
182: => pqh_bpl_shd.g_old_rec.approval_status
183: ,p_wf_transaction_category_id_o
184: =>pqh_bpl_shd.g_old_rec.wf_transaction_category_id

Line 182: => pqh_bpl_shd.g_old_rec.approval_status

178: => pqh_bpl_shd.g_old_rec.parent_pool_id
179: ,p_business_group_id_o
180: => pqh_bpl_shd.g_old_rec.business_group_id
181: ,p_approval_status_o
182: => pqh_bpl_shd.g_old_rec.approval_status
183: ,p_wf_transaction_category_id_o
184: =>pqh_bpl_shd.g_old_rec.wf_transaction_category_id
185: );
186: --

Line 184: =>pqh_bpl_shd.g_old_rec.wf_transaction_category_id

180: => pqh_bpl_shd.g_old_rec.business_group_id
181: ,p_approval_status_o
182: => pqh_bpl_shd.g_old_rec.approval_status
183: ,p_wf_transaction_category_id_o
184: =>pqh_bpl_shd.g_old_rec.wf_transaction_category_id
185: );
186: --
187: exception
188: --

Line 204: (p_rec in pqh_bpl_shd.g_rec_type

200: -- ----------------------------------------------------------------------------
201: -- |---------------------------------< del >----------------------------------|
202: -- ----------------------------------------------------------------------------
203: Procedure del
204: (p_rec in pqh_bpl_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'del';
208: --

Line 214: pqh_bpl_shd.lck

210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: -- We must lock the row which we need to delete.
213: --
214: pqh_bpl_shd.lck
215: (p_rec.pool_id
216: ,p_rec.object_version_number
217: );
218: --

Line 251: l_rec pqh_bpl_shd.g_rec_type;

247: (p_pool_id in number
248: ,p_object_version_number in number
249: ) is
250: --
251: l_rec pqh_bpl_shd.g_rec_type;
252: l_proc varchar2(72) := g_package||'del';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);