APPS.PQH_BFS_BUS dependencies on PQH_BFS_SHD

Line 46: l_api_updating := pqh_bfs_shd.api_updating

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

Line 52: <> pqh_bfs_shd.g_old_rec.budget_fund_src_id) then

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

Line 56: pqh_bfs_shd.constraint_error('PQH_BUDGET_FUND_SRC_PK');

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

Line 66: pqh_bfs_shd.constraint_error('PQH_BUDGET_FUND_SRC_PK');

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

Line 118: l_api_updating := pqh_bfs_shd.api_updating

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

Line 124: <> nvl(pqh_bfs_shd.g_old_rec.budget_element_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_element_id,hr_api.g_number)
124: <> nvl(pqh_bfs_shd.g_old_rec.budget_element_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if budget_element_id value exists in pqh_budget_elements table
128: --

Line 139: pqh_bfs_shd.constraint_error('PQH_BUDGET_FUND_SRCS_FK1');

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

Line 240: l_api_updating := pqh_bfs_shd.api_updating

236: Begin
237: --
238: hr_utility.set_location('Entering:'||l_proc,5);
239: --
240: l_api_updating := pqh_bfs_shd.api_updating
241: (p_budget_fund_src_id => p_budget_fund_src_id,
242: p_object_version_number => p_object_version_number);
243: --
244: if (l_api_updating

Line 246: <> nvl(pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id,hr_api.g_number)

242: p_object_version_number => p_object_version_number);
243: --
244: if (l_api_updating
245: and nvl(p_cost_allocation_keyflex_id,hr_api.g_number)
246: <> nvl(pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id,hr_api.g_number)
247: or not l_api_updating) and p_cost_allocation_keyflex_id is not null then
248: --
249: -- check if cost_allocation_keyflex_id value exists in pay_cost_allocation_keyflex table
250: --

Line 277: Procedure insert_validate(p_rec in pqh_bfs_shd.g_rec_type) is

273:
274: -- ----------------------------------------------------------------------------
275: -- |---------------------------< insert_validate >----------------------------|
276: -- ----------------------------------------------------------------------------
277: Procedure insert_validate(p_rec in pqh_bfs_shd.g_rec_type) is
278: --
279: l_proc varchar2(72) := g_package||'insert_validate';
280: --
281: Begin

Line 315: Procedure update_validate(p_rec in pqh_bfs_shd.g_rec_type) is

311: --
312: -- ----------------------------------------------------------------------------
313: -- |---------------------------< update_validate >----------------------------|
314: -- ----------------------------------------------------------------------------
315: Procedure update_validate(p_rec in pqh_bfs_shd.g_rec_type) is
316: --
317: l_proc varchar2(72) := g_package||'update_validate';
318: --
319: Begin

Line 354: Procedure delete_validate(p_rec in pqh_bfs_shd.g_rec_type) is

350: --
351: -- ----------------------------------------------------------------------------
352: -- |---------------------------< delete_validate >----------------------------|
353: -- ----------------------------------------------------------------------------
354: Procedure delete_validate(p_rec in pqh_bfs_shd.g_rec_type) is
355: --
356: l_proc varchar2(72) := g_package||'delete_validate';
357: --
358: Begin