APPS.WSH_ITM_PARTY_SYNC dependencies on WSH_ITM_PARTY_CONTACTS

Line 1305: /* Bug 7297690 Added check to determine whether Contacts for this party site is already being inserted into wsh_itm_party_contacts

1301: END IF;
1302: -- gtm {
1303: if (l_num_hzpartySiteID_tab.count <> 0 and l_num_hzpartySiteID_tab(i) is not NULL ) then
1304:
1305: /* Bug 7297690 Added check to determine whether Contacts for this party site is already being inserted into wsh_itm_party_contacts
1306: - For each party site this query will be fired n no of times, n is no of usage of this site (billto, shipto etc)
1307: - This needs to be reduced to one, since when the party site is queried first time, contacts will be added
1308: and for all other hits contact will not be inserted since it is inserted first time itself. */
1309: IF NOT l_party_site_id_cache.Exists(l_num_hzpartySiteID_tab(i)) THEN

Line 1408: -- Bug 7297690 Added check to determine whether party contact is already being inserted into wsh_itm_party_contacts

1404:
1405:
1406: -- Added for Bug 3420203
1407: IF l_num_partyrel_tab.COUNT <> 0 THEN
1408: -- Bug 7297690 Added check to determine whether party contact is already being inserted into wsh_itm_party_contacts
1409: FOR j IN l_num_partyrel_tab.FIRST..l_num_partyrel_tab.LAST LOOP
1410: BEGIN
1411:
1412: IF (l_org_contact_cache(l_org_contact_id_tab(j)) = 'Y' ) THEN

Line 1463: -- Bug 7297690 Inserting Party contact only if it is not already populated in wsh_itm_party_contacts

1459:
1460: IF l_debug_on THEN
1461: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Contacts : ' , l_varchar_CtPartyName_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
1462: END IF;
1463: -- Bug 7297690 Inserting Party contact only if it is not already populated in wsh_itm_party_contacts
1464: if l_varchar_CtPartyName_tab.COUNT <> 0 THEN
1465:
1466: FOR j in l_varchar_CtPartyName_tab.FIRST..l_varchar_CtPartyName_tab.LAST LOOP
1467: -- WSH_DEBUG_SV.LOG (l_module_name,'org contact : ',l_org_contact_id_tab(j),WSH_DEBUG_SV.C_STMT_LEVEL);

Line 1480: insert into wsh_itm_party_contacts

1476: IF l_debug_on THEN
1477: WSH_DEBUG_SV.LOGMSG (l_module_name,'Party Contact being inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);
1478: END IF;
1479: l_org_contact_cache(l_org_contact_id_tab(j)) := 'Y';
1480: insert into wsh_itm_party_contacts
1481: (
1482: PARTY_ID ,
1483: NAME ,
1484: JOB_TITLE ,