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_PARTIES

Line 311: FROM HZ_PARTIES party,

307: p_area VARCHAR2,
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

Line 317: cp.owner_table_name = 'HZ_PARTIES' AND

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
317: cp.owner_table_name = 'HZ_PARTIES' AND
318: cp.owner_table_id = party.party_id ;
319: */
320:
321: CURSOR c_party_id (p_country VARCHAR2,

Line 331: cp.owner_table_name = 'HZ_PARTIES'

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
331: cp.owner_table_name = 'HZ_PARTIES'
332: ORDER BY cp.last_update_date DESC;
333: --
334: -- get customer ID given phone number and extension
335: --

Line 339: FROM HZ_PARTIES party,

335: --
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

Line 343: cp.owner_table_name = 'HZ_PARTIES' AND

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 ;
345: */
346:
347: CURSOR c_party_id_w_area_code (p_phone VARCHAR2, p_ext VARCHAR2) IS

Line 352: cp.owner_table_name = 'HZ_PARTIES'

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;
354:
355: --
356: -- get customer ID given phone number and area code

Line 361: FROM HZ_PARTIES party,

357: --
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

Line 365: cp.owner_table_name = 'HZ_PARTIES' AND

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 ;
367: */
368: CURSOR c_party_id_w_ctry_code (p_area VARCHAR2, p_phone VARCHAR2) IS
369: SELECT cp.owner_table_id party_id

Line 373: cp.owner_table_name = 'HZ_PARTIES'

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;
375: --
376: -- get customer ID given phone number, area code and country code
377: --

Line 383: FROM HZ_PARTIES party,

379: CURSOR c_party_id_w_extension (p_country VARCHAR2,
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

Line 388: cp.owner_table_name = 'HZ_PARTIES' AND

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
389: cp.owner_table_id = party.party_id;
390: */
391:
392: CURSOR c_party_id_w_extension (p_country VARCHAR2,

Line 400: cp.owner_table_name = 'HZ_PARTIES'

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'
401: ORDER BY cp.last_update_date DESC;
402: --
403: -- get customer ID given phone number only
404: --

Line 408: FROM HZ_PARTIES party,

404: --
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 ;

Line 411: cp.owner_table_name = 'HZ_PARTIES' AND

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: */
414:
415: CURSOR c_party_id_w_all (p_phone VARCHAR2) IS

Line 419: cp.owner_table_name = 'HZ_PARTIES'

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:
422: BEGIN
423:

Line 491: -- HZ_PARTIES table given a party number. If there is more than one

487: -- Function : Get_Customer_From_CustomerNum
488: -- Usage : Used by the Routing module to get the customer ID from the
489: -- customer number
490: -- Description : This function retrieves a party ID from the
491: -- HZ_PARTIES table given a party number. If there is more than one
492: -- party with the given number, this function will return the
493: -- first party ID that it retrieves.
494: -- Parameters :
495: -- p_party_number IN VARCHAR2(30) Required

Line 515: FROM hz_parties

511: -- get party ID gievn customer number
512: --
513: CURSOR c_party_id (pnum VARCHAR2) IS
514: SELECT party_id
515: FROM hz_parties
516: WHERE party_number = pnum;
517: BEGIN
518:
519: OPEN c_party_id(p_party_number);

Line 583: -- HZ_PARTIES table given a customer ID.

579: -- Function : Get_Name_Of_Customer
580: -- Usage : Used by the Routing module to get the customer name from the
581: -- customer ID
582: -- Description : This function retrieves the customer name from the
583: -- HZ_PARTIES table given a customer ID.
584: -- Parameters :
585: -- p_party_id IN NUMBER Required
586: --
587: -- Return : VARCHAR2(255)

Line 602: FROM hz_parties

598: -- get party name given a party ID
599: --
600: CURSOR c_party_name (pid NUMBER) IS
601: SELECT party_name
602: FROM hz_parties
603: WHERE party_id = pid;
604: BEGIN
605:
606: OPEN c_party_name(p_party_id);

Line 620: -- HZ_PARTIES table given a party ID.

616: ------------------------------------------------------------------------------
617: -- Function : Get_Status_Of_Customer
618: -- Usage : Used by the Routing module to get the customer status
619: -- Description : This function retrieves the customer status flag from the
620: -- HZ_PARTIES table given a party ID.
621: -- Parameters :
622: -- p_party_id IN NUMBER Required
623: --
624: -- Return : VARCHAR2(1)

Line 639: FROM hz_parties

635: -- get customer status given a party ID
636: --
637: CURSOR c_customer_status (pid NUMBER) IS
638: SELECT status
639: FROM hz_parties
640: WHERE party_iD = pid;
641: BEGIN
642:
643: OPEN c_customer_status(p_party_id);

Line 698: -- Description : This function finds a row in the HZ_PARTIES

694: ------------------------------------------------------------------------------
695: -- Function : Customer_ID_Exists
696: -- Usage : Used by the Routing module to determine whether a customer
697: -- exists with the given ID
698: -- Description : This function finds a row in the HZ_PARTIES
699: -- table that matches the given customer ID.
700: -- Parameters :
701: -- p_customer_id IN NUMBER Required
702: --

Line 717: FROM hz_parties

713: -- check if the given customer ID exists
714: --
715: CURSOR c_party_id (custid NUMBER) IS
716: SELECT party_id
717: FROM hz_parties
718: WHERE party_id = custid;
719: BEGIN
720:
721: OPEN c_party_id(p_customer_id);

Line 892: WHERE owner_table_name = 'HZ_PARTIES'

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;
896:

Line 917: -- HZ_PARTIES table by traversing the relationships from HZ_ORG_CONTACTS

913: ------------------------------------------------------------------------------
914: -- Function : Get_Customer_From_ContactNum
915: -- Usage : Used to get the party ID from the Contact Number passed in the IVR parms
916: -- Description : This function retrieves a party ID from the
917: -- HZ_PARTIES table by traversing the relationships from HZ_ORG_CONTACTS
918: -- and HZ_RELATIONSHIPS.
919: -- If there is more than one party_id associated with the given ContactNum
920: -- this function will return the first party_id that it retrieves.
921: -- Parameters :

Line 935: FROM hz_parties p,

931: Return Number IS
932:
933: CURSOR cnum (connum IN VARCHAR2) IS
934: SELECT p.party_id
935: FROM hz_parties p,
936: hz_relationships r,
937: hz_org_contacts c
938: WHERE c.contact_number = connum
939: AND c.party_relationship_id = r.relationship_id

Line 941: AND r.subject_table_name = 'HZ_PARTIES'

937: hz_org_contacts c
938: WHERE c.contact_number = connum
939: AND c.party_relationship_id = r.relationship_id
940: AND r.object_id = p.party_id
941: AND r.subject_table_name = 'HZ_PARTIES'
942: AND r.object_table_name = 'HZ_PARTIES'
943: AND r.directional_flag = 'F';
944: p_party_id NUMBER := null;
945:

Line 942: AND r.object_table_name = 'HZ_PARTIES'

938: WHERE c.contact_number = connum
939: AND c.party_relationship_id = r.relationship_id
940: AND r.object_id = p.party_id
941: AND r.subject_table_name = 'HZ_PARTIES'
942: AND r.object_table_name = 'HZ_PARTIES'
943: AND r.directional_flag = 'F';
944: p_party_id NUMBER := null;
945:
946: BEGIN

Line 1043: AND owner_table_name = 'HZ_PARTIES'

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:
1046: BEGIN
1047: IF p_rANI IS NULL THEN

Line 1145: FROM hz_parties

1141: IF p_party_id IS NOT NULL THEN
1142: BEGIN
1143: SELECT party_name
1144: INTO x_party_name
1145: FROM hz_parties
1146: WHERE party_id = p_party_id;
1147: EXCEPTION WHEN NO_DATA_FOUND THEN
1148: x_party_name := 'NOTFOUND';
1149: return x_party_name;