174: A.LEAD_NUMBER,
175: C.ORDER_ID,
176: C.QUOTE_HEADER_ID,
177: E.PARTY_NAME
178: FROM pv_referrals_b REF,
179: AS_LEADS_ALL A,
180: AS_STATUSES_B AA,
181: ASO_QUOTE_RELATED_OBJECTS B,
182: ASO_QUOTE_HEADERS_ALL C,
292: BEGIN
293: Debug('Updating ''' || x.referral_name || '''(referral_id: ' ||
294: x.referral_id || ')');
295:
296: UPDATE pv_referrals_b
297: SET referral_status = 'CLOSED_LOST_OPPTY',
298: status_change_date = SYSDATE
299: WHERE referral_id = x.referral_id;
300:
399: BEGIN
400: Debug('Updating ''' || x.referral_name || '''(referral_id: ' ||
401: x.referral_id || ')');
402:
403: UPDATE pv_referrals_b
404: SET referral_status = 'CLOSED_OPPTY_WON',
405: status_change_date = SYSDATE
406: WHERE referral_id = x.referral_id;
407:
502: BEGIN
503: Debug('Updating ''' || x.referral_name || '''(referral_id: ' ||
504: x.referral_id || ')');
505:
506: UPDATE pv_referrals_b
507: SET referral_status = 'CLOSED_DEAD_LEAD',
508: status_change_date = SYSDATE
509: WHERE referral_id = x.referral_id;
510:
606: BEGIN
607: Debug('Updating ''' || x.referral_name || '''(referral_id: ' ||
608: x.referral_id || ')');
609:
610: UPDATE pv_referrals_b
611: SET referral_status = 'EXPIRED',
612: status_change_date = SYSDATE
613: WHERE referral_id = x.referral_id;
614:
974: REF.partner_id,
975: REF.referral_code,
976: HZP.party_name partner_name,
977: REF.CUSTOMER_NAME customer_name
978: FROM pv_referrals_b REF,
979: pv_ge_benefits_b BEN,
980: pv_partner_profiles PROF,
981: hz_parties HZP
982: WHERE REF.referral_id = p_referral_id AND
2044: x_return_status := FND_API.G_RET_STS_SUCCESS;
2045: x_a_link_already_exists := 'N';
2046:
2047: FOR x IN (SELECT referral_code
2048: FROM pv_referrals_b
2049: WHERE referral_id = p_referral_id)
2050: LOOP
2051: l_referral_code := x.referral_code;
2052: END LOOP;