APPS.JTF_UM_SUBSCRIPTIONS_PKG dependencies on JTF_UM_SUBSCRIPTIONS_B

Line 27: cursor C is select ROWID from JTF_UM_SUBSCRIPTIONS_B

23: X_LAST_UPDATE_LOGIN in NUMBER,
24: X_AUTH_DELEGATION_ROLE_ID in NUMBER
25: )
26: is
27: cursor C is select ROWID from JTF_UM_SUBSCRIPTIONS_B
28: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
29: ;
30:
31: begin

Line 32: insert into JTF_UM_SUBSCRIPTIONS_B (

28: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
29: ;
30:
31: begin
32: insert into JTF_UM_SUBSCRIPTIONS_B (
33: APPLICATION_ID,
34: EFFECTIVE_START_DATE,
35: SUBSCRIPTION_ID,
36: SUBSCRIPTION_KEY,

Line 52: JTF_UM_SUBSCRIPTIONS_B_S.NEXTVAL,

48: AUTH_DELEGATION_ROLE_ID
49: ) values (
50: X_APPLICATION_ID,
51: X_EFFECTIVE_START_DATE,
52: JTF_UM_SUBSCRIPTIONS_B_S.NEXTVAL,
53: X_SUBSCRIPTION_KEY,
54: X_ENABLED_FLAG,
55: X_EFFECTIVE_END_DATE,
56: X_APPROVAL_ID,

Line 135: from JTF_UM_SUBSCRIPTIONS_B

131: PARENT_SUBSCRIPTION_ID,
132: AVAILABILITY_CODE,
133: LOGON_DISPLAY_FREQUENCY,
134: AUTH_DELEGATION_ROLE_ID
135: from JTF_UM_SUBSCRIPTIONS_B
136: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
137: for update of SUBSCRIPTION_ID nowait;
138: recinfo c%rowtype;
139:

Line 211: update JTF_UM_SUBSCRIPTIONS_B set

207: X_LAST_UPDATE_LOGIN in NUMBER,
208: X_AUTH_DELEGATION_ROLE_ID in NUMBER
209: ) is
210: begin
211: update JTF_UM_SUBSCRIPTIONS_B set
212: APPLICATION_ID = X_APPLICATION_ID,
213: SUBSCRIPTION_KEY = X_SUBSCRIPTION_KEY,
214: ENABLED_FLAG = X_ENABLED_FLAG,
215: EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,

Line 256: delete from JTF_UM_SUBSCRIPTIONS_B

252: if (sql%notfound) then
253: raise no_data_found;
254: end if;
255:
256: delete from JTF_UM_SUBSCRIPTIONS_B
257: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
258:
259: if (sql%notfound) then
260: raise no_data_found;

Line 270: from JTF_UM_SUBSCRIPTIONS_B B

266: begin
267: delete from JTF_UM_SUBSCRIPTIONS_TL T
268: where not exists
269: (select NULL
270: from JTF_UM_SUBSCRIPTIONS_B B
271: where B.SUBSCRIPTION_ID = T.SUBSCRIPTION_ID
272: );
273:
274: update JTF_UM_SUBSCRIPTIONS_TL T set (

Line 399: FROM JTF_UM_SUBSCRIPTIONS_B

395: -- there is a row for this app_id and this app_short_name
396: -- Exception is thrown otherwise.
397: select LAST_UPDATED_BY, LAST_UPDATE_DATE
398: into db_luby, db_ludate
399: FROM JTF_UM_SUBSCRIPTIONS_B
400: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
401:
402: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
403: db_ludate, X_CUSTOM_MODE)) then

Line 852: p_source_name => 'JTF_UM_SUBSCRIPTIONS_B',

848: -- Grant delegation role to a user
849: JTF_UM_UTIL_PVT.GRANT_ROLES(
850: p_user_name => l_principal_name,
851: p_role_id => l_role_id,
852: p_source_name => 'JTF_UM_SUBSCRIPTIONS_B',
853: p_source_id => l_subscription_id
854: );
855:
856: -- Assign the deleagtion access role

Line 861: OWNERTABLE_NAME => 'JTF_UM_SUBSCRIPTIONS_B',

857:
858: JTF_AUTH_BULKLOAD_PKG.ASSIGN_ROLE
859: ( USER_NAME => l_principal_name,
860: ROLE_NAME => 'JTA_UM_DELEGATION_ACCESS',
861: OWNERTABLE_NAME => 'JTF_UM_SUBSCRIPTIONS_B',
862: OWNERTABLE_KEY => l_subscription_id);
863: END IF;
864:
865: END IF;

Line 1261: CURSOR FIND_DELEGATION_ROLE IS SELECT AUTH_DELEGATION_ROLE_ID FROM JTF_UM_SUBSCRIPTIONS_B

1257: ) is
1258:
1259: l_procedure_name CONSTANT varchar2(30) := 'update_grant_delegation_flag';
1260:
1261: CURSOR FIND_DELEGATION_ROLE IS SELECT AUTH_DELEGATION_ROLE_ID FROM JTF_UM_SUBSCRIPTIONS_B
1262: WHERE SUBSCRIPTION_ID = p_subscription_id;
1263:
1264: begin
1265: