APPS.ASO_WORKFLOW_QUOTE_PVT dependencies on HZ_CONTACT_POINTS

Line 390: l_contact_email hz_contact_points.email_address%TYPE;

386: l_contract_Modifier VARCHAR2(120);
387: l_comments VARCHAR2(2000);
388: l_contact_name VARCHAR2(400);
389: l_contact_number VARCHAR2(70);
390: l_contact_email hz_contact_points.email_address%TYPE;
391: l_bill_to_party_name hz_parties.party_name%TYPE;
392: l_bill_to_name VARCHAR2(400);
393: l_bill_to_number VARCHAR2(70);
394: l_bill_to_fax VARCHAR2(70);

Line 458: CURSOR c_hz_contact_points(p_party_id NUMBER) IS

454: SELECT Party_Name,Person_First_Name,Person_Middle_Name,Person_Last_name,party_type,Person_title
455: FROM hz_parties
456: WHERE party_id = p_party_id;
457:
458: CURSOR c_hz_contact_points(p_party_id NUMBER) IS
459: SELECT Contact_Point_type,Primary_flag, Phone_line_type, Phone_Country_code, Phone_area_code, Phone_number, Email_address
460: FROM hz_contact_points
461: WHERE owner_table_name = 'HZ_PARTIES'
462: AND owner_table_id = p_party_id;

Line 460: FROM hz_contact_points

456: WHERE party_id = p_party_id;
457:
458: CURSOR c_hz_contact_points(p_party_id NUMBER) IS
459: SELECT Contact_Point_type,Primary_flag, Phone_line_type, Phone_Country_code, Phone_area_code, Phone_number, Email_address
460: FROM hz_contact_points
461: WHERE owner_table_name = 'HZ_PARTIES'
462: AND owner_table_id = p_party_id;
463:
464:

Line 546: FOR c_hz_contact_rec IN c_hz_contact_points(l_sold_contact_party_id)

542:
543: l_contact_number := null;
544: l_contact_email := null;
545:
546: FOR c_hz_contact_rec IN c_hz_contact_points(l_sold_contact_party_id)
547: LOOP
548:
549: IF (c_hz_contact_rec.contact_point_type = 'PHONE'
550: AND c_hz_contact_rec.phone_line_type = 'GEN')

Line 601: FOR c_hz_contact_rec IN c_hz_contact_points(l_bill_contact_party_id)

597: END IF;
598: END LOOP;
599: END IF;
600:
601: FOR c_hz_contact_rec IN c_hz_contact_points(l_bill_contact_party_id)
602: LOOP
603: IF (c_hz_contact_rec.contact_point_type = 'PHONE' AND c_hz_contact_rec.phone_line_type = 'GEN') AND (l_bill_to_number IS NULL OR c_hz_contact_rec.primary_flag ='Y')
604: THEN
605: l_bill_to_number := trim(c_hz_contact_rec.Phone_Country_code||' '||c_hz_contact_rec.Phone_area_code||' '||c_hz_contact_rec.Phone_number);

Line 695: FOR c_hz_contact_rec IN c_hz_contact_points(l_ship_contact_party_id)

691: END IF;
692: END LOOP;
693: END IF;
694:
695: FOR c_hz_contact_rec IN c_hz_contact_points(l_ship_contact_party_id)
696: LOOP
697: IF (c_hz_contact_rec.contact_point_type = 'PHONE' AND c_hz_contact_rec.phone_line_type = 'GEN')
698: AND (l_ship_to_number IS NULL OR c_hz_contact_rec.primary_flag ='Y')
699: THEN