DBA Data[Home] [Help]

APPS.JTF_UM_ROLE_RESP_PKG dependencies on JTF_UM_SUBSCRIPTION_RESP

Line 408: insert into jtf_um_subscription_resp (

404: x_last_update_login IN NUMBER,
405: x_application_id IN NUMBER
406: ) is
407: begin
408: insert into jtf_um_subscription_resp (
409: subscription_id ,
410: responsibility_key ,
411: effective_start_date ,
412: effective_end_date ,

Line 443: update jtf_um_subscription_resp set

439: x_last_update_login IN NUMBER,
440: x_application_id IN NUMBER
441: ) is
442: begin
443: update jtf_um_subscription_resp set
444: effective_end_date = x_effective_end_date ,
445: last_update_date = x_last_update_date ,
446: last_updated_by = x_last_updated_by ,
447: last_update_login = x_last_update_login ,

Line 490: FROM jtf_um_subscription_resp

486: -- there is a row for this app_id and this app_short_name
487: -- Exception is thrown otherwise.
488: select LAST_UPDATED_BY, LAST_UPDATE_DATE
489: into db_luby, db_ludate
490: FROM jtf_um_subscription_resp
491: where subscription_id = x_subscription_id AND
492: responsibility_key = x_responsibility_key ;
493:
494: