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 1142: cs_hz_sr_contact_points cshcp

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

Line 1156: cs_hz_sr_contact_points cshcp

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

Line 1175: FROM cs_hz_sr_contact_points cshcp

1171: cshcp.contact_type,
1172: cshcp.sr_contact_point_id,
1173: cshcp.contact_point_type,
1174: cshcp.contact_point_id
1175: FROM cs_hz_sr_contact_points cshcp
1176: WHERE cshcp.INCIDENT_ID = l_request_id
1177: AND cshcp.PRIMARY_FLAG = 'Y'
1178: AND cshcp.party_role_code = 'CONTACT'
1179: AND cshcp.end_date_active IS NULL;--12.1.3 Inactivate Contact Points

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

1177: AND cshcp.PRIMARY_FLAG = 'Y'
1178: AND cshcp.party_role_code = 'CONTACT'
1179: AND cshcp.end_date_active IS NULL;--12.1.3 Inactivate Contact Points
1180:
1181: -- Get the primary contact's email information from the cs_hz_sr_contact_points table.
1182:
1183: CURSOR get_primary_email_info_CS (p_party_id IN NUMBER) IS
1184: SELECT cshcp.sr_contact_point_id,
1185: cshcp.contact_point_id

Line 1186: FROM cs_hz_sr_contact_points cshcp

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

Line 1257: cs_hz_sr_contact_points cshcp

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

Line 1270: cs_hz_sr_contact_points cshcp

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

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

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

Line 1293: cs_hz_sr_contact_points cshcp

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

Line 1306: cs_hz_sr_contact_points cshcp

1302: ppf.person_id,
1303: cshcp.contact_type,
1304: cshcp.sr_contact_point_id
1305: from per_all_people_f ppf,
1306: cs_hz_sr_contact_points cshcp
1307: where cshcp.INCIDENT_ID = l_request_id
1308: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1309: AND ppf.person_id = cshcp.party_id
1310: AND cshcp.contact_type = 'EMPLOYEE'

Line 1325: cs_hz_sr_contact_points cshcp

1321: to_number(NULL) person_id,
1322: cshcp.contact_type,
1323: cshcp.sr_contact_point_id
1324: FROM hz_contact_points hcp,
1325: cs_hz_sr_contact_points cshcp
1326: WHERE
1327: hcp.CONTACT_POINT_TYPE = 'EMAIL'
1328: AND hcp.CONTACT_POINT_ID = l_contact_point_id
1329: AND hcp.CONTACT_POINT_ID = cshcp.CONTACT_POINT_ID

Line 1339: cs_hz_sr_contact_points cshcp

1335: ppf.person_id,
1336: cshcp.contact_type,
1337: cshcp.sr_contact_point_id
1338: FROM per_all_people_f ppf,
1339: cs_hz_sr_contact_points cshcp
1340: WHERE
1341: cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1342: AND ppf.PERSON_ID = l_contact_point_id
1343: AND cshcp.PARTY_ID = ppf.person_id

Line 1358: cs_hz_sr_contact_points cshcp,

1354: cshcp.sr_contact_point_id,
1355: cpr.name,
1356: cpr.party_role_code
1357: FROM hz_contact_points hcp,
1358: cs_hz_sr_contact_points cshcp,
1359: cs_party_roles_tl cpr
1360: WHERE
1361: hcp.CONTACT_POINT_TYPE = 'EMAIL'
1362: AND hcp.CONTACT_POINT_ID = l_contact_point_id

Line 1377: cs_hz_sr_contact_points cshcp,

1373: cshcp.sr_contact_point_id,
1374: cpr.name,
1375: cpr.party_role_code
1376: FROM per_all_people_f ppf,
1377: cs_hz_sr_contact_points cshcp,
1378: cs_party_roles_tl cpr
1379: WHERE
1380: cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1381: AND ppf.PERSON_ID = l_contact_point_id

Line 1539: cs_hz_sr_contact_points cshcp

1535: cshcp.contact_type,
1536: cshcp.contact_point_id
1537: FROM hz_parties hzp,
1538: hz_relationships hzr,
1539: cs_hz_sr_contact_points cshcp
1540: WHERE cshcp.INCIDENT_ID = l_request_id
1541: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1542: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1543: AND cshcp.contact_type = 'PARTY_RELATIONSHIP'

Line 1553: cs_hz_sr_contact_points cshcp

1549: hzp.person_last_name last_name,
1550: cshcp.contact_type,
1551: cshcp.contact_point_id
1552: FROM hz_parties hzp,
1553: cs_hz_sr_contact_points cshcp
1554: WHERE cshcp.INCIDENT_ID = l_request_id
1555: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1556: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1557: AND cshcp.contact_type = 'PERSON'

Line 1565: cs_hz_sr_contact_points cshcp

1561: ppf.last_name last_name,
1562: cshcp.contact_type,
1563: cshcp.contact_point_id
1564: FROM per_all_people_f ppf,
1565: cs_hz_sr_contact_points cshcp
1566: WHERE cshcp.INCIDENT_ID = l_request_id
1567: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1568: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1569: AND cshcp.contact_type = 'EMPLOYEE'

Line 1577: cs_hz_sr_contact_points cshcp

1573: SELECT hzp.person_first_name first_name,
1574: hzp.person_last_name last_name
1575: FROM hz_parties hzp,
1576: hz_relationships hzr,
1577: cs_hz_sr_contact_points cshcp
1578: WHERE cshcp.INCIDENT_ID = l_request_id
1579: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1580: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1581: AND cshcp.contact_type = 'PARTY_RELATIONSHIP'

Line 1589: cs_hz_sr_contact_points cshcp

1585: UNION --start bug 12666217
1586: SELECT hzp.person_first_name first_name,
1587: hzp.person_last_name last_name
1588: FROM hz_parties hzp,
1589: cs_hz_sr_contact_points cshcp
1590: WHERE cshcp.INCIDENT_ID = l_request_id
1591: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1592: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1593: AND cshcp.contact_type = 'PERSON'

Line 1599: cs_hz_sr_contact_points cshcp

1595: UNION -- start Bug 12610714
1596: SELECT ppf.first_name first_name,
1597: ppf.last_name last_name
1598: From per_all_people_f ppf,
1599: cs_hz_sr_contact_points cshcp
1600: WHERE cshcp.INCIDENT_ID = l_request_id
1601: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1602: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1603: AND cshcp.contact_type = 'EMPLOYEE'

Line 1607: cs_hz_sr_contact_points cshcp1

1603: AND cshcp.contact_type = 'EMPLOYEE'
1604: AND cshcp.PARTY_ID = ppf.PERSON_ID
1605: AND ppf.effective_end_date = (select max(ppf1.effective_end_date)
1606: from per_all_people_f ppf1,
1607: cs_hz_sr_contact_points cshcp1
1608: WHERE cshcp1.INCIDENT_ID = l_request_id
1609: AND cshcp1.sr_contact_point_id = l_tmp_contact_point_id
1610: AND cshcp1.CONTACT_POINT_TYPE = 'EMAIL'
1611: AND cshcp1.contact_type = 'EMPLOYEE'

Line 1621: cs_hz_sr_contact_points cshcp

1617: FROM (
1618: SELECT ppf.first_name first_name,
1619: ppf.last_name last_name
1620: FROM per_all_people_f ppf,
1621: cs_hz_sr_contact_points cshcp
1622: WHERE cshcp.INCIDENT_ID = l_request_id
1623: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1624: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1625: AND cshcp.contact_type = 'EMPLOYEE'