APPS.PA_PAGE_CONTENTS_PVT SQL Statements

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

Line: 65

      SELECT pa.pa_page_contents_s.nextval */
      SELECT pa_page_contents_s.nextval
      INTO l_content_id
      FROM DUAL;

Line: 70

      PA_PAGE_CONTENTS_PKG.INSERT_PAGE_CONTENTS_ROW (
         l_content_id
        ,P_OBJECT_TYPE
        ,P_PK1_VALUE
        ,P_PK2_VALUE
        ,P_PK3_VALUE
        ,P_PK4_VALUE
        ,P_PK5_VALUE
        ,x_return_status
        ,x_msg_count
        ,x_msg_data
        );

Line: 107

procedure DELETE_PAGE_CONTENTS (
         p_api_version          IN      NUMBER   :=  1.0
        ,p_init_msg_list        IN      VARCHAR2 := fnd_api.g_true
        ,p_commit               IN      VARCHAR2 := FND_API.g_false
        ,p_validate_only        IN      VARCHAR2 := FND_API.g_true
        ,p_max_msg_count        IN      NUMBER   := FND_API.g_miss_num

  	,P_PAGE_CONTENT_ID      IN 	NUMBER
  	,x_return_status        OUT    	NOCOPY VARCHAR2
  	,x_msg_count            OUT    	NOCOPY NUMBER
  	,x_msg_data             OUT    	NOCOPY VARCHAR2
) is
begin
  -- Initialize the Error Stack
  PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_PageContents');

Line: 134

        SAVEPOINT delete_page_contents;

Line: 136

      PA_PAGE_CONTENTS_PKG.DELETE_PAGE_CONTENTS_ROW(
         P_PAGE_CONTENT_ID
        ,x_return_status
        ,x_msg_count
        ,x_msg_data
        );

Line: 156

          ROLLBACK TO delete_page_contents;

Line: 160

        FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_CONTENTS_PVT.delete_page_contents'
                                 ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 165

end DELETE_PAGE_CONTENTS;