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

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

Line: 5


PROCEDURE APPLY_SR_LINK_INSERT
          (p_HA_PAYLOAD_ID  IN  NUMBER,
           p_COL_NAME_LIST  IN  CSM_VARCHAR_LIST,
           p_COL_VALUE_LIST IN  CSM_VARCHAR_LIST,
           x_RETURN_STATUS  OUT NOCOPY VARCHAR2,
           X_Error_Message  Out Nocopy Varchar2
         )
AS
 --Variable Declarations
   L_Api_Version    Number := 2.0;

Line: 29


  CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',FND_LOG.LEVEL_PROCEDURE);

Line: 61


      ELSIF  p_COL_NAME_LIST(i) = 'PROGRAM_UPDATE_DATE' THEN
        L_Link_Rec.PROGRAM_UPDATE_DATE := p_Col_Value_List(I);

Line: 124


  CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',Fnd_Log.Level_Procedure);

Line: 131


   CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',FND_LOG.LEVEL_PROCEDURE);

Line: 134


END APPLY_SR_LINK_INSERT;

Line: 138


PROCEDURE APPLY_SR_LINK_UPDATE
          (p_HA_PAYLOAD_ID  IN  NUMBER,
           p_COL_NAME_LIST  IN  CSM_VARCHAR_LIST,
           p_COL_VALUE_LIST IN  CSM_VARCHAR_LIST,
           x_RETURN_STATUS  OUT NOCOPY VARCHAR2,
           X_Error_Message  Out Nocopy Varchar2
         )
AS
 --Variable Declarations
   L_Api_Version    Number := 2.0;

Line: 161


   SELECT OBJECT_VERSION_NUMBER
   FROM   CS_INCIDENT_LINKS
   WHERE  LINK_ID = B_LINK_ID;

Line: 168


  CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',FND_LOG.LEVEL_PROCEDURE);

Line: 201


      ELSIF  p_COL_NAME_LIST(i) = 'PROGRAM_UPDATE_DATE' THEN
        L_Link_Rec.PROGRAM_UPDATE_DATE := p_Col_Value_List(I);

Line: 247


      Cs_Incidentlinks_Pub.UPDATE_INCIDENTLINK (
        P_Api_Version		=> L_Api_Version,
        P_Init_Msg_List => L_Init_Msg_List,
        P_Commit     		=> NULL,
        P_Resp_Appl_Id	=> Null, -- not used
        P_Resp_Id			  => Null, -- not used
        P_User_Id			  => Fnd_Global.User_Id,
        P_Login_Id		  => NULL,
        P_ORG_ID			  => NULL, -- not used
        P_LINK_ID      => L_LINK_ID,
        P_LINK_REC      => L_LINK_REC,
        P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER,
        X_Return_Status	=> l_return_status,
        X_Msg_Count		  => l_msg_count,
        X_Msg_Data		  => l_msg_data,
        X_Object_Version_Number => L_Object_Version_Number -- new for 1159
        );

Line: 271


  CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',Fnd_Log.Level_Procedure);

Line: 278


   CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',FND_LOG.LEVEL_PROCEDURE);

Line: 281


END APPLY_SR_LINK_UPDATE;

Line: 284


PROCEDURE APPLY_SR_LINK_DELETE
          (p_HA_PAYLOAD_ID  IN  NUMBER,
           p_COL_NAME_LIST  IN  CSM_VARCHAR_LIST,
           p_COL_VALUE_LIST IN  CSM_VARCHAR_LIST,
           x_RETURN_STATUS  OUT NOCOPY VARCHAR2,
           X_Error_Message  Out Nocopy Varchar2
         )
AS
 --Variable Declarations
   L_Api_Version    Number := 2.0;

Line: 305


  CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',FND_LOG.LEVEL_PROCEDURE);

Line: 323


      Cs_Incidentlinks_Pub.DELETE_INCIDENTLINK (
        P_Api_Version		=> L_Api_Version,
        P_Init_Msg_List => FND_API.G_FALSE,
        P_Commit     		=> FND_API.G_FALSE,
        P_Resp_Appl_Id	=> Null, -- not used
        P_Resp_Id			  => Null, -- not used
        P_User_Id			  => Fnd_Global.User_Id,
        P_Login_Id		  => NULL,
        P_ORG_ID			  => NULL, -- not used
        P_LINK_ID      => L_LINK_ID,
        X_Return_Status	=> l_return_status,
        X_Msg_Count		  => l_msg_count,
        X_Msg_Data		  => l_msg_data
        );

Line: 344


  CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',Fnd_Log.Level_Procedure);

Line: 351


   CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',FND_LOG.LEVEL_PROCEDURE);

Line: 354


END APPLY_SR_LINK_DELETE;

Line: 357


PROCEDURE APPLY_SR_ATTR_INSERT
          (p_HA_PAYLOAD_ID  IN  NUMBER,
           p_Col_Name_List  In  Csm_Varchar_List,
           p_COL_VALUE_LIST IN  CSM_VARCHAR_LIST,
           x_RETURN_STATUS  OUT NOCOPY VARCHAR2,
           X_Error_Message  Out Nocopy Varchar2
         )
AS
 --Variable Declarations
  L_Rowid  Varchar2(150);

Line: 391


  L_LAST_UPDATE_DATE  DATE;

Line: 392


  L_Last_Updated_By  Number;

Line: 393


  L_Last_Update_Login  Number;

Line: 400


  CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',FND_LOG.LEVEL_PROCEDURE);

Line: 424


      ELSIF  P_COL_NAME_LIST(i) = 'LAST_UPDATE_DATE' THEN
        L_LAST_UPDATE_DATE := P_COL_NAME_LIST(I);

Line: 426


      Elsif  P_COL_NAME_LIST(I) = 'LAST_UPDATED_BY' Then
         L_Last_Updated_By:= P_COL_NAME_LIST(i);

Line: 428


      ELSIF  P_COL_NAME_LIST(i) = 'LAST_UPDATE_LOGIN' THEN
        L_Last_Update_Login := P_COL_NAME_LIST(I);

Line: 467


      Cug_Incidnt_Attr_Vals_Pkg.Insert_Row (
        X_Rowid => L_Rowid,
        X_Incidnt_Attr_Val_Id => L_Incidnt_Attr_Val_Id,
        X_Object_Version_Number => L_Object_Version_Number,
        X_Incident_Id => L_Incident_Id,
        X_Sr_Attribute_Code => L_Sr_Attribute_Code,
        X_Override_Addr_Valid_Flag => L_Override_Addr_Valid_Flag,
        X_Attribute1 => L_Attribute1,
        X_Attribute2 => L_Attribute2,
        X_Attribute3 => L_Attribute3,
        X_Attribute4 => L_Attribute4,
        X_Attribute5 => L_Attribute5,
        X_Attribute6 => L_Attribute6,
        X_Attribute7 => L_Attribute7,
        X_Attribute8 => L_Attribute8,
        X_Attribute9 => L_Attribute9,
        X_Attribute10 => L_Attribute10,
        X_Attribute11 => L_Attribute11,
        X_Attribute12 => L_Attribute12,
        X_Attribute13 => L_Attribute13,
        X_Attribute14 => L_Attribute14,
        X_Attribute15 => L_Attribute15,
        X_Attribute_Category => L_Attribute_Category,
        X_Sr_Attribute_Value => L_SR_ATTRIBUTE_VALUE,
        X_Creation_Date     => L_Creation_Date,
        X_Created_By        => L_Last_Updated_By,
        X_Last_Update_Date  => L_Last_Update_Date,
        X_Last_Updated_By   => L_Last_Updated_By,
        X_Last_Update_Login => L_Last_Update_Login
      ) ;

Line: 504


  CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',Fnd_Log.Level_Procedure);

Line: 511


   CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',FND_LOG.LEVEL_PROCEDURE);

Line: 514


End APPLY_SR_ATTR_INSERT;

Line: 517


PROCEDURE APPLY_SR_ATTR_UPDATE
          (p_HA_PAYLOAD_ID  IN  NUMBER,
           p_Col_Name_List  In  Csm_Varchar_List,
           p_COL_VALUE_LIST IN  CSM_VARCHAR_LIST,
           x_RETURN_STATUS  OUT NOCOPY VARCHAR2,
           X_Error_Message  Out Nocopy Varchar2
         )
AS
 --Variable Declarations
  L_Rowid  Varchar2(150);

Line: 551


  L_LAST_UPDATE_DATE  DATE;

Line: 552


  L_Last_Updated_By  Number;

Line: 553


  L_Last_Update_Login  Number;

Line: 560


   SELECT OBJECT_VERSION_NUMBER
   FROM   CUG_INCIDNT_ATTR_VALS_B
   WHERE  INCIDNT_ATTR_VAL_ID = B_INCIDNT_ATTR_VAL_ID;

Line: 566


  CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',FND_LOG.LEVEL_PROCEDURE);

Line: 590


      ELSIF  P_COL_NAME_LIST(i) = 'LAST_UPDATE_DATE' THEN
        L_LAST_UPDATE_DATE := P_COL_NAME_LIST(I);

Line: 592


      Elsif  P_COL_NAME_LIST(I) = 'LAST_UPDATED_BY' Then
         L_Last_Updated_By:= P_COL_NAME_LIST(i);

Line: 594


      ELSIF  P_COL_NAME_LIST(i) = 'LAST_UPDATE_LOGIN' THEN
        L_Last_Update_Login := P_COL_NAME_LIST(I);

Line: 633


      CUG_INCIDNT_ATTR_VALS_PKG.UPDATE_ROW
      (
        X_Incidnt_Attr_Val_Id => L_Incidnt_Attr_Val_Id,
        X_Object_Version_Number => L_Object_Version_Number,
        X_Incident_Id => L_Incident_Id,
        X_Sr_Attribute_Code => L_Sr_Attribute_Code,
        X_Override_Addr_Valid_Flag => L_Override_Addr_Valid_Flag,
        X_Attribute1 => L_Attribute1,
        X_Attribute2 => L_Attribute2,
        X_Attribute3 => L_Attribute3,
        X_Attribute4 => L_Attribute4,
        X_Attribute5 => L_Attribute5,
        X_Attribute6 => L_Attribute6,
        X_Attribute7 => L_Attribute7,
        X_Attribute8 => L_Attribute8,
        X_Attribute9 => L_Attribute9,
        X_Attribute10 => L_Attribute10,
        X_Attribute11 => L_Attribute11,
        X_Attribute12 => L_Attribute12,
        X_Attribute13 => L_Attribute13,
        X_Attribute14 => L_Attribute14,
        X_Attribute15 => L_Attribute15,
        X_Attribute_Category => L_Attribute_Category,
        X_Sr_Attribute_Value => L_SR_ATTRIBUTE_VALUE,
        X_Last_Update_Date  => L_Last_Update_Date,
        X_Last_Updated_By   => L_Last_Updated_By,
        X_Last_Update_Login => L_Last_Update_Login
      ) ;

Line: 668


  CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',Fnd_Log.Level_Procedure);

Line: 675


   CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',FND_LOG.LEVEL_PROCEDURE);

Line: 678


END APPLY_SR_ATTR_UPDATE;

Line: 681


PROCEDURE APPLY_SR_ATTR_DELETE
          (p_HA_PAYLOAD_ID  IN  NUMBER,
           p_Col_Name_List  In  Csm_Varchar_List,
           p_COL_VALUE_LIST IN  CSM_VARCHAR_LIST,
           x_RETURN_STATUS  OUT NOCOPY VARCHAR2,
           X_Error_Message  Out Nocopy Varchar2
         )
AS
 --Variable Declarations
  L_Incidnt_Attr_Val_Id  Number;

Line: 697


  CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',FND_LOG.LEVEL_PROCEDURE);

Line: 715


      CUG_INCIDNT_ATTR_VALS_PKG.DELETE_ROW
      (
        X_Incidnt_Attr_Val_Id => L_Incidnt_Attr_Val_Id
      ) ;

Line: 726


  CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',Fnd_Log.Level_Procedure);

Line: 733


   CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
                         'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',FND_LOG.LEVEL_PROCEDURE);

Line: 736


END APPLY_SR_ATTR_DELETE;

Line: 758


            APPLY_SR_ATTR_INSERT
                (p_HA_PAYLOAD_ID => p_HA_PAYLOAD_ID,
                p_COL_NAME_LIST  => P_COL_NAME_LIST,
                p_COL_VALUE_LIST => p_COL_VALUE_LIST,
                x_RETURN_STATUS  => l_RETURN_STATUS,
                x_ERROR_MESSAGE  => l_ERROR_MESSAGE
              );

Line: 767


            APPLY_SR_ATTR_UPDATE
                (p_HA_PAYLOAD_ID => p_HA_PAYLOAD_ID,
                p_COL_NAME_LIST  => P_COL_NAME_LIST,
                p_COL_VALUE_LIST => p_COL_VALUE_LIST,
                x_RETURN_STATUS  => l_RETURN_STATUS,
                X_ERROR_MESSAGE  => L_ERROR_MESSAGE
              );

Line: 776


            APPLY_SR_ATTR_DELETE
                (p_HA_PAYLOAD_ID => p_HA_PAYLOAD_ID,
                p_COL_NAME_LIST  => P_COL_NAME_LIST,
                p_COL_VALUE_LIST => p_COL_VALUE_LIST,
                x_RETURN_STATUS  => l_RETURN_STATUS,
                X_ERROR_MESSAGE  => L_ERROR_MESSAGE
              );

Line: 817


            APPLY_SR_LINK_INSERT
                (p_HA_PAYLOAD_ID  =>p_HA_PAYLOAD_ID,
                p_COL_NAME_LIST  => P_COL_NAME_LIST,
                p_COL_VALUE_LIST => p_COL_VALUE_LIST,
                x_RETURN_STATUS  => l_RETURN_STATUS,
                x_ERROR_MESSAGE  => l_ERROR_MESSAGE
              );

Line: 826


            APPLY_SR_LINK_UPDATE
                (p_HA_PAYLOAD_ID  =>p_HA_PAYLOAD_ID,
                p_COL_NAME_LIST  => P_COL_NAME_LIST,
                p_COL_VALUE_LIST => p_COL_VALUE_LIST,
                x_RETURN_STATUS  => l_RETURN_STATUS,
                X_ERROR_MESSAGE  => L_ERROR_MESSAGE
              );

Line: 835


            APPLY_SR_LINK_DELETE
                (p_HA_PAYLOAD_ID  =>p_HA_PAYLOAD_ID,
                p_COL_NAME_LIST  => P_COL_NAME_LIST,
                p_COL_VALUE_LIST => p_COL_VALUE_LIST,
                x_RETURN_STATUS  => l_RETURN_STATUS,
                X_ERROR_MESSAGE  => L_ERROR_MESSAGE
              );