The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date in varchar2 ,
x_custom_mode in varchar2
)
is
v_db_owner_id number;
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode );
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2 )
is
v_db_owner_id number;
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2 )
is
v_db_owner_id number;
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2
)
is
v_db_owner_id number;
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
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'));
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2
)
is
v_db_owner_id number;
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;
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');
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
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'));
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2
)
is
v_db_owner_id number;
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2
)
is
v_db_owner_id number;
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;
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');
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
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'));
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2
)
is
v_db_owner_id number;
x_last_update_date => x_last_update_date ,
x_custom_mode => x_custom_mode);
X_LAST_UPDATE_DATE => x_last_update_date,
X_CUSTOM_MODE => x_custom_mode
);
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2
)
is
v_db_owner_id number;
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;
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');
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
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'));
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2
)
is
v_db_owner_id number;
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2)
is
v_db_owner_id number;
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
x_last_update_date in varchar2,
x_custom_mode in varchar2
)
is
v_db_owner_id number;
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;
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);
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'));
X_LAST_UPDATE_DATE => x_last_update_date ,
X_CUSTOM_MODE => x_custom_mode
);