DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_STAGED_CONTACTS

Line 641: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc

637: IF (l_to_id IS NULL OR l_to_id = FND_API.G_MISS_NUM OR
638: l_to_id = p_from_id) THEN
639: FOR ORG_CT IN (
640: SELECT oc.ORG_CONTACT_ID
641: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc
642: WHERE oc.PARTY_RELATIONSHIP_ID = p_from_id
643: AND SOC.ORG_CONTACT_ID=oc.ORG_CONTACT_ID) LOOP
644: HZ_DQM_SYNC.stage_contact_merge(
645: 'HZ_STAGED_CONTACTS',

Line 645: 'HZ_STAGED_CONTACTS',

641: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc
642: WHERE oc.PARTY_RELATIONSHIP_ID = p_from_id
643: AND SOC.ORG_CONTACT_ID=oc.ORG_CONTACT_ID) LOOP
644: HZ_DQM_SYNC.stage_contact_merge(
645: 'HZ_STAGED_CONTACTS',
646: ORG_CT.ORG_CONTACT_ID,l_dummy_id,
647: ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
648: 'HZ_ORG_CONTACTS',
649: p_batch_id,p_batch_party_id,x_return_status);

Line 700: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc

696: IF (l_to_id IS NULL OR l_to_id = FND_API.G_MISS_NUM OR
697: l_to_id = p_from_id) THEN
698: FOR ORG_CT IN (
699: SELECT oc.ORG_CONTACT_ID
700: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc
701: WHERE oc.PARTY_RELATIONSHIP_ID = p_from_id
702: AND SOC.ORG_CONTACT_ID=oc.ORG_CONTACT_ID) LOOP
703: HZ_DQM_SYNC.stage_contact_merge(
704: 'HZ_STAGED_CONTACTS',

Line 704: 'HZ_STAGED_CONTACTS',

700: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc
701: WHERE oc.PARTY_RELATIONSHIP_ID = p_from_id
702: AND SOC.ORG_CONTACT_ID=oc.ORG_CONTACT_ID) LOOP
703: HZ_DQM_SYNC.stage_contact_merge(
704: 'HZ_STAGED_CONTACTS',
705: ORG_CT.ORG_CONTACT_ID,l_dummy_id,
706: ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
707: 'HZ_ORG_CONTACTS',
708: p_batch_id,p_batch_party_id,x_return_status);

Line 799: FROM HZ_STAGED_CONTACTS soc

795: IF (l_to_id IS NULL OR l_to_id = FND_API.G_MISS_NUM OR
796: l_to_id = p_from_id) THEN
797: FOR ORG_CT IN (
798: SELECT soc.ORG_CONTACT_ID
799: FROM HZ_STAGED_CONTACTS soc
800: WHERE SOC.ORG_CONTACT_ID= p_from_id) LOOP
801: HZ_DQM_SYNC.stage_contact_merge(
802: 'HZ_STAGED_CONTACTS',
803: ORG_CT.ORG_CONTACT_ID,l_dummy_id,

Line 802: 'HZ_STAGED_CONTACTS',

798: SELECT soc.ORG_CONTACT_ID
799: FROM HZ_STAGED_CONTACTS soc
800: WHERE SOC.ORG_CONTACT_ID= p_from_id) LOOP
801: HZ_DQM_SYNC.stage_contact_merge(
802: 'HZ_STAGED_CONTACTS',
803: ORG_CT.ORG_CONTACT_ID,l_dummy_id,
804: ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
805: 'HZ_ORG_CONTACTS',
806: p_batch_id,p_batch_party_id,x_return_status);