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_BVR_BUS dependencies on PQH_BVR_SHD

Line 46: l_api_updating := pqh_bvr_shd.api_updating

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

Line 52: <> pqh_bvr_shd.g_old_rec.budget_version_id) then

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

Line 56: pqh_bvr_shd.constraint_error('PQH_BUDGET_VERSIONS_PK');

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

Line 66: pqh_bvr_shd.constraint_error('PQH_BUDGET_VERSIONS_PK');

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

Line 118: l_api_updating := pqh_bvr_shd.api_updating

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

Line 124: <> nvl(pqh_bvr_shd.g_old_rec.budget_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_id,hr_api.g_number)
124: <> nvl(pqh_bvr_shd.g_old_rec.budget_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_budget_id is not null then
127: --
128: -- check if budget_id value exists in pqh_budgets table

Line 140: pqh_bvr_shd.constraint_error('PQH_BUDGET_VERSIONS_FK1');

136: --
137: -- raise error as FK does not relate to PK in pqh_budgets
138: -- table.
139: --
140: pqh_bvr_shd.constraint_error('PQH_BUDGET_VERSIONS_FK1');
141: --
142: end if;
143: --
144: close c1;

Line 190: l_api_updating := pqh_bvr_shd.api_updating

186: Begin
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: l_api_updating := pqh_bvr_shd.api_updating
191: (p_budget_version_id => p_budget_version_id,
192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating

Line 196: <> nvl(pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd,hr_api.g_varchar2)

192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and p_xfer_to_other_apps_cd
196: <> nvl(pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd,hr_api.g_varchar2)
197: or not l_api_updating)
198: and p_xfer_to_other_apps_cd is not null then
199: --
200: -- check if value of lookup falls within lookup type.

Line 258: l_api_updating := pqh_bvr_shd.api_updating

254: Begin
255: --
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: l_api_updating := pqh_bvr_shd.api_updating
259: (p_budget_version_id => p_budget_version_id,
260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating

Line 264: <> nvl(pqh_bvr_shd.g_old_rec.transfered_to_gl_flag,hr_api.g_varchar2)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and p_transfered_to_gl_flag
264: <> nvl(pqh_bvr_shd.g_old_rec.transfered_to_gl_flag,hr_api.g_varchar2)
265: or not l_api_updating)
266: and p_transfered_to_gl_flag is not null then
267: --
268: -- check if value of lookup falls within lookup type.

Line 291: Procedure insert_validate(p_rec in pqh_bvr_shd.g_rec_type

287: --
288: -- ----------------------------------------------------------------------------
289: -- |---------------------------< insert_validate >----------------------------|
290: -- ----------------------------------------------------------------------------
291: Procedure insert_validate(p_rec in pqh_bvr_shd.g_rec_type
292: ,p_effective_date in date) is
293: --
294: l_proc varchar2(72) := g_package||'insert_validate';
295: --

Line 330: Procedure update_validate(p_rec in pqh_bvr_shd.g_rec_type

326: --
327: -- ----------------------------------------------------------------------------
328: -- |---------------------------< update_validate >----------------------------|
329: -- ----------------------------------------------------------------------------
330: Procedure update_validate(p_rec in pqh_bvr_shd.g_rec_type
331: ,p_effective_date in date) is
332: --
333: l_proc varchar2(72) := g_package||'update_validate';
334: --

Line 369: Procedure delete_validate(p_rec in pqh_bvr_shd.g_rec_type

365: --
366: -- ----------------------------------------------------------------------------
367: -- |---------------------------< delete_validate >----------------------------|
368: -- ----------------------------------------------------------------------------
369: Procedure delete_validate(p_rec in pqh_bvr_shd.g_rec_type
370: ,p_effective_date in date) is
371: --
372: l_proc varchar2(72) := g_package||'delete_validate';
373: --