APPS.JTF_DPF_LOGICAL_FLOWS_PKG dependencies on JTF_DPF_LOGICAL_FLOWS_TL

Line 97: insert into JTF_DPF_LOGICAL_FLOWS_TL (

93: X_LAST_UPDATED_BY,
94: X_LAST_UPDATE_LOGIN
95: );
96:
97: insert into JTF_DPF_LOGICAL_FLOWS_TL (
98: LOGICAL_FLOW_ID,
99: LOGICAL_FLOW_DESCRIPTION,
100: CREATED_BY,
101: LAST_UPDATE_DATE,

Line 119: from JTF_DPF_LOGICAL_FLOWS_TL T

115: from FND_LANGUAGES L
116: where L.INSTALLED_FLAG in ('I', 'B')
117: and not exists
118: (select NULL
119: from JTF_DPF_LOGICAL_FLOWS_TL T
120: where T.LOGICAL_FLOW_ID = X_LOGICAL_FLOW_ID
121: and T.LANGUAGE = L.LANGUAGE_CODE);
122:
123: open c;

Line 166: from JTF_DPF_LOGICAL_FLOWS_TL

162:
163: cursor c1 is select
164: LOGICAL_FLOW_DESCRIPTION,
165: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
166: from JTF_DPF_LOGICAL_FLOWS_TL
167: where LOGICAL_FLOW_ID = X_LOGICAL_FLOW_ID
168: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
169: for update of LOGICAL_FLOW_ID nowait;
170: begin

Line 251: update JTF_DPF_LOGICAL_FLOWS_TL set

247: if (sql%notfound) then
248: raise no_data_found;
249: end if;
250:
251: update JTF_DPF_LOGICAL_FLOWS_TL set
252: LOGICAL_FLOW_DESCRIPTION = X_LOGICAL_FLOW_DESCRIPTION,
253: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
254: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
255: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 269: delete from JTF_DPF_LOGICAL_FLOWS_TL

265: procedure DELETE_ROW (
266: X_LOGICAL_FLOW_ID in NUMBER
267: ) is
268: begin
269: delete from JTF_DPF_LOGICAL_FLOWS_TL
270: where LOGICAL_FLOW_ID = X_LOGICAL_FLOW_ID;
271:
272: if (sql%notfound) then
273: raise no_data_found;

Line 287: delete from JTF_DPF_LOGICAL_FLOWS_TL T

283:
284: procedure ADD_LANGUAGE
285: is
286: begin
287: delete from JTF_DPF_LOGICAL_FLOWS_TL T
288: where not exists
289: (select NULL
290: from JTF_DPF_LOGICAL_FLOWS_B B
291: where B.LOGICAL_FLOW_ID = T.LOGICAL_FLOW_ID

Line 294: update JTF_DPF_LOGICAL_FLOWS_TL T set (

290: from JTF_DPF_LOGICAL_FLOWS_B B
291: where B.LOGICAL_FLOW_ID = T.LOGICAL_FLOW_ID
292: );
293:
294: update JTF_DPF_LOGICAL_FLOWS_TL T set (
295: LOGICAL_FLOW_DESCRIPTION
296: ) = (select
297: B.LOGICAL_FLOW_DESCRIPTION
298: from JTF_DPF_LOGICAL_FLOWS_TL B

Line 298: from JTF_DPF_LOGICAL_FLOWS_TL B

294: update JTF_DPF_LOGICAL_FLOWS_TL T set (
295: LOGICAL_FLOW_DESCRIPTION
296: ) = (select
297: B.LOGICAL_FLOW_DESCRIPTION
298: from JTF_DPF_LOGICAL_FLOWS_TL B
299: where B.LOGICAL_FLOW_ID = T.LOGICAL_FLOW_ID
300: and B.LANGUAGE = T.SOURCE_LANG)
301: where (
302: T.LOGICAL_FLOW_ID,

Line 307: from JTF_DPF_LOGICAL_FLOWS_TL SUBB, JTF_DPF_LOGICAL_FLOWS_TL SUBT

303: T.LANGUAGE
304: ) in (select
305: SUBT.LOGICAL_FLOW_ID,
306: SUBT.LANGUAGE
307: from JTF_DPF_LOGICAL_FLOWS_TL SUBB, JTF_DPF_LOGICAL_FLOWS_TL SUBT
308: where SUBB.LOGICAL_FLOW_ID = SUBT.LOGICAL_FLOW_ID
309: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
310: and (SUBB.LOGICAL_FLOW_DESCRIPTION <> SUBT.LOGICAL_FLOW_DESCRIPTION
311: or (SUBB.LOGICAL_FLOW_DESCRIPTION is null and SUBT.LOGICAL_FLOW_DESCRIPTION is not null)

Line 315: insert into JTF_DPF_LOGICAL_FLOWS_TL (

311: or (SUBB.LOGICAL_FLOW_DESCRIPTION is null and SUBT.LOGICAL_FLOW_DESCRIPTION is not null)
312: or (SUBB.LOGICAL_FLOW_DESCRIPTION is not null and SUBT.LOGICAL_FLOW_DESCRIPTION is null)
313: ));
314:
315: insert into JTF_DPF_LOGICAL_FLOWS_TL (
316: LOGICAL_FLOW_ID,
317: LOGICAL_FLOW_DESCRIPTION,
318: CREATED_BY,
319: LAST_UPDATE_DATE,

Line 333: from JTF_DPF_LOGICAL_FLOWS_TL B, FND_LANGUAGES L

329: B.LAST_UPDATED_BY,
330: B.LAST_UPDATE_LOGIN,
331: L.LANGUAGE_CODE,
332: B.SOURCE_LANG
333: from JTF_DPF_LOGICAL_FLOWS_TL B, FND_LANGUAGES L
334: where L.INSTALLED_FLAG in ('I', 'B')
335: and B.LANGUAGE = userenv('LANG')
336: and not exists
337: (select NULL

Line 338: from JTF_DPF_LOGICAL_FLOWS_TL T

334: where L.INSTALLED_FLAG in ('I', 'B')
335: and B.LANGUAGE = userenv('LANG')
336: and not exists
337: (select NULL
338: from JTF_DPF_LOGICAL_FLOWS_TL T
339: where T.LOGICAL_FLOW_ID = B.LOGICAL_FLOW_ID
340: and T.LANGUAGE = L.LANGUAGE_CODE);
341: end ADD_LANGUAGE;
342:

Line 433: update jtf_dpf_logical_flows_tl set

429: if x_owner = 'SEED' then l_user_id := 1; end if;
430:
431: l_flow_id := find_oldest_prefer_owned_by(x_flow_name, x_application_id,
432: l_user_id);
433: update jtf_dpf_logical_flows_tl set
434: logical_flow_description = x_flow_description,
435: last_updated_by = l_user_id,
436: last_update_date = sysdate,
437: last_update_login = 0