DBA Data[Home] [Help]

APPS.PQH_BRE_BUS dependencies on HR_API

Line 56: hr_api.mandatory_arg_error

52: hr_utility.set_location('Entering:'|| l_proc, 10);
53: --
54: -- Ensure that all the mandatory parameter are not null
55: --
56: hr_api.mandatory_arg_error
57: (p_api_name => l_proc
58: ,p_argument => 'transaction_type'
59: ,p_argument_value => p_transaction_type );
60: if p_transaction_type IN ('D','R') then

Line 61: hr_api.mandatory_arg_error

57: (p_api_name => l_proc
58: ,p_argument => 'transaction_type'
59: ,p_argument_value => p_transaction_type );
60: if p_transaction_type IN ('D','R') then
61: hr_api.mandatory_arg_error
62: (p_api_name => l_proc
63: ,p_argument => 'pool_id'
64: ,p_argument_value => p_pool_id
65: );

Line 67: hr_api.mandatory_arg_error

63: ,p_argument => 'pool_id'
64: ,p_argument_value => p_pool_id
65: );
66: elsif p_transaction_type IN ('DD','RD') then
67: hr_api.mandatory_arg_error
68: (p_api_name => l_proc
69: ,p_argument => 'txn_detail_id'
70: ,p_argument_value => p_txn_detail_id);
71: end if;

Line 94: hr_api.set_security_group_id

90: close csr_trnx_dtl_sec_grp;
91: --
92: -- Set the security_group_id in CLIENT_INFO
93: --
94: hr_api.set_security_group_id
95: (p_security_group_id => l_security_group_id
96: );
97: end if;
98: elsif p_transaction_type IN ('DD','RD') then

Line 119: hr_api.set_security_group_id

115: close csr_trnx_amt_sec_grp;
116: --
117: -- Set the security_group_id in CLIENT_INFO
118: --
119: hr_api.set_security_group_id
120: (p_security_group_id => l_security_group_id
121: );
122: end if;
123: end if;

Line 165: hr_api.mandatory_arg_error

161: hr_utility.set_location('Entering:'|| l_proc, 10);
162: --
163: -- Ensure that all the mandatory parameter are not null
164: --
165: hr_api.mandatory_arg_error
166: (p_api_name => l_proc
167: ,p_argument => 'reallocation_id'
168: ,p_argument_value => p_reallocation_id
169: );

Line 171: if ( nvl(pqh_bre_bus.g_reallocation_id, hr_api.g_number)

167: ,p_argument => 'reallocation_id'
168: ,p_argument_value => p_reallocation_id
169: );
170: --
171: if ( nvl(pqh_bre_bus.g_reallocation_id, hr_api.g_number)
172: = p_reallocation_id) then
173: --
174: -- The legislation code has already been found with a previous
175: -- call to this function. Just return the value in the global

Line 305: and nvl(p_reallocation_id,hr_api.g_number)

301: (p_reallocation_id => p_reallocation_id,
302: p_object_version_number => p_object_version_number);
303: --
304: if (l_api_updating
305: and nvl(p_reallocation_id,hr_api.g_number)
306: <> pqh_bre_shd.g_old_rec.reallocation_id) then
307: --
308: -- raise error as PK has changed
309: --

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

381: (p_reallocation_id => p_reallocation_id,
382: p_object_version_number => p_object_version_number);
383: --
384: if (l_api_updating
385: and nvl(p_pool_id,hr_api.g_number)
386: <> nvl(pqh_bre_shd.g_old_rec.pool_id,hr_api.g_number)
387: or not l_api_updating) then
388: --
389: -- check if pool_id value exists in pqh_budget_pools table

Line 386: <> nvl(pqh_bre_shd.g_old_rec.pool_id,hr_api.g_number)

382: p_object_version_number => p_object_version_number);
383: --
384: if (l_api_updating
385: and nvl(p_pool_id,hr_api.g_number)
386: <> nvl(pqh_bre_shd.g_old_rec.pool_id,hr_api.g_number)
387: or not l_api_updating) then
388: --
389: -- check if pool_id value exists in pqh_budget_pools table
390: --

Line 419: and nvl(p_txn_detail_id,hr_api.g_number)

415: (p_reallocation_id => p_reallocation_id,
416: p_object_version_number => p_object_version_number);
417: --
418: if (l_api_updating
419: and nvl(p_txn_detail_id,hr_api.g_number)
420: <> nvl(pqh_bre_shd.g_old_rec.txn_detail_id,hr_api.g_number)
421: or not l_api_updating) then
422: --
423: -- check if txn_detail_id value exists in pqh_bdgt_pool_realloctions table

Line 420: <> nvl(pqh_bre_shd.g_old_rec.txn_detail_id,hr_api.g_number)

416: p_object_version_number => p_object_version_number);
417: --
418: if (l_api_updating
419: and nvl(p_txn_detail_id,hr_api.g_number)
420: <> nvl(pqh_bre_shd.g_old_rec.txn_detail_id,hr_api.g_number)
421: or not l_api_updating) then
422: --
423: -- check if txn_detail_id value exists in pqh_bdgt_pool_realloctions table
424: --

Line 468: and nvl(p_reserved_amt,hr_api.g_number)

464: (p_reallocation_id => p_reallocation_id,
465: p_object_version_number => p_object_version_number);
466: --
467: if (l_api_updating
468: and nvl(p_reserved_amt,hr_api.g_number)
469: <> nvl(pqh_bre_shd.g_old_rec.reserved_amt,hr_api.g_number)
470: or not l_api_updating) then
471: --
472: -- check if reserved_amt is greater than 0.

Line 469: <> nvl(pqh_bre_shd.g_old_rec.reserved_amt,hr_api.g_number)

465: p_object_version_number => p_object_version_number);
466: --
467: if (l_api_updating
468: and nvl(p_reserved_amt,hr_api.g_number)
469: <> nvl(pqh_bre_shd.g_old_rec.reserved_amt,hr_api.g_number)
470: or not l_api_updating) then
471: --
472: -- check if reserved_amt is greater than 0.
473: --