DBA Data[Home] [Help]

APPS.JTF_UM_ROLE_RESP_PKG dependencies on JTF_UM_USERTYPE_RESP

Line 142: insert into jtf_um_usertype_resp (

138: x_last_update_login IN NUMBER,
139: x_application_id IN NUMBER
140: ) is
141: begin
142: insert into jtf_um_usertype_resp (
143: usertype_id ,
144: responsibility_key ,
145: is_default_flag ,
146: effective_start_date ,

Line 180: update jtf_um_usertype_resp set

176: x_last_update_login IN NUMBER,
177: x_application_id IN NUMBER
178: ) is
179: begin
180: update jtf_um_usertype_resp set
181: is_default_flag = x_is_default_flag ,
182: effective_end_date = x_effective_end_date ,
183: last_update_date = x_last_update_date ,
184: last_updated_by = x_last_updated_by ,

Line 227: FROM jtf_um_usertype_resp

223: -- there is a row for this app_id and this app_short_name
224: -- Exception is thrown otherwise.
225: select LAST_UPDATED_BY, LAST_UPDATE_DATE
226: into db_luby, db_ludate
227: FROM jtf_um_usertype_resp
228: where usertype_id = x_usertype_id AND
229: responsibility_key = x_responsibility_key ;
230:
231: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,