APPS.PV_USER_ROLE_PVT dependencies on JTF_UM_SUBSCRIPTIONS_B

Line 41: cursor find_enrltype is select subscription_id from jtf_um_subscriptions_b

37: l_principal_name VARCHAR2(255);
38: L_ENRLTYPE_KEY VARCHAR2(30);
39:
40:
41: cursor find_enrltype is select subscription_id from jtf_um_subscriptions_b
42: where subscription_key = L_ENRLTYPE_KEY
43: and (effective_end_date is null or effective_end_date > sysdate) ;
44:
45:

Line 47: from jtf_um_subscriptions_b jusb, jtf_um_subscription_role jusr

43: and (effective_end_date is null or effective_end_date > sysdate) ;
44:
45:
46: cursor primary_enroll_roles is select jusr.principal_name
47: from jtf_um_subscriptions_b jusb, jtf_um_subscription_role jusr
48: where subscription_key = L_ENRLTYPE_KEY
49: and jusb.subscription_id = jusr.subscription_id
50: and jusr.effective_start_date <= sysdate
51: and nvl(jusr.effective_end_date, sysdate) >= sysdate

Line 57: from jtf_um_subscriptions_b jusb, jtf_um_subscription_role jusr

53: and nvl(jusb.effective_end_date, sysdate) >= sysdate
54: and jusb.enabled_flag = 'Y';
55:
56: cursor business_enroll_roles is select jusr.principal_name
57: from jtf_um_subscriptions_b jusb, jtf_um_subscription_role jusr
58: where subscription_key = L_ENRLTYPE_KEY
59: and jusb.subscription_id = jusr.subscription_id
60: and jusr.effective_start_date <= sysdate
61: and nvl(jusr.effective_end_date, sysdate) >= sysdate

Line 143: OWNERTABLE_NAME => 'JTF_UM_SUBSCRIPTIONS_B',

139: if P_USERNAME is not null then
140: JTF_AUTH_BULKLOAD_PKG.ASSIGN_ROLE
141: ( USER_NAME => P_USERNAME,
142: ROLE_NAME => l_principal_name,
143: OWNERTABLE_NAME => 'JTF_UM_SUBSCRIPTIONS_B',
144: OWNERTABLE_KEY => l_enrltype_id
145: -- ,APP_ID => 691
146: );
147: end if;

Line 171: OWNERTABLE_NAME => 'JTF_UM_SUBSCRIPTIONS_B',

167: if P_USERNAME is not null then
168: JTF_AUTH_BULKLOAD_PKG.ASSIGN_ROLE
169: ( USER_NAME => P_USERNAME,
170: ROLE_NAME => l_principal_name,
171: OWNERTABLE_NAME => 'JTF_UM_SUBSCRIPTIONS_B',
172: OWNERTABLE_KEY => l_enrltype_id
173: -- ,APP_ID => 691
174: );
175: end if;