APPS.PSP_EFFORT_REPORT_DETAILS_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_EFFORT_REPORT_LINE_NUM in NUMBER,
  X_ASSIGNMENT_ID in NUMBER,
  X_ELEMENT_TYPE_ID in NUMBER,
  X_GL_CODE_COMBINATION_ID in NUMBER,
  X_PROJECT_ID in NUMBER,
  X_EXPENDITURE_ORGANIZATION_ID in NUMBER,
  X_EXPENDITURE_TYPE in VARCHAR2,
  X_TASK_ID in NUMBER,
  X_AWARD_ID in NUMBER,
  X_TOTAL_AMOUNT in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) is
    cursor C is select ROWID from PSP_EFFORT_REPORT_DETAILS
      where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
      and VERSION_NUM = X_VERSION_NUM
      and EFFORT_REPORT_LINE_NUM = X_EFFORT_REPORT_LINE_NUM;

Line: 23

    X_LAST_UPDATE_DATE DATE;

Line: 24

    X_LAST_UPDATED_BY NUMBER;

Line: 25

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 27

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 29

    X_LAST_UPDATED_BY := 1;

Line: 30

    X_LAST_UPDATE_LOGIN := 0;

Line: 32

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 33

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 36

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 37

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 44

  insert into PSP_EFFORT_REPORT_DETAILS (
    EFFORT_REPORT_ID,
    VERSION_NUM,
    EFFORT_REPORT_LINE_NUM,
    ASSIGNMENT_ID,
    ELEMENT_TYPE_ID,
    GL_CODE_COMBINATION_ID,
    PROJECT_ID,
    EXPENDITURE_ORGANIZATION_ID,
    EXPENDITURE_TYPE,
    TASK_ID,
    AWARD_ID,
    TOTAL_AMOUNT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_EFFORT_REPORT_ID,
    X_VERSION_NUM,
    X_EFFORT_REPORT_LINE_NUM,
    X_ASSIGNMENT_ID,
    X_ELEMENT_TYPE_ID,
    X_GL_CODE_COMBINATION_ID,
    X_PROJECT_ID,
    X_EXPENDITURE_ORGANIZATION_ID,
    X_EXPENDITURE_TYPE,
    X_TASK_ID,
    X_AWARD_ID,
    X_TOTAL_AMOUNT,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 90

end INSERT_ROW;

Line: 106

  cursor c1 is select
      ASSIGNMENT_ID,
      ELEMENT_TYPE_ID,
      GL_CODE_COMBINATION_ID,
      PROJECT_ID,
      EXPENDITURE_ORGANIZATION_ID,
      EXPENDITURE_TYPE,
      TASK_ID,
      AWARD_ID,
      TOTAL_AMOUNT
    from PSP_EFFORT_REPORT_DETAILS
    where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
    and VERSION_NUM = X_VERSION_NUM
    and EFFORT_REPORT_LINE_NUM = X_EFFORT_REPORT_LINE_NUM
    for update of EFFORT_REPORT_ID nowait;

Line: 164

procedure UPDATE_ROW (
  X_EFFORT_REPORT_ID in NUMBER,
  X_VERSION_NUM in NUMBER,
  X_EFFORT_REPORT_LINE_NUM in NUMBER,
  X_ASSIGNMENT_ID in NUMBER,
  X_ELEMENT_TYPE_ID in NUMBER,
  X_GL_CODE_COMBINATION_ID in NUMBER,
  X_PROJECT_ID in NUMBER,
  X_EXPENDITURE_ORGANIZATION_ID in NUMBER,
  X_EXPENDITURE_TYPE in VARCHAR2,
  X_TASK_ID in NUMBER,
  X_AWARD_ID in NUMBER,
  X_TOTAL_AMOUNT in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) is
    X_LAST_UPDATE_DATE DATE;

Line: 180

    X_LAST_UPDATED_BY NUMBER;

Line: 181

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 183

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 185

    X_LAST_UPDATED_BY := 1;

Line: 186

    X_LAST_UPDATE_LOGIN := 0;

Line: 188

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 189

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 192

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 193

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 200

  update PSP_EFFORT_REPORT_DETAILS set
    ASSIGNMENT_ID = X_ASSIGNMENT_ID,
    ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID,
    GL_CODE_COMBINATION_ID = X_GL_CODE_COMBINATION_ID,
    PROJECT_ID = X_PROJECT_ID,
    EXPENDITURE_ORGANIZATION_ID = X_EXPENDITURE_ORGANIZATION_ID,
    EXPENDITURE_TYPE = X_EXPENDITURE_TYPE,
    TASK_ID = X_TASK_ID,
    AWARD_ID = X_AWARD_ID,
    TOTAL_AMOUNT = X_TOTAL_AMOUNT,
    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
  and EFFORT_REPORT_LINE_NUM = X_EFFORT_REPORT_LINE_NUM
  ;

Line: 220

end UPDATE_ROW;

Line: 238

  cursor c1 is select rowid from PSP_EFFORT_REPORT_DETAILS
     where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
     and VERSION_NUM = X_VERSION_NUM
     and EFFORT_REPORT_LINE_NUM = X_EFFORT_REPORT_LINE_NUM
  ;

Line: 249

    INSERT_ROW (
     X_ROWID,
     X_EFFORT_REPORT_ID,
     X_VERSION_NUM,
     X_EFFORT_REPORT_LINE_NUM,
     X_ASSIGNMENT_ID,
     X_ELEMENT_TYPE_ID,
     X_GL_CODE_COMBINATION_ID,
     X_PROJECT_ID,
     X_EXPENDITURE_ORGANIZATION_ID,
     X_EXPENDITURE_TYPE,
     X_TASK_ID,
     X_AWARD_ID,
     X_TOTAL_AMOUNT,
     X_MODE);

Line: 267

  UPDATE_ROW (
   X_EFFORT_REPORT_ID,
   X_VERSION_NUM,
   X_EFFORT_REPORT_LINE_NUM,
   X_ASSIGNMENT_ID,
   X_ELEMENT_TYPE_ID,
   X_GL_CODE_COMBINATION_ID,
   X_PROJECT_ID,
   X_EXPENDITURE_ORGANIZATION_ID,
   X_EXPENDITURE_TYPE,
   X_TASK_ID,
   X_AWARD_ID,
   X_TOTAL_AMOUNT,
   X_MODE);

Line: 283

procedure DELETE_ROW (
  X_EFFORT_REPORT_ID in NUMBER,
  X_VERSION_NUM in NUMBER,
  X_EFFORT_REPORT_LINE_NUM in NUMBER
) is
begin
  delete from PSP_EFFORT_REPORT_DETAILS
  where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
  and VERSION_NUM = X_VERSION_NUM
  and EFFORT_REPORT_LINE_NUM = X_EFFORT_REPORT_LINE_NUM;

Line: 296

end DELETE_ROW;