APPS.AMW_OPINION_VALUE_CODES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 3

procedure INSERT_ROW (
  X_OPINION_VALUE_CODE_ID in NUMBER,
  X_OPINION_VALUE_CODE_NAME in VARCHAR2,
  X_ATTACHMENT_ID in NUMBER,
  X_IMAGE_FILE_NAME in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  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
begin
  insert into AMW_OPINION_VALUE_CODES (
    OPINION_VALUE_CODE_ID,
    OPINION_VALUE_CODE_NAME,
    ATTACHMENT_ID,
    IMAGE_FILE_NAME,
    SECURITY_GROUP_ID,
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) values (
    X_OPINION_VALUE_CODE_ID,
    X_OPINION_VALUE_CODE_NAME,
    X_ATTACHMENT_ID,
    X_IMAGE_FILE_NAME,
    X_SECURITY_GROUP_ID,
    X_OBJECT_VERSION_NUMBER,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN);

Line: 41

end INSERT_ROW;

Line: 43

procedure UPDATE_ROW (
  X_OPINION_VALUE_CODE_ID in NUMBER,
  X_OPINION_VALUE_CODE_NAME in VARCHAR2,
  X_ATTACHMENT_ID in NUMBER,
  X_IMAGE_FILE_NAME in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMW_OPINION_VALUE_CODES set
    OPINION_VALUE_CODE_NAME = X_OPINION_VALUE_CODE_NAME,
    ATTACHMENT_ID = X_ATTACHMENT_ID,
    IMAGE_FILE_NAME = X_IMAGE_FILE_NAME,
    SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where OPINION_VALUE_CODE_ID = X_OPINION_VALUE_CODE_ID;

Line: 69

end UPDATE_ROW;

Line: 71

procedure DELETE_ROW (
  X_OPINION_VALUE_CODE_ID in NUMBER
) is
begin
  delete from AMW_OPINION_VALUE_CODES
  where OPINION_VALUE_CODE_ID = X_OPINION_VALUE_CODE_ID;

Line: 82

end DELETE_ROW;

Line: 89

	X_LAST_UPDATE_DATE    		in VARCHAR2,
	X_OWNER				in VARCHAR2,
	X_CUSTOM_MODE			in VARCHAR2) is

f_luby	number;	-- entity owner in file

Line: 94

f_ludate	date;		-- entity update date in file

Line: 96

db_ludate	date;		-- entity update date in db

Line: 99

	-- Translate owner to file_last_updated_by
	f_luby := fnd_load_util.owner_id(X_OWNER);

Line: 102

	-- Translate char last_update_date to date
	f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 105

	select last_updated_by, last_update_date into db_luby, db_ludate
	from AMW_OPINION_VALUE_CODES
	where opinion_value_code_name = X_OPINION_VALUE_CODE_NAME;

Line: 110

	then AMW_OPINION_VALUE_CODES_PKG.UPDATE_ROW(
		X_OPINION_VALUE_CODE_ID		=> X_OPINION_VALUE_CODE_ID,
		X_OPINION_VALUE_CODE_NAME	=> X_OPINION_VALUE_CODE_NAME,
		X_ATTACHMENT_ID			=> X_ATTACHMENT_ID,
		X_IMAGE_FILE_NAME			=> X_IMAGE_FILE_NAME,
		X_SECURITY_GROUP_ID		=> null,
		X_OBJECT_VERSION_NUMBER		=> 1,
		X_LAST_UPDATE_DATE		=> f_ludate,
		X_LAST_UPDATED_BY			=> f_luby,
		X_LAST_UPDATE_LOGIN		=> 0);

Line: 122

	then AMW_OPINION_VALUE_CODES_PKG.INSERT_ROW(
		X_OPINION_VALUE_CODE_ID		=> X_OPINION_VALUE_CODE_ID,
		X_OPINION_VALUE_CODE_NAME	=> X_OPINION_VALUE_CODE_NAME,
		X_ATTACHMENT_ID			=> X_ATTACHMENT_ID,
		X_IMAGE_FILE_NAME			=> X_IMAGE_FILE_NAME,
		X_SECURITY_GROUP_ID		=> null,
		X_OBJECT_VERSION_NUMBER		=> 1,
		X_CREATION_DATE			=> f_ludate,
		X_CREATED_BY			=> f_luby,
		X_LAST_UPDATE_DATE		=> f_ludate,
		X_LAST_UPDATED_BY			=> f_luby,
		X_LAST_UPDATE_LOGIN		=> 0);