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 282: Cursor c_hz_contact_points(p_party_id NUMBER) IS

278: Person_title
279: FROM hz_parties
280: WHERE party_id = c_party_id;
281:
282: Cursor c_hz_contact_points(p_party_id NUMBER) IS
283: SELECT Contact_Point_type,
284: Primary_flag,
285: Phone_line_type,
286: Phone_Country_code,

Line 290: FROM hz_contact_points

286: Phone_Country_code,
287: Phone_area_code,
288: Phone_number,
289: Email_address
290: FROM hz_contact_points
291: WHERE owner_table_name = 'HZ_PARTIES'
292: AND owner_table_id = p_party_id;
293:
294: cursor c_order_curr_code(c_order_id number) is

Line 3924: l_cust_email_addr hz_contact_points.email_address%TYPE;

3920: x_msg_count OUT NOCOPY NUMBER,
3921: x_msg_data OUT NOCOPY VARCHAR2
3922: ) IS
3923:
3924: l_cust_email_addr hz_contact_points.email_address%TYPE;
3925: l_cust_event_type VARCHAR(20);
3926: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3927: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3928: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;

Line 3963: l_contact_phone hz_contact_points.phone_number%TYPE;

3959: --Bug 2223507
3960: l_quote_num VARCHAR2(1000) := null;
3961: l_first_name VARCHAR2(1000);
3962: l_last_name VARCHAR2(1000);
3963: l_contact_phone hz_contact_points.phone_number%TYPE;
3964: l_cart_name ibe_quote_headers_v.quote_name%TYPE;
3965: l_cart_date ibe_quote_headers_v.last_update_date%TYPE;
3966: l_ship_to_name aso_shipments_v.ship_to_cust_name%TYPE;
3967: l_address VARCHAR2(4000);

Line 4683: from hz_contact_points

4679: ( p_contact_point_id IN NUMBER ,
4680: x_create_adhoc_flag OUT NOCOPY VARCHAR2 ) is
4681: cursor c_contact_point is
4682: select owner_table_name
4683: from hz_contact_points
4684: where contact_point_id = p_contact_point_id;
4685: rec_contact_point c_contact_point%rowtype;
4686:
4687: begin

Line 5458: from HZ_CONTACT_POINTS

5454: l_url VARCHAR2(2000);
5455:
5456: cursor c_get_email(c_contact_point_id NUMBER) is
5457: select email_address
5458: from HZ_CONTACT_POINTS
5459: where contact_point_id = c_contact_point_id;
5460:
5461: rec_get_email c_get_email%rowtype;
5462:

Line 5662: from HZ_CONTACT_POINTS

5658: where quote_header_id = c_qte_header_id;
5659:
5660: cursor c_get_email(c_contact_point_id NUMBER) is
5661: select email_address
5662: from HZ_CONTACT_POINTS
5663: where contact_point_id = c_contact_point_id;
5664:
5665: rec_get_email c_get_email%rowtype;
5666: rec_quote_name c_quote_name%rowtype;

Line 6605: l_contact_email hz_contact_points.email_address%TYPE;

6601: l_party_last_name hz_parties.person_last_name%TYPE;
6602: l_contact_party_id hz_parties.party_id%TYPE;
6603: l_contact_name VARCHAR2(400);
6604: l_contact_number VARCHAR2(70);
6605: l_contact_email hz_contact_points.email_address%TYPE;
6606: l_contact_fax VARCHAR2(70);
6607: l_ship_address hz_locations.address1%TYPE;
6608: l_bill_address hz_locations.address1%TYPE;
6609: l_document VARCHAR2(32000) := '';

Line 6707: FOR c_hz_contact_rec IN c_hz_contact_points(l_contact_party_id) LOOP

6703: l_contact_number := NULL;
6704: l_contact_email := NULL;
6705: l_contact_fax := NULL;
6706:
6707: FOR c_hz_contact_rec IN c_hz_contact_points(l_contact_party_id) LOOP
6708:
6709: If (c_hz_contact_rec.contact_point_type = 'PHONE' AND c_hz_contact_rec.phone_line_type = 'GEN')
6710: AND (l_contact_number IS NULL OR c_hz_contact_rec.primary_flag ='Y')
6711: Then

Line 8627: l_contact_email hz_contact_points.email_address%TYPE;

8623: l_contract_Modifier VARCHAR2(120);
8624: l_comments VARCHAR2(2000);
8625: l_contact_name VARCHAR2(400);
8626: l_contact_number VARCHAR2(70);
8627: l_contact_email hz_contact_points.email_address%TYPE;
8628: l_bill_to_party_name hz_parties.party_name%TYPE;
8629: l_bill_to_name VARCHAR2(400);
8630: l_bill_to_number VARCHAR2(70);
8631: l_bill_to_fax VARCHAR2(70);

Line 8759: FOR c_hz_contact_rec IN c_hz_contact_points(l_sold_contact_party_id) LOOP

8755: l_contact_number := null;
8756: l_contact_email := null;
8757:
8758:
8759: FOR c_hz_contact_rec IN c_hz_contact_points(l_sold_contact_party_id) LOOP
8760:
8761: 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
8762:
8763: 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 8810: FOR c_hz_contact_rec IN c_hz_contact_points(l_bill_contact_party_id) LOOP

8806: End If;
8807: END LOOP;
8808: End if;
8809:
8810: FOR c_hz_contact_rec IN c_hz_contact_points(l_bill_contact_party_id) LOOP
8811:
8812: 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
8813:
8814: 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 8902: FOR c_hz_contact_rec IN c_hz_contact_points(l_ship_contact_party_id) LOOP

8898: End If;
8899: END LOOP;
8900: End If;
8901:
8902: FOR c_hz_contact_rec IN c_hz_contact_points(l_ship_contact_party_id) LOOP
8903:
8904: 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
8905:
8906: 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);