APPS.CS_PARTYMERGE_PKG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 339: -- Cursor to get impacted Contact point transactions due to party merge using TCA log table and CS_HZ_SR_Contact_Points table.

335: FROM hz_merge_parties
336: WHERE merge_reason_code <> 'SAME_PARTY_MERGE'
337: AND batch_id = p_batch_id;
338:
339: -- Cursor to get impacted Contact point transactions due to party merge using TCA log table and CS_HZ_SR_Contact_Points table.
340:
341: CURSOR C_get_contact_point_txns1 IS
342: SELECT p.from_entity_id ,
343: p.to_entity_id ,

Line 347: cs_hz_sr_contact_points cc

343: p.to_entity_id ,
344: p.batch_party_id,
345: cc.sr_contact_point_id
346: FROM hz_merge_party_log p,
347: cs_hz_sr_contact_points cc
348: WHERE p.merge_dict_id = 4
349: AND p.operation_type = 'Merge'
350: AND p.request_id = p_request_id
351: AND p.from_entity_id = cc.contact_point_id

Line 354: -- Cursor to get impacted Contact points data due to contact point merge using TCA log table and cs_hz_sr_contact_points table.

350: AND p.request_id = p_request_id
351: AND p.from_entity_id = cc.contact_point_id
352: AND cc.contact_type <> 'EMPLOYEE';
353:
354: -- Cursor to get impacted Contact points data due to contact point merge using TCA log table and cs_hz_sr_contact_points table.
355:
356: CURSOR c_Get_contact_point_txns2 IS
357: SELECT p.batch_party_id,
358: p.from_party_id ,

Line 362: cs_hz_sr_contact_points cc

358: p.from_party_id ,
359: p.to_party_id ,
360: cc.sr_contact_point_id
361: FROM hz_merge_parties p,
362: cs_hz_sr_contact_points cc
363: WHERE p.merge_type <> 'SAME_PARTY_MERGE'
364: AND p.batch_id = p_batch_id
365: AND p.from_party_id = cc.party_id
366: AND cc.contact_type <> 'EMPLOYEE';

Line 1021: -- Call SR routine to update party id in cs_hz_sr_contact_points table.

1017: IF l_from_party_id_tbl.count <> 0 AND l_last_fetch = FALSE THEN -- for last fetch
1018: EXIT;
1019: END IF ;
1020:
1021: -- Call SR routine to update party id in cs_hz_sr_contact_points table.
1022:
1023: FOR i IN 1..l_sr_contact_point_id_tbl.COUNT
1024: LOOP
1025: CS_SR_PARTY_MERGE_PKG.CS_CONTACTS_MERGE_PARTY

Line 1026: ( p_entity_name => 'CS_HZ_SR_CONTACT_POINTS',

1022:
1023: FOR i IN 1..l_sr_contact_point_id_tbl.COUNT
1024: LOOP
1025: CS_SR_PARTY_MERGE_PKG.CS_CONTACTS_MERGE_PARTY
1026: ( p_entity_name => 'CS_HZ_SR_CONTACT_POINTS',
1027: p_from_id => l_sr_contact_point_id_tbl(i),
1028: x_to_id => l_to_id,
1029: p_from_fk_id => l_from_party_id_tbl(i),
1030: p_to_fk_id => l_to_party_id_tbl(i),

Line 1114: ( p_entity_name => 'CS_HZ_SR_CONTACT_POINTS',

1110: FOR i IN 1..l_sr_contact_point_id_tbl.COUNT
1111:
1112: LOOP
1113: CS_SR_PARTY_MERGE_PKG.CS_CONTACTS_MERGE_CONT_POINTS
1114: ( p_entity_name => 'CS_HZ_SR_CONTACT_POINTS',
1115: p_from_id => l_sr_contact_point_id_tbl(i),
1116: x_to_id => l_to_id,
1117: p_from_fk_id => l_from_email_id_tbl(i),
1118: p_to_fk_id => l_to_email_id_tbl(i),