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_TCA_UPD dependencies on PQH_TCA_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_tca_shd.g_rec_type) is

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

Line 85: pqh_tca_shd.constraint_error

81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: pqh_tca_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_tca_shd.constraint_error

Line 89: pqh_tca_shd.constraint_error

85: pqh_tca_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_tca_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_tca_shd.constraint_error

Line 93: pqh_tca_shd.constraint_error

89: pqh_tca_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_tca_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_tca_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_tca_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_tca_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_tca_shd.g_rec_type) is
175: --
176: l_proc varchar2(72) := g_package||'post_update';
177: --
178: Begin

Line 202: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id

198: ,p_refresh_flag =>p_rec.refresh_flag
199: ,p_select_flag =>p_rec.select_flag
200: ,p_value_style_cd =>p_rec.value_style_cd
201: ,p_effective_date =>p_effective_date
202: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
203: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
204: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
205: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
206: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id

Line 203: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id

199: ,p_select_flag =>p_rec.select_flag
200: ,p_value_style_cd =>p_rec.value_style_cd
201: ,p_effective_date =>p_effective_date
202: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
203: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
204: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
205: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
206: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
207: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name

Line 204: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id

200: ,p_value_style_cd =>p_rec.value_style_cd
201: ,p_effective_date =>p_effective_date
202: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
203: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
204: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
205: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
206: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
207: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
208: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag

Line 205: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number

201: ,p_effective_date =>p_effective_date
202: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
203: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
204: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
205: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
206: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
207: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
208: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
209: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag

Line 206: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id

202: ,p_attribute_id_o =>pqh_tca_shd.g_old_rec.attribute_id
203: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
204: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
205: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
206: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
207: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
208: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
209: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
210: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag

Line 207: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name

203: ,p_transaction_category_id_o =>pqh_tca_shd.g_old_rec.transaction_category_id
204: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
205: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
206: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
207: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
208: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
209: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
210: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
211: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag

Line 208: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag

204: ,p_value_set_id_o =>pqh_tca_shd.g_old_rec.value_set_id
205: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
206: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
207: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
208: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
209: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
210: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
211: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
212: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag

Line 209: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag

205: ,p_object_version_number_o =>pqh_tca_shd.g_old_rec.object_version_number
206: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
207: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
208: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
209: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
210: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
211: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
212: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
213: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd

Line 210: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag

206: ,p_transaction_table_route_id_o =>pqh_tca_shd.g_old_rec.transaction_table_route_id
207: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
208: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
209: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
210: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
211: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
212: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
213: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
214: );

Line 211: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag

207: ,p_form_column_name_o =>pqh_tca_shd.g_old_rec.form_column_name
208: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
209: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
210: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
211: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
212: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
213: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
214: );
215: --

Line 212: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag

208: ,p_identifier_flag_o =>pqh_tca_shd.g_old_rec.identifier_flag
209: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
210: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
211: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
212: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
213: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
214: );
215: --
216: exception

Line 213: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd

209: ,p_list_identifying_flag_o =>pqh_tca_shd.g_old_rec.list_identifying_flag
210: ,p_member_identifying_flag_o =>pqh_tca_shd.g_old_rec.member_identifying_flag
211: ,p_refresh_flag_o =>pqh_tca_shd.g_old_rec.refresh_flag
212: ,p_select_flag_o =>pqh_tca_shd.g_old_rec.select_flag
213: ,p_value_style_cd_o =>pqh_tca_shd.g_old_rec.value_style_cd
214: );
215: --
216: exception
217: --

Line 275: Procedure convert_defs(p_rec in out nocopy pqh_tca_shd.g_rec_type) is

271: -- Internal Row Handler Use Only.
272: --
273: -- {End Of Comments}
274: -- ----------------------------------------------------------------------------
275: Procedure convert_defs(p_rec in out nocopy pqh_tca_shd.g_rec_type) is
276: --
277: l_proc varchar2(72) := g_package||'convert_defs';
278: --
279: Begin

Line 290: pqh_tca_shd.g_old_rec.attribute_id;

286: -- is being used then we must set to the 'current' argument value.
287: --
288: If (p_rec.attribute_id = hr_api.g_number) then
289: p_rec.attribute_id :=
290: pqh_tca_shd.g_old_rec.attribute_id;
291: End If;
292: If (p_rec.transaction_category_id = hr_api.g_number) then
293: p_rec.transaction_category_id :=
294: pqh_tca_shd.g_old_rec.transaction_category_id;

Line 294: pqh_tca_shd.g_old_rec.transaction_category_id;

290: pqh_tca_shd.g_old_rec.attribute_id;
291: End If;
292: If (p_rec.transaction_category_id = hr_api.g_number) then
293: p_rec.transaction_category_id :=
294: pqh_tca_shd.g_old_rec.transaction_category_id;
295: End If;
296: If (p_rec.value_set_id = hr_api.g_number) then
297: p_rec.value_set_id :=
298: pqh_tca_shd.g_old_rec.value_set_id;

Line 298: pqh_tca_shd.g_old_rec.value_set_id;

294: pqh_tca_shd.g_old_rec.transaction_category_id;
295: End If;
296: If (p_rec.value_set_id = hr_api.g_number) then
297: p_rec.value_set_id :=
298: pqh_tca_shd.g_old_rec.value_set_id;
299: End If;
300: If (p_rec.transaction_table_route_id = hr_api.g_number) then
301: p_rec.transaction_table_route_id :=
302: pqh_tca_shd.g_old_rec.transaction_table_route_id;

Line 302: pqh_tca_shd.g_old_rec.transaction_table_route_id;

298: pqh_tca_shd.g_old_rec.value_set_id;
299: End If;
300: If (p_rec.transaction_table_route_id = hr_api.g_number) then
301: p_rec.transaction_table_route_id :=
302: pqh_tca_shd.g_old_rec.transaction_table_route_id;
303: End If;
304: If (p_rec.form_column_name = hr_api.g_varchar2) then
305: p_rec.form_column_name :=
306: pqh_tca_shd.g_old_rec.form_column_name;

Line 306: pqh_tca_shd.g_old_rec.form_column_name;

302: pqh_tca_shd.g_old_rec.transaction_table_route_id;
303: End If;
304: If (p_rec.form_column_name = hr_api.g_varchar2) then
305: p_rec.form_column_name :=
306: pqh_tca_shd.g_old_rec.form_column_name;
307: End If;
308: If (p_rec.identifier_flag = hr_api.g_varchar2) then
309: p_rec.identifier_flag :=
310: pqh_tca_shd.g_old_rec.identifier_flag;

Line 310: pqh_tca_shd.g_old_rec.identifier_flag;

306: pqh_tca_shd.g_old_rec.form_column_name;
307: End If;
308: If (p_rec.identifier_flag = hr_api.g_varchar2) then
309: p_rec.identifier_flag :=
310: pqh_tca_shd.g_old_rec.identifier_flag;
311: End If;
312: If (p_rec.list_identifying_flag = hr_api.g_varchar2) then
313: p_rec.list_identifying_flag :=
314: pqh_tca_shd.g_old_rec.list_identifying_flag;

Line 314: pqh_tca_shd.g_old_rec.list_identifying_flag;

310: pqh_tca_shd.g_old_rec.identifier_flag;
311: End If;
312: If (p_rec.list_identifying_flag = hr_api.g_varchar2) then
313: p_rec.list_identifying_flag :=
314: pqh_tca_shd.g_old_rec.list_identifying_flag;
315: End If;
316: If (p_rec.member_identifying_flag = hr_api.g_varchar2) then
317: p_rec.member_identifying_flag :=
318: pqh_tca_shd.g_old_rec.member_identifying_flag;

Line 318: pqh_tca_shd.g_old_rec.member_identifying_flag;

314: pqh_tca_shd.g_old_rec.list_identifying_flag;
315: End If;
316: If (p_rec.member_identifying_flag = hr_api.g_varchar2) then
317: p_rec.member_identifying_flag :=
318: pqh_tca_shd.g_old_rec.member_identifying_flag;
319: End If;
320: If (p_rec.refresh_flag = hr_api.g_varchar2) then
321: p_rec.refresh_flag :=
322: pqh_tca_shd.g_old_rec.refresh_flag;

Line 322: pqh_tca_shd.g_old_rec.refresh_flag;

318: pqh_tca_shd.g_old_rec.member_identifying_flag;
319: End If;
320: If (p_rec.refresh_flag = hr_api.g_varchar2) then
321: p_rec.refresh_flag :=
322: pqh_tca_shd.g_old_rec.refresh_flag;
323: End If;
324: If (p_rec.select_flag = hr_api.g_varchar2) then
325: p_rec.select_flag :=
326: pqh_tca_shd.g_old_rec.select_flag;

Line 326: pqh_tca_shd.g_old_rec.select_flag;

322: pqh_tca_shd.g_old_rec.refresh_flag;
323: End If;
324: If (p_rec.select_flag = hr_api.g_varchar2) then
325: p_rec.select_flag :=
326: pqh_tca_shd.g_old_rec.select_flag;
327: End If;
328: If (p_rec.value_style_cd = hr_api.g_varchar2) then
329: p_rec.value_style_cd :=
330: pqh_tca_shd.g_old_rec.value_style_cd;

Line 330: pqh_tca_shd.g_old_rec.value_style_cd;

326: pqh_tca_shd.g_old_rec.select_flag;
327: End If;
328: If (p_rec.value_style_cd = hr_api.g_varchar2) then
329: p_rec.value_style_cd :=
330: pqh_tca_shd.g_old_rec.value_style_cd;
331: End If;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334: --

Line 343: p_rec in out nocopy pqh_tca_shd.g_rec_type,

339: -- ----------------------------------------------------------------------------
340: Procedure upd
341: (
342: p_effective_date in date,
343: p_rec in out nocopy pqh_tca_shd.g_rec_type,
344: p_delete_attr_ranges_flag in varchar2
345: ) is
346: --
347: l_proc varchar2(72) := g_package||'upd';

Line 354: pqh_tca_shd.lck

350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: -- We must lock the row which we need to update.
353: --
354: pqh_tca_shd.lck
355: (
356: p_rec.txn_category_attribute_id,
357: p_rec.object_version_number
358: );

Line 406: l_rec pqh_tca_shd.g_rec_type;

402: p_value_style_cd in varchar2 default hr_api.g_varchar2
403: ,p_delete_attr_ranges_flag in varchar2 default hr_api.g_varchar2
404: ) is
405: --
406: l_rec pqh_tca_shd.g_rec_type;
407: l_proc varchar2(72) := g_package||'upd';
408: --
409: Begin
410: hr_utility.set_location('Entering:'||l_proc, 5);

Line 416: pqh_tca_shd.convert_args

412: -- Call conversion function to turn arguments into the
413: -- l_rec structure.
414: --
415: l_rec :=
416: pqh_tca_shd.convert_args
417: (
418: p_txn_category_attribute_id,
419: p_attribute_id,
420: p_transaction_category_id,