APPS.IEX_WRITEOFF_OBJECTS_PUB SQL Statements

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

Line: 139

PROCEDURE update_writeoff_objects(
     P_Api_Version_Number         IN   NUMBER
    ,P_Init_Msg_List              IN   VARCHAR2
    ,P_Commit                     IN   VARCHAR2
    ,P_writeoff_obj_rec           IN   writeoff_obj_rec_type
    ,x_return_status              OUT  NOCOPY VARCHAR2
    ,x_msg_count                  OUT  NOCOPY NUMBER
    ,x_msg_data                   OUT  NOCOPY VARCHAR2
    ,XO_OBJECT_VERSION_NUMBER     OUT  NOCOPY NUMBER) IS

l_api_name                CONSTANT VARCHAR2(60) := 'UPDATE_WRITEOFF_OBJECTS';

Line: 160

                                   'IEX_writeoff_objects_PUB.update_writeoff_objects *** ');

Line: 163

      SAVEPOINT UPDATE_WRITEOFF_OBJECTS_PUB;

Line: 177

                                  'update_writeoff_objects');

Line: 181

       IEX_WRITEOFF_OBJECTS_PVT.update_writeoff_objects(
         P_Api_Version_Number       =>p_Api_Version_Number
        ,P_Init_Msg_List            =>P_Init_Msg_List
        ,P_Commit                   =>p_commit
        ,P_writeoff_obj_rec         =>P_writeoff_obj_rec
        ,XO_object_version_number   =>v_object_version_number
        ,x_return_status            =>l_return_status
        ,x_msg_count                =>l_msg_count
        ,x_msg_data                 =>l_msg_data);

Line: 207

                       'IEX_writeoff_objects_PUB.update_writeoff_objects ** ');

Line: 211

                ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PUB;

Line: 218

                ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PUB;

Line: 225

                ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PUB;

Line: 232

End update_writeoff_objects;

Line: 234

PROCEDURE delete_writeoff_objects(
     P_Api_Version_Number         IN   NUMBER
    ,P_Init_Msg_List              IN   VARCHAR2
    ,P_Commit                     IN   VARCHAR2
    ,p_writeoff_object_id         IN   NUMBER
    ,x_return_status              OUT  NOCOPY VARCHAR2
    ,x_msg_count                  OUT  NOCOPY NUMBER
    ,x_msg_data                   OUT  NOCOPY VARCHAR2) IS

l_api_name                CONSTANT VARCHAR2(50) := 'DELETE_WRITEOFF_OBJECTS';

Line: 251

      SAVEPOINT DELETE_WRITEOFF_OBJECTS_PUB;

Line: 277

       IEX_WRITEOFF_OBJECTS_PVT.delete_writeoff_objects(
         P_Api_Version_Number       =>p_Api_Version_Number
        ,P_Init_Msg_List            =>P_Init_Msg_List
        ,P_Commit                   =>p_commit
        ,P_writeoff_object_id       =>p_writeoff_object_id
        ,x_return_status            =>l_return_status
        ,x_msg_count                =>l_msg_count
        ,x_msg_data                 =>l_msg_data);

Line: 312

                ROLLBACK TO DELETE_WRITEOFF_OBJECTS_PUB;

Line: 319

                ROLLBACK TO DELETE_WRITEOFF_OBJECTS_PUB;

Line: 327

                ROLLBACK TO DELETE_WRITEOFF_OBJECTS_PUB;

Line: 335

End delete_writeoff_objects;