APPS.JTF_UM_USERTYPES_PKG dependencies on JTF_UM_USERTYPES_B

Line 23: cursor C is select ROWID from JTF_UM_USERTYPES_B

19: X_LAST_UPDATE_LOGIN in NUMBER,
20: X_USERTYPE_SHORTNAME in VARCHAR2,
21: X_DISPLAY_ORDER in NUMBER
22: ) is
23: cursor C is select ROWID from JTF_UM_USERTYPES_B
24: where USERTYPE_ID = X_USERTYPE_ID
25: ;
26: begin
27: insert into JTF_UM_USERTYPES_B (

Line 27: insert into JTF_UM_USERTYPES_B (

23: cursor C is select ROWID from JTF_UM_USERTYPES_B
24: where USERTYPE_ID = X_USERTYPE_ID
25: ;
26: begin
27: insert into JTF_UM_USERTYPES_B (
28: EFFECTIVE_END_DATE,
29: APPROVAL_ID,
30: APPLICATION_ID,
31: ENABLED_FLAG,

Line 51: JTF_UM_USERTYPES_B_S.NEXTVAL,

47: X_ENABLED_FLAG,
48: X_EMAIL_NOTIFICATION_FLAG,
49: X_IS_SELF_SERVICE_FLAG,
50: X_EFFECTIVE_START_DATE,
51: JTF_UM_USERTYPES_B_S.NEXTVAL,
52: X_USERTYPE_KEY,
53: X_CREATION_DATE,
54: X_CREATED_BY,
55: X_LAST_UPDATE_DATE,

Line 124: from JTF_UM_USERTYPES_B

120: EMAIL_NOTIFICATION_FLAG,
121: IS_SELF_SERVICE_FLAG,
122: EFFECTIVE_START_DATE,
123: USERTYPE_KEY
124: from JTF_UM_USERTYPES_B
125: where USERTYPE_ID = X_USERTYPE_ID
126: for update of USERTYPE_ID nowait;
127: recinfo c%rowtype;
128:

Line 196: update JTF_UM_USERTYPES_B set

192: X_USERTYPE_SHORTNAME in VARCHAR2,
193: X_DISPLAY_ORDER in NUMBER
194: ) is
195: begin
196: update JTF_UM_USERTYPES_B set
197: EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,
198: APPROVAL_ID = X_APPROVAL_ID,
199: APPLICATION_ID = X_APPLICATION_ID,
200: ENABLED_FLAG = X_ENABLED_FLAG,

Line 241: delete from JTF_UM_USERTYPES_B

237: if (sql%notfound) then
238: raise no_data_found;
239: end if;
240:
241: delete from JTF_UM_USERTYPES_B
242: where USERTYPE_ID = X_USERTYPE_ID;
243:
244: if (sql%notfound) then
245: raise no_data_found;

Line 255: from JTF_UM_USERTYPES_B B

251: begin
252: delete from JTF_UM_USERTYPES_TL T
253: where not exists
254: (select NULL
255: from JTF_UM_USERTYPES_B B
256: where B.USERTYPE_ID = T.USERTYPE_ID
257: );
258:
259: update JTF_UM_USERTYPES_TL T set (

Line 388: FROM JTF_UM_USERTYPES_B

384: -- there is a row for this app_id and this app_short_name
385: -- Exception is thrown otherwise.
386: select LAST_UPDATED_BY, LAST_UPDATE_DATE
387: into db_luby, db_ludate
388: FROM JTF_UM_USERTYPES_B
389: where USERTYPE_ID = X_USERTYPE_ID;
390:
391: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
392: db_ludate, X_CUSTOM_MODE)) then

Line 916: update JTF_UM_USERTYPES_B set

912: begin
913: --if (x_owner = 'SEED') then
914: -- l_user_id := 1;
915: --end if;
916: update JTF_UM_USERTYPES_B set
917: LAST_UPDATE_LOGIN = l_user_id,
918: LAST_UPDATE_DATE = SYSDATE,
919: DISPLAY_ORDER = X_DISPLAY_ORDER
920: where USERTYPE_ID = X_USERTYPE_ID;