APPS.PQH_SAT_UPD dependencies on PQH_SAT_SHD

Line 51: Procedure update_dml(p_rec in out nocopy pqh_sat_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure update_dml(p_rec in out nocopy pqh_sat_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'update_dml';
54: --
55: Begin

Line 85: pqh_sat_shd.constraint_error

81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: pqh_sat_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pqh_sat_shd.constraint_error

Line 89: pqh_sat_shd.constraint_error

85: pqh_sat_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pqh_sat_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: pqh_sat_shd.constraint_error

Line 93: pqh_sat_shd.constraint_error

89: pqh_sat_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: pqh_sat_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then
96: Raise;
97: End update_dml;

Line 131: Procedure pre_update(p_rec in pqh_sat_shd.g_rec_type) is

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

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

170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure post_update(
174: p_effective_date in date,p_rec in pqh_sat_shd.g_rec_type) is
175: --
176: l_proc varchar2(72) := g_package||'post_update';
177: --
178: Begin

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

195: ,p_ddf_column_name =>p_rec.ddf_column_name
196: ,p_ddf_value_column_name =>p_rec.ddf_value_column_name
197: ,p_context =>p_rec.context
198: ,p_effective_date =>p_effective_date
199: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code

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

196: ,p_ddf_value_column_name =>p_rec.ddf_value_column_name
197: ,p_context =>p_rec.context
198: ,p_effective_date =>p_effective_date
199: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number

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

197: ,p_context =>p_rec.context
198: ,p_effective_date =>p_effective_date
199: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name

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

198: ,p_effective_date =>p_effective_date
199: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name

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

199: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
207: ,p_context_o =>pqh_sat_shd.g_old_rec.context

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

200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
207: ,p_context_o =>pqh_sat_shd.g_old_rec.context
208: );

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

201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
207: ,p_context_o =>pqh_sat_shd.g_old_rec.context
208: );
209: --

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

202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
207: ,p_context_o =>pqh_sat_shd.g_old_rec.context
208: );
209: --
210: exception

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

203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
207: ,p_context_o =>pqh_sat_shd.g_old_rec.context
208: );
209: --
210: exception
211: --

Line 269: Procedure convert_defs(p_rec in out nocopy pqh_sat_shd.g_rec_type) is

265: -- Internal Row Handler Use Only.
266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure convert_defs(p_rec in out nocopy pqh_sat_shd.g_rec_type) is
270: --
271: l_proc varchar2(72) := g_package||'convert_defs';
272: --
273: Begin

Line 284: pqh_sat_shd.g_old_rec.txn_category_attribute_id;

280: -- is being used then we must set to the 'current' argument value.
281: --
282: If (p_rec.txn_category_attribute_id = hr_api.g_number) then
283: p_rec.txn_category_attribute_id :=
284: pqh_sat_shd.g_old_rec.txn_category_attribute_id;
285: End If;
286: If (p_rec.attribute_type_cd = hr_api.g_varchar2) then
287: p_rec.attribute_type_cd :=
288: pqh_sat_shd.g_old_rec.attribute_type_cd;

Line 288: pqh_sat_shd.g_old_rec.attribute_type_cd;

284: pqh_sat_shd.g_old_rec.txn_category_attribute_id;
285: End If;
286: If (p_rec.attribute_type_cd = hr_api.g_varchar2) then
287: p_rec.attribute_type_cd :=
288: pqh_sat_shd.g_old_rec.attribute_type_cd;
289: End If;
290: If (p_rec.key_attribute_type = hr_api.g_varchar2) then
291: p_rec.key_attribute_type :=
292: pqh_sat_shd.g_old_rec.key_attribute_type;

Line 292: pqh_sat_shd.g_old_rec.key_attribute_type;

288: pqh_sat_shd.g_old_rec.attribute_type_cd;
289: End If;
290: If (p_rec.key_attribute_type = hr_api.g_varchar2) then
291: p_rec.key_attribute_type :=
292: pqh_sat_shd.g_old_rec.key_attribute_type;
293: End If;
294: If (p_rec.enable_flag = hr_api.g_varchar2) then
295: p_rec.enable_flag :=
296: pqh_sat_shd.g_old_rec.enable_flag;

Line 296: pqh_sat_shd.g_old_rec.enable_flag;

292: pqh_sat_shd.g_old_rec.key_attribute_type;
293: End If;
294: If (p_rec.enable_flag = hr_api.g_varchar2) then
295: p_rec.enable_flag :=
296: pqh_sat_shd.g_old_rec.enable_flag;
297: End If;
298: If (p_rec.flex_code = hr_api.g_varchar2) then
299: p_rec.flex_code :=
300: pqh_sat_shd.g_old_rec.flex_code;

Line 300: pqh_sat_shd.g_old_rec.flex_code;

296: pqh_sat_shd.g_old_rec.enable_flag;
297: End If;
298: If (p_rec.flex_code = hr_api.g_varchar2) then
299: p_rec.flex_code :=
300: pqh_sat_shd.g_old_rec.flex_code;
301: End If;
302: If (p_rec.ddf_column_name = hr_api.g_varchar2) then
303: p_rec.ddf_column_name :=
304: pqh_sat_shd.g_old_rec.ddf_column_name;

Line 304: pqh_sat_shd.g_old_rec.ddf_column_name;

300: pqh_sat_shd.g_old_rec.flex_code;
301: End If;
302: If (p_rec.ddf_column_name = hr_api.g_varchar2) then
303: p_rec.ddf_column_name :=
304: pqh_sat_shd.g_old_rec.ddf_column_name;
305: End If;
306: If (p_rec.ddf_value_column_name = hr_api.g_varchar2) then
307: p_rec.ddf_value_column_name :=
308: pqh_sat_shd.g_old_rec.ddf_value_column_name;

Line 308: pqh_sat_shd.g_old_rec.ddf_value_column_name;

304: pqh_sat_shd.g_old_rec.ddf_column_name;
305: End If;
306: If (p_rec.ddf_value_column_name = hr_api.g_varchar2) then
307: p_rec.ddf_value_column_name :=
308: pqh_sat_shd.g_old_rec.ddf_value_column_name;
309: End If;
310: If (p_rec.context = hr_api.g_varchar2) then
311: p_rec.context :=
312: pqh_sat_shd.g_old_rec.context;

Line 312: pqh_sat_shd.g_old_rec.context;

308: pqh_sat_shd.g_old_rec.ddf_value_column_name;
309: End If;
310: If (p_rec.context = hr_api.g_varchar2) then
311: p_rec.context :=
312: pqh_sat_shd.g_old_rec.context;
313: End If;
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: --

Line 325: p_rec in out nocopy pqh_sat_shd.g_rec_type

321: -- ----------------------------------------------------------------------------
322: Procedure upd
323: (
324: p_effective_date in date,
325: p_rec in out nocopy pqh_sat_shd.g_rec_type
326: ) is
327: --
328: l_proc varchar2(72) := g_package||'upd';
329: --

Line 335: pqh_sat_shd.lck

331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- We must lock the row which we need to update.
334: --
335: pqh_sat_shd.lck
336: (
337: p_rec.special_attribute_id,
338: p_rec.object_version_number
339: );

Line 383: l_rec pqh_sat_shd.g_rec_type;

379: p_ddf_value_column_name in varchar2 default hr_api.g_varchar2,
380: p_context in varchar2 default hr_api.g_varchar2
381: ) is
382: --
383: l_rec pqh_sat_shd.g_rec_type;
384: l_proc varchar2(72) := g_package||'upd';
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);

Line 393: pqh_sat_shd.convert_args

389: -- Call conversion function to turn arguments into the
390: -- l_rec structure.
391: --
392: l_rec :=
393: pqh_sat_shd.convert_args
394: (
395: p_special_attribute_id,
396: p_txn_category_attribute_id,
397: p_attribute_type_cd,