APPS.JTF_UM_WF_DELEGATION_PVT dependencies on JTF_UM_SUBSCRIPTIONS_B

Line 405: l_delegation_role_id JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID%TYPE;

401: x_result out NOCOPY number
402: ) IS
403:
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;

Line 822: l_delegation_role_id JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID%TYPE;

818: and nvl(UTREG.effective_end_date,sysdate+1) > sysdate;
819:
820: l_grant_delegation_flag JTF_UM_SUBSCRIPTION_REG.GRANT_DELEGATION_FLAG%TYPE;
821: l_subscription_id JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_ID%TYPE;
822: l_delegation_role_id JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID%TYPE;
823: l_flag_boolean boolean := false;
824: l_usertype_id number;
825:
826: BEGIN

Line 912: l_delegation_role_id JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID%TYPE;

908: p_usertype_id in number,
909: x_result out NOCOPY number
910: ) IS
911:
912: l_delegation_role_id JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID%TYPE;
913: l_procedure_name CONSTANT varchar2(30) := 'get_checkbox_status_reg';
914:
915: BEGIN
916: