DBA Data[Home] [Help]

APPS.JTF_UM_ROLE_RESP_PKG dependencies on JTF_UM_SUBSCRIPTION_ROLE

Line 279: insert into jtf_um_subscription_role (

275: x_last_updated_by IN NUMBER,
276: x_last_update_login IN NUMBER
277: ) is
278: begin
279: insert into jtf_um_subscription_role (
280: subscription_id ,
281: principal_name ,
282: effective_start_date ,
283: effective_end_date ,

Line 311: update jtf_um_subscription_role set

307: x_last_updated_by IN NUMBER,
308: x_last_update_login IN NUMBER
309: ) is
310: begin
311: update jtf_um_subscription_role set
312: effective_end_date = x_effective_end_date ,
313: last_update_date = x_last_update_date ,
314: last_updated_by = x_last_updated_by ,
315: last_update_login = x_last_update_login

Line 357: FROM jtf_um_subscription_role

353: -- there is a row for this app_id and this app_short_name
354: -- Exception is thrown otherwise.
355: select LAST_UPDATED_BY, LAST_UPDATE_DATE
356: into db_luby, db_ludate
357: FROM jtf_um_subscription_role
358: where subscription_id = x_subscription_id AND
359: principal_name = x_principal_name ;
360:
361: