APPS.JUMF_LCT_PKG SQL Statements

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

Line: 16

 x_last_update_date      in varchar2 ,
 x_custom_mode        in varchar2
)
is

         v_db_owner_id number;

Line: 30

	    X_LAST_UPDATE_DATE => x_last_update_date,
	    X_CUSTOM_MODE => x_custom_mode
	    );

Line: 53

		X_LAST_UPDATE_DATE => x_last_update_date,
	        X_CUSTOM_MODE => x_custom_mode 		 );

Line: 73

                X_LAST_UPDATE_DATE => x_last_update_date,
	        X_CUSTOM_MODE => x_custom_mode
		);

Line: 92

x_last_update_date in varchar2,
x_custom_mode in varchar2 )

is

         v_db_owner_id number;

Line: 106

	    X_LAST_UPDATE_DATE => x_last_update_date,
	    X_CUSTOM_MODE => x_custom_mode
	    );

Line: 128

		X_LAST_UPDATE_DATE => x_last_update_date,
	        X_CUSTOM_MODE => x_custom_mode
		);

Line: 148

		 X_LAST_UPDATE_DATE => x_last_update_date,
	    X_CUSTOM_MODE => x_custom_mode
		);

Line: 165

    x_last_update_date in varchar2,
    x_custom_mode      in varchar2 )

    is

         v_db_owner_id number;

Line: 190

	    X_LAST_UPDATE_DATE => x_last_update_date,
	    X_CUSTOM_MODE => x_custom_mode
	    );

Line: 205

	    X_LAST_UPDATE_DATE => x_last_update_date,
	    X_CUSTOM_MODE => x_custom_mode
	    );

Line: 229

    x_last_update_date in varchar2,
    x_custom_mode in varchar2
    )

    is


         v_db_owner_id number;

Line: 248

	    X_LAST_UPDATE_DATE => x_last_update_date,
	    X_CUSTOM_MODE => x_custom_mode
	    );

Line: 252

            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, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

Line: 274

		X_LAST_UPDATE_DATE => x_last_update_date,
		X_CUSTOM_MODE =>      x_custom_mode
		);

Line: 300

		X_LAST_UPDATE_DATE => x_last_update_date,
		X_CUSTOM_MODE => x_custom_mode
		);

Line: 316

x_last_update_date in varchar2,
x_custom_mode       in varchar2
 )
is

    v_db_owner_id number;

Line: 329

           select count(*)
           into v_active_record_count
           from JTF_UM_USERTYPE_TMPL
           where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
           and EFFECTIVE_END_DATE is NULL
           and LAST_UPDATED_BY <> 1;

Line: 340

           select LAST_UPDATED_BY
           into v_db_owner_id
           from JTF_UM_USERTYPE_TMPL
           where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
           and TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
           and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');

Line: 354

		X_LAST_UPDATE_DATE => x_last_update_date,
		X_CUSTOM_MODE => x_custom_mode
		);

Line: 364

          update JTF_UM_USERTYPE_TMPL
          set EFFECTIVE_END_DATE = SYSDATE
          where EFFECTIVE_END_DATE is NULL
          and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

Line: 375

		X_LAST_UPDATE_DATE => x_last_update_date,
		X_CUSTOM_MODE => x_custom_mode
		);

Line: 390

    x_last_update_date in varchar2,
    x_custom_mode       in varchar2
    )
    is
         v_db_owner_id number;

Line: 415

            X_LAST_UPDATE_DATE => x_last_update_date ,
            X_CUSTOM_MODE => x_custom_mode
	    );

Line: 429

	    X_LAST_UPDATE_DATE => x_last_update_date ,
            X_CUSTOM_MODE => x_custom_mode
            );

Line: 447

x_last_update_date in varchar2,
x_custom_mode       in varchar2
)

is

v_db_owner_id number;

Line: 461

           select count(*)
           into v_active_record_count
           from JTF_UM_USERTYPE_RESP
           where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
           and EFFECTIVE_END_DATE is NULL
           and LAST_UPDATED_BY <> 1;

Line: 472

           select LAST_UPDATED_BY
           into v_db_owner_id
           from JTF_UM_USERTYPE_RESP
           where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
           and RESPONSIBILITY_KEY = x_responsibility_key
           and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');

Line: 488

	       X_LAST_UPDATE_DATE => x_last_update_date ,
               X_CUSTOM_MODE => x_custom_mode

        );

Line: 498

          update JTF_UM_USERTYPE_RESP
          set EFFECTIVE_END_DATE = SYSDATE
          where EFFECTIVE_END_DATE is NULL
          and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

Line: 511

	      X_LAST_UPDATE_DATE => x_last_update_date ,
              X_CUSTOM_MODE => x_custom_mode
          );

Line: 535

x_last_update_date in varchar2,
x_custom_mode   in varchar2

)

is

         v_db_owner_id number;

Line: 551

            x_last_update_date => x_last_update_date ,
            x_custom_mode => x_custom_mode);

Line: 575

		X_LAST_UPDATE_DATE => x_last_update_date,
                X_CUSTOM_MODE => x_custom_mode
		);

Line: 599

		X_LAST_UPDATE_DATE => x_last_update_date ,
                X_CUSTOM_MODE => x_custom_mode
		);

Line: 616

x_last_update_date in varchar2,
x_custom_mode   in varchar2
)

is

v_db_owner_id number;

Line: 630

           select count(*)
           into v_active_record_count
           from JTF_UM_SUBSCRIPTION_TMPL
           where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
           and EFFECTIVE_END_DATE is NULL
           and LAST_UPDATED_BY <> 1;

Line: 641

           select LAST_UPDATED_BY
           into v_db_owner_id
           from JTF_UM_SUBSCRIPTION_TMPL
           where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
           and TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
           and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');

Line: 655

		X_LAST_UPDATE_DATE => x_last_update_date ,
                X_CUSTOM_MODE => x_custom_mode
		);

Line: 664

          update JTF_UM_SUBSCRIPTION_TMPL
          set EFFECTIVE_END_DATE = SYSDATE
          where EFFECTIVE_END_DATE is NULL
          and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

Line: 675

		X_LAST_UPDATE_DATE => x_last_update_date ,
                X_CUSTOM_MODE => x_custom_mode
		);

Line: 695

x_last_update_date in varchar2,
x_custom_mode   in varchar2
)

is

     v_db_owner_id number;

Line: 723

		X_LAST_UPDATE_DATE => x_last_update_date ,
                X_CUSTOM_MODE => x_custom_mode
		);

Line: 739

		X_LAST_UPDATE_DATE => x_last_update_date ,
                X_CUSTOM_MODE => x_custom_mode
		);

Line: 754

x_last_update_date in varchar2,
x_custom_mode   in varchar2)

is

         v_db_owner_id number;

Line: 780

	    X_LAST_UPDATE_DATE => x_last_update_date ,
            X_CUSTOM_MODE => x_custom_mode
          );

Line: 794

	    X_LAST_UPDATE_DATE => x_last_update_date ,
            X_CUSTOM_MODE => x_custom_mode
        );

Line: 810

x_last_update_date in varchar2,
x_custom_mode   in varchar2
)

is

v_db_owner_id number;

Line: 824

           select count(*)
           into v_active_record_count
           from JTF_UM_SUBSCRIPTION_RESP
           where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
           and EFFECTIVE_END_DATE is NULL
           and LAST_UPDATED_BY <> 1;

Line: 850

	       X_LAST_UPDATE_DATE => x_last_update_date ,
               X_CUSTOM_MODE => x_custom_mode
           );

Line: 859

          update JTF_UM_SUBSCRIPTION_RESP
          set EFFECTIVE_END_DATE = SYSDATE
          where EFFECTIVE_END_DATE is NULL
          and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

Line: 871

	       X_LAST_UPDATE_DATE => x_last_update_date ,
               X_CUSTOM_MODE => x_custom_mode
           );