APPS.PER_CALENDAR_ENTRIES_LOAD_PKG SQL Statements

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

Line: 21

    select PGH.HIERARCHY_ID
    from  PER_GEN_HIERARCHY PGH
    where PGH.NAME = X_HIERARCHY_NAME;

Line: 28

    select FVS.FLEX_VALUE_SET_ID
    from FND_FLEX_VALUE_SETS FVS
    where FVS.FLEX_VALUE_SET_NAME = X_FLEX_VALUE_SET_NAME;

Line: 35

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

Line: 40

    select PER_CALENDAR_ENTRIES_S.nextval
    from   dual;

Line: 46

    select HOU.BUSINESS_GROUP_ID
    from HR_ALL_ORGANIZATION_UNITS HOU
    where HOU.NAME = X_BUS_GRP_NAME
    and HOU.ORGANIZATION_ID = HOU.BUSINESS_GROUP_ID;

Line: 54

    select POS.ORGANIZATION_STRUCTURE_ID
    from PER_ORGANIZATION_STRUCTURES POS
    where POS.NAME = X_ORG_HIER_NAME;

Line: 62

    select POSV.ORG_STRUCTURE_VERSION_ID
    from PER_ORGANIZATION_STRUCTURES POS,
         PER_ORG_STRUCTURE_VERSIONS POSV
    where POS.NAME = X_ORG_HIER_NAME
    and POS.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID
    and POSV.VERSION_NUMBER = X_ORG_HIER_VERSION;

Line: 118

procedure INSERT_ROW (
  X_CALENDAR_ENTRY_ID in NUMBER,
  X_NAME in VARCHAR2,
  X_TYPE in VARCHAR2,
  X_START_DATE in DATE,
  X_END_DATE in DATE,
  X_START_HOUR in VARCHAR2,
  X_START_MIN in VARCHAR2,
  X_END_HOUR in VARCHAR2,
  X_END_MIN in VARCHAR2,
  X_HIERARCHY_ID in NUMBER,
  X_VALUE_SET_ID in NUMBER,
  X_ORG_STRUCT_ID in NUMBER,
  X_ORG_STRUCT_VER_ID in NUMBER,
  X_DESCRIPTION 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,
  X_BUS_GRP_ID in NUMBER,
  X_IDENTIFIER_KEY in VARCHAR2,
  X_LEGISLATION_CODE in VARCHAR2
) is
  cursor C is select ROWID from PER_CALENDAR_ENTRIES
    where CALENDAR_ENTRY_ID = X_CALENDAR_ENTRY_ID
    ;

Line: 147

  insert into PER_CALENDAR_ENTRIES (
    CALENDAR_ENTRY_ID,
    NAME,
    TYPE,
    START_DATE,
    END_DATE,
    START_HOUR,
    START_MIN,
    END_HOUR,
    END_MIN,
    HIERARCHY_ID,
    VALUE_SET_ID,
    ORGANIZATION_STRUCTURE_ID,
    ORG_STRUCTURE_VERSION_ID,
    DESCRIPTION,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    BUSINESS_GROUP_ID,
    IDENTIFIER_KEY,
    LEGISLATION_CODE
  ) values (
    X_CALENDAR_ENTRY_ID,
    X_NAME,
    X_TYPE,
    X_START_DATE,
    X_END_DATE,
    X_START_HOUR,
    X_START_MIN,
    X_END_HOUR,
    X_END_MIN,
    X_HIERARCHY_ID,
    X_VALUE_SET_ID,
    X_ORG_STRUCT_ID,
    X_ORG_STRUCT_VER_ID,
    X_DESCRIPTION,
    1,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_BUS_GRP_ID,
    X_IDENTIFIER_KEY,
    X_LEGISLATION_CODE
  );

Line: 205

end INSERT_ROW;

Line: 226

  X_LAST_UPDATE_DATE                    in VARCHAR2)

is

  X_ROWID ROWID;

Line: 263

   PER_CALENDAR_ENTRIES_LOAD_PKG.UPDATE_ROW (
     X_CALENDAR_ENTRY_ID         => X_CALENDAR_ENTRY_ID
    ,X_NAME 		         => X_NAME
    ,X_TYPE                      => X_TYPE
    ,X_START_DATE                => to_date(X_START_DATE,'DD/MM/YYYY')
    ,X_END_DATE                  => to_date(X_END_DATE,'DD/MM/YYYY')
    ,X_START_HOUR                => X_START_HOUR
    ,X_START_MIN                 => X_START_MIN
    ,X_END_HOUR                  => X_END_HOUR
    ,X_END_MIN                   => X_END_MIN
    ,X_VALUE_SET_ID              => X_VALUE_SET_ID
    ,X_HIERARCHY_ID              => X_HIERARCHY_ID
    ,X_ORG_STRUCT_ID             => X_ORG_STRUCT_ID
    ,X_ORG_STRUCT_VER_ID         => X_ORG_STRUCT_VER_ID
    ,X_DESCRIPTION               => X_DESCRIPTION
    ,X_LAST_UPDATE_DATE 	 => sysdate
    ,X_LAST_UPDATED_BY 	  	 => user_id
    ,X_LAST_UPDATE_LOGIN 	 => user_id);  -- note: ID Key, and LEG Code are not updateable

Line: 287

    PER_CALENDAR_ENTRIES_LOAD_PKG.INSERT_ROW (
     X_CALENDAR_ENTRY_ID         => X_CALENDAR_ENTRY_ID
    ,X_NAME                      => X_NAME
    ,X_TYPE                      => X_TYPE
    ,X_START_DATE                => to_date(X_START_DATE,'DD/MM/YYYY')
    ,X_END_DATE                  => to_date(X_END_DATE,'DD/MM/YYYY')
    ,X_START_HOUR                => X_START_HOUR
    ,X_START_MIN                 => X_START_MIN
    ,X_END_HOUR                  => X_END_HOUR
    ,X_END_MIN                   => X_END_MIN
    ,X_VALUE_SET_ID              => X_VALUE_SET_ID
    ,X_HIERARCHY_ID              => X_HIERARCHY_ID
    ,X_ORG_STRUCT_ID             => X_ORG_STRUCT_ID
    ,X_ORG_STRUCT_VER_ID         => X_ORG_STRUCT_VER_ID
    ,X_DESCRIPTION               => X_DESCRIPTION
    ,X_LAST_UPDATE_DATE          => sysdate
    ,X_LAST_UPDATED_BY           => user_id
    ,X_LAST_UPDATE_LOGIN         => 0
    ,X_CREATION_DATE 		 => SYSDATE
    ,X_CREATED_BY   		 => user_id
    ,X_BUS_GRP_ID                => X_BUS_GRP_ID
    ,X_IDENTIFIER_KEY            => X_IDENTIFIER_KEY
    ,X_LEGISLATION_CODE          => X_LEGISLATION_CODE);

Line: 313

procedure UPDATE_ROW (
  X_CALENDAR_ENTRY_ID                   in NUMBER,
  X_NAME                                in VARCHAR2,
  X_TYPE                                in VARCHAR2,
  X_START_DATE                          in DATE,
  X_END_DATE                            in DATE,
  X_START_HOUR                          in VARCHAR2,
  X_START_MIN                           in VARCHAR2,
  X_END_HOUR                            in VARCHAR2,
  X_END_MIN                             in VARCHAR2,
  X_HIERARCHY_ID                        in NUMBER,
  X_VALUE_SET_ID                        in NUMBER,
  X_ORG_STRUCT_ID                       in NUMBER,
  X_ORG_STRUCT_VER_ID                   in NUMBER,
  X_DESCRIPTION                         in VARCHAR2,
  X_LAST_UPDATE_DATE                    in DATE,
  X_LAST_UPDATED_BY                     in NUMBER,
  X_LAST_UPDATE_LOGIN                   in NUMBER) is
begin
  update PER_CALENDAR_ENTRIES set
    NAME = X_NAME,
    TYPE = X_TYPE,
    START_DATE = X_START_DATE,
    END_DATE = X_END_DATE,
    START_HOUR = X_START_HOUR,
    START_MIN = X_START_MIN,
    END_HOUR = X_END_HOUR,
    END_MIN = X_END_MIN,
    HIERARCHY_ID = HIERARCHY_ID,
    VALUE_SET_ID = X_VALUE_SET_ID,
    ORGANIZATION_STRUCTURE_ID = X_ORG_STRUCT_ID,
    ORG_STRUCTURE_VERSION_ID = X_ORG_STRUCT_VER_ID,
    DESCRIPTION = X_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where CALENDAR_ENTRY_ID = X_CALENDAR_ENTRY_ID;

Line: 355

end UPDATE_ROW;