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.CSC_ROUTING_UTL dependencies on HZ_CONTACT_POINTS

Line 273: -- HZ_CONTACT_POINTS table given a phone number of a customer contact.

269: -- Function : Get_Customer_From_ANI
270: -- Usage : Used by the Routing module to get the party ID from the
271: -- contact's phone number
272: -- Description : This function retrieves a party ID from the
273: -- HZ_CONTACT_POINTS table given a phone number of a customer contact.
274: -- If there is more than one customer associated with the given phone
275: -- number, this function will return the first customer ID that
276: -- it retrieves.
277: -- Parameters :

Line 303: /* Enhancement: 1685717 Parties are queried by ordering last_update_date on // hz_contact_points in descending order, so that active parties are selected first */

299:
300: --
301: -- get party ID given phone number, country code, area code and extension
302: --
303: /* Enhancement: 1685717 Parties are queried by ordering last_update_date on *//* hz_contact_points in descending order, so that active parties are selected first */
304:
305: /*
306: CURSOR c_party_id (p_country VARCHAR2,
307: p_area VARCHAR2,

Line 312: hz_contact_points cp

308: p_phone VARCHAR2,
309: p_ext VARCHAR2) IS
310: SELECT party.party_id
311: FROM HZ_PARTIES party,
312: hz_contact_points cp
313: WHERE cp.phone_number = p_phone AND
314: cp.phone_country_code = p_country AND
315: cp.phone_area_code = p_area AND
316: cp.phone_extension = p_ext AND

Line 326: FROM hz_contact_points cp

322: p_area VARCHAR2,
323: p_phone VARCHAR2,
324: p_ext VARCHAR2) IS
325: SELECT cp.owner_table_id party_id
326: FROM hz_contact_points cp
327: WHERE cp.phone_number = p_phone AND
328: cp.phone_country_code = p_country AND
329: cp.phone_area_code = p_area AND
330: cp.phone_extension = p_ext AND

Line 340: hz_contact_points cp

336: /*
337: CURSOR c_party_id_w_area_code (p_phone VARCHAR2, p_ext VARCHAR2) IS
338: SELECT party.party_id
339: FROM HZ_PARTIES party,
340: hz_contact_points cp
341: WHERE cp.phone_number = p_phone AND
342: cp.phone_extension = p_ext AND
343: cp.owner_table_name = 'HZ_PARTIES' AND
344: cp.owner_table_id = party.party_id ;

Line 349: FROM hz_contact_points cp

345: */
346:
347: CURSOR c_party_id_w_area_code (p_phone VARCHAR2, p_ext VARCHAR2) IS
348: SELECT cp.owner_table_id party_id
349: FROM hz_contact_points cp
350: WHERE cp.phone_number = p_phone AND
351: cp.phone_extension = p_ext AND
352: cp.owner_table_name = 'HZ_PARTIES'
353: ORDER BY cp.last_update_date DESC;

Line 362: hz_contact_points cp

358: /*
359: CURSOR c_party_id_w_ctry_code (p_area VARCHAR2, p_phone VARCHAR2) IS
360: SELECT party.party_id
361: FROM HZ_PARTIES party,
362: hz_contact_points cp
363: WHERE cp.phone_number = p_phone AND
364: cp.phone_area_code = p_area AND
365: cp.owner_table_name = 'HZ_PARTIES' AND
366: cp.owner_table_id = party.party_id ;

Line 370: FROM hz_contact_points cp

366: cp.owner_table_id = party.party_id ;
367: */
368: CURSOR c_party_id_w_ctry_code (p_area VARCHAR2, p_phone VARCHAR2) IS
369: SELECT cp.owner_table_id party_id
370: FROM hz_contact_points cp
371: WHERE cp.phone_number = p_phone AND
372: cp.phone_area_code = p_area AND
373: cp.owner_table_name = 'HZ_PARTIES'
374: ORDER BY cp.last_update_date DESC;

Line 384: hz_contact_points cp

380: p_area VARCHAR2,
381: p_phone VARCHAR2) IS
382: SELECT party.party_id
383: FROM HZ_PARTIES party,
384: hz_contact_points cp
385: WHERE cp.phone_number = p_phone AND
386: cp.phone_area_code = p_area AND
387: cp.phone_country_code = p_country AND
388: cp.owner_table_name = 'HZ_PARTIES' AND

Line 396: FROM hz_contact_points cp

392: CURSOR c_party_id_w_extension (p_country VARCHAR2,
393: p_area VARCHAR2,
394: p_phone VARCHAR2) IS
395: SELECT cp.owner_table_id party_id
396: FROM hz_contact_points cp
397: WHERE cp.phone_number = p_phone AND
398: cp.phone_area_code = p_area AND
399: cp.phone_country_code = p_country AND
400: cp.owner_table_name = 'HZ_PARTIES'

Line 409: hz_contact_points cp

405: /*
406: CURSOR c_party_id_w_all (p_phone VARCHAR2) IS
407: SELECT party.party_id
408: FROM HZ_PARTIES party,
409: hz_contact_points cp
410: WHERE cp.phone_number = p_phone AND
411: cp.owner_table_name = 'HZ_PARTIES' AND
412: cp.owner_table_id = party.party_id ;
413: */

Line 417: FROM hz_contact_points cp

413: */
414:
415: CURSOR c_party_id_w_all (p_phone VARCHAR2) IS
416: SELECT cp.owner_table_id party_id
417: FROM hz_contact_points cp
418: WHERE cp.phone_number = p_phone AND
419: cp.owner_table_name = 'HZ_PARTIES'
420: ORDER BY cp.last_update_date DESC;
421:

Line 887: /* Enhancement: 1685717 Parties are queried by ordering last_update_date on // hz_contact_points in descending order, so that active parties are selected first */

883: FROM JTF_CONTACT_POINTS_V
884: WHERE Upper(email_address) = Upper(email) ;
885: */
886:
887: /* Enhancement: 1685717 Parties are queried by ordering last_update_date on *//* hz_contact_points in descending order, so that active parties are selected first */
888:
889: CURSOR c_party_id (email VARCHAR2) IS
890: SELECT owner_table_id party_id
891: FROM hz_contact_points

Line 891: FROM hz_contact_points

887: /* Enhancement: 1685717 Parties are queried by ordering last_update_date on *//* hz_contact_points in descending order, so that active parties are selected first */
888:
889: CURSOR c_party_id (email VARCHAR2) IS
890: SELECT owner_table_id party_id
891: FROM hz_contact_points
892: WHERE owner_table_name = 'HZ_PARTIES'
893: AND contact_point_type = 'EMAIL'
894: AND UPPER(email_address) = UPPER(email)
895: ORDER BY last_update_date DESC;

Line 1017: -- HZ_CONTACT_POINTS

1013: ------------------------------------------------------------------------------
1014: -- Function : Get_Customer_From_Reverse_ANI
1015: -- Usage : Used to get the party ID from the reversed ANI Number passed in the IVR parms
1016: -- Description : This function retrieves a owner_table_id from the
1017: -- HZ_CONTACT_POINTS
1018: -- If there is more than one party_id associated with the given ContactNum
1019: -- this function will return the first party_id that it retrieves.
1020: -- Parameters :
1021: -- p_rANI IN VARCHAR2(1996) Required

Line 1041: FROM hz_contact_points

1037: n_use_exact_ani VARCHAR2(2);
1038: --
1039: CURSOR transpose_phone_cur IS
1040: SELECT transposed_phone_number, owner_table_id, contact_point_id
1041: FROM hz_contact_points
1042: WHERE transposed_phone_number LIKE l_rANI
1043: AND owner_table_name = 'HZ_PARTIES'
1044: ORDER BY last_update_date DESC;
1045: