APPS.JUMF_LCT_PKG dependencies on JTF_UM_SUBSCRIPTIONS_PKG

Line 546: JTF_UM_SUBSCRIPTIONS_PKG.TRANSLATE_ROW(

542: v_db_owner_id number;
543:
544: BEGIN
545: if ( x_upload_mode = 'NLS' ) then
546: JTF_UM_SUBSCRIPTIONS_PKG.TRANSLATE_ROW(
547: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
548: X_SUBSCRIPTION_NAME => x_subscription_name,
549: X_DESCRIPTION => x_description,
550: X_OWNER => x_owner,

Line 560: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_ROW(

556: -- from JTF_UM_SUBSCRIPTIONS_B
557: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
558:
559: -- if (v_db_owner_id = 1) then
560: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_ROW(
561: X_SUBSCRIPTION_KEY => x_subscription_key,
562: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
563: X_AVAILABILITY_CODE => x_availability_code,
564: X_LOGON_DISPLAY_FREQUENCY => to_number(x_logon_display_frequency),

Line 583: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_ROW(

579: end if;
580:
581: exception
582: when no_data_found then
583: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_ROW(
584: X_SUBSCRIPTION_KEY => x_subscription_key,
585: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
586: X_AVAILABILITY_CODE => x_availability_code,
587: X_LOGON_DISPLAY_FREQUENCY => to_number(x_logon_display_frequency),

Line 649: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_SUBSCRIPTION_TMPL_ROW(

645: and TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
646: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
647:
648: if ( v_active_record_count = 0 ) then
649: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_SUBSCRIPTION_TMPL_ROW(
650: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
651: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
652: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
653: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),

Line 669: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_SUBSCRIPTION_TMPL_ROW(

665: set EFFECTIVE_END_DATE = SYSDATE
666: where EFFECTIVE_END_DATE is NULL
667: and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
668:
669: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_SUBSCRIPTION_TMPL_ROW(
670: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
671: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
672: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
673: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),