APPS.OKL_SETUPCONTEXTGROUPS_PVT SQL Statements

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

Line: 14

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
			SFWT_FLAG,
			NAME,
			NVL(DESCRIPTION, OKL_API.G_MISS_CHAR) DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
     FROM Okl_Context_Groups_V
     WHERE okl_Context_Groups_V.id    = p_id;

Line: 43

              l_cgrv_rec.LAST_UPDATED_BY,
              l_cgrv_rec.LAST_UPDATE_DATE,
              l_cgrv_rec.LAST_UPDATE_LOGIN;

Line: 70

  PROCEDURE insert_contextgroups(p_api_version     IN  NUMBER,
                        		  p_init_msg_list   IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                        		  x_return_status   OUT NOCOPY VARCHAR2,
                        		  x_msg_count       OUT NOCOPY NUMBER,
                        		  x_msg_data        OUT NOCOPY VARCHAR2,
                        		  p_cgrv_rec        IN  cgrv_rec_type,
                        		  x_cgrv_rec        OUT NOCOPY cgrv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 79

    l_api_name        CONSTANT VARCHAR2(30)  := 'insert_contextgroups';

Line: 100

	/* public api to insert context groups */
    okl_context_groups_pub.insert_context_groups(p_api_version   => p_api_version,
                              		             p_init_msg_list => p_init_msg_list,
                              		 	   		 x_return_status => l_return_status,
                              		 	   		 x_msg_count     => x_msg_count,
                              		 	   		 x_msg_data      => x_msg_data,
                              		 	   		 p_cgrv_rec      => l_cgrv_rec,
                              		 	   		 x_cgrv_rec      => x_cgrv_rec);

Line: 140

  END insert_contextgroups;

Line: 145

  PROCEDURE update_contextgroups(p_api_version     IN  NUMBER,
                        		  p_init_msg_list   IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                        		  x_return_status   OUT NOCOPY VARCHAR2,
                        		  x_msg_count       OUT NOCOPY NUMBER,
                        		  x_msg_data        OUT NOCOPY VARCHAR2,
                        		  p_cgrv_rec        IN  cgrv_rec_type,
                        		  x_cgrv_rec        OUT NOCOPY cgrv_rec_type
                        ) IS
    l_api_version     CONSTANT NUMBER := 1;

Line: 154

    l_api_name        CONSTANT VARCHAR2(30)  := 'update_contextgroups';

Line: 175

	/* public api to update context groups */
    okl_context_groups_pub.update_context_groups(p_api_version   => p_api_version,
                              		 	         p_init_msg_list => p_init_msg_list,
                              		 	   		 x_return_status => l_return_status,
                              		 	   		 x_msg_count     => x_msg_count,
                              		 	   		 x_msg_data      => x_msg_data,
                              		 	   		 p_cgrv_rec      => l_cgrv_rec,
                              		 	   		 x_cgrv_rec      => x_cgrv_rec);

Line: 215

  END update_contextgroups;