APPS.JTS_SETUP_FLOW_HIEARCHY_PKG dependencies on JTS_SETUP_FLOWS_TL

Line 110: insert into JTS_SETUP_FLOWS_TL (

106: p_last_updated_by,
107: p_last_update_login
108: );
109:
110: insert into JTS_SETUP_FLOWS_TL (
111: FLOW_ID,
112: FLOW_CODE,
113: FLOW_NAME,
114: CREATION_DATE,

Line 136: from JTS_SETUP_FLOWS_TL T

132: from FND_LANGUAGES L
133: where L.INSTALLED_FLAG in ('I', 'B')
134: and not exists
135: (select NULL
136: from JTS_SETUP_FLOWS_TL T
137: where T.FLOW_ID = X_FLOW_ID
138: and T.LANGUAGE = L.LANGUAGE_CODE);
139:
140: EXCEPTION

Line 155: DELETE FROM jts_setup_flows_tl

151: BEGIN
152: DELETE FROM jts_setup_flows_b
153: WHERE flow_code = p_flow_code;
154:
155: DELETE FROM jts_setup_flows_tl
156: WHERE flow_code = p_flow_code;
157:
158: EXCEPTION
159: WHEN OTHERS THEN

Line 173: DELETE FROM jts_setup_flows_tl

169: BEGIN
170: DELETE FROM jts_setup_flows_b
171: WHERE flow_id = p_flow_id;
172:
173: DELETE FROM jts_setup_flows_tl
174: WHERE flow_id = p_flow_id;
175:
176: EXCEPTION
177: WHEN OTHERS THEN

Line 229: update JTS_SETUP_FLOWS_TL set

225: if (sql%notfound) then
226: raise no_data_found;
227: end if;
228:
229: update JTS_SETUP_FLOWS_TL set
230: FLOW_NAME = P_FLOW_NAME,
231: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
232: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
233: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 258: update jts_setup_flows_tl set

254: p_flow_name IN VARCHAR2
255: )
256: IS
257: BEGIN
258: update jts_setup_flows_tl set
259: flow_name = nvl(p_flow_name, flow_name),
260: source_lang = userenv('LANG'),
261: last_update_date = sysdate,
262: last_updated_by = decode(p_owner, 'SEED', 1, 0),

Line 391: from JTS_SETUP_FLOWS_TL

387:
388: cursor c1 is select
389: FLOW_NAME,
390: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
391: from JTS_SETUP_FLOWS_TL
392: where FLOW_ID = X_FLOW_ID
393: and FLOW_CODE = X_FLOW_CODE
394: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
395: for update of FLOW_ID nowait;

Line 450: delete from JTS_SETUP_FLOWS_TL T

446:
447: procedure ADD_LANGUAGE
448: is
449: begin
450: delete from JTS_SETUP_FLOWS_TL T
451: where not exists
452: (select NULL
453: from JTS_SETUP_FLOWS_B B
454: where B.FLOW_ID = T.FLOW_ID

Line 458: update JTS_SETUP_FLOWS_TL T set (

454: where B.FLOW_ID = T.FLOW_ID
455: and B.FLOW_CODE = T.FLOW_CODE
456: );
457:
458: update JTS_SETUP_FLOWS_TL T set (
459: FLOW_NAME
460: ) = (select
461: B.FLOW_NAME
462: from JTS_SETUP_FLOWS_TL B

Line 462: from JTS_SETUP_FLOWS_TL B

458: update JTS_SETUP_FLOWS_TL T set (
459: FLOW_NAME
460: ) = (select
461: B.FLOW_NAME
462: from JTS_SETUP_FLOWS_TL B
463: where B.FLOW_ID = T.FLOW_ID
464: and B.FLOW_CODE = T.FLOW_CODE
465: and B.LANGUAGE = T.SOURCE_LANG)
466: where (

Line 474: from JTS_SETUP_FLOWS_TL SUBB, JTS_SETUP_FLOWS_TL SUBT

470: ) in (select
471: SUBT.FLOW_ID,
472: SUBT.FLOW_CODE,
473: SUBT.LANGUAGE
474: from JTS_SETUP_FLOWS_TL SUBB, JTS_SETUP_FLOWS_TL SUBT
475: where SUBB.FLOW_ID = SUBT.FLOW_ID
476: and SUBB.FLOW_CODE = SUBT.FLOW_CODE
477: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
478: and (SUBB.FLOW_NAME <> SUBT.FLOW_NAME

Line 481: insert into JTS_SETUP_FLOWS_TL (

477: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
478: and (SUBB.FLOW_NAME <> SUBT.FLOW_NAME
479: ));
480:
481: insert into JTS_SETUP_FLOWS_TL (
482: FLOW_ID,
483: FLOW_CODE,
484: FLOW_NAME,
485: CREATION_DATE,

Line 505: from JTS_SETUP_FLOWS_TL B, FND_LANGUAGES L

501: B.LAST_UPDATE_LOGIN,
502: B.SECURITY_GROUP_ID,
503: L.LANGUAGE_CODE,
504: B.SOURCE_LANG
505: from JTS_SETUP_FLOWS_TL B, FND_LANGUAGES L
506: where L.INSTALLED_FLAG in ('I', 'B')
507: and B.LANGUAGE = userenv('LANG')
508: and not exists
509: (select NULL

Line 510: from JTS_SETUP_FLOWS_TL T

506: where L.INSTALLED_FLAG in ('I', 'B')
507: and B.LANGUAGE = userenv('LANG')
508: and not exists
509: (select NULL
510: from JTS_SETUP_FLOWS_TL T
511: where T.FLOW_ID = B.FLOW_ID
512: and T.FLOW_CODE = B.FLOW_CODE
513: and T.LANGUAGE = L.LANGUAGE_CODE);
514: end ADD_LANGUAGE;