APPS.PA_ALLOC_TARGET_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_RULE_ID 		in NUMBER,
  X_LINE_NUM 		in NUMBER,
  X_PROJECT_ORG_ID 	in NUMBER,
  X_TASK_ORG_ID 	in NUMBER,
  X_PROJECT_TYPE 	in VARCHAR2,
  X_CLASS_CATEGORY 	in VARCHAR2,
  X_CLASS_CODE 		in VARCHAR2,
  X_SERVICE_TYPE 	in VARCHAR2,
  X_PROJECT_ID 		in NUMBER,
  X_TASK_ID 		in NUMBER,
  X_EXCLUDE_FLAG 	in VARCHAR2,
  X_BILLABLE_ONLY_FLAG 	in VARCHAR2,
  X_LINE_PERCENT 	in NUMBER,
  X_CREATED_BY		in NUMBER,
  X_CREATION_DATE 	in DATE,
  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 PA_ALLOC_TARGET_LINES
      where RULE_ID = X_RULE_ID
      and LINE_NUM = X_LINE_NUM;

Line: 28

  insert into PA_ALLOC_TARGET_LINES (
    RULE_ID,
    LINE_NUM,
    PROJECT_ORG_ID,
    TASK_ORG_ID,
    PROJECT_TYPE,
    CLASS_CATEGORY,
    CLASS_CODE,
    SERVICE_TYPE,
    PROJECT_ID,
    TASK_ID,
    EXCLUDE_FLAG,
    BILLABLE_ONLY_FLAG,
    LINE_PERCENT,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_RULE_ID,
    X_LINE_NUM,
    X_PROJECT_ORG_ID,
    X_TASK_ORG_ID,
    X_PROJECT_TYPE,
    X_CLASS_CATEGORY,
    X_CLASS_CODE,
    X_SERVICE_TYPE,
    X_PROJECT_ID,
    X_TASK_ID,
    X_EXCLUDE_FLAG,
    X_BILLABLE_ONLY_FLAG,
    X_LINE_PERCENT,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 76

end INSERT_ROW;

Line: 93

  cursor c1 is select
      PROJECT_ORG_ID,
      TASK_ORG_ID,
      PROJECT_TYPE,
      CLASS_CATEGORY,
      CLASS_CODE,
      SERVICE_TYPE,
      PROJECT_ID,
      TASK_ID,
      EXCLUDE_FLAG,
      BILLABLE_ONLY_FLAG,
      LINE_PERCENT
    from PA_ALLOC_TARGET_LINES
    where RULE_ID = X_RULE_ID
    and LINE_NUM = X_LINE_NUM
    for update of RULE_ID nowait;

Line: 162

procedure UPDATE_ROW (
  X_ROWID		in VARCHAR2,
  X_RULE_ID 		in NUMBER,
  X_LINE_NUM 		in NUMBER,
  X_PROJECT_ORG_ID 	in NUMBER,
  X_TASK_ORG_ID 	in NUMBER,
  X_PROJECT_TYPE 	in VARCHAR2,
  X_CLASS_CATEGORY 	in VARCHAR2,
  X_CLASS_CODE 		in VARCHAR2,
  X_SERVICE_TYPE 	in VARCHAR2,
  X_PROJECT_ID 		in NUMBER,
  X_TASK_ID 		in NUMBER,
  X_EXCLUDE_FLAG 	in VARCHAR2,
  X_BILLABLE_ONLY_FLAG 	in VARCHAR2,
  X_LINE_PERCENT 	in NUMBER,
  X_LAST_UPDATE_DATE 	in DATE,
  X_LAST_UPDATED_BY 	in NUMBER,
  X_LAST_UPDATE_LOGIN 	in NUMBER
  ) is

begin

  update PA_ALLOC_TARGET_LINES set
    LINE_NUM = X_LINE_NUM,
    PROJECT_ORG_ID = X_PROJECT_ORG_ID,
    TASK_ORG_ID = X_TASK_ORG_ID,
    PROJECT_TYPE = X_PROJECT_TYPE,
    CLASS_CATEGORY = X_CLASS_CATEGORY,
    CLASS_CODE = X_CLASS_CODE,
    SERVICE_TYPE = X_SERVICE_TYPE,
    PROJECT_ID = X_PROJECT_ID,
    TASK_ID = X_TASK_ID,
    EXCLUDE_FLAG = X_EXCLUDE_FLAG,
    BILLABLE_ONLY_FLAG = X_BILLABLE_ONLY_FLAG,
    LINE_PERCENT = X_LINE_PERCENT,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where ROWID = X_ROWID;

Line: 207

end UPDATE_ROW;

Line: 209

procedure DELETE_ROW (X_ROWID in VARCHAR2
  --X_RULE_ID in NUMBER,
  --X_LINE_NUM in NUMBER
) is
begin
  delete from PA_ALLOC_TARGET_LINES
  where ROWID = X_ROWID;

Line: 221

end DELETE_ROW;