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

Line 415: FROM hz_contact_points

411:
412: -- Cursor to get the primary telephone number
413: CURSOR csr_pri_telephone_num (c_owner_table_id IN VARCHAR2) IS
414: SELECT phone_country_code, phone_area_code, phone_number, phone_extension
415: FROM hz_contact_points
416: WHERE owner_table_id = c_owner_table_id
417: AND phone_line_type = 'GEN'
418: AND primary_flag = 'Y';
419:

Line 421: l_primary_country_code hz_contact_points.phone_country_code%TYPE;

417: AND phone_line_type = 'GEN'
418: AND primary_flag = 'Y';
419:
420: l_primary_return_value VARCHAR2(50);
421: l_primary_country_code hz_contact_points.phone_country_code%TYPE;
422: l_primary_area_code hz_contact_points.phone_area_code%TYPE;
423: l_primary_phone_number hz_contact_points.phone_number%TYPE;
424: l_primary_phone_extn hz_contact_points.phone_extension%TYPE;
425: BEGIN

Line 422: l_primary_area_code hz_contact_points.phone_area_code%TYPE;

418: AND primary_flag = 'Y';
419:
420: l_primary_return_value VARCHAR2(50);
421: l_primary_country_code hz_contact_points.phone_country_code%TYPE;
422: l_primary_area_code hz_contact_points.phone_area_code%TYPE;
423: l_primary_phone_number hz_contact_points.phone_number%TYPE;
424: l_primary_phone_extn hz_contact_points.phone_extension%TYPE;
425: BEGIN
426:

Line 423: l_primary_phone_number hz_contact_points.phone_number%TYPE;

419:
420: l_primary_return_value VARCHAR2(50);
421: l_primary_country_code hz_contact_points.phone_country_code%TYPE;
422: l_primary_area_code hz_contact_points.phone_area_code%TYPE;
423: l_primary_phone_number hz_contact_points.phone_number%TYPE;
424: l_primary_phone_extn hz_contact_points.phone_extension%TYPE;
425: BEGIN
426:
427: IF (csr_pri_telephone_num%ISOPEN) THEN

Line 424: l_primary_phone_extn hz_contact_points.phone_extension%TYPE;

420: l_primary_return_value VARCHAR2(50);
421: l_primary_country_code hz_contact_points.phone_country_code%TYPE;
422: l_primary_area_code hz_contact_points.phone_area_code%TYPE;
423: l_primary_phone_number hz_contact_points.phone_number%TYPE;
424: l_primary_phone_extn hz_contact_points.phone_extension%TYPE;
425: BEGIN
426:
427: IF (csr_pri_telephone_num%ISOPEN) THEN
428: CLOSE csr_pri_telephone_num;

Line 473: FROM hz_contact_points

469:
470: -- Cursor to get the secondary telephone number
471: CURSOR csr_sec_telephone_num (c_owner_table_id IN VARCHAR2) IS
472: SELECT phone_country_code, phone_area_code, phone_number, phone_extension
473: FROM hz_contact_points
474: WHERE owner_table_id = c_owner_table_id
475: AND phone_line_type = 'GEN'
476: AND primary_flag <> 'Y'
477: AND creation_date = (SELECT MAX(creation_date)

Line 478: FROM hz_contact_points

474: WHERE owner_table_id = c_owner_table_id
475: AND phone_line_type = 'GEN'
476: AND primary_flag <> 'Y'
477: AND creation_date = (SELECT MAX(creation_date)
478: FROM hz_contact_points
479: WHERE owner_table_id = c_owner_table_id
480: AND phone_line_type = 'GEN'
481: AND primary_flag <> 'Y');
482:

Line 484: l_secondary_country_code hz_contact_points.phone_country_code%TYPE;

480: AND phone_line_type = 'GEN'
481: AND primary_flag <> 'Y');
482:
483: l_secondary_return_value VARCHAR2(50);
484: l_secondary_country_code hz_contact_points.phone_country_code%TYPE;
485: l_secondary_area_code hz_contact_points.phone_area_code%TYPE;
486: l_secondary_phone_number hz_contact_points.phone_number%TYPE;
487: l_secondary_phone_extn hz_contact_points.phone_extension%TYPE;
488: BEGIN

Line 485: l_secondary_area_code hz_contact_points.phone_area_code%TYPE;

481: AND primary_flag <> 'Y');
482:
483: l_secondary_return_value VARCHAR2(50);
484: l_secondary_country_code hz_contact_points.phone_country_code%TYPE;
485: l_secondary_area_code hz_contact_points.phone_area_code%TYPE;
486: l_secondary_phone_number hz_contact_points.phone_number%TYPE;
487: l_secondary_phone_extn hz_contact_points.phone_extension%TYPE;
488: BEGIN
489:

Line 486: l_secondary_phone_number hz_contact_points.phone_number%TYPE;

482:
483: l_secondary_return_value VARCHAR2(50);
484: l_secondary_country_code hz_contact_points.phone_country_code%TYPE;
485: l_secondary_area_code hz_contact_points.phone_area_code%TYPE;
486: l_secondary_phone_number hz_contact_points.phone_number%TYPE;
487: l_secondary_phone_extn hz_contact_points.phone_extension%TYPE;
488: BEGIN
489:
490: IF (csr_sec_telephone_num%ISOPEN) THEN

Line 487: l_secondary_phone_extn hz_contact_points.phone_extension%TYPE;

483: l_secondary_return_value VARCHAR2(50);
484: l_secondary_country_code hz_contact_points.phone_country_code%TYPE;
485: l_secondary_area_code hz_contact_points.phone_area_code%TYPE;
486: l_secondary_phone_number hz_contact_points.phone_number%TYPE;
487: l_secondary_phone_extn hz_contact_points.phone_extension%TYPE;
488: BEGIN
489:
490: IF (csr_sec_telephone_num%ISOPEN) THEN
491: CLOSE csr_sec_telephone_num;