APPS.HR_ORG_INFO_TYPES_BY_CLASS_PKG SQL Statements

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

Line: 7

  X_LAST_UPDATE_DATE out nocopy DATE,
  X_LAST_UPDATED_BY out nocopy NUMBER,
  X_LAST_UPDATE_LOGIN out nocopy NUMBER
) is
begin
  if X_OWNER = 'SEED' then
    X_CREATED_BY := 1;

Line: 14

    X_LAST_UPDATED_BY := 1;

Line: 17

    X_LAST_UPDATED_BY := 0;

Line: 20

  X_LAST_UPDATE_DATE := sysdate;

Line: 21

  X_LAST_UPDATE_LOGIN := 0;

Line: 23

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_ORG_CLASSIFICATION in VARCHAR2,
  X_ORG_INFORMATION_TYPE in VARCHAR2,
  X_MANDATORY_FLAG in VARCHAR2,
  X_ENABLED_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 HR_ORG_INFO_TYPES_BY_CLASS
    where ORG_CLASSIFICATION = X_ORG_CLASSIFICATION
    and ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
    ;

Line: 40

  insert into HR_ORG_INFO_TYPES_BY_CLASS (
    ORG_CLASSIFICATION,
    ORG_INFORMATION_TYPE,
    MANDATORY_FLAG,
    ENABLED_FLAG,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY,
    CREATION_DATE
  ) values(
    X_ORG_CLASSIFICATION,
    X_ORG_INFORMATION_TYPE,
    X_MANDATORY_FLAG,
    X_ENABLED_FLAG,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CREATED_BY,
    X_CREATION_DATE);

Line: 69

end INSERT_ROW;

Line: 76

  cursor c1 is select
      MANDATORY_FLAG
    from HR_ORG_INFO_TYPES_BY_CLASS
    where ORG_CLASSIFICATION = X_ORG_CLASSIFICATION
    and ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
    for update of ORG_CLASSIFICATION nowait;

Line: 95

procedure UPDATE_ROW (
  X_ORG_CLASSIFICATION in VARCHAR2,
  X_ORG_INFORMATION_TYPE in VARCHAR2,
  X_MANDATORY_FLAG in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update HR_ORG_INFO_TYPES_BY_CLASS set
    MANDATORY_FLAG = X_MANDATORY_FLAG,
    ENABLED_FLAG = X_ENABLED_FLAG,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where ORG_CLASSIFICATION = X_ORG_CLASSIFICATION
  and ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;

Line: 117

end UPDATE_ROW;

Line: 119

procedure DELETE_ROW (
  X_ORG_CLASSIFICATION in VARCHAR2,
  X_ORG_INFORMATION_TYPE in VARCHAR2
) is
begin
  delete from HR_ORG_INFO_TYPES_BY_CLASS
  where ORG_CLASSIFICATION = X_ORG_CLASSIFICATION
  and ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;

Line: 132

end DELETE_ROW;

Line: 140

X_LAST_UPDATE_DATE      IN VARCHAR2 default sysdate,
X_CUSTOM_MODE           IN VARCHAR2 default null
) is
  X_ROWID ROWID;

Line: 146

  X_LAST_UPDATED_BY NUMBER;

Line: 147

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 150

  f_ludate  date;    -- entity update date in file

Line: 152

  db_ludate date;    -- entity update date in db

Line: 157

 f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 158

        select LAST_UPDATED_BY, LAST_UPDATE_DATE
        into db_luby, db_ludate
        from HR_ORG_INFO_TYPES_BY_CLASS
        where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
        and ORG_CLASSIFICATION=X_ORG_CLASSIFICATION;

Line: 169

                    UPDATE_ROW (
                            X_ORG_CLASSIFICATION ,
                            X_ORG_INFORMATION_TYPE ,
                            X_MANDATORY_FLAG ,
                            l_enabled_flag,
                            f_ludate ,
                            f_luby ,
                            0 );

Line: 180

	      INSERT_ROW (
		        X_ROWID ,
		        X_ORG_CLASSIFICATION ,
		        X_ORG_INFORMATION_TYPE ,
		        X_MANDATORY_FLAG ,
		        l_enabled_flag,
		        f_luby ,
		        f_ludate ,
		        f_ludate ,
		        f_luby ,
		        0 );