APPS.JTF_UM_USERTYPES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_USERTYPE_ID out NOCOPY NUMBER,
  X_EFFECTIVE_END_DATE in DATE,
  X_APPROVAL_ID in NUMBER,
  X_APPLICATION_ID in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_EMAIL_NOTIFICATION_FLAG in VARCHAR2,
  X_IS_SELF_SERVICE_FLAG in VARCHAR2,
  X_EFFECTIVE_START_DATE in DATE,
  X_USERTYPE_KEY in VARCHAR2,
  X_USERTYPE_NAME in VARCHAR2,
  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_USERTYPE_SHORTNAME in VARCHAR2,
  X_DISPLAY_ORDER in NUMBER
) is
  cursor C is select ROWID from JTF_UM_USERTYPES_B
    where USERTYPE_ID = X_USERTYPE_ID
    ;

Line: 27

  insert into JTF_UM_USERTYPES_B (
    EFFECTIVE_END_DATE,
    APPROVAL_ID,
    APPLICATION_ID,
    ENABLED_FLAG,
    EMAIL_NOTIFICATION_FLAG,
    IS_SELF_SERVICE_FLAG,
    EFFECTIVE_START_DATE,
    USERTYPE_ID,
    USERTYPE_KEY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    DISPLAY_ORDER
  ) values (
    X_EFFECTIVE_END_DATE,
    X_APPROVAL_ID,
    X_APPLICATION_ID,
    X_ENABLED_FLAG,
    X_EMAIL_NOTIFICATION_FLAG,
    X_IS_SELF_SERVICE_FLAG,
    X_EFFECTIVE_START_DATE,
    JTF_UM_USERTYPES_B_S.NEXTVAL,
    X_USERTYPE_KEY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_DISPLAY_ORDER
  ) RETURNING USERTYPE_ID INTO X_USERTYPE_ID;

Line: 61

  insert into JTF_UM_USERTYPES_TL (
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    USERTYPE_NAME,
    DESCRIPTION,
    CREATION_DATE,
    USERTYPE_ID,
    LANGUAGE,
    SOURCE_LANG,
    USERTYPE_SHORTNAME
  ) select
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_USERTYPE_NAME,
    X_DESCRIPTION,
    X_CREATION_DATE,
    X_USERTYPE_ID,
    L.LANGUAGE_CODE,
    userenv('LANG'),
    X_USERTYPE_SHORTNAME
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from JTF_UM_USERTYPES_TL T
    where T.USERTYPE_ID = X_USERTYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 100

end INSERT_ROW;

Line: 115

  cursor c is select
      EFFECTIVE_END_DATE,
      APPROVAL_ID,
      APPLICATION_ID,
      ENABLED_FLAG,
      EMAIL_NOTIFICATION_FLAG,
      IS_SELF_SERVICE_FLAG,
      EFFECTIVE_START_DATE,
      USERTYPE_KEY
    from JTF_UM_USERTYPES_B
    where USERTYPE_ID = X_USERTYPE_ID
    for update of USERTYPE_ID nowait;

Line: 129

  cursor c1 is select
      USERTYPE_NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from JTF_UM_USERTYPES_TL
    where USERTYPE_ID = X_USERTYPE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of USERTYPE_ID nowait;

Line: 142

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 178

procedure UPDATE_ROW (
  X_USERTYPE_ID in NUMBER,
  X_EFFECTIVE_END_DATE in DATE,
  X_APPROVAL_ID in NUMBER,
  X_APPLICATION_ID in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_EMAIL_NOTIFICATION_FLAG in VARCHAR2,
  X_IS_SELF_SERVICE_FLAG in VARCHAR2,
  X_USERTYPE_KEY in VARCHAR2,
  X_USERTYPE_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_USERTYPE_SHORTNAME in VARCHAR2,
  X_DISPLAY_ORDER in NUMBER
) is
begin
  update JTF_UM_USERTYPES_B set
    EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,
    APPROVAL_ID = X_APPROVAL_ID,
    APPLICATION_ID = X_APPLICATION_ID,
    ENABLED_FLAG = X_ENABLED_FLAG,
    EMAIL_NOTIFICATION_FLAG = X_EMAIL_NOTIFICATION_FLAG,
    IS_SELF_SERVICE_FLAG = X_IS_SELF_SERVICE_FLAG,
    USERTYPE_KEY = X_USERTYPE_KEY,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    DISPLAY_ORDER = X_DISPLAY_ORDER
  where USERTYPE_ID = X_USERTYPE_ID;

Line: 214

  update JTF_UM_USERTYPES_TL set
    USERTYPE_NAME = X_USERTYPE_NAME,
    DESCRIPTION = X_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG'),
    USERTYPE_SHORTNAME = X_USERTYPE_SHORTNAME
  where USERTYPE_ID = X_USERTYPE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 228

end UPDATE_ROW;

Line: 230

procedure DELETE_ROW (
  X_USERTYPE_ID in NUMBER
) is
begin
  delete from JTF_UM_USERTYPES_TL
  where USERTYPE_ID = X_USERTYPE_ID;

Line: 241

  delete from JTF_UM_USERTYPES_B
  where USERTYPE_ID = X_USERTYPE_ID;

Line: 247

end DELETE_ROW;

Line: 252

  delete from JTF_UM_USERTYPES_TL T
  where not exists
    (select NULL
    from JTF_UM_USERTYPES_B B
    where B.USERTYPE_ID = T.USERTYPE_ID
    );

Line: 259

  update JTF_UM_USERTYPES_TL T set (
      USERTYPE_NAME,
      DESCRIPTION,
      USERTYPE_SHORTNAME
    ) = (select
      B.USERTYPE_NAME,
      B.DESCRIPTION,
      B.USERTYPE_SHORTNAME
    from JTF_UM_USERTYPES_TL B
    where B.USERTYPE_ID = T.USERTYPE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.USERTYPE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.USERTYPE_ID,
      SUBT.LANGUAGE
    from JTF_UM_USERTYPES_TL SUBB, JTF_UM_USERTYPES_TL SUBT
    where SUBB.USERTYPE_ID = SUBT.USERTYPE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.USERTYPE_NAME <> SUBT.USERTYPE_NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or SUBB.USERTYPE_SHORTNAME <> SUBT.USERTYPE_SHORTNAME
  ));

Line: 284

  insert into JTF_UM_USERTYPES_TL (
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    USERTYPE_NAME,
    DESCRIPTION,
    CREATION_DATE,
    USERTYPE_ID,
    LANGUAGE,
    SOURCE_LANG,
    USERTYPE_SHORTNAME
  ) select
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.USERTYPE_NAME,
    B.DESCRIPTION,
    B.CREATION_DATE,
    B.USERTYPE_ID,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG,
    B.USERTYPE_SHORTNAME
  from JTF_UM_USERTYPES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from JTF_UM_USERTYPES_TL T
    where T.USERTYPE_ID = B.USERTYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 336

    x_last_update_date       in varchar2 default NULL,
    X_CUSTOM_MODE            in varchar2 default NULL
) is
        l_user_id NUMBER :=  fnd_load_util.owner_id(x_owner);

Line: 342

         f_ludate  date;    -- entity update date in file

Line: 344

         db_ludate date;    -- entity update date in db

Line: 357

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

Line: 361

           INSERT_ROW(
		X_USERTYPE_ID 		=> l_usertype_id,
                X_EFFECTIVE_START_DATE 	=> X_EFFECTIVE_START_DATE,
		X_EFFECTIVE_END_DATE 	=> X_EFFECTIVE_END_DATE,
		X_APPROVAL_ID 		=> X_APPROVAL_ID,
		X_APPLICATION_ID 	=> X_APPLICATION_ID,
		X_ENABLED_FLAG 		=> X_ENABLED_FLAG,
		X_EMAIL_NOTIFICATION_FLAG => X_EMAIL_NOTIFICATION_FLAG,
		X_IS_SELF_SERVICE_FLAG	=> X_IS_SELF_SERVICE_FLAG,
		X_USERTYPE_KEY		=> X_USERTYPE_KEY,
		X_USERTYPE_NAME		=> X_USERTYPE_NAME,
		X_DESCRIPTION		=> X_DESCRIPTION,
                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     => l_user_id,
                X_USERTYPE_SHORTNAME    => X_USERTYPE_SHORTNAME,
                X_DISPLAY_ORDER         => X_DISPLAY_ORDER

             );

Line: 386

             select LAST_UPDATED_BY, LAST_UPDATE_DATE
               into db_luby, db_ludate
               FROM JTF_UM_USERTYPES_B
              where USERTYPE_ID = X_USERTYPE_ID;

Line: 394

                    UPDATE_ROW(
		          X_USERTYPE_ID 		=> X_USERTYPE_ID,
		          X_EFFECTIVE_END_DATE 	=> X_EFFECTIVE_END_DATE,
		          X_APPROVAL_ID 		=> X_APPROVAL_ID,
		          X_APPLICATION_ID 	=> X_APPLICATION_ID,
		          X_ENABLED_FLAG 		=> X_ENABLED_FLAG,
		          X_EMAIL_NOTIFICATION_FLAG => X_EMAIL_NOTIFICATION_FLAG,
		          X_IS_SELF_SERVICE_FLAG	=> X_IS_SELF_SERVICE_FLAG,
		          X_USERTYPE_KEY		=> X_USERTYPE_KEY,
		          X_USERTYPE_NAME		=> X_USERTYPE_NAME,
		          X_DESCRIPTION		=> X_DESCRIPTION,
                          X_LAST_UPDATE_DATE      => f_ludate,
                          X_LAST_UPDATED_BY       => f_luby,
                          X_LAST_UPDATE_LOGIN     => l_user_id,
                          X_USERTYPE_SHORTNAME    => X_USERTYPE_SHORTNAME,
                          X_DISPLAY_ORDER         => X_DISPLAY_ORDER
                       );

Line: 414

	    select LAST_UPDATED_BY, DISPLAY_ORDER, USERTYPE_SHORTNAME
            into v_db_owner_id, v_db_display_order, v_db_usertype_shortname
            from JTF_UM_USERTYPES_VL
            where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, X_EFFECTIVE_START_DATE);

Line: 423

                UPDATE_ROW_SPECIAL(
  		  X_USERTYPE_ID		=> JTF_UMUTIL.usertype_lookup(x_usertype_key, X_EFFECTIVE_START_DATE),
  		  X_USERTYPE_NAME => x_usertype_name,
                  X_USERTYPE_SHORTNAME => NVL(x_usertype_shortname, 'CHANGE ME IN THE ADMIN CONSOLE: USERTYPE SETUP SCREEN'),
                  X_DISPLAY_ORDER => x_display_order,
  		  X_OWNER => x_owner);

Line: 437

CURSOR C IS SELECT USERTYPE_ID FROM JTF_UM_USERTYPE_TMPL WHERE USERTYPE_ID = X_USERTYPE_ID AND TEMPLATE_ID = X_TEMPLATE_ID AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE);

Line: 455

   UPDATE JTF_UM_USERTYPE_TMPL SET
   EFFECTIVE_END_DATE = SYSDATE,
   LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
   LAST_UPDATE_DATE= SYSDATE
   WHERE USERTYPE_ID = X_USERTYPE_ID;

Line: 469

   X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
) is
begin

INSERT INTO JTF_UM_USERTYPE_TMPL(
            USERTYPE_ID,
	    TEMPLATE_ID,
	    EFFECTIVE_START_DATE,
	    EFFECTIVE_END_DATE,
	    CREATED_BY,
	    CREATION_DATE,
	    LAST_UPDATED_BY,
	    LAST_UPDATE_DATE)
      VALUES(
             X_USERTYPE_ID,
	     X_TEMPLATE_ID,
	     X_EFFECTIVE_START_DATE,
	     X_EFFECTIVE_END_DATE,
	     X_CREATED_BY,
	     SYSDATE,
	     X_LAST_UPDATED_BY,
	     SYSDATE
	     );

Line: 507

procedure UPDATE_TEMPLATE_ASSIGNMENT(
   X_USERTYPE_ID IN NUMBER,
   X_TEMPLATE_ID IN NUMBER,
   X_EFFECTIVE_START_DATE IN DATE,
   X_EFFECTIVE_END_DATE IN DATE,
   X_LAST_UPDATE_DATE IN DATE,
   X_LAST_UPDATED_BY IN NUMBER,
   X_LAST_UPDATE_LOGIN IN NUMBER
) is
begin
	update JTF_UM_USERTYPE_TMPL
	set EFFECTIVE_END_DATE=X_EFFECTIVE_END_DATE,
	    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
	    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
	    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
	where  USERTYPE_ID = X_USERTYPE_ID
	and    TEMPLATE_ID = X_TEMPLATE_ID
	and    EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;

Line: 526

end UPDATE_TEMPLATE_ASSIGNMENT;

Line: 534

    x_last_update_date       in varchar2 default NULL,
    X_CUSTOM_MODE            in varchar2 default NULL
) is
        l_user_id NUMBER :=  fnd_load_util.owner_id(x_owner);

Line: 540

  f_ludate  date;    -- entity update date in file

Line: 542

  db_ludate date;    -- entity update date in db

Line: 548

        select count(*)
        into   h_record_exists
        from   jtf_UM_USERTYPE_TMPL
	where  USERTYPE_ID = X_USERTYPE_ID
	and    TEMPLATE_ID = X_TEMPLATE_ID
	and    EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;

Line: 559

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

Line: 572

                X_LAST_UPDATED_BY       => f_luby
             );

Line: 578

             select LAST_UPDATED_BY, LAST_UPDATE_DATE
               into db_luby, db_ludate
               FROM JTF_UM_USERTYPE_TMPL
              where USERTYPE_ID = X_USERTYPE_ID
	         and    TEMPLATE_ID = X_TEMPLATE_ID
	         and    EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;

Line: 587

                    UPDATE_TEMPLATE_ASSIGNMENT(
                         X_USERTYPE_ID           => X_USERTYPE_ID,
                         X_TEMPLATE_ID           => X_TEMPLATE_ID,
                         X_EFFECTIVE_START_DATE  => X_EFFECTIVE_START_DATE,
                         X_EFFECTIVE_END_DATE    => X_EFFECTIVE_END_DATE,
                         X_LAST_UPDATE_DATE      => f_ludate,
                         X_LAST_UPDATED_BY       => f_luby,
                         X_LAST_UPDATE_LOGIN     => l_user_id
                      );

Line: 610

   UPDATE JTF_UM_USERTYPE_SUBSCRIP SET
   EFFECTIVE_END_DATE = SYSDATE,
   LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
   LAST_UPDATE_DATE= SYSDATE
   WHERE USERTYPE_ID = X_USERTYPE_ID
   AND   SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;

Line: 627

   X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
) is
begin
INSERT INTO JTF_UM_USERTYPE_SUBSCRIP(
            USERTYPE_ID,
	    SUBSCRIPTION_ID,
	    SUBSCRIPTION_FLAG,
	    SUBSCRIPTION_DISPLAY_ORDER,
	    EFFECTIVE_START_DATE,
	    EFFECTIVE_END_DATE,
	    CREATED_BY,
	    CREATION_DATE,
	    LAST_UPDATED_BY,
	    LAST_UPDATE_DATE)
      VALUES(
             X_USERTYPE_ID,
	     X_SUBSCRIPTION_ID,
	     X_SUBSCRIPTION_FLAG,
	     X_DISPLAY_ORDER,
	     X_EFFECTIVE_START_DATE,
	     X_EFFECTIVE_END_DATE,
	     X_CREATED_BY,
	     SYSDATE,
	     X_LAST_UPDATED_BY,
	     SYSDATE
	     );

Line: 655

procedure UPDATE_SUBSCRIPTION_ASSIGNMENT(
   X_USERTYPE_ID NUMBER,
   X_SUBSCRIPTION_ID NUMBER,
   X_SUBSCRIPTION_FLAG VARCHAR2,
   X_DISPLAY_ORDER NUMBER
) is
begin
	update JTF_UM_USERTYPE_SUBSCRIP
	set SUBSCRIPTION_FLAG=X_SUBSCRIPTION_FLAG,
    	    SUBSCRIPTION_DISPLAY_ORDER = X_DISPLAY_ORDER
	where  USERTYPE_ID = X_USERTYPE_ID
	and    SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;

Line: 668

end UPDATE_SUBSCRIPTION_ASSIGNMENT;

Line: 670

procedure UPDATE_SUBSCRIPTION_ASSIGNMENT(
   X_USERTYPE_ID 		IN NUMBER,
   X_SUBSCRIPTION_ID 		IN NUMBER,
   X_SUBSCRIPTION_FLAG 		IN VARCHAR2,
   X_DISPLAY_ORDER 		IN NUMBER,
   X_EFFECTIVE_START_DATE 	IN DATE,
   X_EFFECTIVE_END_DATE 	IN DATE,
   X_LAST_UPDATE_DATE	  	IN DATE,
   X_LAST_UPDATED_BY  		IN NUMBER,
   X_LAST_UPDATE_LOGIN 		IN NUMBER
) is
begin
        update JTF_UM_USERTYPE_SUBSCRIP
        set SUBSCRIPTION_FLAG=X_SUBSCRIPTION_FLAG,
            SUBSCRIPTION_DISPLAY_ORDER = X_DISPLAY_ORDER,
	    EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,
	    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
	    LAST_UPDATED_BY  = X_LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
        where  USERTYPE_ID = X_USERTYPE_ID
        and    SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
        and    EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;

Line: 693

end UPDATE_SUBSCRIPTION_ASSIGNMENT;

Line: 704

    x_last_update_date       in varchar2 default NULL,
    X_CUSTOM_MODE            in varchar2 default NULL
) is
        l_user_id NUMBER :=  fnd_load_util.owner_id(x_owner);

Line: 710

  f_ludate  date;    -- entity update date in file

Line: 712

  db_ludate date;    -- entity update date in db

Line: 718

        select count(*)
        into   h_record_exists
        from   jtf_UM_USERTYPE_SUBSCRIP
        where  USERTYPE_ID = X_USERTYPE_ID
        and    SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
        and    EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;

Line: 729

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

Line: 743

                X_LAST_UPDATED_BY       => f_luby
             );

Line: 749

             select LAST_UPDATED_BY, LAST_UPDATE_DATE
	      into db_luby, db_ludate
	      FROM JTF_UM_USERTYPE_SUBSCRIP
	     where USERTYPE_ID = X_USERTYPE_ID
		and    SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
		and    EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;

Line: 758

		   UPDATE_SUBSCRIPTION_ASSIGNMENT(
			X_USERTYPE_ID           => X_USERTYPE_ID,
			X_SUBSCRIPTION_ID       => X_SUBSCRIPTION_ID,
			X_SUBSCRIPTION_FLAG     => X_SUBSCRIPTION_FLAG,
			X_DISPLAY_ORDER       	=> X_DISPLAY_ORDER,
			X_EFFECTIVE_START_DATE  => X_EFFECTIVE_START_DATE,
			X_EFFECTIVE_END_DATE    => X_EFFECTIVE_END_DATE,
			X_LAST_UPDATE_DATE      => f_ludate,
			X_LAST_UPDATED_BY       => f_luby,
			X_LAST_UPDATE_LOGIN     => l_user_id
		     );

Line: 781

  x_last_update_date       in varchar2 default NULL,
  X_CUSTOM_MODE            in varchar2 default NULL
)

is
  f_luby    number;  -- entity owner in file

Line: 787

  f_ludate  date;    -- entity update date in file

Line: 789

  db_ludate date;    -- entity update date in db

Line: 798

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

Line: 803

      select LAST_UPDATED_BY, LAST_UPDATE_DATE
      into db_luby, db_ludate
      FROM JTF_UM_USERTYPES_TL
      where USERTYPE_ID = X_USERTYPE_ID
      and LANGUAGE = userenv('LANG');

Line: 812

           update JTF_UM_USERTYPES_TL set
	        USERTYPE_NAME 	  = X_USERTYPE_NAME,
	        DESCRIPTION       = X_DESCRIPTION,
	        LAST_UPDATE_DATE  = f_ludate,
	        LAST_UPDATED_BY   = f_luby,
	        LAST_UPDATE_LOGIN = 0,
                USERTYPE_SHORTNAME = X_USERTYPE_SHORTNAME,
	        SOURCE_LANG       = userenv('LANG')
          where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
  	        and USERTYPE_ID = X_USERTYPE_ID;

Line: 827

procedure INSERT_UMREG_ROW (
  X_USERTYPE_ID in NUMBER,
  X_LAST_APPROVER_COMMENT in VARCHAR2,
  X_APPROVER_USER_ID in NUMBER,
  X_EFFECTIVE_END_DATE in DATE,
  X_WF_ITEM_TYPE in VARCHAR2,
  X_EFFECTIVE_START_DATE in DATE,
  X_USERTYPE_REG_ID out NOCOPY NUMBER,
  X_USER_ID in NUMBER,
  X_STATUS_CODE 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

lcnt NUMBER ;

Line: 853

   SELECT COUNT(*) INTO lcnt
   FROM jtf_um_usertype_reg
   WHERE user_id =X_USER_ID and status_code in ( 'PENDING', 'UPGRADE_APPROVAL_PENDING')  --- Changes done for Bug 7291138 / bug 6617457
   AND NVL(effective_end_date, SYSDATE + 1) > SYSDATE;

Line: 864

   UPDATE jtf_um_usertype_reg
   SET effective_end_date=SYSDATE
   WHERE user_id =X_USER_ID and status_code in ( 'APPROVED', 'UPGRADE')   --- Changes done for Bug 7291138 / bug 6617457
   AND NVL(effective_end_date, SYSDATE + 1) > SYSDATE;

Line: 871

  insert into JTF_UM_USERTYPE_REG (
    LAST_APPROVER_COMMENT,
    APPROVER_USER_ID,
    EFFECTIVE_END_DATE,
    WF_ITEM_TYPE,
    EFFECTIVE_START_DATE,
    USERTYPE_REG_ID,
    USERTYPE_ID,
    USER_ID,
    STATUS_CODE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_LAST_APPROVER_COMMENT,
    X_APPROVER_USER_ID,
    X_EFFECTIVE_END_DATE,
    X_WF_ITEM_TYPE,
    X_EFFECTIVE_START_DATE,
    JTF_UM_UT_SUBSC_REG_S.NEXTVAL,
    X_USERTYPE_ID,
    X_USER_ID,
    X_STATUS_CODE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  ) RETURNING USERTYPE_REG_ID INTO X_USERTYPE_REG_ID;

Line: 902

end INSERT_UMREG_ROW;

Line: 904

procedure UPDATE_ROW_SPECIAL (
  X_OWNER in VARCHAR2,
  X_USERTYPE_ID in NUMBER,
  X_USERTYPE_NAME in VARCHAR2,
  X_USERTYPE_SHORTNAME in VARCHAR2,
  X_DISPLAY_ORDER in NUMBER
) is
        l_user_id NUMBER :=  fnd_load_util.owner_id(x_owner);

Line: 916

  update JTF_UM_USERTYPES_B set
    LAST_UPDATE_LOGIN = l_user_id,
    LAST_UPDATE_DATE = SYSDATE,
    DISPLAY_ORDER = X_DISPLAY_ORDER
  where USERTYPE_ID = X_USERTYPE_ID;

Line: 926

  update JTF_UM_USERTYPES_TL set
    USERTYPE_NAME = X_USERTYPE_NAME,
    LAST_UPDATED_BY = l_user_id,
    LAST_UPDATE_LOGIN = l_user_id,
    LAST_UPDATE_DATE = SYSDATE,
    SOURCE_LANG = userenv('LANG'),
    USERTYPE_SHORTNAME = X_USERTYPE_SHORTNAME
  where USERTYPE_ID = X_USERTYPE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 939

end UPDATE_ROW_SPECIAL;