DBA Data[Home] [Help]

APPS.PSP_EFFORT_REPORTS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_EFFORT_REPORT_ID in NUMBER,
  X_VERSION_NUM in NUMBER,
  X_PERSON_ID in NUMBER,
  X_EFFECTIVE_START_DATE in DATE,
  X_EFFECTIVE_END_DATE in DATE,
  X_VERSION_CREATION_DATE in DATE,
  X_VERSION_REASON_CODE in VARCHAR2,
  X_MESSAGE_ID in NUMBER,
  X_REPORT_COMMENT in VARCHAR2,
  X_REPORT_CREATION_DATE in DATE,
  X_STATUS_CODE in VARCHAR2,
  X_TEMPLATE_ID in NUMBER,
  X_PREV_EFFORT_REPORT_ID in NUMBER,
  X_BUSINESS_GROUP_ID	in   NUMBER,
  X_SET_OF_BOOKS_ID	in   NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) is
    cursor C is select ROWID from PSP_EFFORT_REPORTS
      where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
      and VERSION_NUM = X_VERSION_NUM;
Line: 25

    X_LAST_UPDATE_DATE DATE;
Line: 26

    X_LAST_UPDATED_BY NUMBER;
Line: 27

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 29

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 31

    X_LAST_UPDATED_BY := 1;
Line: 32

    X_LAST_UPDATE_LOGIN := 0;
Line: 34

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 35

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 38

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 39

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 46

  insert into PSP_EFFORT_REPORTS (
    EFFORT_REPORT_ID,
    VERSION_NUM,
    PERSON_ID,
    EFFECTIVE_START_DATE,
    EFFECTIVE_END_DATE,
    VERSION_CREATION_DATE,
    VERSION_REASON_CODE,
    MESSAGE_ID,
    REPORT_COMMENT,
    REPORT_CREATION_DATE,
    STATUS_CODE,
    TEMPLATE_ID,
    PREV_EFFORT_REPORT_ID,
    BUSINESS_GROUP_ID,
    SET_OF_BOOKS_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_EFFORT_REPORT_ID,
    X_VERSION_NUM,
    X_PERSON_ID,
    X_EFFECTIVE_START_DATE,
    X_EFFECTIVE_END_DATE,
    X_VERSION_CREATION_DATE,
    X_VERSION_REASON_CODE,
    X_MESSAGE_ID,
    X_REPORT_COMMENT,
    X_REPORT_CREATION_DATE,
    X_STATUS_CODE,
    X_TEMPLATE_ID,
    X_PREV_EFFORT_REPORT_ID,
    X_BUSINESS_GROUP_ID,
    X_SET_OF_BOOKS_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );
Line: 98

end INSERT_ROW;
Line: 117

  cursor c1 is select
      PERSON_ID,
      EFFECTIVE_START_DATE,
      EFFECTIVE_END_DATE,
      VERSION_CREATION_DATE,
      VERSION_REASON_CODE,
      MESSAGE_ID,
      REPORT_COMMENT,
      REPORT_CREATION_DATE,
      STATUS_CODE,
      TEMPLATE_ID,
      PREV_EFFORT_REPORT_ID
    from PSP_EFFORT_REPORTS
    where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
    and VERSION_NUM = X_VERSION_NUM
    for update of EFFORT_REPORT_ID nowait;
Line: 182

procedure UPDATE_ROW (
  X_EFFORT_REPORT_ID in NUMBER,
  X_VERSION_NUM in NUMBER,
  X_PERSON_ID in NUMBER,
  X_EFFECTIVE_START_DATE in DATE,
  X_EFFECTIVE_END_DATE in DATE,
  X_VERSION_CREATION_DATE in DATE,
  X_VERSION_REASON_CODE in VARCHAR2,
  X_MESSAGE_ID in NUMBER,
  X_REPORT_COMMENT in VARCHAR2,
  X_REPORT_CREATION_DATE in DATE,
  X_STATUS_CODE in VARCHAR2,
  X_TEMPLATE_ID in NUMBER,
  X_PREV_EFFORT_REPORT_ID in NUMBER,
  X_BUSINESS_GROUP_ID	in   NUMBER,
  X_SET_OF_BOOKS_ID	in   NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) is
    X_LAST_UPDATE_DATE DATE;
Line: 201

    X_LAST_UPDATED_BY NUMBER;
Line: 202

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 204

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 206

    X_LAST_UPDATED_BY := 1;
Line: 207

    X_LAST_UPDATE_LOGIN := 0;
Line: 209

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 210

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 213

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 214

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 221

  update PSP_EFFORT_REPORTS set
    PERSON_ID = X_PERSON_ID,
    EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE,
    EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,
    VERSION_CREATION_DATE = X_VERSION_CREATION_DATE,
    VERSION_REASON_CODE = X_VERSION_REASON_CODE,
    MESSAGE_ID = X_MESSAGE_ID,
    REPORT_COMMENT = X_REPORT_COMMENT,
    REPORT_CREATION_DATE = X_REPORT_CREATION_DATE,
    STATUS_CODE = X_STATUS_CODE,
    TEMPLATE_ID = X_TEMPLATE_ID,
    PREV_EFFORT_REPORT_ID = X_PREV_EFFORT_REPORT_ID,
    BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
    SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
  and VERSION_NUM = X_VERSION_NUM
  ;
Line: 245

end UPDATE_ROW;
Line: 266

  cursor c1 is select rowid from PSP_EFFORT_REPORTS
     where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
     and VERSION_NUM = X_VERSION_NUM
  ;
Line: 276

    INSERT_ROW (
     X_ROWID,
     X_EFFORT_REPORT_ID,
     X_VERSION_NUM,
     X_PERSON_ID,
     X_EFFECTIVE_START_DATE,
     X_EFFECTIVE_END_DATE,
     X_VERSION_CREATION_DATE,
     X_VERSION_REASON_CODE,
     X_MESSAGE_ID,
     X_REPORT_COMMENT,
     X_REPORT_CREATION_DATE,
     X_STATUS_CODE,
     X_TEMPLATE_ID,
     X_PREV_EFFORT_REPORT_ID,
     X_BUSINESS_GROUP_ID,
     X_SET_OF_BOOKS_ID,
     X_MODE);
Line: 297

  UPDATE_ROW (
   X_EFFORT_REPORT_ID,
   X_VERSION_NUM,
   X_PERSON_ID,
   X_EFFECTIVE_START_DATE,
   X_EFFECTIVE_END_DATE,
   X_VERSION_CREATION_DATE,
   X_VERSION_REASON_CODE,
   X_MESSAGE_ID,
   X_REPORT_COMMENT,
   X_REPORT_CREATION_DATE,
   X_STATUS_CODE,
   X_TEMPLATE_ID,
   X_PREV_EFFORT_REPORT_ID,
   X_BUSINESS_GROUP_ID,
   X_SET_OF_BOOKS_ID,
   X_MODE);
Line: 316

procedure DELETE_ROW (
  X_EFFORT_REPORT_ID in NUMBER,
  X_VERSION_NUM in NUMBER
) is
begin
  delete from PSP_EFFORT_REPORTS
  where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
  and VERSION_NUM = X_VERSION_NUM;
Line: 327

end DELETE_ROW;