APPS.CS_PARTYMERGE_PKG dependencies on CS_ESTIMATE_DETAILS

Line 291: FROM cs_estimate_details c,

287: pbs.to_entity_id to_bill_to_site_id,
288: c.ship_to_org_id,
289: pss.from_entity_id from_ship_to_site_id,
290: pss.to_entity_id to_ship_to_site_id
291: FROM cs_estimate_details c,
292: hz_merge_party_log pbp,
293: hz_merge_party_log psp,
294: hz_merge_party_log pbc,
295: hz_merge_party_log psc,

Line 830: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS', FALSE);

826:
827: -- get all the impacted SR Charges transactions in a batch of 1000 .
828: -- obtain lock on records to be updated.
829: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
830: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS', FALSE);
831:
832: OPEN C_Get_Estimate_details;
833: LOOP -- Loop for BULK SR charges processing in a batch of 1000
834: FETCH C_Get_Estimate_details BULK COLLECT

Line 874: -- update cs_estimate_details table

870: END IF;
871: END IF;
872: END IF;
873:
874: -- update cs_estimate_details table
875:
876: FORALL i IN 1..l_rowid_tbl.COUNT
877:
878: UPDATE cs_estimate_details c

Line 878: UPDATE cs_estimate_details c

874: -- update cs_estimate_details table
875:
876: FORALL i IN 1..l_rowid_tbl.COUNT
877:
878: UPDATE cs_estimate_details c
879: SET c.bill_to_party_id = DECODE(c.bill_to_party_id , l_from_bill_to_party_id_tbl(i) ,
880: l_to_bill_to_party_id_tbl(i) , c.bill_to_party_id),
881: c.ship_to_party_id = DECODE(c.ship_to_party_id , l_from_ship_to_party_id_tbl(i) ,
882: l_to_ship_to_party_id_tbl(i) , c.ship_to_party_id),

Line 922: 'CS_ESTIMATE_DETAILS for columns referring HZ entities');

918:
919: EXCEPTION
920: WHEN resource_busy THEN
921: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||
922: 'CS_ESTIMATE_DETAILS for columns referring HZ entities');
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: ROLLBACK;
925: RAISE;
926:

Line 1108: -- update cs_estimate_details table

1104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_PartyMerge_PKG.Update_CS_Data', dbg_msg);
1105: END IF;
1106: END IF;
1107: END IF;
1108: -- update cs_estimate_details table
1109:
1110: FOR i IN 1..l_sr_contact_point_id_tbl.COUNT
1111:
1112: LOOP

Line 1195: -- update cs_estimate_details table

1191: END IF;
1192: END IF;
1193: END IF;
1194:
1195: -- update cs_estimate_details table
1196: -- Call Charges party merge routine for sub restrictions.
1197:
1198: FOR i IN 1..l_from_party_id_tbl.COUNT
1199:

Line 1295: -- update cs_estimate_details table

1291: END IF;
1292: END IF;
1293: END IF;
1294:
1295: -- update cs_estimate_details table
1296: -- Call Charges party merge routine for sub restrictions.
1297:
1298: FORALL i IN 1..l_rowid_tbl.COUNT
1299: