DBA Data[Home] [Help]

APPS.IRC_INP_BUS dependencies on HZ_PARTIES

Line 344: -- Validates if the party id exists in the HZ_PARTIES with party_type = 'PERSON'

340: -- |---------------------------< chk_party_id >-------------------------------|
341: -- ----------------------------------------------------------------------------
342: --
343: -- Description:
344: -- Validates if the party id exists in the HZ_PARTIES with party_type = 'PERSON'
345: --
346: -- Prerequisites:
347: -- Must be called as the first step in insert_validate.
348: --

Line 353: -- If the party_id is existing in HZ_PARTIES with party_type = 'PERSON'

349: -- In Arguments:
350: -- p_party_id
351: --
352: -- Post Success:
353: -- If the party_id is existing in HZ_PARTIES with party_type = 'PERSON'
354: -- then continue.
355: --
356: -- Post Failure:
357: -- If the party_id does not existing in HZ_PARTIES with party_type = 'PERSON'

Line 357: -- If the party_id does not existing in HZ_PARTIES with party_type = 'PERSON'

353: -- If the party_id is existing in HZ_PARTIES with party_type = 'PERSON'
354: -- then continue.
355: --
356: -- Post Failure:
357: -- If the party_id does not existing in HZ_PARTIES with party_type = 'PERSON'
358: -- then throw an error indicating the same.
359: --
360: -- Access Status:
361: -- Internal Row Handler Use Only.

Line 375: from hz_parties

371: --
372: l_inp_pk varchar2(1);
373: cursor csr_party_id is
374: select 1
375: from hz_parties
376: where party_id = p_party_id
377: and party_type = 'PERSON';
378: --
379: cursor csr_chk_inp_pk is