APPS.ASO_WORKFLOW_PVT dependencies on HZ_CONTACT_POINTS

Line 52: Cursor c_hz_contact_points(p_party_id NUMBER) IS

48: Person_Last_name,party_type
49: FROM hz_parties
50: WHERE party_id = p_party_id;
51:
52: Cursor c_hz_contact_points(p_party_id NUMBER) IS
53: SELECT Contact_Point_type,Primary_flag, Phone_line_type,
54: Phone_Country_code, Phone_area_code, Phone_number, Email_address
55: FROM hz_contact_points
56: WHERE owner_table_name = 'HZ_PARTIES'

Line 55: FROM hz_contact_points

51:
52: Cursor c_hz_contact_points(p_party_id NUMBER) IS
53: SELECT Contact_Point_type,Primary_flag, Phone_line_type,
54: Phone_Country_code, Phone_area_code, Phone_number, Email_address
55: FROM hz_contact_points
56: WHERE owner_table_name = 'HZ_PARTIES'
57: AND owner_table_id = p_party_id;
58:
59:

Line 273: l_contact_email hz_contact_points.email_address%TYPE;

269: l_contract_Number VARCHAR2(120);
270: l_contract_Modifier VARCHAR2(120);
271: l_contact_name VARCHAR2(400);
272: l_contact_number VARCHAR2(70);
273: l_contact_email hz_contact_points.email_address%TYPE;
274: l_bill_to_party_name hz_parties.party_name%TYPE;
275: l_bill_to_name VARCHAR2(400);
276: l_bill_to_number VARCHAR2(70);
277: l_bill_to_fax VARCHAR2(70);

Line 391: FOR c_hz_contact_rec IN c_hz_contact_points(l_sold_contact_party_id) LOOP

387: l_contact_number := null;
388: l_contact_email := null;
389:
390:
391: FOR c_hz_contact_rec IN c_hz_contact_points(l_sold_contact_party_id) LOOP
392:
393: If (c_hz_contact_rec.contact_point_type = 'PHONE' AND c_hz_contact_rec.phone_line_type = 'GEN') AND (l_contact_number IS NULL OR c_hz_contact_rec.primary_flag ='Y') Then
394:
395: l_contact_number := trim(c_hz_contact_rec.Phone_Country_code||' '||c_hz_contact_rec.Phone_area_code||' '||c_hz_contact_rec.Phone_number);

Line 443: FOR c_hz_contact_rec IN c_hz_contact_points(l_bill_contact_party_id) LOOP

439: End If;
440: END LOOP;
441: End if;
442:
443: FOR c_hz_contact_rec IN c_hz_contact_points(l_bill_contact_party_id) LOOP
444:
445: 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') Then
446:
447: 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 532: FOR c_hz_contact_rec IN c_hz_contact_points(l_ship_contact_party_id) LOOP

528: End If;
529: END LOOP;
530: End If;
531:
532: FOR c_hz_contact_rec IN c_hz_contact_points(l_ship_contact_party_id) LOOP
533:
534: If (c_hz_contact_rec.contact_point_type = 'PHONE' AND c_hz_contact_rec.phone_line_type = 'GEN') AND (l_ship_to_number IS NULL OR c_hz_contact_rec.primary_flag ='Y') Then
535:
536: l_ship_to_number := trim(c_hz_contact_rec.Phone_Country_code||' '||c_hz_contact_rec.Phone_area_code||' '||c_hz_contact_rec.Phone_number);