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

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

Line: 19


  SELECT party_id        -- Fix for Sql Performance
  FROM HZ_PARTIES
  WHERE PARTY_ID = b_party_id;

Line: 62


PROCEDURE INSERT_ACC_RECORD( p_party_id    IN NUMBER
                           , p_resource_id IN NUMBER )
IS
BEGIN
  IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
    jtm_message_log_pkg.Log_Msg
    ( p_party_id
    , g_table_name
    , 'Entering Insert_Acc_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 78


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

Line: 82


  JTM_HOOK_UTIL_PKG.Insert_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
     , P_ACC_TABLE_NAME         => g_acc_table_name
     , P_PK1_NAME               => g_pk1_name
     , P_PK1_NUM_VALUE          => p_party_id
     , P_RESOURCE_ID            => p_resource_id
     );

Line: 94


    , 'Leaving Insert_Acc_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 98


END INSERT_ACC_RECORD;

Line: 103


PROCEDURE UPDATE_ACC_RECORD( p_access_id IN NUMBER
                           , p_party_id IN NUMBER
                           , p_resource_id IN NUMBER )
IS
BEGIN
  IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
    jtm_message_log_pkg.Log_Msg
    ( p_party_id
    , g_table_name
    , 'Entering Update_Acc_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 125


  JTM_HOOK_UTIL_PKG.Update_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
     , P_ACC_TABLE_NAME         => g_acc_table_name
     , P_RESOURCE_ID            => p_resource_id
     , P_ACCESS_ID              => p_access_id
     );

Line: 136


    , 'Leaving Update_Acc_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 139


END UPDATE_ACC_RECORD;

Line: 144


PROCEDURE DELETE_ACC_RECORD( p_party_id IN NUMBER
                           , p_resource_id IN NUMBER )
IS
BEGIN
  IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
    jtm_message_log_pkg.Log_Msg
    ( p_party_id
    , g_table_name
    , 'Entering Delete_Acc_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 164


  JTM_HOOK_UTIL_PKG.Delete_Acc
    ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
     ,P_ACC_TABLE_NAME         => g_acc_table_name
     ,P_PK1_NAME               => g_pk1_name
     ,P_PK1_NUM_VALUE          => p_party_id
     ,P_RESOURCE_ID            => p_resource_id
    );

Line: 176


    , 'Leaving Delete_Acc_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 179


END DELETE_ACC_RECORD;

Line: 184


PROCEDURE INSERT_PARTY( p_party_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_return BOOLEAN;

Line: 196


    , 'Entering Insert_Party'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 203


    INSERT_ACC_RECORD( p_party_id, p_resource_id );

Line: 214


      l_return := CSL_JTF_NOTES_ACC_PKG.PRE_INSERT_CHILDREN
                                      ( P_SOURCE_OBJ_ID   => p_party_id
  				      , P_SOURCE_OBJ_CODE => 'PARTY'
  				      , P_RESOURCE_ID     => p_resource_id );

Line: 225


    , 'Leaving Insert_Party'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 229


END INSERT_PARTY;

Line: 234


PROCEDURE UPDATE_PARTY( p_party_id IN NUMBER )
IS
  l_tab_resource_id    dbms_sql.Number_Table;

Line: 244


    , 'Entering Update_Party'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 259


        UPDATE_ACC_RECORD( p_access_id   => l_tab_access_id(i)
	                 , p_party_id    => p_party_id
			 , p_resource_id => l_tab_resource_id(i));

Line: 269


    , 'Leaving Update_Party'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 272


END UPDATE_PARTY;

Line: 277


PROCEDURE DELETE_PARTY( p_party_id    IN NUMBER
                      , p_resource_id IN NUMBER
		      , p_flow_type   IN NUMBER )--DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL)
IS
BEGIN
  g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line: 287


    , 'Entering Delete_Party'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 291


  DELETE_ACC_RECORD( p_party_id, p_resource_id );

Line: 297


    , 'Delete the notes for this party'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 303


    CSL_JTF_NOTES_ACC_PKG.POST_DELETE_CHILDREN( P_SOURCE_OBJ_ID   => p_party_id
                                              , P_SOURCE_OBJ_CODE => 'PARTY'
  					      , P_RESOURCE_ID     => p_resource_id );

Line: 312


    , 'Leaving Delete_Party'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 316


END DELETE_PARTY;

Line: 345


  /*Party is changed so delete the old one ( basicly we lower the counter )*/
  DELETE_ACC_RECORD( p_old_party_id, p_resource_id );

Line: 352


    , 'Delete the notes for the old party'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 355


  /*Delete the matching notes*/
  CSL_JTF_NOTES_ACC_PKG.POST_DELETE_CHILDREN( P_SOURCE_OBJ_ID   => p_old_party_id
                                            , P_SOURCE_OBJ_CODE => 'PARTY'
					    , P_RESOURCE_ID     => p_resource_id );

Line: 362


    /*Insert the new party*/
    INSERT_ACC_RECORD( p_new_party_id, p_resource_id );

Line: 368


      , 'Insert the notes for the new party'
      , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 371


    /*Insert the notes*/
    l_return := CSL_JTF_NOTES_ACC_PKG.PRE_INSERT_CHILDREN
                                    ( P_SOURCE_OBJ_ID   => p_new_party_id
  				    , P_SOURCE_OBJ_CODE => 'PARTY'
  				    , P_RESOURCE_ID     => p_resource_id );

Line: 390


PROCEDURE PRE_INSERT_PARTY ( x_return_status OUT NOCOPY varchar2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 399


PROCEDURE POST_INSERT_PARTY ( x_return_status OUT NOCOPY varchar2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 408


PROCEDURE PRE_UPDATE_PARTY ( x_return_status OUT NOCOPY varchar2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 417


PROCEDURE POST_UPDATE_PARTY ( x_return_status OUT NOCOPY varchar2)
IS
 l_party_id NUMBER;

Line: 432


    , 'Entering POST_UPDATE_PARTY'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 458


        UPDATE_ACC_RECORD( p_access_id   => l_tab_access_id(i)
  	                 , p_party_id    => l_party_id
  			 , p_resource_id => l_tab_resource_id(i));

Line: 469


    , 'Leaving POST_UPDATE_PARTY'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 478


PROCEDURE PRE_DELETE_PARTY ( x_return_status OUT NOCOPY varchar2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 487


PROCEDURE POST_DELETE_PARTY ( x_return_status OUT NOCOPY varchar2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 493


FUNCTION UPDATE_PARTY_WFSUB( p_subscription_guid   in     raw
               , p_event               in out NOCOPY wf_event_t)
return varchar2
IS
 l_key                    varchar2(240) := p_event.GetEventKey();

Line: 513


    , 'Entering UPDATE_PARTY_WFSUB'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 549


  UPDATE_PARTY(l_party_id);

Line: 556


    , 'Leaving UPDATE_PARTY_WFSUB'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 564


     WF_CORE.CONTEXT('CSL_HZ_PARTIES_ACC_PKG', 'UPDATE_PARTY_WFSUB', p_event.getEventName(), p_subscription_guid);

Line: 567


END UPDATE_PARTY_WFSUB;