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.PA_CC_TP_SCHEDULE_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,/*File.sql.39*/
 X_SCHEDULE_LINE_ID             in  NUMBER,
 X_TP_SCHEDULE_ID               in  NUMBER,
 X_PRVDR_ORGANIZATION_ID        in   NUMBER,
 X_START_DATE_ACTIVE            in   DATE,
 X_DEFAULT_FLAG                 in   varchar2,
 X_TP_AMT_TYPE_CODE		in   VARCHAR2,
 X_LAST_UPDATE_DATE             in   DATE,
 X_LAST_UPDATED_BY              in   NUMBER,
 X_CREATION_DATE                in   DATE,
 X_CREATED_BY                   in   NUMBER,
 X_LAST_UPDATE_LOGIN            in   NUMBER,
 X_SORT_ORDER                   in   NUMBER,
 X_LABOR_TP_RULE_ID             in   NUMBER,
 X_LABOR_PERCENTAGE_APPLIED     in   NUMBER,
 X_NL_TP_RULE_ID                in   NUMBER,
 X_NL_PERCENTAGE_APPLIED        in   NUMBER,
 X_RECVR_ORGANIZATION_ID        in   NUMBER,
 X_END_DATE_ACTIVE              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
) is
    cursor C is select ROWID from PA_CC_TP_SCHEDULE_LINES
      where TP_SCHEDULE_ID = X_TP_SCHEDULE_ID
      and   TP_SCHEDULE_LINE_ID=X_SCHEDULE_LINE_ID;

Line: 44


  insert into PA_CC_TP_SCHEDULE_LINES (
 TP_SCHEDULE_LINE_ID,
 TP_SCHEDULE_ID,
 PRVDR_ORGANIZATION_ID,
 START_DATE_ACTIVE,
 DEFAULT_FLAG,
 TP_AMT_TYPE_CODE,
 LAST_UPDATE_DATE,
 LAST_UPDATED_BY,
 CREATION_DATE,
 CREATED_BY,
 LAST_UPDATE_LOGIN,
 SORT_ORDER,
 LABOR_TP_RULE_ID,
 LABOR_PERCENTAGE_APPLIED,
 NL_TP_RULE_ID,
 NL_PERCENTAGE_APPLIED,
 RECVR_ORGANIZATION_ID,
 END_DATE_ACTIVE,
 ATTRIBUTE_CATEGORY,
 ATTRIBUTE1,
 ATTRIBUTE2,
 ATTRIBUTE3,
 ATTRIBUTE4,
 ATTRIBUTE5,
 ATTRIBUTE6,
 ATTRIBUTE7,
 ATTRIBUTE8,
 ATTRIBUTE9,
 ATTRIBUTE10,
 ATTRIBUTE11,
 ATTRIBUTE12,
 ATTRIBUTE13,
 ATTRIBUTE14,
 ATTRIBUTE15
) values (
 X_SCHEDULE_LINE_ID,
 X_TP_SCHEDULE_ID,
 X_PRVDR_ORGANIZATION_ID,
 X_START_DATE_ACTIVE,
 X_DEFAULT_FLAG,
 X_TP_AMT_TYPE_CODE,
 X_LAST_UPDATE_DATE,
 X_LAST_UPDATED_BY,
 X_CREATION_DATE,
 X_CREATED_BY,
 X_LAST_UPDATE_LOGIN,
 X_SORT_ORDER,
 X_LABOR_TP_RULE_ID,
 X_LABOR_PERCENTAGE_APPLIED,
 X_NL_TP_RULE_ID,
 X_NL_PERCENTAGE_APPLIED,
 X_RECVR_ORGANIZATION_ID,
 X_END_DATE_ACTIVE,
 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
);

Line: 122


end INSERT_ROW;

Line: 131


 X_LAST_UPDATE_DATE             in   DATE,
 X_LAST_UPDATED_BY              in   NUMBER,
 X_CREATION_DATE                in   DATE,
 X_CREATED_BY                   in   NUMBER,
 X_LAST_UPDATE_LOGIN            in   NUMBER,
 X_SORT_ORDER                   in   NUMBER,
 X_LABOR_TP_RULE_ID             in   NUMBER,
 X_LABOR_PERCENTAGE_APPLIED     in   NUMBER,
 X_NL_TP_RULE_ID                in   NUMBER,
 X_NL_PERCENTAGE_APPLIED        in   NUMBER,
 X_RECVR_ORGANIZATION_ID        in   NUMBER,
 X_END_DATE_ACTIVE              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
) is
  cursor c1 is select
 TP_SCHEDULE_LINE_ID,
 TP_SCHEDULE_ID,
 PRVDR_ORGANIZATION_ID,
 START_DATE_ACTIVE,
 DEFAULT_FLAG,
 TP_AMT_TYPE_CODE,
 LAST_UPDATE_DATE,
 LAST_UPDATED_BY,
 CREATION_DATE,
 CREATED_BY,
 LAST_UPDATE_LOGIN,
 SORT_ORDER,
 LABOR_TP_RULE_ID,
 LABOR_PERCENTAGE_APPLIED,
 NL_TP_RULE_ID,
 NL_PERCENTAGE_APPLIED,
 RECVR_ORGANIZATION_ID,
 END_DATE_ACTIVE,
 ATTRIBUTE_CATEGORY,
 ATTRIBUTE1,
 ATTRIBUTE2,
 ATTRIBUTE3,
 ATTRIBUTE4,
 ATTRIBUTE5,
 ATTRIBUTE6,
 ATTRIBUTE7,
 ATTRIBUTE8,
 ATTRIBUTE9,
 ATTRIBUTE10,
 ATTRIBUTE11,
 ATTRIBUTE12,
 ATTRIBUTE13,
 ATTRIBUTE14,
 ATTRIBUTE15
from PA_CC_TP_SCHEDULE_LINES
where TP_SCHEDULE_ID = X_TP_SCHEDULE_ID
and   TP_SCHEDULE_LINE_ID=X_SCHEDULE_LINE_ID
for update of TP_SCHEDULE_ID nowait;

Line: 205


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

Line: 277


procedure UPDATE_ROW (
 X_ROWID                       in VARCHAR2,
 X_SCHEDULE_LINE_ID             in  NUMBER,
 X_TP_SCHEDULE_ID               in  NUMBER,
 X_PRVDR_ORGANIZATION_ID        in   NUMBER,
 X_START_DATE_ACTIVE            in   DATE,
 X_DEFAULT_FLAG                 in varchar2,
 X_TP_AMT_TYPE_CODE 		in   VARCHAR2,
 X_LAST_UPDATE_DATE             in DATE,
 X_LAST_UPDATED_BY              in NUMBER,
 X_LAST_UPDATE_LOGIN            in NUMBER,
 X_SORT_ORDER                   in   NUMBER,
 X_LABOR_TP_RULE_ID             in   NUMBER,
 X_LABOR_PERCENTAGE_APPLIED     in   NUMBER,
 X_NL_TP_RULE_ID                in   NUMBER,
 X_NL_PERCENTAGE_APPLIED        in   NUMBER,
 X_RECVR_ORGANIZATION_ID        in   NUMBER,
 X_END_DATE_ACTIVE              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
) is
  begin
  update PA_CC_TP_SCHEDULE_LINES set
 TP_SCHEDULE_LINE_ID=X_SCHEDULE_LINE_ID,
 TP_SCHEDULE_ID=X_TP_SCHEDULE_ID,
 PRVDR_ORGANIZATION_ID=X_PRVDR_ORGANIZATION_ID,
 START_DATE_ACTIVE=X_START_DATE_ACTIVE,
 DEFAULT_FLAG=X_DEFAULT_FLAG,
 TP_AMT_TYPE_CODE=X_TP_AMT_TYPE_CODE,
 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
 SORT_ORDER=X_SORT_ORDER,
 LABOR_TP_RULE_ID=X_LABOR_TP_RULE_ID,
 LABOR_PERCENTAGE_APPLIED=X_LABOR_PERCENTAGE_APPLIED,
 NL_TP_RULE_ID=X_NL_TP_RULE_ID,
 NL_PERCENTAGE_APPLIED=X_NL_PERCENTAGE_APPLIED,
 RECVR_ORGANIZATION_ID=X_RECVR_ORGANIZATION_ID,
 END_DATE_ACTIVE=X_END_DATE_ACTIVE,
 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
where rowid = X_rowid;

Line: 350


end UPDATE_ROW;

Line: 352


procedure DELETE_ROW (
  X_ROWID in varchar2
) is
begin
  delete from PA_CC_TP_SCHEDULE_LINES
  where Rowid = X_rowid;

Line: 361


end DELETE_ROW;