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.IGS_CO_PROCESS dependencies on HZ_PARTY_SITES

Line 913: CURSOR c_org_unit_email(cp_id_flag hz_party_sites.IDENTIFYING_ADDRESS_FLAG%TYPE,

909:
910: l_org_unit_addr c_org_unit_addr%ROWTYPE;
911:
912: -- Cursor to obtain the primary email address of the primary address of an Orgn Unit
913: CURSOR c_org_unit_email(cp_id_flag hz_party_sites.IDENTIFYING_ADDRESS_FLAG%TYPE,
914: cp_owner_tbl hz_contact_points.OWNER_TABLE_NAME%TYPE,
915: cp_cnt_type hz_contact_points.CONTACT_POINT_TYPE%TYPE,
916: cp_prim_flag hz_contact_points.PRIMARY_FLAG%TYPE,
917: cp_party_id HZ_PARTY_SITES.PARTY_ID%TYPE) IS

Line 917: cp_party_id HZ_PARTY_SITES.PARTY_ID%TYPE) IS

913: CURSOR c_org_unit_email(cp_id_flag hz_party_sites.IDENTIFYING_ADDRESS_FLAG%TYPE,
914: cp_owner_tbl hz_contact_points.OWNER_TABLE_NAME%TYPE,
915: cp_cnt_type hz_contact_points.CONTACT_POINT_TYPE%TYPE,
916: cp_prim_flag hz_contact_points.PRIMARY_FLAG%TYPE,
917: cp_party_id HZ_PARTY_SITES.PARTY_ID%TYPE) IS
918: SELECT
919: CPE.EMAIL_ADDRESS
920: FROM
921: HZ_PARTY_SITES PS,

Line 921: HZ_PARTY_SITES PS,

917: cp_party_id HZ_PARTY_SITES.PARTY_ID%TYPE) IS
918: SELECT
919: CPE.EMAIL_ADDRESS
920: FROM
921: HZ_PARTY_SITES PS,
922: HZ_CONTACT_POINTS CPE
923: WHERE
924: PS.PARTY_ID = cp_party_id AND
925: PS.IDENTIFYING_ADDRESS_FLAG = cp_id_flag AND

Line 934: CURSOR c_org_unit_phone (cp_id_flag hz_party_sites.IDENTIFYING_ADDRESS_FLAG%TYPE,

930:
931: l_org_unit_email c_org_unit_email%ROWTYPE;
932:
933: -- Cursor to obtain the Phone/Fax of an Organization Unit
934: CURSOR c_org_unit_phone (cp_id_flag hz_party_sites.IDENTIFYING_ADDRESS_FLAG%TYPE,
935: cp_owner_tbl hz_contact_points.OWNER_TABLE_NAME%TYPE,
936: cp_cnt_type hz_contact_points.CONTACT_POINT_TYPE%TYPE,
937: cp_status hz_contact_points.STATUS%TYPE,
938: cp_party_id hz_party_sites.PARTY_ID%TYPE,

Line 938: cp_party_id hz_party_sites.PARTY_ID%TYPE,

934: CURSOR c_org_unit_phone (cp_id_flag hz_party_sites.IDENTIFYING_ADDRESS_FLAG%TYPE,
935: cp_owner_tbl hz_contact_points.OWNER_TABLE_NAME%TYPE,
936: cp_cnt_type hz_contact_points.CONTACT_POINT_TYPE%TYPE,
937: cp_status hz_contact_points.STATUS%TYPE,
938: cp_party_id hz_party_sites.PARTY_ID%TYPE,
939: cp_line_type1 hz_contact_points.PHONE_LINE_TYPE%TYPE,
940: cp_line_type2 hz_contact_points.PHONE_LINE_TYPE%TYPE) IS
941: SELECT
942: NVL (CPP.PHONE_AREA_CODE,'*') PHONE_AREA_CODE,

Line 948: HZ_PARTY_SITES PS,

944: NVL (CPP.PHONE_NUMBER,'*') PHONE_NUMBER,
945: NVL (CPP.PHONE_EXTENSION,'*') PHONE_EXTENSION,
946: CPP.PHONE_LINE_TYPE
947: FROM
948: HZ_PARTY_SITES PS,
949: HZ_CONTACT_POINTS CPP
950: WHERE
951: PS.PARTY_ID = cp_party_id AND
952: PS.IDENTIFYING_ADDRESS_FLAG = cp_id_flag AND

Line 1125: OPEN c_org_unit_email ( 'Y','HZ_PARTY_SITES', 'EMAIL', 'Y',p_org_unit_id);

1121: FETCH c_org_unit_addr INTO l_org_unit_addr;
1122: CLOSE c_org_unit_addr;
1123:
1124: IF l_org_unit_addr.ADDRESS1 IS NOT NULL THEN
1125: OPEN c_org_unit_email ( 'Y','HZ_PARTY_SITES', 'EMAIL', 'Y',p_org_unit_id);
1126: FETCH c_org_unit_email INTO l_org_unit_email;
1127: CLOSE c_org_unit_email;
1128:
1129: OPEN c_org_unit_phone ( 'Y','HZ_PARTY_SITES', 'PHONE', 'A',p_org_unit_id,'GEN','FAX');

Line 1129: OPEN c_org_unit_phone ( 'Y','HZ_PARTY_SITES', 'PHONE', 'A',p_org_unit_id,'GEN','FAX');

1125: OPEN c_org_unit_email ( 'Y','HZ_PARTY_SITES', 'EMAIL', 'Y',p_org_unit_id);
1126: FETCH c_org_unit_email INTO l_org_unit_email;
1127: CLOSE c_org_unit_email;
1128:
1129: OPEN c_org_unit_phone ( 'Y','HZ_PARTY_SITES', 'PHONE', 'A',p_org_unit_id,'GEN','FAX');
1130: LOOP
1131: FETCH c_org_unit_phone INTO l_org_unit_phone;
1132: EXIT WHEN (c_org_unit_phone%NOTFOUND OR (l_fax_count = 3 AND l_phone_count = 3));
1133: