eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_DEFAULT_SCHEDULES_PKG SQL Statements

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

Line: 5


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ORG_SCHEDULE_ID in NUMBER,
  X_ORGANIZATION_ID in NUMBER,
  X_SCHEDULE_BEGIN_DATE in DATE,
  X_SCHEDULE_END_DATE in DATE,
  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_SCHEDULE_PERCENT in NUMBER,
  X_COMMENTS in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_BUSINESS_GROUP_ID in NUMBER,
  X_SET_OF_BOOKS_ID in NUMBER,
  X_POETA_START_DATE in DATE DEFAULT NULL,
  X_POETA_END_DATE   in DATE DEFAULT NULL
  ) is
    cursor C is select ROWID from PSP_DEFAULT_LABOR_SCHEDULES
      where ORG_SCHEDULE_ID = X_ORG_SCHEDULE_ID
      and business_group_id = X_BUSINESS_GROUP_ID
      and set_of_books_id = X_SET_OF_BOOKS_ID;

Line: 45


    X_LAST_UPDATE_DATE DATE;

Line: 46


    X_LAST_UPDATED_BY NUMBER;

Line: 47


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 49


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 51


    X_LAST_UPDATED_BY := 1;

Line: 52


    X_LAST_UPDATE_LOGIN := 0;

Line: 54


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 55


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 58


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 59


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 66


  insert into PSP_DEFAULT_LABOR_SCHEDULES (
    ORG_SCHEDULE_ID,
    ORGANIZATION_ID,
    SCHEDULE_BEGIN_DATE,
    SCHEDULE_END_DATE,
    GL_CODE_COMBINATION_ID,
    PROJECT_ID,
    EXPENDITURE_ORGANIZATION_ID,
    EXPENDITURE_TYPE,
    TASK_ID,
    AWARD_ID,
    SCHEDULE_PERCENT,
    COMMENTS,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    BUSINESS_GROUP_ID,
    SET_OF_BOOKS_ID
  ) values (
    X_ORG_SCHEDULE_ID,
    X_ORGANIZATION_ID,
    X_SCHEDULE_BEGIN_DATE,
    X_SCHEDULE_END_DATE,
    X_GL_CODE_COMBINATION_ID,
    X_PROJECT_ID,
    X_EXPENDITURE_ORGANIZATION_ID,
    X_EXPENDITURE_TYPE,
    X_TASK_ID,
    X_AWARD_ID,
    X_SCHEDULE_PERCENT,
    X_COMMENTS,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_BUSINESS_GROUP_ID,
    X_SET_OF_BOOKS_ID
  );

Line: 148


end INSERT_ROW;

Line: 185


  cursor c1 is select
      ORGANIZATION_ID,
      SCHEDULE_BEGIN_DATE,
      SCHEDULE_END_DATE,
      GL_CODE_COMBINATION_ID,
      PROJECT_ID,
      EXPENDITURE_ORGANIZATION_ID,
      EXPENDITURE_TYPE,
      TASK_ID,
      AWARD_ID,
      SCHEDULE_PERCENT,
      COMMENTS,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      BUSINESS_GROUP_ID,
      SET_OF_BOOKS_ID
    from PSP_DEFAULT_LABOR_SCHEDULES
    where ORG_SCHEDULE_ID = X_ORG_SCHEDULE_ID
    and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
    and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
    for update of ORG_SCHEDULE_ID nowait;

Line: 318


procedure UPDATE_ROW (
  X_ORG_SCHEDULE_ID in NUMBER,
  X_ORGANIZATION_ID in NUMBER,
  X_SCHEDULE_BEGIN_DATE in DATE,
  X_SCHEDULE_END_DATE in DATE,
  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_SCHEDULE_PERCENT in NUMBER,
  X_COMMENTS in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_BUSINESS_GROUP_ID in NUMBER,
  X_SET_OF_BOOKS_ID in NUMBER,
  X_POETA_START_DATE in DATE DEFAULT NULL,
  X_POETA_END_DATE   in DATE DEFAULT NULL
  ) is
    X_LAST_UPDATE_DATE DATE;

Line: 354


    X_LAST_UPDATED_BY NUMBER;

Line: 355


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 357


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 359


    X_LAST_UPDATED_BY := 1;

Line: 360


    X_LAST_UPDATE_LOGIN := 0;

Line: 362


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 363


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 366


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 367


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 374


  update PSP_DEFAULT_LABOR_SCHEDULES set
    ORGANIZATION_ID = X_ORGANIZATION_ID,
    SCHEDULE_BEGIN_DATE = X_SCHEDULE_BEGIN_DATE,
    SCHEDULE_END_DATE = X_SCHEDULE_END_DATE,
    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,
    SCHEDULE_PERCENT = X_SCHEDULE_PERCENT,
    COMMENTS = X_COMMENTS,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
    SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
  where ORG_SCHEDULE_ID = X_ORG_SCHEDULE_ID
  and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
  and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
  ;

Line: 414


end UPDATE_ROW;

Line: 453


  cursor c1 is select rowid from PSP_DEFAULT_LABOR_SCHEDULES
     where ORG_SCHEDULE_ID = X_ORG_SCHEDULE_ID
     and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
     and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
  ;

Line: 465


    INSERT_ROW (
     X_ROWID,
     X_ORG_SCHEDULE_ID,
     X_ORGANIZATION_ID,
     X_SCHEDULE_BEGIN_DATE,
     X_SCHEDULE_END_DATE,
     X_GL_CODE_COMBINATION_ID,
     X_PROJECT_ID,
     X_EXPENDITURE_ORGANIZATION_ID,
     X_EXPENDITURE_TYPE,
     X_TASK_ID,
     X_AWARD_ID,
     X_SCHEDULE_PERCENT,
     X_COMMENTS,
     X_ATTRIBUTE_CATEGORY,
     X_ATTRIBUTE1,
     X_ATTRIBUTE2,
     X_ATTRIBUTE3,
     X_ATTRIBUTE4,
     X_ATTRIBUTE5,
     X_ATTRIBUTE6,
     X_ATTRIBUTE7,
     X_ATTRIBUTE8,
     X_ATTRIBUTE9,
     X_ATTRIBUTE10,
     X_ATTRIBUTE11,
     X_ATTRIBUTE12,
     X_ATTRIBUTE13,
     X_ATTRIBUTE14,
     X_ATTRIBUTE15,
     X_MODE,
     X_BUSINESS_GROUP_ID,
     X_SET_OF_BOOKS_ID,
     X_POETA_START_DATE,
     X_POETA_END_DATE);

Line: 505


  UPDATE_ROW (
   X_ORG_SCHEDULE_ID,
   X_ORGANIZATION_ID,
   X_SCHEDULE_BEGIN_DATE,
   X_SCHEDULE_END_DATE,
   X_GL_CODE_COMBINATION_ID,
   X_PROJECT_ID,
   X_EXPENDITURE_ORGANIZATION_ID,
   X_EXPENDITURE_TYPE,
   X_TASK_ID,
   X_AWARD_ID,
   X_SCHEDULE_PERCENT,
   X_COMMENTS,
   X_ATTRIBUTE_CATEGORY,
   X_ATTRIBUTE1,
   X_ATTRIBUTE2,
   X_ATTRIBUTE3,
   X_ATTRIBUTE4,
   X_ATTRIBUTE5,
   X_ATTRIBUTE6,
   X_ATTRIBUTE7,
   X_ATTRIBUTE8,
   X_ATTRIBUTE9,
   X_ATTRIBUTE10,
   X_ATTRIBUTE11,
   X_ATTRIBUTE12,
   X_ATTRIBUTE13,
   X_ATTRIBUTE14,
   X_ATTRIBUTE15,
   X_MODE,
   X_BUSINESS_GROUP_ID,
   X_SET_OF_BOOKS_ID,
   X_POETA_START_DATE,
   X_POETA_END_DATE);

Line: 541


procedure DELETE_ROW (
  X_ORG_SCHEDULE_ID in NUMBER,
  X_BUSINESS_GROUP_ID in NUMBER,
  X_SET_OF_BOOKS_ID in NUMBER
) is
begin
  delete from PSP_DEFAULT_LABOR_SCHEDULES
  where ORG_SCHEDULE_ID = X_ORG_SCHEDULE_ID
  and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
  and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID;

Line: 554


end DELETE_ROW;