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_BPR_BUS dependencies on PQH_BPR_SHD

Line 46: l_api_updating := pqh_bpr_shd.api_updating

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

Line 52: <> pqh_bpr_shd.g_old_rec.budget_period_id) then

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

Line 56: pqh_bpr_shd.constraint_error('PQH_BUDGET_PERIODS_PK');

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

Line 66: pqh_bpr_shd.constraint_error('PQH_BUDGET_PERIODS_PK');

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

Line 118: l_api_updating := pqh_bpr_shd.api_updating

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

Line 124: <> nvl(pqh_bpr_shd.g_old_rec.end_time_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_end_time_period_id,hr_api.g_number)
124: <> nvl(pqh_bpr_shd.g_old_rec.end_time_period_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if end_time_period_id value exists in per_time_periods table
128: --

Line 139: pqh_bpr_shd.constraint_error('PQH_BUDGET_PERIODS_FK3');

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

Line 193: l_api_updating := pqh_bpr_shd.api_updating

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

Line 199: <> nvl(pqh_bpr_shd.g_old_rec.start_time_period_id,hr_api.g_number)

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

Line 214: pqh_bpr_shd.constraint_error('PQH_BUDGET_PERIODS_FK2');

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

Line 268: l_api_updating := pqh_bpr_shd.api_updating

264: Begin
265: --
266: hr_utility.set_location('Entering:'||l_proc,5);
267: --
268: l_api_updating := pqh_bpr_shd.api_updating
269: (p_budget_period_id => p_budget_period_id,
270: p_object_version_number => p_object_version_number);
271: --
272: if (l_api_updating

Line 274: <> nvl(pqh_bpr_shd.g_old_rec.budget_detail_id,hr_api.g_number)

270: p_object_version_number => p_object_version_number);
271: --
272: if (l_api_updating
273: and nvl(p_budget_detail_id,hr_api.g_number)
274: <> nvl(pqh_bpr_shd.g_old_rec.budget_detail_id,hr_api.g_number)
275: or not l_api_updating) then
276: --
277: -- check if budget_detail_id value exists in pqh_budget_details table
278: --

Line 289: pqh_bpr_shd.constraint_error('PQH_BUDGET_PERIODS_FK1');

285: --
286: -- raise error as FK does not relate to PK in pqh_budget_details
287: -- table.
288: --
289: pqh_bpr_shd.constraint_error('PQH_BUDGET_PERIODS_FK1');
290: --
291: end if;
292: --
293: close c1;

Line 340: l_api_updating := pqh_bpr_shd.api_updating

336: Begin
337: --
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: l_api_updating := pqh_bpr_shd.api_updating
341: (p_budget_period_id => p_budget_period_id,
342: p_object_version_number => p_object_version_number);
343: --
344: if (l_api_updating

Line 346: <> nvl(pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)

342: p_object_version_number => p_object_version_number);
343: --
344: if (l_api_updating
345: and p_budget_unit3_value_type_cd
346: <> nvl(pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)
347: or not l_api_updating)
348: and p_budget_unit3_value_type_cd is not null then
349: --
350: -- check if value of lookup falls within lookup type.

Line 408: l_api_updating := pqh_bpr_shd.api_updating

404: Begin
405: --
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: l_api_updating := pqh_bpr_shd.api_updating
409: (p_budget_period_id => p_budget_period_id,
410: p_object_version_number => p_object_version_number);
411: --
412: if (l_api_updating

Line 414: <> nvl(pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)

410: p_object_version_number => p_object_version_number);
411: --
412: if (l_api_updating
413: and p_budget_unit2_value_type_cd
414: <> nvl(pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)
415: or not l_api_updating)
416: and p_budget_unit2_value_type_cd is not null then
417: --
418: -- check if value of lookup falls within lookup type.

Line 476: l_api_updating := pqh_bpr_shd.api_updating

472: Begin
473: --
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: l_api_updating := pqh_bpr_shd.api_updating
477: (p_budget_period_id => p_budget_period_id,
478: p_object_version_number => p_object_version_number);
479: --
480: if (l_api_updating

Line 482: <> nvl(pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)

478: p_object_version_number => p_object_version_number);
479: --
480: if (l_api_updating
481: and p_budget_unit1_value_type_cd
482: <> nvl(pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)
483: or not l_api_updating)
484: and p_budget_unit1_value_type_cd is not null then
485: --
486: -- check if value of lookup falls within lookup type.

Line 509: Procedure insert_validate(p_rec in pqh_bpr_shd.g_rec_type) is

505: --
506: -- ----------------------------------------------------------------------------
507: -- |---------------------------< insert_validate >----------------------------|
508: -- ----------------------------------------------------------------------------
509: Procedure insert_validate(p_rec in pqh_bpr_shd.g_rec_type) is
510: --
511: l_proc varchar2(72) := g_package||'insert_validate';
512: --
513: Begin

Line 563: Procedure update_validate(p_rec in pqh_bpr_shd.g_rec_type) is

559: --
560: -- ----------------------------------------------------------------------------
561: -- |---------------------------< update_validate >----------------------------|
562: -- ----------------------------------------------------------------------------
563: Procedure update_validate(p_rec in pqh_bpr_shd.g_rec_type) is
564: --
565: l_proc varchar2(72) := g_package||'update_validate';
566: --
567: Begin

Line 617: Procedure delete_validate(p_rec in pqh_bpr_shd.g_rec_type) is

613: --
614: -- ----------------------------------------------------------------------------
615: -- |---------------------------< delete_validate >----------------------------|
616: -- ----------------------------------------------------------------------------
617: Procedure delete_validate(p_rec in pqh_bpr_shd.g_rec_type) is
618: --
619: l_proc varchar2(72) := g_package||'delete_validate';
620: --
621: Begin