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.CS_SR_LOAD_BALANCE_WT_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_WEIGHT_ID in NUMBER,
  X_INCIDENT_TYPE_ID in NUMBER,
  X_INCIDENT_SEVERITY_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_PRODUCT_SKILL_WT in NUMBER,
  X_PLATFORM_SKILL_WT in NUMBER,
  X_PROB_CODE_SKILL_WT in NUMBER,
  X_LAST_LOGIN_TIME_WT in NUMBER,
  X_SEVERITY1_COUNT_WT in NUMBER,
  X_SEVERITY2_COUNT_WT in NUMBER,
  X_SEVERITY3_COUNT_WT in NUMBER,
  X_SEVERITY4_COUNT_WT in NUMBER,
  X_TIME_ZONE_DIFF_WT in NUMBER,
  X_CATEGORY_SKILL_WT in NUMBER,
  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_CONTEXT in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER)
is
    cursor C is select ROWID from CS_SR_LOAD_BALANCE_WT
    where WEIGHT_ID = X_WEIGHT_ID
    ;

Line: 47


  insert into CS_SR_LOAD_BALANCE_WT (
  WEIGHT_ID ,
  INCIDENT_TYPE_ID ,
  INCIDENT_SEVERITY_ID ,
  START_DATE_ACTIVE ,
  END_DATE_ACTIVE ,
  PRODUCT_SKILL_WT ,
  PLATFORM_SKILL_WT ,
  PROB_CODE_SKILL_WT ,
  LAST_LOGIN_TIME_WT ,
  SEVERITY1_COUNT_WT ,
  SEVERITY2_COUNT_WT ,
  SEVERITY3_COUNT_WT ,
  SEVERITY4_COUNT_WT ,
  TIME_ZONE_DIFF_WT ,
  CATEGORY_SKILL_WT ,
  ATTRIBUTE1 ,
  ATTRIBUTE2 ,
  ATTRIBUTE3 ,
  ATTRIBUTE4 ,
  ATTRIBUTE5 ,
  ATTRIBUTE6 ,
  ATTRIBUTE7 ,
  ATTRIBUTE8 ,
  ATTRIBUTE9 ,
  ATTRIBUTE10 ,
  ATTRIBUTE11 ,
  ATTRIBUTE12 ,
  ATTRIBUTE13 ,
  ATTRIBUTE14 ,
  ATTRIBUTE15 ,
  CONTEXT ,
  OBJECT_VERSION_NUMBER,
  CREATION_DATE ,
  CREATED_BY ,
  LAST_UPDATE_DATE ,
  LAST_UPDATED_BY ,
  LAST_UPDATE_LOGIN )
values (
  X_WEIGHT_ID ,
  X_INCIDENT_TYPE_ID ,
  X_INCIDENT_SEVERITY_ID ,
  X_START_DATE_ACTIVE ,
  X_END_DATE_ACTIVE ,
  X_PRODUCT_SKILL_WT,
  X_PLATFORM_SKILL_WT ,
  X_PROB_CODE_SKILL_WT,
  X_LAST_LOGIN_TIME_WT ,
  X_SEVERITY1_COUNT_WT ,
  X_SEVERITY2_COUNT_WT ,
  X_SEVERITY3_COUNT_WT ,
  X_SEVERITY4_COUNT_WT ,
  X_TIME_ZONE_DIFF_WT ,
  X_CATEGORY_SKILL_WT ,
  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_CONTEXT ,
  X_OBJECT_VERSION_NUMBER,
  X_CREATION_DATE ,
  X_CREATED_BY ,
  X_LAST_UPDATE_DATE ,
  X_LAST_UPDATED_BY ,
  X_LAST_UPDATE_LOGIN );

Line: 132


end INSERT_ROW;

Line: 168


  cursor c is select
  INCIDENT_TYPE_ID ,
  INCIDENT_SEVERITY_ID ,
  START_DATE_ACTIVE ,
  END_DATE_ACTIVE ,
  PRODUCT_SKILL_WT ,
  PLATFORM_SKILL_WT ,
  PROB_CODE_SKILL_WT ,
  LAST_LOGIN_TIME_WT ,
  SEVERITY1_COUNT_WT ,
  SEVERITY2_COUNT_WT ,
  SEVERITY3_COUNT_WT ,
  SEVERITY4_COUNT_WT ,
  TIME_ZONE_DIFF_WT ,
  CATEGORY_SKILL_WT ,
  ATTRIBUTE1 ,
  ATTRIBUTE2 ,
  ATTRIBUTE3 ,
  ATTRIBUTE4 ,
  ATTRIBUTE5 ,
  ATTRIBUTE6 ,
  ATTRIBUTE7 ,
  ATTRIBUTE8 ,
  ATTRIBUTE9 ,
  ATTRIBUTE10 ,
  ATTRIBUTE11 ,
  ATTRIBUTE12 ,
  ATTRIBUTE13 ,
  ATTRIBUTE14 ,
  ATTRIBUTE15 ,
  CONTEXT,
  OBJECT_VERSION_NUMBER
    from CS_SR_LOAD_BALANCE_WT
    where WEIGHT_ID = X_WEIGHT_ID
    for update of WEIGHT_ID nowait;

Line: 210


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 285


procedure UPDATE_ROW (
  X_WEIGHT_ID in NUMBER,
  X_INCIDENT_TYPE_ID in NUMBER,
  X_INCIDENT_SEVERITY_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_PRODUCT_SKILL_WT in NUMBER,
  X_PLATFORM_SKILL_WT in NUMBER,
  X_PROB_CODE_SKILL_WT in NUMBER,
  X_LAST_LOGIN_TIME_WT in NUMBER,
  X_SEVERITY1_COUNT_WT in NUMBER,
  X_SEVERITY2_COUNT_WT in NUMBER,
  X_SEVERITY3_COUNT_WT in NUMBER,
  X_SEVERITY4_COUNT_WT in NUMBER,
  X_TIME_ZONE_DIFF_WT in NUMBER,
  X_CATEGORY_SKILL_WT in NUMBER,
  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_CONTEXT in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update CS_SR_LOAD_BALANCE_WT set
  INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID,
  INCIDENT_SEVERITY_ID = X_INCIDENT_SEVERITY_ID,
  START_DATE_ACTIVE = X_START_DATE_ACTIVE,
  END_DATE_ACTIVE = X_END_DATE_ACTIVE,
  PRODUCT_SKILL_WT = X_PRODUCT_SKILL_WT,
  PLATFORM_SKILL_WT = X_PLATFORM_SKILL_WT,
  PROB_CODE_SKILL_WT = X_PROB_CODE_SKILL_WT,
  LAST_LOGIN_TIME_WT = X_LAST_LOGIN_TIME_WT,
  SEVERITY1_COUNT_WT = X_SEVERITY1_COUNT_WT,
  SEVERITY2_COUNT_WT = X_SEVERITY2_COUNT_WT,
  SEVERITY3_COUNT_WT = X_SEVERITY3_COUNT_WT,
  SEVERITY4_COUNT_WT = X_SEVERITY4_COUNT_WT,
  TIME_ZONE_DIFF_WT = X_TIME_ZONE_DIFF_WT,
  CATEGORY_SKILL_WT = X_CATEGORY_SKILL_WT,
  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,
  CONTEXT = X_CONTEXT,
  OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
  LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
  LAST_UPDATED_BY = X_LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where WEIGHT_ID = X_WEIGHT_ID;

Line: 363


end UPDATE_ROW;

Line: 365


procedure DELETE_ROW(
 X_WEIGHT_ID in NUMBER)
is
begin
 delete from CS_SR_LOAD_BALANCE_WT
 where WEIGHT_ID = X_WEIGHT_ID;

Line: 376


end DELETE_ROW;