APPS.PA_ALLOC_SOURCE_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_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_SOURCE_LINES
      where RULE_ID = X_RULE_ID
      and LINE_NUM = X_LINE_NUM;

Line: 27

  insert into PA_ALLOC_SOURCE_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,
    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_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 70

end INSERT_ROW;

Line: 85

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

Line: 146

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_LAST_UPDATE_DATE	in DATE,
  X_LAST_UPDATED_BY	in NUMBER,
  X_LAST_UPDATE_LOGIN	in NUMBER
  ) is

begin

  update PA_ALLOC_SOURCE_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,
    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: 186

end UPDATE_ROW;

Line: 188

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

Line: 200

end DELETE_ROW;