DBA Data[Home] [Help]

APPS.PER_ADD_BUS dependencies on HZ_PARTIES

Line 267: -- - Validates that a party id exists in table hz_parties.

263: -- |---------------------------< chk_party_id >----------------------------|
264: -- ---------------------------------------------------------------------------
265: --
266: -- Description:
267: -- - Validates that a party id exists in table hz_parties.
268: --
269: -- Pre-conditions:
270: -- None.
271: --

Line 276: -- If a row does exist in hz_parties for the given party id then

272: -- In Arguments:
273: -- p_party_id
274: --
275: -- Post Success:
276: -- If a row does exist in hz_parties for the given party id then
277: -- processing continues.
278: --
279: -- Post Failure:
280: -- If a row does not exist in hz_parties for the given party id then

Line 280: -- If a row does not exist in hz_parties for the given party id then

276: -- If a row does exist in hz_parties for the given party id then
277: -- processing continues.
278: --
279: -- Post Failure:
280: -- If a row does not exist in hz_parties for the given party id then
281: -- an application error will be raised and processing is terminated.
282: --
283: -- Access Status:
284: -- Internal Table Handler Use Only.

Line 313: from hz_parties hzp

309: and nvl(per.effective_end_date,hr_api.g_eot);
310: --
311: cursor csr_valid_party_id is
312: select party_id
313: from hz_parties hzp
314: where hzp.party_id = p_rec.party_id;
315: --
316: begin
317: hr_utility.set_location('Entering:'|| l_proc, 1);