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_STR_DEL dependencies on PQH_STR_SHD

Line 55: (p_rec in pqh_str_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure delete_dml
55: (p_rec in pqh_str_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'delete_dml';
59: --

Line 90: pqh_str_shd.constraint_error

86: Exception
87: When hr_api.child_integrity_violated then
88: -- Child integrity has been violated
89: --
90: pqh_str_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When Others Then
93: --
94: Raise;

Line 129: Procedure pre_delete(p_rec in pqh_str_shd.g_rec_type) is

125: -- Internal Row Handler Use Only.
126: --
127: -- {End Of Comments}
128: -- ----------------------------------------------------------------------------
129: Procedure pre_delete(p_rec in pqh_str_shd.g_rec_type) is
130: --
131: l_proc varchar2(72) := g_package||'pre_delete';
132: --
133: Begin

Line 180: Procedure post_delete(p_rec in pqh_str_shd.g_rec_type) is

176: -- Internal Row Handler Use Only.
177: --
178: -- {End Of Comments}
179: -- -----------------------------------------------------------------------------
180: Procedure post_delete(p_rec in pqh_str_shd.g_rec_type) is
181: --
182: l_proc varchar2(72) := g_package||'post_delete';
183: --
184: Begin

Line 197: => pqh_str_shd.g_old_rec.statutory_situation_id

193: pqh_str_rkd.after_delete
194: (p_stat_situation_rule_id
195: => p_rec.stat_situation_rule_id
196: ,p_statutory_situation_id_o
197: => pqh_str_shd.g_old_rec.statutory_situation_id
198: ,p_processing_sequence_o
199: => pqh_str_shd.g_old_rec.processing_sequence
200: ,p_txn_category_attribute_id_o
201: => pqh_str_shd.g_old_rec.txn_category_attribute_id

Line 199: => pqh_str_shd.g_old_rec.processing_sequence

195: => p_rec.stat_situation_rule_id
196: ,p_statutory_situation_id_o
197: => pqh_str_shd.g_old_rec.statutory_situation_id
198: ,p_processing_sequence_o
199: => pqh_str_shd.g_old_rec.processing_sequence
200: ,p_txn_category_attribute_id_o
201: => pqh_str_shd.g_old_rec.txn_category_attribute_id
202: ,p_from_value_o
203: => pqh_str_shd.g_old_rec.from_value

Line 201: => pqh_str_shd.g_old_rec.txn_category_attribute_id

197: => pqh_str_shd.g_old_rec.statutory_situation_id
198: ,p_processing_sequence_o
199: => pqh_str_shd.g_old_rec.processing_sequence
200: ,p_txn_category_attribute_id_o
201: => pqh_str_shd.g_old_rec.txn_category_attribute_id
202: ,p_from_value_o
203: => pqh_str_shd.g_old_rec.from_value
204: ,p_to_value_o
205: => pqh_str_shd.g_old_rec.to_value

Line 203: => pqh_str_shd.g_old_rec.from_value

199: => pqh_str_shd.g_old_rec.processing_sequence
200: ,p_txn_category_attribute_id_o
201: => pqh_str_shd.g_old_rec.txn_category_attribute_id
202: ,p_from_value_o
203: => pqh_str_shd.g_old_rec.from_value
204: ,p_to_value_o
205: => pqh_str_shd.g_old_rec.to_value
206: ,p_enabled_flag_o
207: => pqh_str_shd.g_old_rec.enabled_flag

Line 205: => pqh_str_shd.g_old_rec.to_value

201: => pqh_str_shd.g_old_rec.txn_category_attribute_id
202: ,p_from_value_o
203: => pqh_str_shd.g_old_rec.from_value
204: ,p_to_value_o
205: => pqh_str_shd.g_old_rec.to_value
206: ,p_enabled_flag_o
207: => pqh_str_shd.g_old_rec.enabled_flag
208: ,p_required_flag_o
209: => pqh_str_shd.g_old_rec.required_flag

Line 207: => pqh_str_shd.g_old_rec.enabled_flag

203: => pqh_str_shd.g_old_rec.from_value
204: ,p_to_value_o
205: => pqh_str_shd.g_old_rec.to_value
206: ,p_enabled_flag_o
207: => pqh_str_shd.g_old_rec.enabled_flag
208: ,p_required_flag_o
209: => pqh_str_shd.g_old_rec.required_flag
210: ,p_exclude_flag_o
211: => pqh_str_shd.g_old_rec.exclude_flag

Line 209: => pqh_str_shd.g_old_rec.required_flag

205: => pqh_str_shd.g_old_rec.to_value
206: ,p_enabled_flag_o
207: => pqh_str_shd.g_old_rec.enabled_flag
208: ,p_required_flag_o
209: => pqh_str_shd.g_old_rec.required_flag
210: ,p_exclude_flag_o
211: => pqh_str_shd.g_old_rec.exclude_flag
212: ,p_object_version_number_o
213: => pqh_str_shd.g_old_rec.object_version_number

Line 211: => pqh_str_shd.g_old_rec.exclude_flag

207: => pqh_str_shd.g_old_rec.enabled_flag
208: ,p_required_flag_o
209: => pqh_str_shd.g_old_rec.required_flag
210: ,p_exclude_flag_o
211: => pqh_str_shd.g_old_rec.exclude_flag
212: ,p_object_version_number_o
213: => pqh_str_shd.g_old_rec.object_version_number
214: );
215: --

Line 213: => pqh_str_shd.g_old_rec.object_version_number

209: => pqh_str_shd.g_old_rec.required_flag
210: ,p_exclude_flag_o
211: => pqh_str_shd.g_old_rec.exclude_flag
212: ,p_object_version_number_o
213: => pqh_str_shd.g_old_rec.object_version_number
214: );
215: --
216: exception
217: --

Line 238: (p_rec in pqh_str_shd.g_rec_type

234: -- ----------------------------------------------------------------------------
235: -- |---------------------------------< del >----------------------------------|
236: -- ----------------------------------------------------------------------------
237: Procedure del
238: (p_rec in pqh_str_shd.g_rec_type
239: ) is
240: --
241: l_proc varchar2(72) := g_package||'del';
242: --

Line 256: pqh_str_shd.lck

252:
253: --
254: -- We must lock the row which we need to delete.
255: --
256: pqh_str_shd.lck
257: (p_rec.stat_situation_rule_id
258: ,p_rec.object_version_number
259: );
260: --

Line 293: l_rec pqh_str_shd.g_rec_type;

289: (p_stat_situation_rule_id in number
290: ,p_object_version_number in number
291: ) is
292: --
293: l_rec pqh_str_shd.g_rec_type;
294: l_proc varchar2(72) := g_package||'del';
295: --
296: Begin
297: