DBA Data[Home] [Help]

APPS.PSP_PAYROLL_SUB_LINES_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_SUB_LINE_ID in NUMBER,
  X_PAYROLL_LINE_ID in NUMBER,
  X_SUB_LINE_START_DATE in DATE,
  X_SUB_LINE_END_DATE in DATE,
  X_REASON_CODE in VARCHAR2,
  X_PAY_AMOUNT in NUMBER,
  X_DAILY_RATE in NUMBER,
  X_SALARY_USED in NUMBER,
  X_CURRENT_SALARY in NUMBER,
  X_FTE in NUMBER,
  X_ORGANIZATION_ID in NUMBER,
  X_JOB_ID in NUMBER,
  X_POSITION_ID in NUMBER,
  X_GRADE_ID    in NUMBER,
  X_PEOPLE_GRP_ID in NUMBER,
  X_EMPLOYMENT_BEGIN_DATE in DATE,
  X_EMPLOYMENT_END_DATE in DATE,
  X_EMPLOYEE_STATUS_INACTIVE_DAT in DATE,
  X_EMPLOYEE_STATUS_ACTIVE_DATE in DATE,
  X_ASSIGNMENT_BEGIN_DATE in DATE,
  X_ASSIGNMENT_END_DATE in DATE,
  X_ATTRIBUTE_CATEGORY IN VARCHAR2,	-- Introduced DFF columns for bug fix 2908859
  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_MODE in VARCHAR2 default 'R'
  ) is
    cursor C is select ROWID from PSP_PAYROLL_SUB_LINES
      where PAYROLL_SUB_LINE_ID = X_PAYROLL_SUB_LINE_ID;
Line: 41

    X_LAST_UPDATE_DATE DATE;
Line: 42

    X_LAST_UPDATED_BY NUMBER;
Line: 43

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 45

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 47

    X_LAST_UPDATED_BY := 1;
Line: 48

    X_LAST_UPDATE_LOGIN := 0;
Line: 50

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 51

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

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 55

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

  insert into PSP_PAYROLL_SUB_LINES (
    PAYROLL_SUB_LINE_ID,
    PAYROLL_LINE_ID,
    SUB_LINE_START_DATE,
    SUB_LINE_END_DATE,
    REASON_CODE,
    PAY_AMOUNT,
    DAILY_RATE,
    SALARY_USED,
    CURRENT_SALARY,
    FTE,
    ORGANIZATION_ID,
    JOB_ID,
    POSITION_ID,
    GRADE_ID,
    PEOPLE_GROUP_ID,
    EMPLOYMENT_BEGIN_DATE,
    EMPLOYMENT_END_DATE,
    EMPLOYEE_STATUS_INACTIVE_DATE,
    EMPLOYEE_STATUS_ACTIVE_DATE,
    ASSIGNMENT_BEGIN_DATE,
    ASSIGNMENT_END_DATE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ATTRIBUTE_CATEGORY,		-- Introduced DFF columns for bug fix 2908859
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10
  ) values (
    X_PAYROLL_SUB_LINE_ID,
    X_PAYROLL_LINE_ID,
    X_SUB_LINE_START_DATE,
    X_SUB_LINE_END_DATE,
    X_REASON_CODE,
    X_PAY_AMOUNT,
    X_DAILY_RATE,
    X_SALARY_USED,
    X_CURRENT_SALARY,
    X_FTE,
    X_ORGANIZATION_ID,
    X_JOB_ID,
    X_POSITION_ID,
    X_GRADE_ID    ,
    X_PEOPLE_GRP_ID ,
    X_EMPLOYMENT_BEGIN_DATE,
    X_EMPLOYMENT_END_DATE,
    X_EMPLOYEE_STATUS_INACTIVE_DAT,
    X_EMPLOYEE_STATUS_ACTIVE_DATE,
    X_ASSIGNMENT_BEGIN_DATE,
    X_ASSIGNMENT_END_DATE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_ATTRIBUTE_CATEGORY,		-- Introduced DFF columns for bug fix 2908859
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10
  );
Line: 148

end INSERT_ROW;
Line: 184

  cursor c1 is select
      PAYROLL_LINE_ID,
      SUB_LINE_START_DATE,
      SUB_LINE_END_DATE,
      REASON_CODE,
      PAY_AMOUNT,
      DAILY_RATE,
      SALARY_USED,
      CURRENT_SALARY,
      FTE,
      ORGANIZATION_ID,
      JOB_ID,
      POSITION_ID,
      GRADE_ID,
      PEOPLE_GROUP_ID,
      EMPLOYMENT_BEGIN_DATE,
      EMPLOYMENT_END_DATE,
      EMPLOYEE_STATUS_INACTIVE_DATE,
      EMPLOYEE_STATUS_ACTIVE_DATE,
      ASSIGNMENT_BEGIN_DATE,
      ASSIGNMENT_END_DATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10
    from PSP_PAYROLL_SUB_LINES
    where PAYROLL_SUB_LINE_ID = X_PAYROLL_SUB_LINE_ID
    for update of PAYROLL_SUB_LINE_ID nowait;
Line: 322

procedure UPDATE_ROW (
  X_PAYROLL_SUB_LINE_ID in NUMBER,
  X_PAYROLL_LINE_ID in NUMBER,
  X_SUB_LINE_START_DATE in DATE,
  X_SUB_LINE_END_DATE in DATE,
  X_REASON_CODE in VARCHAR2,
  X_PAY_AMOUNT in NUMBER,
  X_DAILY_RATE in NUMBER,
  X_SALARY_USED in NUMBER,
  X_CURRENT_SALARY in NUMBER,
  X_FTE in NUMBER,
  X_ORGANIZATION_ID in NUMBER,
  X_JOB_ID in NUMBER,
  X_POSITION_ID in NUMBER,
  X_GRADE_ID    in NUMBER,
  X_PEOPLE_GRP_ID in NUMBER,
  X_EMPLOYMENT_BEGIN_DATE in DATE,
  X_EMPLOYMENT_END_DATE in DATE,
  X_EMPLOYEE_STATUS_INACTIVE_DAT in DATE,
  X_EMPLOYEE_STATUS_ACTIVE_DATE in DATE,
  X_ASSIGNMENT_BEGIN_DATE in DATE,
  X_ASSIGNMENT_END_DATE in DATE,
  X_ATTRIBUTE_CATEGORY IN VARCHAR2,	-- Introduced DFF columns for bug fix 2908859
  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_MODE in VARCHAR2 default 'R'
  ) is
    X_LAST_UPDATE_DATE DATE;
Line: 358

    X_LAST_UPDATED_BY NUMBER;
Line: 359

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 361

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 363

    X_LAST_UPDATED_BY := 1;
Line: 364

    X_LAST_UPDATE_LOGIN := 0;
Line: 366

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 367

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

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 371

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

  update PSP_PAYROLL_SUB_LINES set
    PAYROLL_LINE_ID = X_PAYROLL_LINE_ID,
    SUB_LINE_START_DATE = X_SUB_LINE_START_DATE,
    SUB_LINE_END_DATE = X_SUB_LINE_END_DATE,
    REASON_CODE = X_REASON_CODE,
    PAY_AMOUNT = X_PAY_AMOUNT,
    DAILY_RATE = X_DAILY_RATE,
    SALARY_USED = X_SALARY_USED,
    CURRENT_SALARY = X_CURRENT_SALARY,
    FTE = X_FTE,
    ORGANIZATION_ID = X_ORGANIZATION_ID,
    JOB_ID = X_JOB_ID,
    POSITION_ID = X_POSITION_ID,
    GRADE_ID    = X_GRADE_ID,
    PEOPLE_GROUP_ID  = X_PEOPLE_GRP_ID,
    EMPLOYMENT_BEGIN_DATE = X_EMPLOYMENT_BEGIN_DATE,
    EMPLOYMENT_END_DATE = X_EMPLOYMENT_END_DATE,
    EMPLOYEE_STATUS_INACTIVE_DATE = X_EMPLOYEE_STATUS_INACTIVE_DAT,
    EMPLOYEE_STATUS_ACTIVE_DATE = X_EMPLOYEE_STATUS_ACTIVE_DATE,
    ASSIGNMENT_BEGIN_DATE = X_ASSIGNMENT_BEGIN_DATE,
    ASSIGNMENT_END_DATE = X_ASSIGNMENT_END_DATE,
    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,			-- Introduced DFF columns for bub fix 2908859
    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
  where PAYROLL_SUB_LINE_ID = X_PAYROLL_SUB_LINE_ID
  ;
Line: 418

end UPDATE_ROW;
Line: 456

  cursor c1 is select rowid from PSP_PAYROLL_SUB_LINES
     where PAYROLL_SUB_LINE_ID = X_PAYROLL_SUB_LINE_ID
  ;
Line: 465

    INSERT_ROW (
     X_ROWID,
     X_PAYROLL_SUB_LINE_ID,
     X_PAYROLL_LINE_ID,
     X_SUB_LINE_START_DATE,
     X_SUB_LINE_END_DATE,
     X_REASON_CODE,
     X_PAY_AMOUNT,
     X_DAILY_RATE,
     X_SALARY_USED,
     X_CURRENT_SALARY,
     X_FTE,
     X_ORGANIZATION_ID,
     X_JOB_ID,
     X_POSITION_ID,
     X_GRADE_ID,
     X_PEOPLE_GRP_ID,
     X_EMPLOYMENT_BEGIN_DATE,
     X_EMPLOYMENT_END_DATE,
     X_EMPLOYEE_STATUS_INACTIVE_DAT,
     X_EMPLOYEE_STATUS_ACTIVE_DATE,
     X_ASSIGNMENT_BEGIN_DATE,
     X_ASSIGNMENT_END_DATE,
     X_ATTRIBUTE_CATEGORY,		-- Introduced DFF columns for bug fix 2908859
     X_ATTRIBUTE1,
     X_ATTRIBUTE2,
     X_ATTRIBUTE3,
     X_ATTRIBUTE4,
     X_ATTRIBUTE5,
     X_ATTRIBUTE6,
     X_ATTRIBUTE7,
     X_ATTRIBUTE8,
     X_ATTRIBUTE9,
     X_ATTRIBUTE10,
     X_MODE);
Line: 503

  UPDATE_ROW (
   X_PAYROLL_SUB_LINE_ID,
   X_PAYROLL_LINE_ID,
   X_SUB_LINE_START_DATE,
   X_SUB_LINE_END_DATE,
   X_REASON_CODE,
   X_PAY_AMOUNT,
   X_DAILY_RATE,
   X_SALARY_USED,
   X_CURRENT_SALARY,
   X_FTE,
   X_ORGANIZATION_ID,
   X_JOB_ID,
   X_POSITION_ID,
   X_GRADE_ID,
   X_PEOPLE_GRP_ID,
   X_EMPLOYMENT_BEGIN_DATE,
   X_EMPLOYMENT_END_DATE,
   X_EMPLOYEE_STATUS_INACTIVE_DAT,
   X_EMPLOYEE_STATUS_ACTIVE_DATE,
   X_ASSIGNMENT_BEGIN_DATE,
   X_ASSIGNMENT_END_DATE,
   X_ATTRIBUTE_CATEGORY,		-- Introduced DFF columns for bug fix 2908859
   X_ATTRIBUTE1,
   X_ATTRIBUTE2,
   X_ATTRIBUTE3,
   X_ATTRIBUTE4,
   X_ATTRIBUTE5,
   X_ATTRIBUTE6,
   X_ATTRIBUTE7,
   X_ATTRIBUTE8,
   X_ATTRIBUTE9,
   X_ATTRIBUTE10,
   X_MODE);
Line: 539

procedure DELETE_ROW (
  X_PAYROLL_SUB_LINE_ID in NUMBER
) is
begin
  delete from PSP_PAYROLL_SUB_LINES
  where PAYROLL_SUB_LINE_ID = X_PAYROLL_SUB_LINE_ID;
Line: 548

end DELETE_ROW;