APPS.JTS_FLOW_STEPS_PKG dependencies on JTS_FLOW_STEPS_TL

Line 74: insert into JTS_FLOW_STEPS_TL (

70: p_last_updated_by,
71: p_last_update_login
72: );
73:
74: insert into JTS_FLOW_STEPS_TL (
75: STEP_ID,
76: STEP_NAME,
77: DESCRIPTION,
78: IMPACT,

Line 102: from JTS_FLOW_STEPS_TL T

98: from FND_LANGUAGES L
99: where L.INSTALLED_FLAG in ('I', 'B')
100: and not exists
101: (select NULL
102: from JTS_FLOW_STEPS_TL T
103: where T.STEP_ID = X_STEP_ID
104: and T.LANGUAGE = L.LANGUAGE_CODE);
105:
106: EXCEPTION

Line 121: DELETE FROM jts_flow_steps_tl

117: BEGIN
118: DELETE FROM jts_flow_steps_b
119: WHERE step_id = p_step_id;
120:
121: DELETE FROM jts_flow_steps_tl
122: WHERE step_id = p_step_id;
123:
124: EXCEPTION
125: WHEN OTHERS THEN

Line 169: update JTS_FLOW_STEPS_TL set

165: if (sql%notfound) then
166: raise no_data_found;
167: end if;
168:
169: update JTS_FLOW_STEPS_TL set
170: STEP_NAME = P_STEP_NAME,
171: DESCRIPTION = P_DESCRIPTION,
172: IMPACT = P_IMPACT,
173: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 202: update jts_flow_steps_tl set

198: p_impact IN VARCHAR2
199: )
200: IS
201: BEGIN
202: update jts_flow_steps_tl set
203: step_name = nvl(p_step_name, step_name),
204: description = nvl(p_description, description),
205: impact = nvl(p_impact, impact),
206: source_lang = userenv('LANG'),

Line 325: from JTS_FLOW_STEPS_TL

321: STEP_NAME,
322: DESCRIPTION,
323: IMPACT,
324: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
325: from JTS_FLOW_STEPS_TL
326: where STEP_ID = X_STEP_ID
327: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
328: for update of STEP_ID nowait;
329: begin

Line 375: delete from JTS_FLOW_STEPS_TL T

371: ------------------------------------------------
372: procedure ADD_LANGUAGE
373: is
374: begin
375: delete from JTS_FLOW_STEPS_TL T
376: where not exists
377: (select NULL
378: from JTS_FLOW_STEPS_B B
379: where B.STEP_ID = T.STEP_ID

Line 382: update JTS_FLOW_STEPS_TL T set (

378: from JTS_FLOW_STEPS_B B
379: where B.STEP_ID = T.STEP_ID
380: );
381:
382: update JTS_FLOW_STEPS_TL T set (
383: STEP_NAME,
384: DESCRIPTION,
385: IMPACT
386: ) = (select

Line 390: from JTS_FLOW_STEPS_TL B

386: ) = (select
387: B.STEP_NAME,
388: B.DESCRIPTION,
389: B.IMPACT
390: from JTS_FLOW_STEPS_TL B
391: where B.STEP_ID = T.STEP_ID
392: and B.LANGUAGE = T.SOURCE_LANG)
393: where (
394: T.STEP_ID,

Line 399: from JTS_FLOW_STEPS_TL SUBB, JTS_FLOW_STEPS_TL SUBT

395: T.LANGUAGE
396: ) in (select
397: SUBT.STEP_ID,
398: SUBT.LANGUAGE
399: from JTS_FLOW_STEPS_TL SUBB, JTS_FLOW_STEPS_TL SUBT
400: where SUBB.STEP_ID = SUBT.STEP_ID
401: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
402: and (SUBB.STEP_NAME <> SUBT.STEP_NAME
403: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 407: insert into JTS_FLOW_STEPS_TL (

403: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
404: or SUBB.IMPACT <> SUBT.IMPACT
405: ));
406:
407: insert into JTS_FLOW_STEPS_TL (
408: STEP_ID,
409: STEP_NAME,
410: DESCRIPTION,
411: IMPACT,

Line 433: from JTS_FLOW_STEPS_TL B, FND_LANGUAGES L

429: B.LAST_UPDATE_LOGIN,
430: B.SECURITY_GROUP_ID,
431: L.LANGUAGE_CODE,
432: B.SOURCE_LANG
433: from JTS_FLOW_STEPS_TL B, FND_LANGUAGES L
434: where L.INSTALLED_FLAG in ('I', 'B')
435: and B.LANGUAGE = userenv('LANG')
436: and not exists
437: (select NULL

Line 438: from JTS_FLOW_STEPS_TL T

434: where L.INSTALLED_FLAG in ('I', 'B')
435: and B.LANGUAGE = userenv('LANG')
436: and not exists
437: (select NULL
438: from JTS_FLOW_STEPS_TL T
439: where T.STEP_ID = B.STEP_ID
440: and T.LANGUAGE = L.LANGUAGE_CODE);
441: end ADD_LANGUAGE;
442: