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

Line 241: FROM CS_HZ_SR_CONTACT_POINTS CHS

237: CURSOR c_contacts( b_incident_id NUMBER
238: , b_resource_id NUMBER)
239: IS
240: SELECT CHS.*
241: FROM CS_HZ_SR_CONTACT_POINTS CHS
242: WHERE CHS.INCIDENT_ID = b_incident_id
243: AND CHS.SR_CONTACT_POINT_ID NOT IN (
244: SELECT CCA.SR_CONTACT_POINT_ID
245: FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA

Line 257: FROM CS_HZ_SR_CONTACT_POINTS CHS

253: FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA
254: WHERE CCA.RESOURCE_ID = b_resource_id
255: AND CCA.SR_CONTACT_POINT_ID NOT IN (
256: SELECT CHS.SR_CONTACT_POINT_ID
257: FROM CS_HZ_SR_CONTACT_POINTS CHS
258: --WHERE CHS.INCIDENT_ID = b_incident_id
259: );
260:
261: /*Each procedure has its own set of constants*/

Line 262: l_table_name CONSTANT VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';

258: --WHERE CHS.INCIDENT_ID = b_incident_id
259: );
260:
261: /*Each procedure has its own set of constants*/
262: l_table_name CONSTANT VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';
263: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CS_HZ_SR_CONTACT_PTS_ACC';
264: l_pk1_name CONSTANT VARCHAR2(30) := 'SR_CONTACT_POINT_ID';
265: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
266: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CS_HZ_SR_CONTACT_PTS');

Line 407: l_table_name CONSTANT VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';

403: PROCEDURE DELETE_CS_HZ_SR_CONTACTS( p_incident_id IN NUMBER
404: , p_resource_id IN NUMBER
405: , p_flow_type IN NUMBER ) --DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL)
406: IS
407: l_table_name CONSTANT VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';
408: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CS_HZ_SR_CONTACT_PTS_ACC';
409: l_pk1_name CONSTANT VARCHAR2(30) := 'SR_CONTACT_POINT_ID';
410: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
411: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CS_HZ_SR_CONTACT_PTS');

Line 417: FROM CS_HZ_SR_CONTACT_POINTS CHS

413: CURSOR c_contacts( b_incident_id NUMBER
414: , b_resource_id NUMBER)
415: IS
416: SELECT CHS.*
417: FROM CS_HZ_SR_CONTACT_POINTS CHS
418: WHERE CHS.INCIDENT_ID = b_incident_id
419: AND CHS.SR_CONTACT_POINT_ID IN (
420: SELECT CCA.SR_CONTACT_POINT_ID
421: FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA