eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_WORKFLOW_PVT dependencies on HZ_CONTACT_POINTS

Line 272: Cursor c_hz_contact_points(p_party_id NUMBER) IS

268: Person_title
269: FROM hz_parties
270: WHERE party_id = c_party_id;
271:
272: Cursor c_hz_contact_points(p_party_id NUMBER) IS
273: SELECT Contact_Point_type,
274: Primary_flag,
275: Phone_line_type,
276: Phone_Country_code,

Line 280: FROM hz_contact_points

276: Phone_Country_code,
277: Phone_area_code,
278: Phone_number,
279: Email_address
280: FROM hz_contact_points
281: WHERE owner_table_name = 'HZ_PARTIES'
282: AND owner_table_id = p_party_id;
283:
284: cursor c_order_curr_code(c_order_id number) is

Line 3829: l_cust_email_addr hz_contact_points.email_address%TYPE;

3825: x_msg_count OUT NOCOPY NUMBER,
3826: x_msg_data OUT NOCOPY VARCHAR2
3827: ) IS
3828:
3829: l_cust_email_addr hz_contact_points.email_address%TYPE;
3830: l_cust_event_type VARCHAR(20);
3831: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3832: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3833: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;

Line 3868: l_contact_phone hz_contact_points.phone_number%TYPE;

3864: --Bug 2223507
3865: l_quote_num VARCHAR2(1000) := null;
3866: l_first_name VARCHAR2(1000);
3867: l_last_name VARCHAR2(1000);
3868: l_contact_phone hz_contact_points.phone_number%TYPE;
3869: l_cart_name ibe_quote_headers_v.quote_name%TYPE;
3870: l_cart_date ibe_quote_headers_v.last_update_date%TYPE;
3871: l_ship_to_name aso_shipments_v.ship_to_cust_name%TYPE;
3872: l_address VARCHAR2(4000);

Line 4588: from hz_contact_points

4584: ( p_contact_point_id IN NUMBER ,
4585: x_create_adhoc_flag OUT NOCOPY VARCHAR2 ) is
4586: cursor c_contact_point is
4587: select owner_table_name
4588: from hz_contact_points
4589: where contact_point_id = p_contact_point_id;
4590: rec_contact_point c_contact_point%rowtype;
4591:
4592: begin

Line 5363: from HZ_CONTACT_POINTS

5359: l_url VARCHAR2(2000);
5360:
5361: cursor c_get_email(c_contact_point_id NUMBER) is
5362: select email_address
5363: from HZ_CONTACT_POINTS
5364: where contact_point_id = c_contact_point_id;
5365:
5366: rec_get_email c_get_email%rowtype;
5367:

Line 5567: from HZ_CONTACT_POINTS

5563: where quote_header_id = c_qte_header_id;
5564:
5565: cursor c_get_email(c_contact_point_id NUMBER) is
5566: select email_address
5567: from HZ_CONTACT_POINTS
5568: where contact_point_id = c_contact_point_id;
5569:
5570: rec_get_email c_get_email%rowtype;
5571: rec_quote_name c_quote_name%rowtype;

Line 6510: l_contact_email hz_contact_points.email_address%TYPE;

6506: l_party_last_name hz_parties.person_last_name%TYPE;
6507: l_contact_party_id hz_parties.party_id%TYPE;
6508: l_contact_name VARCHAR2(400);
6509: l_contact_number VARCHAR2(70);
6510: l_contact_email hz_contact_points.email_address%TYPE;
6511: l_contact_fax VARCHAR2(70);
6512: l_ship_address hz_locations.address1%TYPE;
6513: l_bill_address hz_locations.address1%TYPE;
6514: l_document VARCHAR2(32000) := '';

Line 6612: FOR c_hz_contact_rec IN c_hz_contact_points(l_contact_party_id) LOOP

6608: l_contact_number := NULL;
6609: l_contact_email := NULL;
6610: l_contact_fax := NULL;
6611:
6612: FOR c_hz_contact_rec IN c_hz_contact_points(l_contact_party_id) LOOP
6613:
6614: If (c_hz_contact_rec.contact_point_type = 'PHONE' AND c_hz_contact_rec.phone_line_type = 'GEN')
6615: AND (l_contact_number IS NULL OR c_hz_contact_rec.primary_flag ='Y')
6616: Then

Line 8532: l_contact_email hz_contact_points.email_address%TYPE;

8528: l_contract_Modifier VARCHAR2(120);
8529: l_comments VARCHAR2(2000);
8530: l_contact_name VARCHAR2(400);
8531: l_contact_number VARCHAR2(70);
8532: l_contact_email hz_contact_points.email_address%TYPE;
8533: l_bill_to_party_name hz_parties.party_name%TYPE;
8534: l_bill_to_name VARCHAR2(400);
8535: l_bill_to_number VARCHAR2(70);
8536: l_bill_to_fax VARCHAR2(70);

Line 8664: FOR c_hz_contact_rec IN c_hz_contact_points(l_sold_contact_party_id) LOOP

8660: l_contact_number := null;
8661: l_contact_email := null;
8662:
8663:
8664: FOR c_hz_contact_rec IN c_hz_contact_points(l_sold_contact_party_id) LOOP
8665:
8666: 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
8667:
8668: 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 8715: FOR c_hz_contact_rec IN c_hz_contact_points(l_bill_contact_party_id) LOOP

8711: End If;
8712: END LOOP;
8713: End if;
8714:
8715: FOR c_hz_contact_rec IN c_hz_contact_points(l_bill_contact_party_id) LOOP
8716:
8717: 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
8718:
8719: 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 8807: FOR c_hz_contact_rec IN c_hz_contact_points(l_ship_contact_party_id) LOOP

8803: End If;
8804: END LOOP;
8805: End If;
8806:
8807: FOR c_hz_contact_rec IN c_hz_contact_points(l_ship_contact_party_id) LOOP
8808:
8809: 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
8810:
8811: 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);