APPS.GML_OP_ORDR_TYP_PKG dependencies on OP_ORDR_TYP_TL

Line 93: insert into OP_ORDR_TYP_TL (

89: X_LAST_UPDATED_BY,
90: X_LAST_UPDATE_LOGIN
91: );
92:
93: insert into OP_ORDR_TYP_TL (
94: ORDER_TYPE,
95: ORDER_TYPE_CODE,
96: ORDER_TYPE_DESC,
97: CREATED_BY,

Line 119: from OP_ORDR_TYP_TL T

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

Line 186: from OP_ORDR_TYP_TL

182: cursor c1 is select
183: ORDER_TYPE_CODE,
184: ORDER_TYPE_DESC,
185: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
186: from OP_ORDR_TYP_TL
187: where ORDER_TYPE = X_ORDER_TYPE
188: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
189: for update of ORDER_TYPE nowait;
190: begin

Line 297: update OP_ORDR_TYP_TL set

293: if (sql%notfound) then
294: raise no_data_found;
295: end if;
296:
297: update OP_ORDR_TYP_TL set
298: ORDER_TYPE_CODE = X_ORDER_TYPE_CODE,
299: ORDER_TYPE_DESC = X_ORDER_TYPE_DESC,
300: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
301: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 316: delete from OP_ORDR_TYP_TL

312: procedure DELETE_ROW (
313: X_ORDER_TYPE in NUMBER
314: ) is
315: begin
316: delete from OP_ORDR_TYP_TL
317: where ORDER_TYPE = X_ORDER_TYPE;
318:
319: if (sql%notfound) then
320: raise no_data_found;

Line 334: delete from OP_ORDR_TYP_TL T

330:
331: procedure ADD_LANGUAGE
332: is
333: begin
334: delete from OP_ORDR_TYP_TL T
335: where not exists
336: (select NULL
337: from OP_ORDR_TYP_B B
338: where B.ORDER_TYPE = T.ORDER_TYPE

Line 341: update OP_ORDR_TYP_TL T set (

337: from OP_ORDR_TYP_B B
338: where B.ORDER_TYPE = T.ORDER_TYPE
339: );
340:
341: update OP_ORDR_TYP_TL T set (
342: ORDER_TYPE_CODE,
343: ORDER_TYPE_DESC
344: ) = (select
345: B.ORDER_TYPE_CODE,

Line 347: from OP_ORDR_TYP_TL B

343: ORDER_TYPE_DESC
344: ) = (select
345: B.ORDER_TYPE_CODE,
346: B.ORDER_TYPE_DESC
347: from OP_ORDR_TYP_TL B
348: where B.ORDER_TYPE = T.ORDER_TYPE
349: and B.LANGUAGE = T.SOURCE_LANG)
350: where (
351: T.ORDER_TYPE,

Line 356: from OP_ORDR_TYP_TL SUBB, OP_ORDR_TYP_TL SUBT

352: T.LANGUAGE
353: ) in (select
354: SUBT.ORDER_TYPE,
355: SUBT.LANGUAGE
356: from OP_ORDR_TYP_TL SUBB, OP_ORDR_TYP_TL SUBT
357: where SUBB.ORDER_TYPE = SUBT.ORDER_TYPE
358: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
359: and (SUBB.ORDER_TYPE_CODE <> SUBT.ORDER_TYPE_CODE
360: or SUBB.ORDER_TYPE_DESC <> SUBT.ORDER_TYPE_DESC

Line 363: insert into OP_ORDR_TYP_TL (

359: and (SUBB.ORDER_TYPE_CODE <> SUBT.ORDER_TYPE_CODE
360: or SUBB.ORDER_TYPE_DESC <> SUBT.ORDER_TYPE_DESC
361: ));
362:
363: insert into OP_ORDR_TYP_TL (
364: ORDER_TYPE,
365: ORDER_TYPE_CODE,
366: ORDER_TYPE_DESC,
367: CREATED_BY,

Line 385: from OP_ORDR_TYP_TL B, FND_LANGUAGES L

381: B.LAST_UPDATE_DATE,
382: B.LAST_UPDATE_LOGIN,
383: L.LANGUAGE_CODE,
384: B.SOURCE_LANG
385: from OP_ORDR_TYP_TL B, FND_LANGUAGES L
386: where L.INSTALLED_FLAG in ('I', 'B')
387: and B.LANGUAGE = userenv('LANG')
388: and not exists
389: (select NULL

Line 390: from OP_ORDR_TYP_TL T

386: where L.INSTALLED_FLAG in ('I', 'B')
387: and B.LANGUAGE = userenv('LANG')
388: and not exists
389: (select NULL
390: from OP_ORDR_TYP_TL T
391: where T.ORDER_TYPE = B.ORDER_TYPE
392: and T.LANGUAGE = L.LANGUAGE_CODE);
393: end ADD_LANGUAGE;
394:

Line 403: update OP_ORDR_TYP_TL set

399: X_ORDER_TYPE_DESC in VARCHAR2
400: ) IS
401:
402: BEGIN
403: update OP_ORDR_TYP_TL set
404: ORDER_TYPE_CODE = X_ORDER_TYPE_CODE,
405: ORDER_TYPE_DESC = X_ORDER_TYPE_DESC,
406: SOURCE_LANG = userenv('LANG'),
407: LAST_UPDATE_DATE = sysdate,