APPS.ICX_CAT_POPULATE_CATG_GRP SQL Statements

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

Line: 144

PROCEDURE populateValidCategorySetInsert
(       p_api_version           IN              NUMBER                                  ,
        p_commit                IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_init_msg_list         IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_validation_level      IN              VARCHAR2 := FND_API.G_VALID_LEVEL_FULL  ,
        x_return_status         OUT NOCOPY      VARCHAR2                                ,
        p_category_set_id       IN              NUMBER                                  ,
        p_category_id           IN              NUMBER
)
IS
l_api_name                      CONSTANT VARCHAR2(30)   := 'populateValidCategorySetInsert';

Line: 166

  SAVEPOINT popValidCatgSetInsert_sp;

Line: 210

  ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE := ICX_CAT_POPULATE_CATG_PVT.g_DML_INSERT_TYPE;

Line: 213

  ICX_CAT_POPULATE_CATG_PVT.populateValidCategorySetInsert(P_CATEGORY_ID);

Line: 246

      ROLLBACK TO popValidCatgSetInsert_sp;

Line: 258

END populateValidCategorySetInsert;

Line: 264

PROCEDURE populateValidCategorySetUpdate
(       p_api_version           IN              NUMBER                                  ,
        p_commit                IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_init_msg_list         IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_validation_level      IN              VARCHAR2 := FND_API.G_VALID_LEVEL_FULL  ,
        x_return_status         OUT NOCOPY      VARCHAR2                                ,
        p_category_set_id       IN              NUMBER                                  ,
        p_old_category_id       IN              NUMBER                                  ,
        p_new_category_id       IN              NUMBER
)
IS
l_api_name                      CONSTANT VARCHAR2(30)   := 'populateValidCategorySetUpdate';

Line: 287

  SAVEPOINT popValidCatgSetUpdate_sp;

Line: 332

  ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE := ICX_CAT_POPULATE_CATG_PVT.g_DML_UPDATE_TYPE;

Line: 335

  ICX_CAT_POPULATE_CATG_PVT.populateValidCategorySetUpdate(P_OLD_CATEGORY_ID, P_NEW_CATEGORY_ID);

Line: 368

      ROLLBACK TO popValidCatgSetUpdate_sp;

Line: 380

END populateValidCategorySetUpdate;

Line: 386

PROCEDURE populateValidCategorySetDelete
(       p_api_version           IN              NUMBER                                  ,
        p_commit                IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_init_msg_list         IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_validation_level      IN              VARCHAR2 := FND_API.G_VALID_LEVEL_FULL  ,
        x_return_status         OUT NOCOPY      VARCHAR2                                ,
        p_category_set_id       IN              NUMBER                                  ,
        p_category_id           IN              NUMBER
)
IS
l_api_name                      CONSTANT VARCHAR2(30)   := 'populateValidCategorySetDelete';

Line: 408

  SAVEPOINT popValidCatgSetDelete_sp;

Line: 453

  ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE := ICX_CAT_POPULATE_CATG_PVT.g_DML_DELETE_TYPE;

Line: 456

  ICX_CAT_POPULATE_CATG_PVT.populateValidCategorySetDelete(P_CATEGORY_ID);

Line: 489

      ROLLBACK TO popValidCatgSetDelete_sp;

Line: 501

END populateValidCategorySetDelete;