APPS.CS_CH_PARTY_MERGE_PKG dependencies on CS_CHG_SUB_RESTRICTIONS

Line 9: -- CS_ESTIMATE_DETAILS and CS_CHG_SUB_RESTRICTIONS.

5: -- Package name : CS_CH_PARTY_MERGE_PKG
6: -- Purpose : Merges duplicate party_sites in Service tables. The
7: -- Service tables that need to be considered
8: -- are:
9: -- CS_ESTIMATE_DETAILS and CS_CHG_SUB_RESTRICTIONS.
10: --
11: -- History
12: -- MM-DD-YYYY NAME MODIFICATIONS
13: -- 11-20-2000 aseethep Created.

Line 296: -- The following procedure merges CS_CHG_SUB_RESTRICTIONS columns:

292: end if;
293:
294: END CS_CHG_ALL_MERGE_SITE_ID;
295:
296: -- The following procedure merges CS_CHG_SUB_RESTRICTIONS columns:
297: -- value_object_id
298:
299: PROCEDURE CS_CHG_ALL_SETUP_PARTY(
300: p_entity_name IN VARCHAR2,

Line 316: from cs_chg_sub_restrictions

312: --then process all rows.
313: --cursor fetches all the records that need to be merged.
314: cursor c1 is
315: select rowid
316: from cs_chg_sub_restrictions
317: where value_object_id = p_from_fk_id
318: and restriction_type = 'BILL_TO_CUSTOMER'
319: for update nowait;
320:

Line 325: from cs_chg_sub_restrictions

321: --add cursor to check for active restrictions which are of p_to_fk_id
322: --Fix for Bug # 3599517
323: cursor c_active_restrictions is
324: select restriction_id, value_object_id
325: from cs_chg_sub_restrictions
326: where restriction_type = 'BILL_TO_CUSTOMER'
327: and end_date_active IS NULL;
328:
329:

Line 368: arp_message.set_token('TABLE_NAME', 'CS_CHG_SUB_RESTRICTIONS', FALSE);

364: if p_from_fk_id <> p_to_fk_id then
365: begin
366: -- obtain lock on records to be updated.
367: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
368: arp_message.set_token('TABLE_NAME', 'CS_CHG_SUB_RESTRICTIONS', FALSE);
369:
370: open c1;
371: fetch c1 bulk collect into l_rowid_tbl;
372: close c1;

Line 395: update cs_chg_sub_restrictions

391: l_to_match_found = 'Y';
392: END LOOP;
393:
394: forall i in 1..l_rowid_tbl.count
395: update cs_chg_sub_restrictions
396: set value_object_id = decode(value_object_id, p_from_fk_id, p_to_fk_id,value_object_id),
397: object_version_number = object_version_number + 1,
398: last_update_date = SYSDATE,
399: last_updated_by = G_USER_ID,

Line 413: update cs_chg_sub_restrictions

409: --p_to_fk_id since there can only be one active restriction at any one point
410: --Fix for Bug # 3599517
411: IF l_to_match_found = 'Y' AND
412: l_from_match_found = 'Y' THEN
413: update cs_chg_sub_restrictions
414: set end_date_active = SYSDATE - 1
415: where restriction_id = l_from_restriction_id;
416: ELSE
417: null;

Line 424: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CS_CHG_SUB_RESTRICTIONS for value_object_id' || 'bill_to_contact_id / ship_to_contact_id = ' || p_from_fk_id );

420:
421:
422: exception
423: when resource_busy then
424: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CS_CHG_SUB_RESTRICTIONS for value_object_id' || 'bill_to_contact_id / ship_to_contact_id = ' || p_from_fk_id );
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: raise;
427:
428: when others then