DBA Data[Home] [Help]

APPS.PA_ALLOC_RESOURCES_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_MEMBER_TYPE 		in VARCHAR2,
  X_RESOURCE_LIST_MEMBER_ID 	in NUMBER,
  X_EXCLUDE_FLAG 		in VARCHAR2,
  X_TARGET_EXPND_TYPE 		in VARCHAR2,
  X_OFFSET_EXPND_TYPE 		in VARCHAR2,
  X_RESOURCE_PERCENTAGE 	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_RESOURCES
      where RULE_ID = X_RULE_ID
      and MEMBER_TYPE = X_MEMBER_TYPE
      and RESOURCE_LIST_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID;
Line: 25

  insert into PA_ALLOC_RESOURCES (
    RULE_ID,
    MEMBER_TYPE,
    RESOURCE_LIST_MEMBER_ID,
    EXCLUDE_FLAG,
    TARGET_EXPND_TYPE,
    OFFSET_EXPND_TYPE,
    RESOURCE_PERCENTAGE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_RULE_ID,
    X_MEMBER_TYPE,
    X_RESOURCE_LIST_MEMBER_ID,
    X_EXCLUDE_FLAG,
    X_TARGET_EXPND_TYPE,
    X_OFFSET_EXPND_TYPE,
    X_RESOURCE_PERCENTAGE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );
Line: 61

end INSERT_ROW;
Line: 72

  cursor c1 is select
      EXCLUDE_FLAG,
      TARGET_EXPND_TYPE,
      OFFSET_EXPND_TYPE,
      RESOURCE_PERCENTAGE
    from PA_ALLOC_RESOURCES
    where RULE_ID = X_RULE_ID
    and MEMBER_TYPE = X_MEMBER_TYPE
    and RESOURCE_LIST_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID
    for update of RULE_ID nowait;
Line: 114

procedure UPDATE_ROW (
  X_ROWID 			in varchar2,
  X_RULE_ID 			in NUMBER,
  X_MEMBER_TYPE 		in VARCHAR2,
  X_RESOURCE_LIST_MEMBER_ID 	in NUMBER,
  X_EXCLUDE_FLAG 		in VARCHAR2,
  X_TARGET_EXPND_TYPE 		in VARCHAR2,
  X_OFFSET_EXPND_TYPE 		in VARCHAR2,
  X_RESOURCE_PERCENTAGE 	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_RESOURCES set
    RESOURCE_LIST_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID,
    EXCLUDE_FLAG = X_EXCLUDE_FLAG,
    TARGET_EXPND_TYPE = X_TARGET_EXPND_TYPE,
    OFFSET_EXPND_TYPE = X_OFFSET_EXPND_TYPE,
    RESOURCE_PERCENTAGE = X_RESOURCE_PERCENTAGE,
    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: 145

end UPDATE_ROW;
Line: 147

procedure DELETE_ROW (X_ROWID in varchar2
) is
begin
  delete from PA_ALLOC_RESOURCES
  where ROWID = X_ROWID;
Line: 155

end DELETE_ROW;