APPS.PA_PAGE_CONTENTS_PKG SQL Statements

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

Line: 5

procedure INSERT_PAGE_CONTENTS_ROW (

  P_PAGE_CONTENT_ID  	IN NUMBER,
  P_OBJECT_TYPE    	IN VARCHAR2,
  P_PK1_VALUE      	IN VARCHAR2,
  P_PK2_VALUE      	IN VARCHAR2,
  P_PK3_VALUE      	IN VARCHAR2,
  P_PK4_VALUE      	IN VARCHAR2,
  P_PK5_VALUE      	IN VARCHAR2,

  x_return_status       OUT    NOCOPY VARCHAR2,
  x_msg_count           OUT    NOCOPY NUMBER,
  x_msg_data            OUT    NOCOPY VARCHAR2
) is

  l_ROWID ROWID;

Line: 22

   cursor C is select ROWID from PA_PAGE_CONTENTS
     where Page_content_id = P_PAGE_CONTENT_ID;

Line: 35

  insert into PA_PAGE_CONTENTS (
    PAGE_CONTENT_ID,
    OBJECT_TYPE,
    PK1_VALUE,
    PK2_VALUE,
    PK3_VALUE,
    PK4_VALUE,
    PK5_VALUE,
    PAGE_CONTENT,
    RECORD_VERSION_NUMBER,
    LAST_UPDATED_BY,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN

  ) VALUES (
    P_PAGE_CONTENT_ID,
    P_OBJECT_TYPE,
    P_PK1_VALUE,
    P_PK2_VALUE,
    P_PK3_VALUE,
    P_PK4_VALUE,
    P_PK5_VALUE,
    empty_clob(),
    1,
    fnd_global.user_id,
    fnd_global.user_id,
    sysdate,
    sysdate,
    fnd_global.user_id
    );

Line: 83

end INSERT_PAGE_CONTENTS_ROW;

Line: 100

  update PA_PAGE_CONTENTS set
    PAGE_CONTENT              = empty_clob(),
    RECORD_VERSION_NUMBER     = record_version_number +1,
    LAST_UPDATED_BY           = fnd_global.user_id,
    LAST_UPDATE_DATE          = sysdate,
    LAST_UPDATE_LOGIN         = fnd_global.login_id
    where page_content_id     = p_page_content_id;

Line: 121

procedure UPDATE_PAGE_CONTENTS_ROW (
  P_PAGE_CONTENT_ID       in NUMBER,
  P_OBJECT_TYPE           in VARCHAR2,
  P_PK1_VALUE             in VARCHAR2,
  P_PK2_VALUE             in VARCHAR2,
  P_PK3_VALUE             in VARCHAR2,
  P_PK4_VALUE             in VARCHAR2,
  P_PK5_VALUE             in VARCHAR2,
  p_record_version_number IN NUMBER,

  x_return_status               OUT    NOCOPY VARCHAR2,
  x_msg_count                   OUT    NOCOPY NUMBER,
  x_msg_data                    OUT    NOCOPY VARCHAR2
) is
begin
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 138

  update PA_PAGE_CONTENTS set
    OBJECT_TYPE               = Nvl(p_object_type, object_type),
    PK1_VALUE                 = Nvl(P_PK1_VALUE, PK1_VALUE),
    PK2_VALUE                 = Nvl(P_PK2_VALUE, PK2_VALUE),
    PK3_VALUE                 = Nvl(P_PK3_VALUE, PK3_VALUE),
    PK4_VALUE                 = Nvl(P_PK4_VALUE, PK4_VALUE),
    PK5_VALUE                 = Nvl(P_PK5_VALUE, PK5_VALUE),

    RECORD_VERSION_NUMBER     = record_version_number +1,
    LAST_UPDATED_BY           = fnd_global.user_id,
    LAST_UPDATE_DATE          = sysdate,
    LAST_UPDATE_LOGIN         = fnd_global.login_id
    where page_content_id     = p_page_content_id
    AND record_version_number = Nvl(p_record_version_number, record_version_number);

Line: 162

end UPDATE_PAGE_CONTENTS_ROW;

Line: 166

procedure DELETE_PAGE_CONTENTS_ROW (
  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
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 175

  DELETE FROM  PA_PAGE_CONTENTS
    where page_content_id = P_PAGE_CONTENT_ID;

Line: 183

end DELETE_PAGE_CONTENTS_ROW;