1260: l_return_status VARCHAR2(1);
1261:
1262: CURSOR C_Party_Site_Exists (X_Party_Id NUMBER, X_Party_Site_Id NUMBER) IS
1263: SELECT 1
1264: FROM AS_PARTY_ADDRESSES_V
1265: WHERE party_id = X_Party_Id
1266: AND party_site_id = X_Party_Site_Id;
1267:
1268: -- C_Party_Site_Exists_For_Partner_Party
1267:
1268: -- C_Party_Site_Exists_For_Partner_Party
1269: CURSOR C_Party_Site_Exists_Partner (X_Party_Id NUMBER, X_Party_Site_Id NUMBER) IS
1270: SELECT 1
1271: FROM AS_PARTY_ADDRESSES_V
1272: WHERE party_id = (SELECT PARTNER_PARTY_ID FROM PV_PARTNER_PROFILES WHERE PARTNER_ID = X_Party_Id)
1273: AND party_site_id = X_Party_Site_Id;
1274:
1275: BEGIN