DBA Data[Home] [Help]

APPS.PSP_PAYROLL_CONTROLS_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_PAYROLL_CONTROL_ID in NUMBER,
  X_SUBLINES_DR_AMOUNT in NUMBER,
  X_SUBLINES_CR_AMOUNT in NUMBER,
  X_DIST_DR_AMOUNT in NUMBER,
  X_DIST_CR_AMOUNT in NUMBER,
  X_OGM_DR_AMOUNT in NUMBER,
  X_OGM_CR_AMOUNT in NUMBER,
  X_GL_DR_AMOUNT in NUMBER,
  X_GL_CR_AMOUNT in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_TOTAL_DR_AMOUNT in NUMBER,
  X_TOTAL_CR_AMOUNT in NUMBER,
  X_NUMBER_OF_CR in NUMBER,
  X_NUMBER_OF_DR in NUMBER,
  X_PAYROLL_SOURCE_CODE in VARCHAR2,
  X_SOURCE_TYPE in VARCHAR2,
  X_PAYROLL_ID in NUMBER,
  X_TIME_PERIOD_ID in NUMBER,
  X_BATCH_NAME in VARCHAR2,
  X_PAYROLL_ACTION_ID in NUMBER,
  X_MODE in VARCHAR2 default 'R',
  X_GL_POSTING_OVERRIDE_DATE in DATE,
  X_GMS_POSTING_OVERRIDE_DATE in DATE,
  X_SET_OF_BOOKS_ID in NUMBER,
  X_BUSINESS_GROUP_ID in NUMBER,
  X_GL_PHASE in VARCHAR2,
  X_GMS_PHASE in VARCHAR2,
  X_ADJ_SUM_BATCH_NAME in VARCHAR2,
  X_CURRENCY_CODE   in VARCHAR2,
  X_EXCHANGE_RATE_TYPE in VARCHAR2,
  X_PARENT_PAYROLL_CONTROL_ID in NUMBER default null
  ) is
    cursor C is select ROWID from PSP_PAYROLL_CONTROLS
      where PAYROLL_CONTROL_ID = X_PAYROLL_CONTROL_ID;
Line: 39

    X_LAST_UPDATE_DATE DATE;
Line: 40

    X_LAST_UPDATED_BY NUMBER;
Line: 41

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 43

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 45

    X_LAST_UPDATED_BY := 1;
Line: 46

    X_LAST_UPDATE_LOGIN := 0;
Line: 48

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 49

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

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 53

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

  insert into PSP_PAYROLL_CONTROLS (
    SUBLINES_DR_AMOUNT,
    SUBLINES_CR_AMOUNT,
    DIST_DR_AMOUNT,
    DIST_CR_AMOUNT,
    OGM_DR_AMOUNT,
    OGM_CR_AMOUNT,
    GL_DR_AMOUNT,
    GL_CR_AMOUNT,
    STATUS_CODE,
    TOTAL_DR_AMOUNT,
    TOTAL_CR_AMOUNT,
    NUMBER_OF_CR,
    NUMBER_OF_DR,
    PAYROLL_SOURCE_CODE,
    SOURCE_TYPE,
    PAYROLL_ID,
    TIME_PERIOD_ID,
    BATCH_NAME,
    PAYROLL_CONTROL_ID,
    PAYROLL_ACTION_ID,
    GL_POSTING_OVERRIDE_DATE,
    GMS_POSTING_OVERRIDE_DATE,
    SET_OF_BOOKS_ID,
    BUSINESS_GROUP_ID,
    GL_PHASE,
    GMS_PHASE,
    ADJ_SUM_BATCH_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CURRENCY_CODE,
    EXCHANGE_RATE_TYPE,
    PARENT_PAYROLL_CONTROL_ID
  ) values (
    X_SUBLINES_DR_AMOUNT,
    X_SUBLINES_CR_AMOUNT,
    X_DIST_DR_AMOUNT,
    X_DIST_CR_AMOUNT,
    X_OGM_DR_AMOUNT,
    X_OGM_CR_AMOUNT,
    X_GL_DR_AMOUNT,
    X_GL_CR_AMOUNT,
    X_STATUS_CODE,
    X_TOTAL_DR_AMOUNT,
    X_TOTAL_CR_AMOUNT,
    X_NUMBER_OF_CR,
    X_NUMBER_OF_DR,
    X_PAYROLL_SOURCE_CODE,
    X_SOURCE_TYPE,
    X_PAYROLL_ID,
    X_TIME_PERIOD_ID,
    X_BATCH_NAME,
    X_PAYROLL_CONTROL_ID,
    X_PAYROLL_ACTION_ID,
    X_GL_POSTING_OVERRIDE_DATE,
    X_GMS_POSTING_OVERRIDE_DATE,
    X_SET_OF_BOOKS_ID,
    X_BUSINESS_GROUP_ID,
    X_GL_PHASE,
    X_GMS_PHASE,
    X_ADJ_SUM_BATCH_NAME,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CURRENCY_CODE,
    X_EXCHANGE_RATE_TYPE,
    X_PARENT_PAYROLL_CONTROL_ID
  );
Line: 142

end INSERT_ROW;
Line: 175

  cursor c1 is select
      SUBLINES_DR_AMOUNT,
      SUBLINES_CR_AMOUNT,
      DIST_DR_AMOUNT,
      DIST_CR_AMOUNT,
      OGM_DR_AMOUNT,
      OGM_CR_AMOUNT,
      GL_DR_AMOUNT,
      GL_CR_AMOUNT,
      STATUS_CODE,
      TOTAL_DR_AMOUNT,
      TOTAL_CR_AMOUNT,
      NUMBER_OF_CR,
      NUMBER_OF_DR,
      PAYROLL_SOURCE_CODE,
      SOURCE_TYPE,
      PAYROLL_ID,
      TIME_PERIOD_ID,
      BATCH_NAME,
      PAYROLL_ACTION_ID,
      GL_POSTING_OVERRIDE_DATE,
      GMS_POSTING_OVERRIDE_DATE,
      SET_OF_BOOKS_ID,
      BUSINESS_GROUP_ID,
      GL_PHASE,
      GMS_PHASE,
      ADJ_SUM_BATCH_NAME,
      CURRENCY_CODE,
      EXCHANGE_RATE_TYPE
    from PSP_PAYROLL_CONTROLS
    where PAYROLL_CONTROL_ID = X_PAYROLL_CONTROL_ID
    for update of PAYROLL_CONTROL_ID nowait;
Line: 279

procedure UPDATE_ROW (
  X_PAYROLL_CONTROL_ID in NUMBER,
  X_SUBLINES_DR_AMOUNT in NUMBER,
  X_SUBLINES_CR_AMOUNT in NUMBER,
  X_DIST_DR_AMOUNT in NUMBER,
  X_DIST_CR_AMOUNT in NUMBER,
  X_OGM_DR_AMOUNT in NUMBER,
  X_OGM_CR_AMOUNT in NUMBER,
  X_GL_DR_AMOUNT in NUMBER,
  X_GL_CR_AMOUNT in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_TOTAL_DR_AMOUNT in NUMBER,
  X_TOTAL_CR_AMOUNT in NUMBER,
  X_NUMBER_OF_CR in NUMBER,
  X_NUMBER_OF_DR in NUMBER,
  X_PAYROLL_SOURCE_CODE in VARCHAR2,
  X_SOURCE_TYPE in VARCHAR2,
  X_PAYROLL_ID in NUMBER,
  X_TIME_PERIOD_ID in NUMBER,
  X_BATCH_NAME in VARCHAR2,
  X_PAYROLL_ACTION_ID in NUMBER,
  X_MODE in VARCHAR2 default 'R',
  X_GL_POSTING_OVERRIDE_DATE in DATE,
  X_GMS_POSTING_OVERRIDE_DATE in DATE,
  X_SET_OF_BOOKS_ID in NUMBER,
  X_BUSINESS_GROUP_ID in NUMBER,
  X_GL_PHASE in VARCHAR2,
  X_GMS_PHASE in VARCHAR2,
  X_ADJ_SUM_BATCH_NAME in VARCHAR2,
  X_CURRENCY_CODE   in VARCHAR2,
  X_EXCHANGE_RATE_TYPE in VARCHAR2
  ) is
    X_LAST_UPDATE_DATE DATE;
Line: 312

    X_LAST_UPDATED_BY NUMBER;
Line: 313

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 315

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 317

    X_LAST_UPDATED_BY := 1;
Line: 318

    X_LAST_UPDATE_LOGIN := 0;
Line: 320

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 321

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

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 325

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

  update PSP_PAYROLL_CONTROLS set
    SUBLINES_DR_AMOUNT = X_SUBLINES_DR_AMOUNT,
    SUBLINES_CR_AMOUNT = X_SUBLINES_CR_AMOUNT,
    DIST_DR_AMOUNT = X_DIST_DR_AMOUNT,
    DIST_CR_AMOUNT = X_DIST_CR_AMOUNT,
    OGM_DR_AMOUNT = X_OGM_DR_AMOUNT,
    OGM_CR_AMOUNT = X_OGM_CR_AMOUNT,
    GL_DR_AMOUNT = X_GL_DR_AMOUNT,
    GL_CR_AMOUNT = X_GL_CR_AMOUNT,
    STATUS_CODE = X_STATUS_CODE,
    TOTAL_DR_AMOUNT = X_TOTAL_DR_AMOUNT,
    TOTAL_CR_AMOUNT = X_TOTAL_CR_AMOUNT,
    NUMBER_OF_CR = X_NUMBER_OF_CR,
    NUMBER_OF_DR = X_NUMBER_OF_DR,
    PAYROLL_SOURCE_CODE = X_PAYROLL_SOURCE_CODE,
    SOURCE_TYPE = X_SOURCE_TYPE,
    PAYROLL_ID = X_PAYROLL_ID,
    TIME_PERIOD_ID = X_TIME_PERIOD_ID,
    BATCH_NAME = X_BATCH_NAME,
    PAYROLL_ACTION_ID = X_PAYROLL_ACTION_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    GL_POSTING_OVERRIDE_DATE = X_GL_POSTING_OVERRIDE_DATE,
    GMS_POSTING_OVERRIDE_DATE = X_GMS_POSTING_OVERRIDE_DATE,
    SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID,
    BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
    GL_PHASE  = X_GL_PHASE,
    GMS_PHASE  = X_GMS_PHASE,
    ADJ_SUM_BATCH_NAME  = X_ADJ_SUM_BATCH_NAME,
    CURRENCY_CODE = X_CURRENCY_CODE,
    EXCHANGE_RATE_TYPE = X_EXCHANGE_RATE_TYPE
  where PAYROLL_CONTROL_ID = X_PAYROLL_CONTROL_ID
  ;
Line: 369

end UPDATE_ROW;
Line: 404

  cursor c1 is select rowid from PSP_PAYROLL_CONTROLS
     where PAYROLL_CONTROL_ID = X_PAYROLL_CONTROL_ID
  ;
Line: 413

    INSERT_ROW (
     X_ROWID,
     X_PAYROLL_CONTROL_ID,
     X_SUBLINES_DR_AMOUNT,
     X_SUBLINES_CR_AMOUNT,
     X_DIST_DR_AMOUNT,
     X_DIST_CR_AMOUNT,
     X_OGM_DR_AMOUNT,
     X_OGM_CR_AMOUNT,
     X_GL_DR_AMOUNT,
     X_GL_CR_AMOUNT,
     X_STATUS_CODE,
     X_TOTAL_DR_AMOUNT,
     X_TOTAL_CR_AMOUNT,
     X_NUMBER_OF_CR,
     X_NUMBER_OF_DR,
     X_PAYROLL_SOURCE_CODE,
     X_SOURCE_TYPE,
     X_PAYROLL_ID,
     X_TIME_PERIOD_ID,
     X_BATCH_NAME,
     X_PAYROLL_ACTION_ID,
     X_MODE,
     X_GL_POSTING_OVERRIDE_DATE,
     X_GMS_POSTING_OVERRIDE_DATE,
     X_SET_OF_BOOKS_ID,
     X_BUSINESS_GROUP_ID,
     X_GL_PHASE,
     X_GMS_PHASE,
     X_ADJ_SUM_BATCH_NAME,
     X_CURRENCY_CODE,
     X_EXCHANGE_RATE_TYPE, null);
Line: 448

  UPDATE_ROW (
   X_PAYROLL_CONTROL_ID,
   X_SUBLINES_DR_AMOUNT,
   X_SUBLINES_CR_AMOUNT,
   X_DIST_DR_AMOUNT,
   X_DIST_CR_AMOUNT,
   X_OGM_DR_AMOUNT,
   X_OGM_CR_AMOUNT,
   X_GL_DR_AMOUNT,
   X_GL_CR_AMOUNT,
   X_STATUS_CODE,
   X_TOTAL_DR_AMOUNT,
   X_TOTAL_CR_AMOUNT,
   X_NUMBER_OF_CR,
   X_NUMBER_OF_DR,
   X_PAYROLL_SOURCE_CODE,
   X_SOURCE_TYPE,
   X_PAYROLL_ID,
   X_TIME_PERIOD_ID,
   X_BATCH_NAME,
   X_PAYROLL_ACTION_ID,
   X_MODE,
   X_GL_POSTING_OVERRIDE_DATE,
   X_GMS_POSTING_OVERRIDE_DATE,
   X_SET_OF_BOOKS_ID,
   X_BUSINESS_GROUP_ID,
   X_GL_PHASE,
   X_GMS_PHASE,
   X_ADJ_SUM_BATCH_NAME,
   X_CURRENCY_CODE,
   X_EXCHANGE_RATE_TYPE);
Line: 481

procedure DELETE_ROW (
  X_PAYROLL_CONTROL_ID in NUMBER
) is
begin
  delete from PSP_PAYROLL_CONTROLS
  where PAYROLL_CONTROL_ID = X_PAYROLL_CONTROL_ID;
Line: 490

end DELETE_ROW;