APPS.IGW_PARTY_MERGE_PUB dependencies on IGW_PROP_PERSON_SUPPORT

Line 356: update igw_prop_person_support

352: RAISE fnd_api.g_exc_error;
353: end;
354:
355: begin
356: update igw_prop_person_support
357: set party_id = p_to_fk_id
358: where proposal_id = from_party_rec.proposal_id
359: and party_id = from_party_rec.person_party_id;
360: exception

Line 527: from igw_prop_person_support

523: x_return_status OUT NOCOPY VARCHAR2) IS
524:
525: cursor from_party_cur(l_prop_person_support_id number) is
526: select *
527: from igw_prop_person_support
528: where prop_person_support_id = l_prop_person_support_id;
529:
530: from_party_rec from_party_cur%rowtype;
531:

Line 549: if (p_entity_name <> 'IGW_PROP_PERSON_SUPPORT')

545: savepoint party_merge_sp;
546:
547: x_return_status := fnd_api.g_ret_sts_success;
548:
549: if (p_entity_name <> 'IGW_PROP_PERSON_SUPPORT')
550: or (p_parent_entity_name <> 'HZ_PARTIES') then
551: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
552: fnd_message.set_token('P_ENTITY',p_entity_name);
553: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

Line 576: update igw_prop_person_support

572: RAISE fnd_api.g_exc_error;
573:
574: else */
575: --update from record with new party id
576: update igw_prop_person_support
577: set location_party_id = p_to_fk_id
578: where prop_person_support_id = p_from_id
579: and location_party_id = p_from_fk_id;
580:

Line 619: from igw_prop_person_support

615: x_return_status OUT NOCOPY VARCHAR2) IS
616:
617: cursor from_party_cur(l_prop_person_support_id number) is
618: select *
619: from igw_prop_person_support
620: where prop_person_support_id = l_prop_person_support_id;
621:
622: from_party_rec from_party_cur%rowtype;
623:

Line 641: if (p_entity_name <> 'IGW_PROP_PERSON_SUPPORT')

637: savepoint party_merge_sp;
638:
639: x_return_status := fnd_api.g_ret_sts_success;
640:
641: if (p_entity_name <> 'IGW_PROP_PERSON_SUPPORT')
642: or (p_parent_entity_name <> 'HZ_PARTIES') then
643: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
644: fnd_message.set_token('P_ENTITY',p_entity_name);
645: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

Line 668: update igw_prop_person_support

664: RAISE fnd_api.g_exc_error;
665:
666: else */
667: --update from record with new party id
668: update igw_prop_person_support
669: set pi_party_id = p_to_fk_id
670: where prop_person_support_id = p_from_id
671: and pi_party_id = p_from_fk_id;
672: