APPS.CS_SR_PARTY_MERGE_PKG dependencies on CS_INCIDENTS_AUDIT_B

Line 412: -- Create an audit record for each service request in cs_incidents_audit_b table

408: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
409: arp_message.set_token('NUM_ROWS', to_char(l_count) );
410:
411:
412: -- Create an audit record for each service request in cs_incidents_audit_b table
413: -- for which the bill_to_site_use_id or ship_to_site_use_id is updated
414:
415: FOR i IN 1..l_incident_id.COUNT
416: LOOP

Line 712: -- create audit record in cs_incidents_audit_b table for each service

708:
709: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
710: arp_message.set_token('NUM_ROWS', to_char(l_count) );
711:
712: -- create audit record in cs_incidents_audit_b table for each service
713: -- request for which site_id is updated.
714:
715: FOR i IN 1..l_incident_id.COUNT
716: LOOP

Line 888: from cs_incidents_audit_b

884: x_return_status OUT NOCOPY VARCHAR2)
885: IS
886: cursor c1 is
887: select rowid
888: from cs_incidents_audit_b
889: where p_from_fk_id in (bill_to_contact_id, ship_to_contact_id, old_bill_to_contact_id,
890: old_ship_to_contact_id)
891: for update nowait;
892:

Line 941: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_AUDIT_B', FALSE);

937: if p_from_fk_id <> p_to_fk_id then
938: begin
939: -- obtain lock on records to be updated.
940: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
941: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_AUDIT_B', FALSE);
942:
943: open c1;
944: fetch c1 bulk collect into l_rowid_tbl;
945: close c1;

Line 952: update cs_incidents_audit_b

948: RETURN;
949: end if;
950:
951: forall i in 1.. l_rowid_tbl.count
952: update cs_incidents_audit_b
953: set bill_to_contact_id = decode(bill_to_contact_id, p_from_fk_id, p_to_fk_id,
954: bill_to_contact_id ),
955: old_bill_to_contact_id= decode(old_bill_to_contact_id, p_from_fk_id, p_to_fk_id,
956: old_bill_to_contact_id ),

Line 976: 'CS_INCIDENTS_AUDIT_B for bill_to_contact_id = ' || p_from_fk_id );

972: exception
973: when resource_busy then
974: arp_message.set_line(g_proc_name || '.' || l_api_name ||
975: '; Could not obtain lock for records in table ' ||
976: 'CS_INCIDENTS_AUDIT_B for bill_to_contact_id = ' || p_from_fk_id );
977:
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: raise;
980:

Line 1056: from cs_incidents_audit_b

1052: IS
1053: -- cursor fetches all the records that need to be merged.
1054: cursor c1 is
1055: select rowid
1056: from cs_incidents_audit_b
1057: where p_from_fk_id in (site_id, old_site_id)
1058: for update nowait;
1059:
1060: l_rowid_tbl ROWID_TBL;

Line 1108: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_AUDIT_B', FALSE);

1104: if p_from_fk_id <> p_to_fk_id then
1105: begin
1106: -- obtain lock on records to be updated.
1107: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1108: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_AUDIT_B', FALSE);
1109:
1110: open c1;
1111: fetch c1 bulk collect into l_rowid_tbl;
1112: close c1;

Line 1119: update cs_incidents_audit_b

1115: RETURN;
1116: end if;
1117:
1118: forall i in 1..l_rowid_tbl.count
1119: update cs_incidents_audit_b
1120: set site_id = decode(site_id, p_from_fk_id, p_to_fk_id,
1121: site_id),
1122: old_site_id = decode(old_site_id, p_from_fk_id, p_to_fk_id,
1123: old_site_id),

Line 1139: 'CS_INCIDENTS_AUDIT_B for site_id = ' || p_from_fk_id );

1135: exception
1136: when resource_busy then
1137: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1138: '; Could not obtain lock for records in table ' ||
1139: 'CS_INCIDENTS_AUDIT_B for site_id = ' || p_from_fk_id );
1140:
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: raise;
1143:

Line 2086: -- create audit record in cs_incidents_audit_b table for each service

2082:
2083: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
2084: arp_message.set_token('NUM_ROWS', to_char(l_count) );
2085:
2086: -- create audit record in cs_incidents_audit_b table for each service
2087: -- request for which site_id is updated.
2088:
2089: FOR i IN 1..l_incident_id.COUNT
2090: LOOP