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_PAYROLL_INTERFACE_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_PAYROLL_INTERFACE_ID in NUMBER,
  X_BATCH_NAME in VARCHAR2,
  X_PAYROLL_ID in NUMBER,
  X_PAYROLL_PERIOD_ID in NUMBER,
  X_PERSON_ID in NUMBER,
  X_ASSIGNMENT_ID in NUMBER,
  X_ELEMENT_TYPE_ID in NUMBER,
  X_PAY_AMOUNT in NUMBER,
  X_EARNED_DATE in DATE,
  X_CHECK_DATE in DATE,
  X_EFFECTIVE_DATE in DATE,
  X_PAYROLL_SOURCE_CODE in VARCHAR2,
  X_FTE in NUMBER,
  X_REASON_CODE in VARCHAR2,
  X_SUB_LINE_START_DATE in DATE,
  X_SUB_LINE_END_DATE in DATE,
  X_DAILY_RATE in NUMBER,
  X_SALARY_USED in NUMBER,
  X_DR_CR_FLAG in VARCHAR2,
  X_STATUS_CODE in VARCHAR2,
  X_ERROR_CODE in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_GL_POSTING_OVERRIDE_DATE in DATE,
  X_GMS_POSTING_OVERRIDE_DATE in DATE,
  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_BUSINESS_GROUP_ID in NUMBER,
  X_SET_OF_BOOKS_ID   in NUMBER,
  X_CURRENCY_CODE     in VARCHAR2
  ) is
    cursor C is select ROWID from PSP_PAYROLL_INTERFACE
      where PAYROLL_INTERFACE_ID = X_PAYROLL_INTERFACE_ID
      and BATCH_NAME = X_BATCH_NAME;

Line: 54


    X_LAST_UPDATE_DATE DATE;

Line: 55


    X_LAST_UPDATED_BY NUMBER;

Line: 56


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 58


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 60


    X_LAST_UPDATED_BY := 1;

Line: 61


    X_LAST_UPDATE_LOGIN := 0;

Line: 63


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 64


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 67


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 68


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 75


  insert into PSP_PAYROLL_INTERFACE (
    PAYROLL_INTERFACE_ID,
    PAYROLL_ID,
    PAYROLL_PERIOD_ID,
    PERSON_ID,
    ASSIGNMENT_ID,
    ELEMENT_TYPE_ID,
    PAY_AMOUNT,
    EARNED_DATE,
    CHECK_DATE,
    EFFECTIVE_DATE,
    GL_POSTING_OVERRIDE_DATE,
    GMS_POSTING_OVERRIDE_DATE,
    PAYROLL_SOURCE_CODE,
    FTE,
    REASON_CODE,
    SUB_LINE_START_DATE,
    SUB_LINE_END_DATE,
    DAILY_RATE,
    SALARY_USED,
    DR_CR_FLAG,
    STATUS_CODE,
    BATCH_NAME,
    ERROR_CODE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    BUSINESS_GROUP_ID ,
    SET_OF_BOOKS_ID,
    CURRENCY_CODE
  ) values (
    X_PAYROLL_INTERFACE_ID,
    X_PAYROLL_ID,
    X_PAYROLL_PERIOD_ID,
    X_PERSON_ID,
    X_ASSIGNMENT_ID,
    X_ELEMENT_TYPE_ID,
    X_PAY_AMOUNT,
    X_EARNED_DATE,
    X_CHECK_DATE,
    X_EFFECTIVE_DATE,
    X_GL_POSTING_OVERRIDE_DATE,
    X_GMS_POSTING_OVERRIDE_DATE,
    X_PAYROLL_SOURCE_CODE,
    X_FTE,
    X_REASON_CODE,
    X_SUB_LINE_START_DATE,
    X_SUB_LINE_END_DATE,
    X_DAILY_RATE,
    X_SALARY_USED,
    X_DR_CR_FLAG,
    X_STATUS_CODE,
    X_BATCH_NAME,
    X_ERROR_CODE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    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_BUSINESS_GROUP_ID ,
    X_SET_OF_BOOKS_ID,
    X_CURRENCY_CODE
  );

Line: 181


end INSERT_ROW;

Line: 226


  cursor c1 is select
      PAYROLL_ID,
      PAYROLL_PERIOD_ID,
      PERSON_ID,
      ASSIGNMENT_ID,
      ELEMENT_TYPE_ID,
      PAY_AMOUNT,
      EARNED_DATE,
      CHECK_DATE,
      EFFECTIVE_DATE,
      GL_POSTING_OVERRIDE_DATE,
      GMS_POSTING_OVERRIDE_DATE,
      PAYROLL_SOURCE_CODE,
      FTE,
      REASON_CODE,
      SUB_LINE_START_DATE,
      SUB_LINE_END_DATE,
      DAILY_RATE,
      SALARY_USED,
      DR_CR_FLAG,
      STATUS_CODE,
      ERROR_CODE,
      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_PAYROLL_INTERFACE
    where PAYROLL_INTERFACE_ID = X_PAYROLL_INTERFACE_ID
    and BATCH_NAME = X_BATCH_NAME
    and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
    and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
    for update of PAYROLL_INTERFACE_ID nowait;

Line: 372


procedure UPDATE_ROW (
  X_PAYROLL_INTERFACE_ID in NUMBER,
  X_BATCH_NAME in VARCHAR2,
  X_PAYROLL_ID in NUMBER,
  X_PAYROLL_PERIOD_ID in NUMBER,
  X_PERSON_ID in NUMBER,
  X_ASSIGNMENT_ID in NUMBER,
  X_ELEMENT_TYPE_ID in NUMBER,
  X_PAY_AMOUNT in NUMBER,
  X_EARNED_DATE in DATE,
  X_CHECK_DATE in DATE,
  X_EFFECTIVE_DATE in DATE,
  X_PAYROLL_SOURCE_CODE in VARCHAR2,
  X_FTE in NUMBER,
  X_REASON_CODE in VARCHAR2,
  X_SUB_LINE_START_DATE in DATE,
  X_SUB_LINE_END_DATE in DATE,
  X_DAILY_RATE in NUMBER,
  X_SALARY_USED in NUMBER,
  X_DR_CR_FLAG in VARCHAR2,
  X_STATUS_CODE in VARCHAR2,
  X_ERROR_CODE in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_GL_POSTING_OVERRIDE_DATE in DATE,
  X_GMS_POSTING_OVERRIDE_DATE in DATE,
  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_BUSINESS_GROUP_ID in NUMBER,
  X_SET_OF_BOOKS_ID   in NUMBER,
  X_CURRENCY_CODE     in VARCHAR2
  ) is
    X_LAST_UPDATE_DATE DATE;

Line: 418


    X_LAST_UPDATED_BY NUMBER;

Line: 419


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 421


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 423


    X_LAST_UPDATED_BY := 1;

Line: 424


    X_LAST_UPDATE_LOGIN := 0;

Line: 426


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 427


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 430


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 431


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 438


  update PSP_PAYROLL_INTERFACE set
    PAYROLL_ID = X_PAYROLL_ID,
    PAYROLL_PERIOD_ID = X_PAYROLL_PERIOD_ID,
    PERSON_ID = X_PERSON_ID,
    ASSIGNMENT_ID = X_ASSIGNMENT_ID,
    ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID,
    PAY_AMOUNT = X_PAY_AMOUNT,
    EARNED_DATE = X_EARNED_DATE,
    CHECK_DATE = X_CHECK_DATE,
    EFFECTIVE_DATE = X_EFFECTIVE_DATE,
    GL_POSTING_OVERRIDE_DATE = X_GL_POSTING_OVERRIDE_DATE,
    GMS_POSTING_OVERRIDE_DATE = X_GMS_POSTING_OVERRIDE_DATE,
    PAYROLL_SOURCE_CODE = X_PAYROLL_SOURCE_CODE,
    FTE = X_FTE,
    REASON_CODE = X_REASON_CODE,
    SUB_LINE_START_DATE = X_SUB_LINE_START_DATE,
    SUB_LINE_END_DATE = X_SUB_LINE_END_DATE,
    DAILY_RATE = X_DAILY_RATE,
    SALARY_USED = X_SALARY_USED,
    DR_CR_FLAG = X_DR_CR_FLAG,
    STATUS_CODE = X_STATUS_CODE,
    ERROR_CODE = X_ERROR_CODE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    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,
    BUSINESS_GROUP_ID =  X_BUSINESS_GROUP_ID ,
    SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID   ,
    CURRENCY_CODE  = X_CURRENCY_CODE
  where PAYROLL_INTERFACE_ID = X_PAYROLL_INTERFACE_ID
  and BATCH_NAME = X_BATCH_NAME
  and BUSINESS_GROUP_ID =  X_BUSINESS_GROUP_ID
  and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
  ;

Line: 490


end UPDATE_ROW;

Line: 538


  cursor c1 is select rowid from PSP_PAYROLL_INTERFACE
     where PAYROLL_INTERFACE_ID = X_PAYROLL_INTERFACE_ID
     and BATCH_NAME = X_BATCH_NAME
  ;

Line: 548


    INSERT_ROW (
     X_ROWID,
     X_PAYROLL_INTERFACE_ID,
     X_BATCH_NAME,
     X_PAYROLL_ID,
     X_PAYROLL_PERIOD_ID,
     X_PERSON_ID,
     X_ASSIGNMENT_ID,
     X_ELEMENT_TYPE_ID,
     X_PAY_AMOUNT,
     X_EARNED_DATE,
     X_CHECK_DATE,
     X_EFFECTIVE_DATE,
     X_PAYROLL_SOURCE_CODE,
     X_FTE,
     X_REASON_CODE,
     X_SUB_LINE_START_DATE,
     X_SUB_LINE_END_DATE,
     X_DAILY_RATE,
     X_SALARY_USED,
     X_DR_CR_FLAG,
     X_STATUS_CODE,
     X_ERROR_CODE,
     X_MODE,
     X_GL_POSTING_OVERRIDE_DATE,
     X_GMS_POSTING_OVERRIDE_DATE,
     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_BUSINESS_GROUP_ID ,
     X_SET_OF_BOOKS_ID  ,
     X_CURRENCY_CODE
     );

Line: 597


  UPDATE_ROW (
   X_PAYROLL_INTERFACE_ID,
   X_BATCH_NAME,
   X_PAYROLL_ID,
   X_PAYROLL_PERIOD_ID,
   X_PERSON_ID,
   X_ASSIGNMENT_ID,
   X_ELEMENT_TYPE_ID,
   X_PAY_AMOUNT,
   X_EARNED_DATE,
   X_CHECK_DATE,
   X_EFFECTIVE_DATE,
   X_PAYROLL_SOURCE_CODE,
   X_FTE,
   X_REASON_CODE,
   X_SUB_LINE_START_DATE,
   X_SUB_LINE_END_DATE,
   X_DAILY_RATE,
   X_SALARY_USED,
   X_DR_CR_FLAG,
   X_STATUS_CODE,
   X_ERROR_CODE,
   X_MODE,
   X_GL_POSTING_OVERRIDE_DATE,
   X_GMS_POSTING_OVERRIDE_DATE,
   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_BUSINESS_GROUP_ID ,
   X_SET_OF_BOOKS_ID   ,
   X_CURRENCY_CODE
   );

Line: 644


procedure DELETE_ROW (
  X_PAYROLL_INTERFACE_ID in NUMBER,
  X_BATCH_NAME in VARCHAR2,
  X_BUSINESS_GROUP_ID in NUMBER,
  X_SET_OF_BOOKS_ID   in NUMBER
) is
begin
  delete from PSP_PAYROLL_INTERFACE
  where PAYROLL_INTERFACE_ID = X_PAYROLL_INTERFACE_ID
  and BATCH_NAME = X_BATCH_NAME;

Line: 657


end DELETE_ROW;