APPS.PER_CAL_ENTRY_VALUES_LOAD_PKG SQL Statements

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

Line: 23

    select ENV.CAL_ENTRY_VALUE_ID
    from PER_CAL_ENTRY_VALUES ENV
    where ENV.IDENTIFIER_KEY = X_VALUE;

Line: 28

    select PER_CAL_ENTRY_VALUES_S.nextval
    from   dual;

Line: 32

    select ENT.CALENDAR_ENTRY_ID
    from PER_CALENDAR_ENTRIES ENT
    where ENT.IDENTIFIER_KEY = X_ENTRY_IDENTIFIER_KEY;

Line: 37

    SELECT PGN.HIERARCHY_NODE_ID
    FROM PER_GEN_HIERARCHY_NODES PGN
    WHERE PGN.IDENTIFIER_KEY = X_HIERARCHY_NODE_NAME;

Line: 42

    select POSE.ORG_STRUCTURE_ELEMENT_ID
    from   PER_ORGANIZATION_STRUCTURES POS
          ,PER_ORG_STRUCTURE_VERSIONS  POSV
          ,PER_ORG_STRUCTURE_ELEMENTS  POSE
          ,HR_ALL_ORGANIZATION_UNITS   HOU_P
          ,HR_ALL_ORGANIZATION_UNITS   HOU_C
    where  POS.NAME = X_ORG_HIER_NAME
    and    POS.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID
    and    POSV.VERSION_NUMBER = X_ORG_HIER_VERSION
    and    POSV.ORG_STRUCTURE_VERSION_ID = POSE.ORG_STRUCTURE_VERSION_ID
    and    POSE.ORGANIZATION_ID_PARENT = HOU_P.ORGANIZATION_ID
    and    HOU_P.NAME = X_ORG_HIER_ELEMENT_PARENT
    and    POSE.ORGANIZATION_ID_CHILD = HOU_C.ORGANIZATION_ID
    and    HOU_C.NAME = X_ORG_HIER_ELEMENT_CHILD;

Line: 58

    select HOU.ORGANIZATION_ID
    from   HR_ALL_ORGANIZATION_UNITS HOU
    where  HOU.NAME = X_ORG_HIER_NODE_NAME;

Line: 119

procedure INSERT_ROW (
  X_CAL_ENTRY_VALUE_ID                  in NUMBER,
  X_CALENDAR_ENTRY_ID                   in NUMBER,
  X_HIERARCHY_NODE_ID                   in NUMBER,
  X_IDVALUE                             in VARCHAR2,
  X_ORG_STRUCTURE_ELEMENT_ID            in NUMBER,
  X_ORGANIZATION_ID                     in NUMBER,
  X_OVERRIDE_NAME                       in VARCHAR2,
  X_OVERRIDE_TYPE                       in VARCHAR2,
  X_PARENT_ENTRY_VALUE_ID               in NUMBER,
  X_USAGE_FLAG                          in VARCHAR2,
  X_CREATED_BY                          in NUMBER,
  X_LAST_UPDATE_DATE                    in DATE,
  X_LAST_UPDATED_BY                     in NUMBER,
  X_LAST_UPDATE_LOGIN                   in NUMBER,
  X_CREATION_DATE                       in DATE,
  X_IDENTIFIER_KEY                      in VARCHAR2) is

  cursor C is select ROWID from PER_CAL_ENTRY_VALUES
    where CAL_ENTRY_VALUE_ID = X_CAL_ENTRY_VALUE_ID;

Line: 141

  insert into PER_CAL_ENTRY_VALUES (
    CAL_ENTRY_VALUE_ID,
    CALENDAR_ENTRY_ID,
    HIERARCHY_NODE_ID,
    IDVALUE,
    ORG_STRUCTURE_ELEMENT_ID,
    ORGANIZATION_ID,
    OVERRIDE_NAME,
    OVERRIDE_TYPE,
    PARENT_ENTRY_VALUE_ID,
    USAGE_FLAG,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    IDENTIFIER_KEY
  ) values (
    X_CAL_ENTRY_VALUE_ID,
    X_CALENDAR_ENTRY_ID,
    X_HIERARCHY_NODE_ID,
    X_IDVALUE,
    X_ORG_STRUCTURE_ELEMENT_ID,
    X_ORGANIZATION_ID,
    X_OVERRIDE_NAME,
    X_OVERRIDE_TYPE,
    X_PARENT_ENTRY_VALUE_ID,
    X_USAGE_FLAG,
    1,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_IDENTIFIER_KEY
  );

Line: 187

end INSERT_ROW;

Line: 205

  X_LAST_UPDATE_DATE                    in VARCHAR2) IS

  X_ROWID ROWID;

Line: 243

   PER_CAL_ENTRY_VALUES_LOAD_PKG.UPDATE_ROW (
     X_CAL_ENTRY_VALUE_ID         => X_CAL_ENTRY_VALUE_ID
    ,X_HIERARCHY_NODE_ID 	  => X_HIERARCHY_NODE_ID
    ,X_IDVALUE                    => X_IDVALUE
    ,X_ORG_STRUCTURE_ELEMENT_ID   => X_ORG_STRUCTURE_ELEMENT_ID
    ,X_ORGANIZATION_ID            => X_ORGANIZATION_ID
    ,X_OVERRIDE_NAME              => X_OVERRIDE_NAME
    ,X_OVERRIDE_TYPE              => X_OVERRIDE_TYPE
    ,X_USAGE_FLAG                 => X_USAGE_FLAG
    ,X_LAST_UPDATE_DATE           => sysdate
    ,X_LAST_UPDATED_BY 	  	  => user_id
    ,X_LAST_UPDATE_LOGIN 	  => user_id);

Line: 258

    PER_CAL_ENTRY_VALUES_LOAD_PKG.INSERT_ROW (
     X_CAL_ENTRY_VALUE_ID        => X_CAL_ENTRY_VALUE_ID
    ,X_CALENDAR_ENTRY_ID         => X_CALENDAR_ENTRY_ID
    ,X_HIERARCHY_NODE_ID         => X_HIERARCHY_NODE_ID
    ,X_IDVALUE                   => X_IDVALUE
    ,X_ORG_STRUCTURE_ELEMENT_ID  => X_ORG_STRUCTURE_ELEMENT_ID
    ,X_ORGANIZATION_ID           => X_ORGANIZATION_ID
    ,X_OVERRIDE_NAME             => X_OVERRIDE_NAME
    ,X_OVERRIDE_TYPE             => X_OVERRIDE_TYPE
    ,X_PARENT_ENTRY_VALUE_ID     => X_PARENT_ENTRY_VALUE_ID
    ,X_USAGE_FLAG                => X_USAGE_FLAG
    ,X_CREATED_BY                => user_id
    ,X_LAST_UPDATE_DATE          => sysdate
    ,X_LAST_UPDATED_BY           => user_id
    ,X_LAST_UPDATE_LOGIN         => 0
    ,X_CREATION_DATE 		 => SYSDATE
    ,X_IDENTIFIER_KEY            => X_VALUE_IDENTIFIER_KEY);

Line: 278

procedure UPDATE_ROW (
   X_CAL_ENTRY_VALUE_ID                 in NUMBER,
   X_HIERARCHY_NODE_ID                  in NUMBER,
   X_IDVALUE                            in VARCHAR2,
   X_ORG_STRUCTURE_ELEMENT_ID           in NUMBER,
   X_ORGANIZATION_ID                    in NUMBER,
   X_OVERRIDE_NAME                      in VARCHAR2,
   X_OVERRIDE_TYPE                      in VARCHAR2,
   X_USAGE_FLAG                         in VARCHAR2,
   X_LAST_UPDATE_DATE                   in DATE,
   X_LAST_UPDATED_BY                    in NUMBER,
   X_LAST_UPDATE_LOGIN                  in NUMBER) IS

begin
  update PER_CAL_ENTRY_VALUES set
    HIERARCHY_NODE_ID = X_HIERARCHY_NODE_ID,
    IDVALUE = X_IDVALUE,
    ORG_STRUCTURE_ELEMENT_ID = X_ORG_STRUCTURE_ELEMENT_ID,
    ORGANIZATION_ID = X_ORGANIZATION_ID,
    OVERRIDE_NAME = X_OVERRIDE_NAME,
    OVERRIDE_TYPE = X_OVERRIDE_TYPE,
    USAGE_FLAG = X_USAGE_FLAG,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where CAL_ENTRY_VALUE_ID = X_CAL_ENTRY_VALUE_ID;

Line: 309

end UPDATE_ROW;