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.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 1141: cs_hz_sr_contact_points cshcp

1137: to_number(NULL) person_id,
1138: cshcp.contact_type,
1139: cshcp.sr_contact_point_id
1140: FROM hz_contact_points hcp,
1141: cs_hz_sr_contact_points cshcp
1142: WHERE cshcp.INCIDENT_ID = l_request_id
1143: AND cshcp.PRIMARY_FLAG = 'Y'
1144: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1145: AND hcp.CONTACT_POINT_ID = cshcp.CONTACT_POINT_ID

Line 1155: cs_hz_sr_contact_points cshcp

1151: ppf.person_id,
1152: cshcp.contact_type,
1153: cshcp.sr_contact_point_id
1154: from per_all_people_f ppf,
1155: cs_hz_sr_contact_points cshcp
1156: where cshcp.INCIDENT_ID = l_request_id
1157: AND cshcp.PRIMARY_FLAG = 'Y'
1158: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1159: AND ppf.person_id = cshcp.party_id

Line 1174: FROM cs_hz_sr_contact_points cshcp

1170: cshcp.contact_type,
1171: cshcp.sr_contact_point_id,
1172: cshcp.contact_point_type,
1173: cshcp.contact_point_id
1174: FROM cs_hz_sr_contact_points cshcp
1175: WHERE cshcp.INCIDENT_ID = l_request_id
1176: AND cshcp.PRIMARY_FLAG = 'Y'
1177: AND cshcp.party_role_code = 'CONTACT';
1178:

Line 1179: -- Get the primary contact's email information from the cs_hz_sr_contact_points table.

1175: WHERE cshcp.INCIDENT_ID = l_request_id
1176: AND cshcp.PRIMARY_FLAG = 'Y'
1177: AND cshcp.party_role_code = 'CONTACT';
1178:
1179: -- Get the primary contact's email information from the cs_hz_sr_contact_points table.
1180:
1181: CURSOR get_primary_email_info_CS (p_party_id IN NUMBER) IS
1182: SELECT cshcp.sr_contact_point_id,
1183: cshcp.contact_point_id

Line 1184: FROM cs_hz_sr_contact_points cshcp

1180:
1181: CURSOR get_primary_email_info_CS (p_party_id IN NUMBER) IS
1182: SELECT cshcp.sr_contact_point_id,
1183: cshcp.contact_point_id
1184: FROM cs_hz_sr_contact_points cshcp
1185: WHERE cshcp.INCIDENT_ID = l_request_id
1186: AND cshcp.party_role_code = 'CONTACT'
1187: AND cshcp.contact_point_type = 'EMAIL'
1188: AND cshcp.party_id = p_party_id ;

Line 1254: cs_hz_sr_contact_points cshcp

1250: to_number(NULL) person_id,
1251: cshcp.contact_type,
1252: cshcp.sr_contact_point_id
1253: FROM hz_contact_points hcp,
1254: cs_hz_sr_contact_points cshcp
1255: WHERE cshcp.INCIDENT_ID = l_request_id
1256: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1257: AND hcp.CONTACT_POINT_ID = cshcp.CONTACT_POINT_ID
1258: AND cshcp.contact_type <> 'EMPLOYEE'

Line 1267: cs_hz_sr_contact_points cshcp

1263: ppf.person_id,
1264: cshcp.contact_type,
1265: cshcp.sr_contact_point_id
1266: from per_all_people_f ppf,
1267: cs_hz_sr_contact_points cshcp
1268: where cshcp.INCIDENT_ID = l_request_id
1269: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1270: AND ppf.person_id = cshcp.party_id
1271: AND cshcp.contact_type = 'EMPLOYEE'

Line 1279: -- Cursor to query contacts from cs_hz_sr_contact_points table for notification to be

1275: --Added and condition for party role in R12 ... aneemuch
1276:
1277:
1278: -- Rel 12.0 changes
1279: -- Cursor to query contacts from cs_hz_sr_contact_points table for notification to be
1280: -- sent to all the contacts of a particular party role code.
1281:
1282: CURSOR sel_party_role_contacts_csr IS
1283: SELECT hcp.EMAIL_ADDRESS,

Line 1289: cs_hz_sr_contact_points cshcp

1285: to_number(NULL) person_id,
1286: cshcp.contact_type,
1287: cshcp.sr_contact_point_id
1288: FROM hz_contact_points hcp,
1289: cs_hz_sr_contact_points cshcp
1290: WHERE cshcp.INCIDENT_ID = l_request_id
1291: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1292: AND hcp.CONTACT_POINT_ID = cshcp.CONTACT_POINT_ID
1293: AND cshcp.contact_type <> 'EMPLOYEE'

Line 1302: cs_hz_sr_contact_points cshcp

1298: ppf.person_id,
1299: cshcp.contact_type,
1300: cshcp.sr_contact_point_id
1301: from per_all_people_f ppf,
1302: cs_hz_sr_contact_points cshcp
1303: where cshcp.INCIDENT_ID = l_request_id
1304: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1305: AND ppf.person_id = cshcp.party_id
1306: AND cshcp.contact_type = 'EMPLOYEE'

Line 1321: cs_hz_sr_contact_points cshcp

1317: to_number(NULL) person_id,
1318: cshcp.contact_type,
1319: cshcp.sr_contact_point_id
1320: FROM hz_contact_points hcp,
1321: cs_hz_sr_contact_points cshcp
1322: WHERE
1323: hcp.CONTACT_POINT_TYPE = 'EMAIL'
1324: AND hcp.CONTACT_POINT_ID = l_contact_point_id
1325: AND hcp.CONTACT_POINT_ID = cshcp.CONTACT_POINT_ID

Line 1335: cs_hz_sr_contact_points cshcp

1331: ppf.person_id,
1332: cshcp.contact_type,
1333: cshcp.sr_contact_point_id
1334: FROM per_all_people_f ppf,
1335: cs_hz_sr_contact_points cshcp
1336: WHERE
1337: cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1338: AND ppf.PERSON_ID = l_contact_point_id
1339: AND cshcp.PARTY_ID = ppf.person_id

Line 1354: cs_hz_sr_contact_points cshcp,

1350: cshcp.sr_contact_point_id,
1351: cpr.name,
1352: cpr.party_role_code
1353: FROM hz_contact_points hcp,
1354: cs_hz_sr_contact_points cshcp,
1355: cs_party_roles_tl cpr
1356: WHERE
1357: hcp.CONTACT_POINT_TYPE = 'EMAIL'
1358: AND hcp.CONTACT_POINT_ID = l_contact_point_id

Line 1373: cs_hz_sr_contact_points cshcp,

1369: cshcp.sr_contact_point_id,
1370: cpr.name,
1371: cpr.party_role_code
1372: FROM per_all_people_f ppf,
1373: cs_hz_sr_contact_points cshcp,
1374: cs_party_roles_tl cpr
1375: WHERE
1376: cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1377: AND ppf.PERSON_ID = l_contact_point_id

Line 1535: cs_hz_sr_contact_points cshcp

1531: cshcp.contact_type,
1532: cshcp.contact_point_id
1533: FROM hz_parties hzp,
1534: hz_relationships hzr,
1535: cs_hz_sr_contact_points cshcp
1536: WHERE cshcp.INCIDENT_ID = l_request_id
1537: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1538: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1539: AND cshcp.contact_type = 'PARTY_RELATIONSHIP'

Line 1549: cs_hz_sr_contact_points cshcp

1545: hzp.person_last_name last_name,
1546: cshcp.contact_type,
1547: cshcp.contact_point_id
1548: FROM hz_parties hzp,
1549: cs_hz_sr_contact_points cshcp
1550: WHERE cshcp.INCIDENT_ID = l_request_id
1551: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1552: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1553: AND cshcp.contact_type = 'PERSON'

Line 1561: cs_hz_sr_contact_points cshcp

1557: ppf.last_name last_name,
1558: cshcp.contact_type,
1559: cshcp.contact_point_id
1560: FROM per_all_people_f ppf,
1561: cs_hz_sr_contact_points cshcp
1562: WHERE cshcp.INCIDENT_ID = l_request_id
1563: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1564: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1565: AND cshcp.contact_type = 'EMPLOYEE'