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 CSL_CS_INCIDENTS_ALL_ACC_PKG

Line 235: , p_flow_type IN NUMBER )--DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL)

231: *
232: */
233: PROCEDURE INSERT_CS_HZ_SR_CONTACTS( p_incident_id IN NUMBER
234: , p_resource_id IN NUMBER
235: , p_flow_type IN NUMBER )--DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL)
236: IS
237: CURSOR c_contacts( b_incident_id NUMBER
238: , b_resource_id NUMBER)
239: IS

Line 281: IF p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL OR (

277: END IF;
278:
279: /*** Insert contact point ACC record ***/
280: FOR r_contact IN c_contacts( b_incident_id => p_incident_id, b_resource_id => p_resource_id ) LOOP
281: IF p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL OR (
282: p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY AND
283: r_contact.PRIMARY_FLAG = 'Y' ) THEN
284: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
285: jtm_message_log_pkg.Log_Msg

Line 282: p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY AND

278:
279: /*** Insert contact point ACC record ***/
280: FOR r_contact IN c_contacts( b_incident_id => p_incident_id, b_resource_id => p_resource_id ) LOOP
281: IF p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL OR (
282: p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY AND
283: r_contact.PRIMARY_FLAG = 'Y' ) THEN
284: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
285: jtm_message_log_pkg.Log_Msg
286: ( r_contact.SR_CONTACT_POINT_ID

Line 405: , p_flow_type IN NUMBER ) --DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL)

401: *
402: */
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';

Line 435: IF p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL OR (

431: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
432: END IF;
433:
434: FOR r_contact IN c_contacts( b_incident_id => p_incident_id, b_resource_id => p_resource_id ) LOOP
435: IF p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL OR (
436: p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY AND
437: r_contact.PRIMARY_FLAG = 'Y' ) THEN
438:
439: /*Delete the records from incident-contact mapping table*/

Line 436: p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY AND

432: END IF;
433:
434: FOR r_contact IN c_contacts( b_incident_id => p_incident_id, b_resource_id => p_resource_id ) LOOP
435: IF p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL OR (
436: p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY AND
437: r_contact.PRIMARY_FLAG = 'Y' ) THEN
438:
439: /*Delete the records from incident-contact mapping table*/
440: JTM_HOOK_UTIL_PKG.Delete_Acc