APPS.JTF_UM_ROLE_RESP_PKG dependencies on JTF_UM_USERTYPE_ROLE

Line 15: insert into jtf_um_usertype_role (

11: x_last_updated_by IN NUMBER,
12: x_last_update_login IN NUMBER
13: ) is
14: begin
15: insert into jtf_um_usertype_role (
16: usertype_id ,
17: principal_name ,
18: effective_start_date ,
19: effective_end_date ,

Line 47: update jtf_um_usertype_role set

43: x_last_updated_by IN NUMBER,
44: x_last_update_login IN NUMBER
45: ) is
46: begin
47: update jtf_um_usertype_role set
48: effective_end_date = x_effective_end_date ,
49: last_update_date = x_last_update_date ,
50: last_updated_by = x_last_updated_by ,
51: last_update_login = x_last_update_login

Line 92: FROM jtf_um_usertype_role

88: -- there is a row for this app_id and this app_short_name
89: -- Exception is thrown otherwise.
90: select LAST_UPDATED_BY, LAST_UPDATE_DATE
91: into db_luby, db_ludate
92: FROM jtf_um_usertype_role
93: where usertype_id = x_usertype_id AND
94: principal_name = x_principal_name;
95:
96: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,