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_SAT_DEL dependencies on PQH_SAT_SHD

Line 48: Procedure delete_dml(p_rec in pqh_sat_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure delete_dml(p_rec in pqh_sat_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'delete_dml';
51: --
52: Begin

Line 67: pqh_sat_shd.constraint_error

63: --
64: Exception
65: When hr_api.child_integrity_violated then
66: -- Child integrity has been violated
67: pqh_sat_shd.constraint_error
68: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
69: When Others Then
70: Raise;
71: End delete_dml;

Line 105: Procedure pre_delete(p_rec in pqh_sat_shd.g_rec_type) is

101: -- Internal Row Handler Use Only.
102: --
103: -- {End Of Comments}
104: -- ----------------------------------------------------------------------------
105: Procedure pre_delete(p_rec in pqh_sat_shd.g_rec_type) is
106: --
107: l_proc varchar2(72) := g_package||'pre_delete';
108: --
109: Begin

Line 148: p_effective_date in date,p_rec in pqh_sat_shd.g_rec_type) is

144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure post_delete(
148: p_effective_date in date,p_rec in pqh_sat_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'post_delete';
151: --
152: Begin

Line 163: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id

159: --
160: pqh_sat_rkd.after_delete
161: (
162: p_special_attribute_id =>p_rec.special_attribute_id
163: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
164: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
165: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
166: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
167: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code

Line 164: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd

160: pqh_sat_rkd.after_delete
161: (
162: p_special_attribute_id =>p_rec.special_attribute_id
163: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
164: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
165: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
166: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
167: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
168: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number

Line 165: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type

161: (
162: p_special_attribute_id =>p_rec.special_attribute_id
163: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
164: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
165: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
166: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
167: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
168: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
169: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name

Line 166: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag

162: p_special_attribute_id =>p_rec.special_attribute_id
163: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
164: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
165: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
166: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
167: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
168: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
169: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
170: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name

Line 167: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code

163: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
164: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
165: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
166: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
167: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
168: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
169: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
170: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
171: ,p_context_o =>pqh_sat_shd.g_old_rec.context

Line 168: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number

164: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
165: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
166: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
167: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
168: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
169: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
170: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
171: ,p_context_o =>pqh_sat_shd.g_old_rec.context
172: );

Line 169: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name

165: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
166: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
167: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
168: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
169: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
170: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
171: ,p_context_o =>pqh_sat_shd.g_old_rec.context
172: );
173: --

Line 170: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name

166: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
167: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
168: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
169: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
170: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
171: ,p_context_o =>pqh_sat_shd.g_old_rec.context
172: );
173: --
174: exception

Line 171: ,p_context_o =>pqh_sat_shd.g_old_rec.context

167: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
168: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
169: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
170: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
171: ,p_context_o =>pqh_sat_shd.g_old_rec.context
172: );
173: --
174: exception
175: --

Line 196: p_rec in pqh_sat_shd.g_rec_type

192: -- ----------------------------------------------------------------------------
193: Procedure del
194: (
195: p_effective_date in date,
196: p_rec in pqh_sat_shd.g_rec_type
197: ) is
198: --
199: l_proc varchar2(72) := g_package||'del';
200: --

Line 206: pqh_sat_shd.lck

202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: -- We must lock the row which we need to delete.
205: --
206: pqh_sat_shd.lck
207: (
208: p_rec.special_attribute_id,
209: p_rec.object_version_number
210: );

Line 241: l_rec pqh_sat_shd.g_rec_type;

237: p_special_attribute_id in number,
238: p_object_version_number in number
239: ) is
240: --
241: l_rec pqh_sat_shd.g_rec_type;
242: l_proc varchar2(72) := g_package||'del';
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);