APPS.JUMF_LCT_PKG dependencies on JTF_UM_USERTYPE_TMPL

Line 331: from JTF_UM_USERTYPE_TMPL

327: return;
328: else
329: select count(*)
330: into v_active_record_count
331: from JTF_UM_USERTYPE_TMPL
332: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
333: and EFFECTIVE_END_DATE is NULL
334: and LAST_UPDATED_BY <> 1;
335:

Line 342: from JTF_UM_USERTYPE_TMPL

338: end if;
339:
340: select LAST_UPDATED_BY
341: into v_db_owner_id
342: from JTF_UM_USERTYPE_TMPL
343: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
344: and TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
345: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
346:

Line 364: update JTF_UM_USERTYPE_TMPL

360:
361: exception
362: when no_data_found then
363:
364: update JTF_UM_USERTYPE_TMPL
365: set EFFECTIVE_END_DATE = SYSDATE
366: where EFFECTIVE_END_DATE is NULL
367: and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
368: