APPS.WSH_ITM_PARTY_SYNC dependencies on WSH_ITM_PARTY_CONTACTS

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

960: IF l_debug_on THEN
961: WSH_DEBUG_SV.LOG (l_module_name, 'Getting Contacts for Party : ' , l_varchar_PartyName_tab(i),WSH_DEBUG_SV.C_STMT_LEVEL);
962: END IF;
963:
964: /* Bug 7297690 Added check to determine whether Contacts for this party site is already being inserted into wsh_itm_party_contacts
965: - For each party site this query will be fired n no of times, n is no of usage of this site (billto, shipto etc)
966: - This needs to be reduced to one, since when the party site is queried first time, contacts will be added
967: and for all other hits contact will not be inserted since it is inserted first time itself. */
968: IF NOT l_party_site_id_cache.Exists(l_num_hzpartySiteID_tab(i)) THEN

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

1025:
1026:
1027: -- Added for Bug 3420203
1028: IF l_num_partyrel_tab.COUNT <> 0 THEN
1029: -- Bug 7297690 Added check to determine whether party contact is already being inserted into wsh_itm_party_contacts
1030: FOR j IN l_num_partyrel_tab.FIRST..l_num_partyrel_tab.LAST LOOP
1031: BEGIN
1032:
1033: IF (l_org_contact_cache(l_org_contact_id_tab(j)) = 'Y' ) THEN

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

1078:
1079: IF l_debug_on THEN
1080: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Contacts : ' , l_varchar_CtPartyName_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
1081: END IF;
1082: -- Bug 7297690 Inserting Party contact only if it is not already populated in wsh_itm_party_contacts
1083: if l_varchar_CtPartyName_tab.COUNT <> 0 THEN
1084:
1085: FOR j in l_varchar_CtPartyName_tab.FIRST..l_varchar_CtPartyName_tab.LAST LOOP
1086: -- WSH_DEBUG_SV.LOG (l_module_name,'org contact : ',l_org_contact_id_tab(j),WSH_DEBUG_SV.C_STMT_LEVEL);

Line 1095: insert into wsh_itm_party_contacts

1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: WSH_DEBUG_SV.LOG (l_module_name,'Party Contact being inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);
1094: l_org_contact_cache(l_org_contact_id_tab(j)) := 'Y';
1095: insert into wsh_itm_party_contacts
1096: (
1097: PARTY_ID ,
1098: NAME ,
1099: JOB_TITLE ,