APPS.PQH_BPL_BUS dependencies on HR_API

Line 45: hr_api.mandatory_arg_error

41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
46: (p_api_name => l_proc
47: ,p_argument => 'pool_id'
48: ,p_argument_value => p_pool_id
49: );

Line 71: hr_api.set_security_group_id

67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --

Line 109: hr_api.mandatory_arg_error

105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'pool_id'
112: ,p_argument_value => p_pool_id
113: );

Line 115: if ( nvl(pqh_bpl_bus.g_pool_id, hr_api.g_number)

111: ,p_argument => 'pool_id'
112: ,p_argument_value => p_pool_id
113: );
114: --
115: if ( nvl(pqh_bpl_bus.g_pool_id, hr_api.g_number)
116: = p_pool_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global

Line 244: and nvl(p_pool_id,hr_api.g_number)

240: (p_pool_id => p_pool_id,
241: p_object_version_number => p_object_version_number);
242: --
243: if (l_api_updating
244: and nvl(p_pool_id,hr_api.g_number)
245: <> pqh_bpl_shd.g_old_rec.pool_id) then
246: --
247: -- raise error as PK has changed
248: --

Line 321: and nvl(p_budget_version_id,hr_api.g_number)

317: (p_pool_id => p_pool_id,
318: p_object_version_number => p_object_version_number);
319: --
320: if (l_api_updating
321: and nvl(p_budget_version_id,hr_api.g_number)
322: <> nvl(pqh_bpl_shd.g_old_rec.budget_version_id,hr_api.g_number)
323: or not l_api_updating) then
324: --
325: -- check if budget_version_id value exists in pqh_budgets table

Line 322: <> nvl(pqh_bpl_shd.g_old_rec.budget_version_id,hr_api.g_number)

318: p_object_version_number => p_object_version_number);
319: --
320: if (l_api_updating
321: and nvl(p_budget_version_id,hr_api.g_number)
322: <> nvl(pqh_bpl_shd.g_old_rec.budget_version_id,hr_api.g_number)
323: or not l_api_updating) then
324: --
325: -- check if budget_version_id value exists in pqh_budgets table
326: --

Line 443: <> nvl(pqh_bpl_shd.g_old_rec.budget_unit_id,hr_api.g_number)

439: p_object_version_number => p_object_version_number);
440: --
441: if (l_api_updating
442: and p_budget_unit_id
443: <> nvl(pqh_bpl_shd.g_old_rec.budget_unit_id,hr_api.g_number)
444: or not l_api_updating) then
445: --
446: -- check if value of budget_unit falls within per shared types
447: --

Line 580: <> nvl(pqh_bpl_shd.g_old_rec.name,hr_api.g_varchar2)

576: p_object_version_number => p_object_version_number);
577: --
578: if (l_api_updating
579: and p_name
580: <> nvl(pqh_bpl_shd.g_old_rec.name,hr_api.g_varchar2)
581: or not l_api_updating) then
582:
583: If p_name IS NULL then
584: If p_parent_pool_id IS NULL Then

Line 648: and (nvl(p_budget_version_id,hr_api.g_number)

644: (p_pool_id => p_pool_id,
645: p_object_version_number => p_object_version_number);
646: --
647: if (l_api_updating
648: and (nvl(p_budget_version_id,hr_api.g_number)
649: <> nvl(pqh_bpl_shd.g_old_rec.budget_version_id,hr_api.g_number)
650: or p_budget_unit_id
651: <> nvl(pqh_bpl_shd.g_old_rec.budget_unit_id,hr_api.g_number) )
652: or not l_api_updating) then

Line 649: <> nvl(pqh_bpl_shd.g_old_rec.budget_version_id,hr_api.g_number)

645: p_object_version_number => p_object_version_number);
646: --
647: if (l_api_updating
648: and (nvl(p_budget_version_id,hr_api.g_number)
649: <> nvl(pqh_bpl_shd.g_old_rec.budget_version_id,hr_api.g_number)
650: or p_budget_unit_id
651: <> nvl(pqh_bpl_shd.g_old_rec.budget_unit_id,hr_api.g_number) )
652: or not l_api_updating) then
653: --

Line 651: <> nvl(pqh_bpl_shd.g_old_rec.budget_unit_id,hr_api.g_number) )

647: if (l_api_updating
648: and (nvl(p_budget_version_id,hr_api.g_number)
649: <> nvl(pqh_bpl_shd.g_old_rec.budget_version_id,hr_api.g_number)
650: or p_budget_unit_id
651: <> nvl(pqh_bpl_shd.g_old_rec.budget_unit_id,hr_api.g_number) )
652: or not l_api_updating) then
653: --
654: --
655: Open c1;

Line 711: hr_api.validate_bus_grp_id

707: hr_utility.set_location('Entering:'||l_proc, 5);
708: --
709: -- Call all supporting business operations
710: --
711: hr_api.validate_bus_grp_id
712: (p_business_group_id => p_rec.business_group_id
713: ,p_associated_column1 => pqh_bpl_shd.g_tab_nam
714: || '.BUSINESS_GROUP_ID');
715: --

Line 771: hr_api.validate_bus_grp_id

767: hr_utility.set_location('Entering:'||l_proc, 5);
768: --
769: -- Call all supporting business operations
770: --
771: hr_api.validate_bus_grp_id
772: (p_business_group_id => p_rec.business_group_id
773: ,p_associated_column1 => pqh_bpl_shd.g_tab_nam
774: || '.BUSINESS_GROUP_ID');
775: chk_pool_id