APPS.PVX_PARTY_MERGE_PKG dependencies on PV_PARTNER_PROFILES

Line 150: SELECT partner_party_id from pv_partner_profiles where

146: FUNCTION IsPVPartner(p_party_id NUMBER)
147: return VARCHAR2
148: IS
149: CURSOR IsPVPartner IS
150: SELECT partner_party_id from pv_partner_profiles where
151: partner_party_id = p_party_id and
152: (status = 'A' OR STATUS = 'I');
153:
154: l_partner_party_id number;

Line 181: FROM pv_partner_profiles ppp,

177: IS
178:
179: CURSOR intVendOrg_csr(cv_party_id NUMBER, cv_partner_id NUMBER) IS
180: SELECT hzr.object_id
181: FROM pv_partner_profiles ppp,
182: hz_relationships hzr
183: WHERE ppp.partner_party_id = cv_party_id
184: AND ppp.partner_id = cv_partner_id
185: AND hzr.subject_id = ppp.partner_party_id

Line 284: FROM pv_partner_profiles a,

280: -- hz_relationships. We don't need any that have been "merged."
281: -- ------------------------------------------------------------------
282: /* CURSOR c1 IS
283: SELECT DISTINCT a.partner_profile_id, a.partner_party_id, b.party_id partner_id
284: FROM pv_partner_profiles a,
285: hz_relationships b
286: WHERE a.partner_party_id = p_from_fk_id AND
287: a.partner_id = b.party_id AND
288: b.relationship_code = 'PARTNER_OF' AND

Line 294: FROM pv_partner_profiles

290:
291: /**** Fixed the issue reported in bug # 5307731 by adding STATUS check **********/
292: CURSOR c1 IS
293: SELECT partner_profile_id, partner_party_id, partner_id
294: FROM pv_partner_profiles
295: WHERE partner_party_id = p_from_fk_id
296: AND status = 'A';
297:
298: /**** Fixed the issue reported in bug # 5307731 by adding STATUS check **********/

Line 301: FROM pv_partner_profiles

297:
298: /**** Fixed the issue reported in bug # 5307731 by adding STATUS check **********/
299: CURSOR c2 IS
300: SELECT partner_profile_id, partner_party_id, partner_id
301: FROM pv_partner_profiles
302: WHERE partner_party_id = p_to_fk_id
303: AND status = 'A';
304:
305: BEGIN

Line 323: UPDATE pv_partner_profiles

319: -- corresponding PARTNER_OF relationship has a status of 'M'. We are
320: -- only interested in "active" ones.
321: -- -------------------------------------------------------------------
322: /* FOR x IN c1 LOOP
323: UPDATE pv_partner_profiles
324: SET partner_party_id = p_to_fk_id,
325: last_update_date = SYSDATE,
326: last_updated_by = G_USER_ID,
327: last_update_login = G_LOGIN_ID

Line 340: UPDATE pv_partner_profiles

336: FOR x IN c1 LOOP
337: FOR y IN c2 LOOP
338: IF get_intVendorOrg(x.partner_party_id, x.partner_id) = get_intVendorOrg(y.partner_party_id, y.partner_id)
339: THEN
340: UPDATE pv_partner_profiles
341: SET status = 'M',
342: last_update_date = SYSDATE,
343: last_updated_by = G_USER_ID,
344: last_update_login = G_LOGIN_ID

Line 348: UPDATE pv_partner_profiles

344: last_update_login = G_LOGIN_ID
345: WHERE partner_profile_id = x.partner_profile_id;
346: ELSE
347:
348: UPDATE pv_partner_profiles
349: SET partner_party_id = p_to_fk_id,
350: last_update_date = SYSDATE,
351: last_updated_by = G_USER_ID,
352: last_update_login = G_LOGIN_ID

Line 361: UPDATE pv_partner_profiles

357: else
358:
359: -- Update the party id of the partner to that of customer/Non PRM partner
360: FOR x IN c1 LOOP
361: UPDATE pv_partner_profiles
362: SET partner_party_id = p_to_fk_id,
363: last_update_date = SYSDATE,
364: last_updated_by = G_USER_ID,
365: last_update_login = G_LOGIN_ID