APPS.JTF_PREFAB_WSH_POES_PKG dependencies on JTF_PREFAB_WSH_POES_TL

Line 57: insert into JTF_PREFAB_WSH_POES_TL (

53: X_LAST_UPDATED_BY,
54: X_LAST_UPDATE_LOGIN
55: );
56:
57: insert into JTF_PREFAB_WSH_POES_TL (
58: WSH_PO_ID,
59: DESCRIPTION,
60: CREATED_BY,
61: CREATION_DATE,

Line 85: from JTF_PREFAB_WSH_POES_TL T

81: from FND_LANGUAGES L
82: where L.INSTALLED_FLAG in ('I', 'B')
83: and not exists
84: (select NULL
85: from JTF_PREFAB_WSH_POES_TL T
86: where T.WSH_PO_ID = X_WSH_PO_ID
87: and T.LANGUAGE = L.LANGUAGE_CODE);
88:
89: open c;

Line 128: from JTF_PREFAB_WSH_POES_TL

124:
125: cursor c1 is select
126: DESCRIPTION,
127: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
128: from JTF_PREFAB_WSH_POES_TL
129: where WSH_PO_ID = X_WSH_PO_ID
130: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
131: for update of WSH_PO_ID nowait;
132: begin

Line 205: update JTF_PREFAB_WSH_POES_TL set

201: if (sql%notfound) then
202: raise no_data_found;
203: end if;
204:
205: update JTF_PREFAB_WSH_POES_TL set
206: DESCRIPTION = X_DESCRIPTION,
207: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
208: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
209: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 223: delete from JTF_PREFAB_WSH_POES_TL

219: procedure DELETE_ROW (
220: X_WSH_PO_ID in NUMBER
221: ) is
222: begin
223: delete from JTF_PREFAB_WSH_POES_TL
224: where WSH_PO_ID = X_WSH_PO_ID;
225:
226: if (sql%notfound) then
227: raise no_data_found;

Line 241: delete from JTF_PREFAB_WSH_POES_TL T

237:
238: procedure ADD_LANGUAGE
239: is
240: begin
241: delete from JTF_PREFAB_WSH_POES_TL T
242: where not exists
243: (select NULL
244: from JTF_PREFAB_WSH_POES_B B
245: where B.WSH_PO_ID = T.WSH_PO_ID

Line 248: update JTF_PREFAB_WSH_POES_TL T set (

244: from JTF_PREFAB_WSH_POES_B B
245: where B.WSH_PO_ID = T.WSH_PO_ID
246: );
247:
248: update JTF_PREFAB_WSH_POES_TL T set (
249: DESCRIPTION
250: ) = (select
251: B.DESCRIPTION
252: from JTF_PREFAB_WSH_POES_TL B

Line 252: from JTF_PREFAB_WSH_POES_TL B

248: update JTF_PREFAB_WSH_POES_TL T set (
249: DESCRIPTION
250: ) = (select
251: B.DESCRIPTION
252: from JTF_PREFAB_WSH_POES_TL B
253: where B.WSH_PO_ID = T.WSH_PO_ID
254: and B.LANGUAGE = T.SOURCE_LANG)
255: where (
256: T.WSH_PO_ID,

Line 261: from JTF_PREFAB_WSH_POES_TL SUBB, JTF_PREFAB_WSH_POES_TL SUBT

257: T.LANGUAGE
258: ) in (select
259: SUBT.WSH_PO_ID,
260: SUBT.LANGUAGE
261: from JTF_PREFAB_WSH_POES_TL SUBB, JTF_PREFAB_WSH_POES_TL SUBT
262: where SUBB.WSH_PO_ID = SUBT.WSH_PO_ID
263: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
264: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
265: ));

Line 267: insert into JTF_PREFAB_WSH_POES_TL (

263: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
264: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
265: ));
266:
267: insert into JTF_PREFAB_WSH_POES_TL (
268: WSH_PO_ID,
269: DESCRIPTION,
270: CREATED_BY,
271: CREATION_DATE,

Line 291: from JTF_PREFAB_WSH_POES_TL B, FND_LANGUAGES L

287: -- B.SECURITY_GROUP_ID,
288: B.WSH_PO_ID,
289: L.LANGUAGE_CODE,
290: B.SOURCE_LANG
291: from JTF_PREFAB_WSH_POES_TL B, FND_LANGUAGES L
292: where L.INSTALLED_FLAG in ('I', 'B')
293: and B.LANGUAGE = userenv('LANG')
294: and not exists
295: (select NULL

Line 296: from JTF_PREFAB_WSH_POES_TL T

292: where L.INSTALLED_FLAG in ('I', 'B')
293: and B.LANGUAGE = userenv('LANG')
294: and not exists
295: (select NULL
296: from JTF_PREFAB_WSH_POES_TL T
297: where T.WSH_PO_ID = B.WSH_PO_ID
298: and T.LANGUAGE = L.LANGUAGE_CODE);
299: end ADD_LANGUAGE;
300: