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

Line 46: l_api_updating := pqh_sat_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_sat_shd.api_updating
47: (p_special_attribute_id => p_special_attribute_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> pqh_sat_shd.g_old_rec.special_attribute_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_special_attribute_id,hr_api.g_number)
52: <> pqh_sat_shd.g_old_rec.special_attribute_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_sat_shd.constraint_error('PQH_SPECIAL_ATTRIBUTES_PK');

Line 56: pqh_sat_shd.constraint_error('PQH_SPECIAL_ATTRIBUTES_PK');

52: <> pqh_sat_shd.g_old_rec.special_attribute_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_sat_shd.constraint_error('PQH_SPECIAL_ATTRIBUTES_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_sat_shd.constraint_error('PQH_SPECIAL_ATTRIBUTES_PK');

62: if p_special_attribute_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_sat_shd.constraint_error('PQH_SPECIAL_ATTRIBUTES_PK');
67: --
68: end if;
69: --
70: end if;

Line 118: l_api_updating := pqh_sat_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_sat_shd.api_updating
119: (p_special_attribute_id => p_special_attribute_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating

Line 124: <> nvl(pqh_sat_shd.g_old_rec.context,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_context,hr_api.g_varchar2)
124: <> nvl(pqh_sat_shd.g_old_rec.context,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if context value exists in pqh_copy_entity_contexts table
128: --

Line 139: pqh_sat_shd.constraint_error('PQH_SPECIAL_ATTRIBUTES_FK2');

135: --
136: -- raise error as FK does not relate to PK in pqh_copy_entity_contexts
137: -- table.
138: --
139: pqh_sat_shd.constraint_error('PQH_SPECIAL_ATTRIBUTES_FK2');
140: --
141: end if;
142: --
143: close c1;

Line 193: l_api_updating := pqh_sat_shd.api_updating

189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := pqh_sat_shd.api_updating
194: (p_special_attribute_id => p_special_attribute_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating

Line 199: <> nvl(pqh_sat_shd.g_old_rec.txn_category_attribute_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_txn_category_attribute_id,hr_api.g_number)
199: <> nvl(pqh_sat_shd.g_old_rec.txn_category_attribute_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if txn_category_attribute_id value exists in pqh_txn_category_attributes table
203: --

Line 214: pqh_sat_shd.constraint_error('PQH_SPECIAL_ATTRIBUTES_FK1');

210: --
211: -- raise error as FK does not relate to PK in pqh_txn_category_attributes
212: -- table.
213: --
214: pqh_sat_shd.constraint_error('PQH_SPECIAL_ATTRIBUTES_FK1');
215: --
216: end if;
217: --
218: close c1;

Line 264: l_api_updating := pqh_sat_shd.api_updating

260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: l_api_updating := pqh_sat_shd.api_updating
265: (p_special_attribute_id => p_special_attribute_id,
266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating

Line 270: <> nvl(pqh_sat_shd.g_old_rec.key_attribute_type,hr_api.g_varchar2)

266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating
269: and p_key_attribute_type
270: <> nvl(pqh_sat_shd.g_old_rec.key_attribute_type,hr_api.g_varchar2)
271: or not l_api_updating)
272: and p_key_attribute_type is not null then
273: --
274: -- check if value of lookup falls within lookup type.

Line 331: l_api_updating := pqh_sat_shd.api_updating

327: Begin
328: --
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: l_api_updating := pqh_sat_shd.api_updating
332: (p_special_attribute_id => p_special_attribute_id,
333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating

Line 337: <> nvl(pqh_sat_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating
336: and p_enable_flag
337: <> nvl(pqh_sat_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
338: or not l_api_updating)
339: and p_enable_flag is not null then
340: --
341: -- check if value of lookup falls within lookup type.

Line 399: l_api_updating := pqh_sat_shd.api_updating

395: Begin
396: --
397: hr_utility.set_location('Entering:'||l_proc, 5);
398: --
399: l_api_updating := pqh_sat_shd.api_updating
400: (p_special_attribute_id => p_special_attribute_id,
401: p_object_version_number => p_object_version_number);
402: --
403: if (l_api_updating

Line 405: <> nvl(pqh_sat_shd.g_old_rec.attribute_type_cd,hr_api.g_varchar2)

401: p_object_version_number => p_object_version_number);
402: --
403: if (l_api_updating
404: and p_attribute_type_cd
405: <> nvl(pqh_sat_shd.g_old_rec.attribute_type_cd,hr_api.g_varchar2)
406: or not l_api_updating)
407: and p_attribute_type_cd is not null then
408: --
409: -- check if value of lookup falls within lookup type.

Line 432: Procedure insert_validate(p_rec in pqh_sat_shd.g_rec_type

428: --
429: -- ----------------------------------------------------------------------------
430: -- |---------------------------< insert_validate >----------------------------|
431: -- ----------------------------------------------------------------------------
432: Procedure insert_validate(p_rec in pqh_sat_shd.g_rec_type
433: ,p_effective_date in date) is
434: --
435: l_proc varchar2(72) := g_package||'insert_validate';
436: --

Line 482: Procedure update_validate(p_rec in pqh_sat_shd.g_rec_type

478: --
479: -- ----------------------------------------------------------------------------
480: -- |---------------------------< update_validate >----------------------------|
481: -- ----------------------------------------------------------------------------
482: Procedure update_validate(p_rec in pqh_sat_shd.g_rec_type
483: ,p_effective_date in date) is
484: --
485: l_proc varchar2(72) := g_package||'update_validate';
486: --

Line 532: Procedure delete_validate(p_rec in pqh_sat_shd.g_rec_type

528: --
529: -- ----------------------------------------------------------------------------
530: -- |---------------------------< delete_validate >----------------------------|
531: -- ----------------------------------------------------------------------------
532: Procedure delete_validate(p_rec in pqh_sat_shd.g_rec_type
533: ,p_effective_date in date) is
534: --
535: l_proc varchar2(72) := g_package||'delete_validate';
536: --