APPS.JTF_PREFAB_UD_KEYS_PKG dependencies on JTF_PREFAB_UD_KEYS_B

Line 20: cursor C is select ROWID from JTF_PREFAB_UD_KEYS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from JTF_PREFAB_UD_KEYS_B
21: where UD_KEY_ID = X_UD_KEY_ID
22: ;
23: begin
24: insert into JTF_PREFAB_UD_KEYS_B (

Line 24: insert into JTF_PREFAB_UD_KEYS_B (

20: cursor C is select ROWID from JTF_PREFAB_UD_KEYS_B
21: where UD_KEY_ID = X_UD_KEY_ID
22: ;
23: begin
24: insert into JTF_PREFAB_UD_KEYS_B (
25: UD_KEY_ID,
26: OBJECT_VERSION_NUMBER,
27: -- SECURITY_GROUP_ID,
28: APPLICATION_ID,

Line 113: from JTF_PREFAB_UD_KEYS_B

109: UD_KEY_NAME,
110: FILENAME,
111: USER_DEFINED_KEYS,
112: ENABLED_FLAG
113: from JTF_PREFAB_UD_KEYS_B
114: where UD_KEY_ID = X_UD_KEY_ID
115: for update of UD_KEY_ID nowait;
116: recinfo c%rowtype;
117:

Line 178: update JTF_PREFAB_UD_KEYS_B set

174: X_LAST_UPDATED_BY in NUMBER,
175: X_LAST_UPDATE_LOGIN in NUMBER
176: ) is
177: begin
178: update JTF_PREFAB_UD_KEYS_B set
179: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
180: -- SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
181: APPLICATION_ID = X_APPLICATION_ID,
182: UD_KEY_NAME = X_UD_KEY_NAME,

Line 220: delete from JTF_PREFAB_UD_KEYS_B

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: delete from JTF_PREFAB_UD_KEYS_B
221: where UD_KEY_ID = X_UD_KEY_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 234: from JTF_PREFAB_UD_KEYS_B B

230: begin
231: delete from JTF_PREFAB_UD_KEYS_TL T
232: where not exists
233: (select NULL
234: from JTF_PREFAB_UD_KEYS_B B
235: where B.UD_KEY_ID = T.UD_KEY_ID
236: );
237:
238: update JTF_PREFAB_UD_KEYS_TL T set (

Line 311: cursor c is select nvl(max(UD_KEY_ID), 0) from jtf_prefab_ud_keys_b where UD_KEY_ID < 10000;

307: db_luby NUMBER;
308: db_ludate DATE;
309: l_ud_key_id NUMBER;
310:
311: cursor c is select nvl(max(UD_KEY_ID), 0) from jtf_prefab_ud_keys_b where UD_KEY_ID < 10000;
312: l_pseudo_seq NUMBER := NULL;
313: begin
314:
315: if (X_OWNER = 'SEED') then

Line 326: FROM JTF_PREFAB_UD_KEYS_B

322:
323: begin
324: SELECT UD_KEY_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
325: INTO l_ud_key_id, db_luby, db_ludate
326: FROM JTF_PREFAB_UD_KEYS_B
327: WHERE APPLICATION_ID = X_APPLICATION_ID AND
328: UD_KEY_NAME = X_UD_KEY_NAME;
329:
330: -- **** Entry is there, check if it's legal to update ****

Line 405: FROM JTF_PREFAB_UD_KEYS_B b, JTF_PREFAB_UD_KEYS_TL tl

401:
402: begin
403: SELECT tl.UD_KEY_ID, tl.LAST_UPDATED_BY, tl.LAST_UPDATE_DATE
404: INTO l_ud_key_id, db_luby, db_ludate
405: FROM JTF_PREFAB_UD_KEYS_B b, JTF_PREFAB_UD_KEYS_TL tl
406: WHERE b.UD_KEY_ID = tl.UD_KEY_ID AND
407: b.APPLICATION_ID = X_APPLICATION_ID AND
408: b.UD_KEY_NAME = X_UD_KEY_NAME AND
409: tl.LANGUAGE = userenv('LANG');