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_BST_BUS dependencies on PQH_BST_SHD

Line 46: l_api_updating := pqh_bst_shd.api_updating

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

Line 52: <> pqh_bst_shd.g_old_rec.budget_set_id) then

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

Line 56: pqh_bst_shd.constraint_error('PQH_BUDGET_SETS_PK');

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

Line 66: pqh_bst_shd.constraint_error('PQH_BUDGET_SETS_PK');

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

Line 118: l_api_updating := pqh_bst_shd.api_updating

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

Line 124: <> nvl(pqh_bst_shd.g_old_rec.budget_period_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_budget_period_id,hr_api.g_number)
124: <> nvl(pqh_bst_shd.g_old_rec.budget_period_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if budget_period_id value exists in pqh_budget_periods table
128: --

Line 139: pqh_bst_shd.constraint_error('PQH_BUDGET_SETS_FK2');

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

Line 193: l_api_updating := pqh_bst_shd.api_updating

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

Line 199: <> nvl(pqh_bst_shd.g_old_rec.dflt_budget_set_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_dflt_budget_set_id,hr_api.g_number)
199: <> nvl(pqh_bst_shd.g_old_rec.dflt_budget_set_id,hr_api.g_number)
200: or not l_api_updating) and
201: p_dflt_budget_set_id is not null then
202: --
203: -- check if dflt_budget_set_id value exists in pqh_dflt_budget_sets table

Line 215: pqh_bst_shd.constraint_error('PQH_BUDGET_SETS_FK1');

211: --
212: -- raise error as FK does not relate to PK in pqh_dflt_budget_sets
213: -- table.
214: --
215: pqh_bst_shd.constraint_error('PQH_BUDGET_SETS_FK1');
216: --
217: end if;
218: --
219: close c1;

Line 265: l_api_updating := pqh_bst_shd.api_updating

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

Line 271: <> nvl(pqh_bst_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)

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

Line 333: l_api_updating := pqh_bst_shd.api_updating

329: Begin
330: --
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: l_api_updating := pqh_bst_shd.api_updating
334: (p_budget_set_id => p_budget_set_id,
335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating

Line 339: <> nvl(pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)

335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and p_budget_unit2_value_type_cd
339: <> nvl(pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)
340: or not l_api_updating)
341: and p_budget_unit2_value_type_cd is not null then
342: --
343: -- check if value of lookup falls within lookup type.

Line 401: l_api_updating := pqh_bst_shd.api_updating

397: Begin
398: --
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: l_api_updating := pqh_bst_shd.api_updating
402: (p_budget_set_id => p_budget_set_id,
403: p_object_version_number => p_object_version_number);
404: --
405: if (l_api_updating

Line 407: <> nvl(pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)

403: p_object_version_number => p_object_version_number);
404: --
405: if (l_api_updating
406: and p_budget_unit1_value_type_cd
407: <> nvl(pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)
408: or not l_api_updating)
409: and p_budget_unit1_value_type_cd is not null then
410: --
411: -- check if value of lookup falls within lookup type.

Line 434: Procedure insert_validate(p_rec in pqh_bst_shd.g_rec_type

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

Line 484: Procedure update_validate(p_rec in pqh_bst_shd.g_rec_type

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

Line 534: Procedure delete_validate(p_rec in pqh_bst_shd.g_rec_type

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