APPS.JTF_UM_WF_DELEGATION_PVT dependencies on JTF_UM_USERTYPE_SUBSCRIP

Line 200: l_sub_flag jtf_um_usertype_subscrip.subscription_flag%type;

196: p_usertype_id in number,
197: x_result out NOCOPY boolean) is
198:
199: l_procedure_name CONSTANT varchar2 (23) := 'can_enrollment_delegate';
200: l_sub_flag jtf_um_usertype_subscrip.subscription_flag%type;
201:
202: cursor get_subscription_flag is
203: select subscription_flag
204: from jtf_um_usertype_subscrip

Line 204: from jtf_um_usertype_subscrip

200: l_sub_flag jtf_um_usertype_subscrip.subscription_flag%type;
201:
202: cursor get_subscription_flag is
203: select subscription_flag
204: from jtf_um_usertype_subscrip
205: where usertype_id = p_usertype_id
206: and subscription_id = p_subscription_id
207: and effective_start_date <= sysdate
208: and nvl (effective_end_date, sysdate + 1) > sysdate;

Line 408: l_activation_mode JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE;

404: l_procedure_name CONSTANT varchar2(30) := 'get_checkbox_status';
405: l_delegation_role_id JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID%TYPE;
406: l_has_user_enrollment number;
407: query_user_has_roles number :=0;
408: l_activation_mode JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE;
409: l_user_has_role boolean := false;
410:
411: -- This query will find out the active user type to subscription mapping
412: -- If no active mapping exists, then it will pick up the latest record

Line 415: CURSOR FIND_ACTIVATION_MODE IS SELECT SUBSCRIPTION_FLAG FROM JTF_UM_USERTYPE_SUBSCRIP

411: -- This query will find out the active user type to subscription mapping
412: -- If no active mapping exists, then it will pick up the latest record
413: -- which has been end dated
414:
415: CURSOR FIND_ACTIVATION_MODE IS SELECT SUBSCRIPTION_FLAG FROM JTF_UM_USERTYPE_SUBSCRIP
416: WHERE SUBSCRIPTION_ID = p_subscription_id
417: AND USERTYPE_ID = p_usertype_id
418: ORDER BY EFFECTIVE_END_DATE DESC;
419: