APPS.PA_PAGE_CONTENTS_PUB SQL Statements

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

Line: 37

		SELECT PAGE_CONTENT_ID
		FROM   PA_PAGE_CONTENTS
		WHERE  OBJECT_TYPE	= P_OBJECT_TYPE
  		AND    NVL(PK1_VALUE,0)	= NVL(P_PK1_VALUE,0)
        	AND    NVL(PK2_VALUE,0) = NVL(P_PK2_VALUE,0)
        	AND    NVL(PK3_VALUE,0) = NVL(P_PK3_VALUE,0)
        	AND    NVL(PK4_VALUE,0) = NVL(P_PK4_VALUE,0)
        	AND    NVL(PK5_VALUE,0) = NVL(P_PK5_VALUE,0);

Line: 132

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   :=NULL
        ,P_OBJECT_TYPE          IN      VARCHAR2 :=NULL
        ,P_PK1_VALUE            IN      VARCHAR2 :=NULL
        ,P_PK2_VALUE            IN      VARCHAR2 :=NULL
        ,P_PK3_VALUE            IN      VARCHAR2 :=NULL
        ,P_PK4_VALUE            IN      VARCHAR2 :=NULL
        ,P_PK5_VALUE            IN      VARCHAR2 :=NULL

  --      ,x_page_content_id      OUT     NUMBER
        ,x_return_status        OUT     NOCOPY VARCHAR2
        ,x_msg_count            OUT     NOCOPY NUMBER
        ,x_msg_data             OUT     NOCOPY VARCHAR2
) is
        l_rowid         ROWID;

Line: 158

                SELECT PAGE_CONTENT_ID
                FROM   PA_PAGE_CONTENTS
                WHERE  OBJECT_TYPE      = P_OBJECT_TYPE
                AND    NVL(PK1_VALUE,0) = NVL(P_PK1_VALUE,0)
                AND    NVL(PK2_VALUE,0) = NVL(P_PK2_VALUE,0)
                AND    NVL(PK3_VALUE,0) = NVL(P_PK3_VALUE,0)
                AND    NVL(PK4_VALUE,0) = NVL(P_PK4_VALUE,0)
                AND    NVL(PK5_VALUE,0) = NVL(P_PK5_VALUE,0);

Line: 169

  PA_DEBUG.init_err_stack('PA_PAGE_CONTENTS_PUB.Delete_Page_Contents');

Line: 196

  PA_PAGE_CONTENTS_PVT.DELETE_PAGE_CONTENTS (
         p_api_version
        ,p_init_msg_list
        ,p_commit
        ,p_validate_only
        ,p_max_msg_count

        ,l_content_id
        ,x_return_status
        ,x_msg_count
        ,x_msg_data);

Line: 228

       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_CONTENTS_PUB.DELETE_PAGE_CONTENTS'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 233

end DELETE_PAGE_CONTENTS;