APPS.PSP_REP_ORG_DLS_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_ORG_DLS_LINE_ID in NUMBER,
  X_ORG_DLS_BATCH_ID in NUMBER,
  X_ORGANIZATION_ID in NUMBER,
  X_ASSIGNMENT_ID in NUMBER,
  X_PERSON_ID in NUMBER,
  X_ELEMENT_TYPE_ID in NUMBER,
  X_SCHEDULE_LINE_ID in NUMBER,
  X_SCHEDULE_BEGIN_DATE in DATE,
  X_SCHEDULE_END_DATE in DATE,
  X_ORIGINAL_SCH_CODE in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) is
    cursor C is select ROWID from PSP_REP_ORG_DLS
      where ORG_DLS_LINE_ID = X_ORG_DLS_LINE_ID;

Line: 19

    X_LAST_UPDATE_DATE DATE;

Line: 20

    X_LAST_UPDATED_BY NUMBER;

Line: 21

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 23

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 25

    X_LAST_UPDATED_BY := 1;

Line: 26

    X_LAST_UPDATE_LOGIN := 0;

Line: 28

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 29

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 32

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 33

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 40

  insert into PSP_REP_ORG_DLS (
    ORG_DLS_BATCH_ID,
    ORG_DLS_LINE_ID,
    ORGANIZATION_ID,
    ASSIGNMENT_ID,
    PERSON_ID,
    ELEMENT_TYPE_ID,
    SCHEDULE_LINE_ID,
    SCHEDULE_BEGIN_DATE,
    SCHEDULE_END_DATE,
    ORIGINAL_SCH_CODE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_ORG_DLS_BATCH_ID,
    X_ORG_DLS_LINE_ID,
    X_ORGANIZATION_ID,
    X_ASSIGNMENT_ID,
    X_PERSON_ID,
    X_ELEMENT_TYPE_ID,
    X_SCHEDULE_LINE_ID,
    X_SCHEDULE_BEGIN_DATE,
    X_SCHEDULE_END_DATE,
    X_ORIGINAL_SCH_CODE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 82

end INSERT_ROW;

Line: 96

  cursor c1 is select
      ORG_DLS_BATCH_ID,
      ORGANIZATION_ID,
      ASSIGNMENT_ID,
      PERSON_ID,
      ELEMENT_TYPE_ID,
      SCHEDULE_LINE_ID,
      SCHEDULE_BEGIN_DATE,
      SCHEDULE_END_DATE,
      ORIGINAL_SCH_CODE
    from PSP_REP_ORG_DLS
    where ORG_DLS_LINE_ID = X_ORG_DLS_LINE_ID
    for update of ORG_DLS_LINE_ID nowait;

Line: 144

procedure UPDATE_ROW (
  X_ORG_DLS_LINE_ID in NUMBER,
  X_ORG_DLS_BATCH_ID in NUMBER,
  X_ORGANIZATION_ID in NUMBER,
  X_ASSIGNMENT_ID in NUMBER,
  X_PERSON_ID in NUMBER,
  X_ELEMENT_TYPE_ID in NUMBER,
  X_SCHEDULE_LINE_ID in NUMBER,
  X_SCHEDULE_BEGIN_DATE in DATE,
  X_SCHEDULE_END_DATE in DATE,
  X_ORIGINAL_SCH_CODE in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) is
    X_LAST_UPDATE_DATE DATE;

Line: 158

    X_LAST_UPDATED_BY NUMBER;

Line: 159

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 161

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 163

    X_LAST_UPDATED_BY := 1;

Line: 164

    X_LAST_UPDATE_LOGIN := 0;

Line: 166

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 167

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 170

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 171

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 178

  update PSP_REP_ORG_DLS set
    ORG_DLS_BATCH_ID = X_ORG_DLS_BATCH_ID,
    ORGANIZATION_ID = X_ORGANIZATION_ID,
    ASSIGNMENT_ID = X_ASSIGNMENT_ID,
    PERSON_ID = X_PERSON_ID,
    ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID,
    SCHEDULE_LINE_ID = X_SCHEDULE_LINE_ID,
    SCHEDULE_BEGIN_DATE = X_SCHEDULE_BEGIN_DATE,
    SCHEDULE_END_DATE = X_SCHEDULE_END_DATE,
    ORIGINAL_SCH_CODE = X_ORIGINAL_SCH_CODE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where ORG_DLS_LINE_ID = X_ORG_DLS_LINE_ID
  ;

Line: 196

end UPDATE_ROW;

Line: 212

  cursor c1 is select rowid from PSP_REP_ORG_DLS
     where ORG_DLS_LINE_ID = X_ORG_DLS_LINE_ID
  ;

Line: 221

    INSERT_ROW (
     X_ROWID,
     X_ORG_DLS_LINE_ID,
     X_ORG_DLS_BATCH_ID,
     X_ORGANIZATION_ID,
     X_ASSIGNMENT_ID,
     X_PERSON_ID,
     X_ELEMENT_TYPE_ID,
     X_SCHEDULE_LINE_ID,
     X_SCHEDULE_BEGIN_DATE,
     X_SCHEDULE_END_DATE,
     X_ORIGINAL_SCH_CODE,
     X_MODE);

Line: 237

  UPDATE_ROW (
   X_ORG_DLS_LINE_ID,
   X_ORG_DLS_BATCH_ID,
   X_ORGANIZATION_ID,
   X_ASSIGNMENT_ID,
   X_PERSON_ID,
   X_ELEMENT_TYPE_ID,
   X_SCHEDULE_LINE_ID,
   X_SCHEDULE_BEGIN_DATE,
   X_SCHEDULE_END_DATE,
   X_ORIGINAL_SCH_CODE,
   X_MODE);

Line: 251

procedure DELETE_ROW (
  X_ORG_DLS_LINE_ID in NUMBER
) is
begin
  delete from PSP_REP_ORG_DLS
  where ORG_DLS_LINE_ID = X_ORG_DLS_LINE_ID;

Line: 260

end DELETE_ROW;