APPS.AR_BPA_AREA_ITEMS_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_AREA_ITEM_ID in NUMBER,
  X_SECONDARY_APP_ID in NUMBER,
  X_ITEM_ID in NUMBER,
  X_DISPLAY_SEQUENCE in NUMBER,
  X_TEMPLATE_ID in NUMBER,
  X_DISPLAY_LEVEL in VARCHAR2,
  X_PARENT_AREA_CODE in VARCHAR2,
  X_DATA_SOURCE_ID in NUMBER,
  X_FLEXFIELD_ITEM_FLAG in VARCHAR2,
  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 AR_BPA_AREA_ITEMS
    where AREA_ITEM_ID = X_AREA_ITEM_ID
    ;

Line: 24

  insert into AR_BPA_AREA_ITEMS (
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    SECONDARY_APP_ID,
    ITEM_ID,
    DISPLAY_SEQUENCE,
    CREATED_BY,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    PARENT_AREA_CODE,
    TEMPLATE_ID,
    DISPLAY_LEVEL,
    AREA_ITEM_ID,
    DATA_SOURCE_ID,
    FLEXFIELD_ITEM_FLAG
  ) select
    X_LAST_UPDATE_LOGIN,
    X_CREATION_DATE,
    X_SECONDARY_APP_ID,
    X_ITEM_ID,
    X_DISPLAY_SEQUENCE,
    X_CREATED_BY,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_PARENT_AREA_CODE,
    X_TEMPLATE_ID,
    X_DISPLAY_LEVEL,
    X_AREA_ITEM_ID,
    X_DATA_SOURCE_ID,
    X_FLEXFIELD_ITEM_FLAG
  FROM DUAL;

Line: 64

end INSERT_ROW;

Line: 77

  cursor c1 is select
      SECONDARY_APP_ID,
      ITEM_ID,
      DISPLAY_SEQUENCE,
      TEMPLATE_ID,
      DISPLAY_LEVEL,
      PARENT_AREA_CODE,
      DATA_SOURCE_ID,
      FLEXFIELD_ITEM_FLAG
    from AR_BPA_AREA_ITEMS
    where AREA_ITEM_ID = X_AREA_ITEM_ID
    for update of AREA_ITEM_ID nowait;

Line: 109

procedure UPDATE_ROW (
  X_AREA_ITEM_ID in NUMBER,
  X_SECONDARY_APP_ID in NUMBER,
  X_ITEM_ID in NUMBER,
  X_DISPLAY_SEQUENCE in NUMBER,
  X_TEMPLATE_ID in NUMBER,
  X_DISPLAY_LEVEL in VARCHAR2,
  X_PARENT_AREA_CODE in VARCHAR2,
  X_DATA_SOURCE_ID in NUMBER,
  X_FLEXFIELD_ITEM_FLAG in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AR_BPA_AREA_ITEMS set
    SECONDARY_APP_ID = X_SECONDARY_APP_ID,
    ITEM_ID = X_ITEM_ID,
    DISPLAY_SEQUENCE = X_DISPLAY_SEQUENCE,
    TEMPLATE_ID = X_TEMPLATE_ID,
    DISPLAY_LEVEL = X_DISPLAY_LEVEL,
    PARENT_AREA_CODE = X_PARENT_AREA_CODE,
    DATA_SOURCE_ID = X_DATA_SOURCE_ID,
    FLEXFIELD_ITEM_FLAG = X_FLEXFIELD_ITEM_FLAG,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where AREA_ITEM_ID = X_AREA_ITEM_ID;

Line: 141

end UPDATE_ROW;

Line: 143

procedure DELETE_ROW (
  X_AREA_ITEM_ID in NUMBER
) is
begin
  delete from AR_BPA_AREA_ITEMS
  where AREA_ITEM_ID = X_AREA_ITEM_ID;

Line: 154

end DELETE_ROW;

Line: 177

    AR_BPA_AREA_ITEMS_PKG.UPDATE_ROW (
	  X_AREA_ITEM_ID  => X_AREA_ITEM_ID,
	  X_SECONDARY_APP_ID => X_SECONDARY_APP_ID,
	  X_ITEM_ID => X_ITEM_ID,
	  X_DISPLAY_SEQUENCE => X_DISPLAY_SEQUENCE,
	  X_TEMPLATE_ID => X_TEMPLATE_ID,
	  X_DISPLAY_LEVEL => X_DISPLAY_LEVEL,
	  X_PARENT_AREA_CODE => X_PARENT_AREA_CODE,
	  X_DATA_SOURCE_ID => X_DATA_SOURCE_ID,
	  X_FLEXFIELD_ITEM_FLAG => X_FLEXFIELD_ITEM_FLAG,
        X_LAST_UPDATE_DATE 	=> sysdate,
         X_LAST_UPDATED_BY 	=> user_id,
         X_LAST_UPDATE_LOGIN 	=> 0);

Line: 192

           AR_BPA_AREA_ITEMS_PKG.INSERT_ROW (
                 X_ROWID => row_id,
		  X_AREA_ITEM_ID  => X_AREA_ITEM_ID,
		  X_SECONDARY_APP_ID => X_SECONDARY_APP_ID,
		  X_ITEM_ID => X_ITEM_ID,
		  X_DISPLAY_SEQUENCE => X_DISPLAY_SEQUENCE,
		  X_TEMPLATE_ID => X_TEMPLATE_ID,
		  X_DISPLAY_LEVEL => X_DISPLAY_LEVEL,
		  X_PARENT_AREA_CODE => X_PARENT_AREA_CODE,
		  X_DATA_SOURCE_ID => X_DATA_SOURCE_ID,
		  X_FLEXFIELD_ITEM_FLAG => X_FLEXFIELD_ITEM_FLAG,
			X_CREATION_DATE 	=> sysdate,
                X_CREATED_BY 		=> user_id,
                X_LAST_UPDATE_DATE 	=> sysdate,
                X_LAST_UPDATED_BY 	=> user_id,
                X_LAST_UPDATE_LOGIN 	=> 0);