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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9


PROCEDURE INSERT_CONTACT_POINT( p_contact_point_id IN NUMBER
                              , p_resource_id IN NUMBER )
IS
 l_table_name            CONSTANT VARCHAR2(30) := 'HZ_CONTACT_POINTS';

Line: 23


    , 'Entering INSERT_CONTACT_POINT'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 31


      , 'Inserting ACC record for resource_id = '||p_resource_id
      , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 35


  JTM_HOOK_UTIL_PKG.Insert_Acc
     ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name
     , P_ACC_TABLE_NAME         => l_acc_table_name
     , P_PK1_NAME               => l_pk1_name
     , P_PK1_NUM_VALUE          => p_contact_point_id
     , P_RESOURCE_ID            => p_resource_id
     );

Line: 47


    , 'Leaving INSERT_CONTACT_POINT'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 50


END INSERT_CONTACT_POINT;

Line: 55


PROCEDURE DELETE_CONTACT_POINT( p_contact_point_id IN NUMBER
                              , p_resource_id IN NUMBER )
IS
 l_table_name            CONSTANT VARCHAR2(30) := 'HZ_CONTACT_POINTS';

Line: 68


    , 'Entering DELETE_CONTACT_POINT'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 72


  JTM_HOOK_UTIL_PKG.Delete_Acc
     (  P_PUBLICATION_ITEM_NAMES => l_publication_item_name
      , P_ACC_TABLE_NAME         => l_acc_table_name
      , P_PK1_NAME               => l_pk1_name
      , P_PK1_NUM_VALUE          => p_contact_point_id
      , P_RESOURCE_ID            => p_resource_id
     );

Line: 84


    , 'Leaving DELETE_CONTACT_POINT'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 88


END DELETE_CONTACT_POINT;

Line: 93


PROCEDURE INSERT_HZ_RELATIONSHIP( p_party_id IN NUMBER
                                , p_resource_id IN NUMBER )
IS
 l_table_name            CONSTANT VARCHAR2(30) := 'HZ_RELATIONSHIPS';

Line: 106


   SELECT *
   FROM HZ_RELATIONSHIPS
   WHERE PARTY_ID = b_party_id
   AND DIRECTIONAL_FLAG = 'F';

Line: 118


    , 'Entering INSERT_HZ_RELATIONSHIP'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 129


        , 'Inserting ACC record for resource_id = '||p_resource_id
        , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 133


    JTM_HOOK_UTIL_PKG.Insert_Acc
       ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name
       , P_ACC_TABLE_NAME         => l_acc_table_name
       , P_PK1_NAME               => l_pk1_name
       , P_PK1_NUM_VALUE          => r_relationship.relationship_id
       , P_PK2_NAME               => l_pk2_name
       , p_PK2_CHAR_VALUE         => 'F'
       , P_RESOURCE_ID            => p_resource_id
       );

Line: 151


    CSL_HZ_PARTIES_ACC_PKG.INSERT_PARTY( r_relationship.SUBJECT_ID, p_resource_id );

Line: 166


    , 'Leaving INSERT_HZ_RELATIONSHIP'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 169


END INSERT_HZ_RELATIONSHIP;

Line: 174


PROCEDURE DELETE_HZ_RELATIONSHIP( p_party_id IN NUMBER
                                , p_resource_id IN NUMBER )
IS
 l_table_name            CONSTANT VARCHAR2(30) := 'HZ_RELATIONSHIPS';

Line: 186


   SELECT *
   FROM HZ_RELATIONSHIPS
   WHERE PARTY_ID = b_party_id
   AND DIRECTIONAL_FLAG = 'F';

Line: 198


    , 'Entering DELETE_HZ_RELATIONSHIP'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 206


    JTM_HOOK_UTIL_PKG.Delete_Acc
       (  P_PUBLICATION_ITEM_NAMES => l_publication_item_name
        , P_ACC_TABLE_NAME         => l_acc_table_name
        , P_PK1_NAME               => l_pk1_name
        , P_PK1_NUM_VALUE          => p_party_id
        , P_PK2_NAME               => l_pk2_name
        , P_PK2_CHAR_VALUE         => 'F'
        , P_RESOURCE_ID            => p_resource_id
       );

Line: 216


    /*Delete the matching party*/
    CSL_HZ_PARTIES_ACC_PKG.INSERT_PARTY( r_relationship.SUBJECT_ID, p_resource_id );

Line: 225


    , 'Leaving DELETE_HZ_RELATIONSHIP'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 228


END DELETE_HZ_RELATIONSHIP;

Line: 233


PROCEDURE INSERT_CS_HZ_SR_CONTACTS( p_incident_id IN NUMBER
                                  , p_resource_id IN NUMBER
				  , p_flow_type   IN NUMBER )--DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL)
IS
 CURSOR c_contacts( b_incident_id NUMBER
                  , b_resource_id NUMBER)
 IS
  SELECT CHS.*
  FROM CS_HZ_SR_CONTACT_POINTS CHS
  WHERE CHS.INCIDENT_ID =  b_incident_id
  AND   CHS.SR_CONTACT_POINT_ID NOT IN (
    SELECT CCA.SR_CONTACT_POINT_ID
    FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA
    WHERE  CCA.RESOURCE_ID = b_resource_id
  );

Line: 252


  SELECT CCA.*
  FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA
  WHERE CCA.RESOURCE_ID = b_resource_id
  AND CCA.SR_CONTACT_POINT_ID NOT IN (
    SELECT CHS.SR_CONTACT_POINT_ID
    FROM CS_HZ_SR_CONTACT_POINTS CHS
    --WHERE CHS.INCIDENT_ID =  b_incident_id
  );

Line: 275


    , 'Entering INSERT_CS_HZ_SR_CONTACTS'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 279


  /*** Insert contact point ACC record ***/
  FOR r_contact IN c_contacts( b_incident_id => p_incident_id, b_resource_id => p_resource_id ) LOOP
   IF p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL OR (
      p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY AND
      r_contact.PRIMARY_FLAG = 'Y' ) THEN
    IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
      jtm_message_log_pkg.Log_Msg
      ( r_contact.SR_CONTACT_POINT_ID
      , l_table_name
      , 'Inserting ACC record for resource_id = '||p_resource_id
      , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 292


   JTM_HOOK_UTIL_PKG.Insert_Acc
       ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name
       , P_ACC_TABLE_NAME         => l_acc_table_name
       , P_PK1_NAME               => l_pk1_name
       , P_PK1_NUM_VALUE          => r_contact.SR_CONTACT_POINT_ID
       , P_RESOURCE_ID            => p_resource_id
       );

Line: 301


   /*Insert the contact point record*/
   IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
      jtm_message_log_pkg.Log_Msg
      ( r_contact.SR_CONTACT_POINT_ID
      , l_table_name
      , 'Calling Insert_Contact_point for contact'||r_contact.CONTACT_POINT_ID
      , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 310


     /*Insert the contact point record*/
     INSERT_CONTACT_POINT( r_contact.CONTACT_POINT_ID, p_resource_id );

Line: 322


	     'Calling the CSL_HZ_PARTIES_ACC_PKG.INSERT_PARTY'
           , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 325


        CSL_HZ_PARTIES_ACC_PKG.INSERT_PARTY( r_contact.PARTY_ID , p_resource_id );

Line: 335


	     'Calling INSERT_HZ_RELATIONSHIP'
           , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 338


        INSERT_HZ_RELATIONSHIP( r_contact.PARTY_ID, p_resource_id );

Line: 348


	     'Calling INSERT_PER_ALL_PEOPLE_F'
           , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 351


        INSERT_PER_ALL_PEOPLE_F( r_contact.PARTY_ID, p_resource_id );

Line: 369


  /*Delete all contacts in the acc table for this incident that are no longer valid*/
  FOR r_obsolete IN c_obsolete_contacts( b_incident_id => p_incident_id, b_resource_id => p_resource_id ) LOOP
    IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
       jtm_message_log_pkg.Log_Msg
       ( r_obsolete.SR_CONTACT_POINT_ID
       , l_table_name
       , 'Deleting contact record '||r_obsolete.SR_CONTACT_POINT_ID||fnd_global.local_chr(10)||
         'for resource '||p_resource_id
       , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 380


    JTM_HOOK_UTIL_PKG.Delete_Acc
     (  P_PUBLICATION_ITEM_NAMES => l_publication_item_name
      , P_ACC_TABLE_NAME         => l_acc_table_name
      , P_PK1_NAME               => l_pk1_name
      , P_PK1_NUM_VALUE          => r_obsolete.SR_CONTACT_POINT_ID
      , P_RESOURCE_ID            => p_resource_id
     );

Line: 395


    , 'Leaving INSERT_CS_HZ_SR_CONTACTS'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 398


END INSERT_CS_HZ_SR_CONTACTS;

Line: 403


PROCEDURE DELETE_CS_HZ_SR_CONTACTS( p_incident_id IN NUMBER
                                  , p_resource_id IN NUMBER
				  , p_flow_type   IN NUMBER ) --DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL)
IS
 l_table_name            CONSTANT VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';

Line: 416


  SELECT CHS.*
  FROM CS_HZ_SR_CONTACT_POINTS CHS
  WHERE CHS.INCIDENT_ID =  b_incident_id
  AND   CHS.SR_CONTACT_POINT_ID IN (
    SELECT CCA.SR_CONTACT_POINT_ID
    FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA
    WHERE  CCA.RESOURCE_ID = b_resource_id
  );

Line: 430


    , 'Entering DELETE_CS_HZ_SR_CONTACTS'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 439


     /*Delete the records from incident-contact mapping table*/
      JTM_HOOK_UTIL_PKG.Delete_Acc
       (  P_PUBLICATION_ITEM_NAMES => l_publication_item_name
        , P_ACC_TABLE_NAME         => l_acc_table_name
        , P_PK1_NAME               => l_pk1_name
        , P_PK1_NUM_VALUE          => r_contact.SR_CONTACT_POINT_ID
        , P_RESOURCE_ID            => p_resource_id
       );

Line: 448


      /*Delete the real contacts*/
      DELETE_CONTACT_POINT( r_contact.CONTACT_POINT_ID, p_resource_id );

Line: 452


        CSL_HZ_PARTIES_ACC_PKG.DELETE_PARTY( r_contact.PARTY_ID , p_resource_id );

Line: 456


        DELETE_HZ_RELATIONSHIP( r_contact.PARTY_ID, p_resource_id );

Line: 460


        DELETE_PER_ALL_PEOPLE_F( r_contact.PARTY_ID, p_resource_id );

Line: 473


    , 'Leaving DELETE_CS_HZ_SR_CONTACTS'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 477


END DELETE_CS_HZ_SR_CONTACTS;

Line: 482


PROCEDURE INSERT_PER_ALL_PEOPLE_F( p_person_id IN NUMBER
                                 , p_resource_id IN NUMBER )
IS

 CURSOR c_per_all_people(b_person_id NUMBER) IS
   SELECT EFFECTIVE_START_DATE , EFFECTIVE_END_DATE
   FROM PER_ALL_PEOPLE_F
   WHERE PERSON_ID = b_person_id;

Line: 503


    , 'Entering INSERT_PER_ALL_PEOPLE_F'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 512


        , 'Inserting ACC record for resource_id = '||p_resource_id
        , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 516


    JTM_HOOK_UTIL_PKG.Insert_Acc
       ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name
       , P_ACC_TABLE_NAME         => l_acc_table_name
       , P_PK1_NAME               => l_pk1_name
       , P_PK1_NUM_VALUE          => p_person_id
       , P_PK2_NAME               => l_pk2_name
       , P_PK2_DATE_VALUE         => r_per_all_people.EFFECTIVE_START_DATE
       , P_PK3_NAME               => l_pk3_name
       , P_PK3_DATE_VALUE         => r_per_all_people.EFFECTIVE_END_DATE
       , P_RESOURCE_ID            => p_resource_id
       );

Line: 533


    , 'Leaving INSERT_PER_ALL_PEOPLE_F'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 536


END INSERT_PER_ALL_PEOPLE_F;

Line: 541


PROCEDURE DELETE_PER_ALL_PEOPLE_F ( p_person_id IN NUMBER
                                  , p_resource_id IN NUMBER )
IS
 CURSOR c_per_all_people(b_person_id NUMBER) IS
   SELECT EFFECTIVE_START_DATE , EFFECTIVE_END_DATE
   FROM PER_ALL_PEOPLE_F
   WHERE PERSON_ID = b_person_id;

Line: 561


    , 'Entering DELETE_PER_ALL_PEOPLE_F'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 574


    JTM_HOOK_UTIL_PKG.Delete_Acc
       (  P_PUBLICATION_ITEM_NAMES => l_publication_item_name
       , P_ACC_TABLE_NAME          => l_acc_table_name
       , P_PK1_NAME                => l_pk1_name
       , P_PK1_NUM_VALUE           => p_person_id
       , P_PK2_NAME                => l_pk2_name
       , P_PK2_DATE_VALUE          => r_per_all_people.EFFECTIVE_START_DATE
       , P_PK3_NAME                => l_pk3_name
       , P_PK3_DATE_VALUE          => r_per_all_people.EFFECTIVE_END_DATE
       , P_RESOURCE_ID             => p_resource_id
       );

Line: 591


    , 'Leaving DELETE_PER_ALL_PEOPLE_F'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 595


END DELETE_PER_ALL_PEOPLE_F;

Line: 597


FUNCTION UPDATE_CONTACT_POINT_WFSUB( p_subscription_guid   in     raw
               , p_event               in out NOCOPY wf_event_t)
return varchar2
IS
 l_table_name            CONSTANT VARCHAR2(30) := 'HZ_CONTACT_POINTS';

Line: 624


    , 'Entering UPDATE_CONTACT_POINT_WFSUB'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 669


        JTM_HOOK_UTIL_PKG.Update_Acc
           ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name
           , P_ACC_TABLE_NAME         => l_acc_table_name
           , P_RESOURCE_ID            => l_tab_resource_id(i)
           , P_ACCESS_ID              => l_tab_access_id(i)
           );

Line: 682


    , 'Leaving UPDATE_CONTACT_POINT_WFSUB'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 690


     WF_CORE.CONTEXT('CSL_PARTY_CONTACTS_ACC_PKG', 'UPDATE_CONTACT_POINT_WFSUB', p_event.getEventName(), p_subscription_guid);

Line: 693


END UPDATE_CONTACT_POINT_WFSUB;