APPS.CS_PARTYMERGE_PKG dependencies on CS_INCIDENTS_ALL_B

Line 168: FROM cs_incidents_all_B i,

164: i.customer_email_id,
165: pce.from_entity_id from_email_id,
166: pce.to_entity_id to_email_id ,
167: i.last_update_program_code
168: FROM cs_incidents_all_B i,
169: hz_merge_party_log pc,
170: hz_merge_party_log pbp,
171: hz_merge_party_log psp,
172: hz_merge_party_log pbc,

Line 416: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);

412: END IF;
413: END IF;
414: -- obtain lock on records to be updated.
415: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
416: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
417:
418: OPEN C_Get_ServiceRequests;
419: LOOP -- Loop for BULK SR processing in a batch of 1000
420:

Line 494: -- update cs_incidents_all_b table

490: IF l_rowid_tbl.count <> 0 AND NOT l_last_fetch THEN -- for last fetch
491: EXIT;
492: END IF;
493:
494: -- update cs_incidents_all_b table
495:
496: FORALL i IN 1..l_rowid_tbl.COUNT -- ..l_rowid_tbl.LAST
497:
498: UPDATE cs_incidents_all_b i

Line 498: UPDATE cs_incidents_all_b i

494: -- update cs_incidents_all_b table
495:
496: FORALL i IN 1..l_rowid_tbl.COUNT -- ..l_rowid_tbl.LAST
497:
498: UPDATE cs_incidents_all_b i
499: SET i.customer_id = DECODE(i.customer_id,l_from_party_id_tbl(i),
500: l_to_party_id_tbl(i) , i.customer_id),
501: i.bill_to_party_id = DECODE(i.bill_to_party_id,l_from_bill_to_party_id_tbl(i),
502: l_to_bill_to_party_id_tbl(i),i.bill_to_party_id),

Line 709: 'CS_INCIDENTS_ALL_B for columns referring HZ parties');

705: RAISE;
706:
707: WHEN resource_busy THEN
708: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||
709: 'CS_INCIDENTS_ALL_B for columns referring HZ parties');
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: ROLLBACK;
712: RAISE;
713: