APPS.PO_HAZARD_CLASSES_PKG dependencies on PO_HAZARD_CLASSES_TL

Line 88: insert into PO_HAZARD_CLASSES_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into PO_HAZARD_CLASSES_TL (
89: HAZARD_CLASS_ID,
90: HAZARD_CLASS,
91: DESCRIPTION,
92: CREATION_DATE,

Line 114: from PO_HAZARD_CLASSES_TL T

110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from PO_HAZARD_CLASSES_TL T
115: where T.HAZARD_CLASS_ID = X_HAZARD_CLASS_ID
116: and T.LANGUAGE = L.LANGUAGE_CODE);
117:
118: open c;

Line 179: from PO_HAZARD_CLASSES_TL

175: cursor c1 is select
176: HAZARD_CLASS,
177: DESCRIPTION,
178: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
179: from PO_HAZARD_CLASSES_TL
180: where HAZARD_CLASS_ID = X_HAZARD_CLASS_ID
181: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
182: for update of HAZARD_CLASS_ID nowait;
183: begin

Line 306: update PO_HAZARD_CLASSES_TL set

302: if (sql%notfound) then
303: raise no_data_found;
304: end if;
305:
306: update PO_HAZARD_CLASSES_TL set
307: HAZARD_CLASS = X_HAZARD_CLASS,
308: DESCRIPTION = X_DESCRIPTION,
309: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
310: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 325: delete from PO_HAZARD_CLASSES_TL

321: procedure DELETE_ROW (
322: X_HAZARD_CLASS_ID in NUMBER
323: ) is
324: begin
325: delete from PO_HAZARD_CLASSES_TL
326: where HAZARD_CLASS_ID = X_HAZARD_CLASS_ID;
327:
328: if (sql%notfound) then
329: raise no_data_found;

Line 343: delete from PO_HAZARD_CLASSES_TL T

339:
340: procedure ADD_LANGUAGE
341: is
342: begin
343: delete from PO_HAZARD_CLASSES_TL T
344: where not exists
345: (select NULL
346: from PO_HAZARD_CLASSES_B B
347: where B.HAZARD_CLASS_ID = T.HAZARD_CLASS_ID

Line 350: update PO_HAZARD_CLASSES_TL T set (

346: from PO_HAZARD_CLASSES_B B
347: where B.HAZARD_CLASS_ID = T.HAZARD_CLASS_ID
348: );
349:
350: update PO_HAZARD_CLASSES_TL T set (
351: HAZARD_CLASS,
352: DESCRIPTION
353: ) = (select
354: B.HAZARD_CLASS,

Line 356: from PO_HAZARD_CLASSES_TL B

352: DESCRIPTION
353: ) = (select
354: B.HAZARD_CLASS,
355: B.DESCRIPTION
356: from PO_HAZARD_CLASSES_TL B
357: where B.HAZARD_CLASS_ID = T.HAZARD_CLASS_ID
358: and B.LANGUAGE = T.SOURCE_LANG)
359: where (
360: T.HAZARD_CLASS_ID,

Line 365: from PO_HAZARD_CLASSES_TL SUBB, PO_HAZARD_CLASSES_TL SUBT

361: T.LANGUAGE
362: ) in (select
363: SUBT.HAZARD_CLASS_ID,
364: SUBT.LANGUAGE
365: from PO_HAZARD_CLASSES_TL SUBB, PO_HAZARD_CLASSES_TL SUBT
366: where SUBB.HAZARD_CLASS_ID = SUBT.HAZARD_CLASS_ID
367: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
368: and (SUBB.HAZARD_CLASS <> SUBT.HAZARD_CLASS
369: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 374: insert into PO_HAZARD_CLASSES_TL (

370: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
371: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
372: ));
373:
374: insert into PO_HAZARD_CLASSES_TL (
375: HAZARD_CLASS_ID,
376: HAZARD_CLASS,
377: DESCRIPTION,
378: CREATION_DATE,

Line 396: from PO_HAZARD_CLASSES_TL B, FND_LANGUAGES L

392: B.LAST_UPDATE_DATE,
393: B.LAST_UPDATE_LOGIN,
394: L.LANGUAGE_CODE,
395: B.SOURCE_LANG
396: from PO_HAZARD_CLASSES_TL B, FND_LANGUAGES L
397: where L.INSTALLED_FLAG in ('I', 'B')
398: and B.LANGUAGE = userenv('LANG')
399: and not exists
400: (select NULL

Line 401: from PO_HAZARD_CLASSES_TL T

397: where L.INSTALLED_FLAG in ('I', 'B')
398: and B.LANGUAGE = userenv('LANG')
399: and not exists
400: (select NULL
401: from PO_HAZARD_CLASSES_TL T
402: where T.HAZARD_CLASS_ID = B.HAZARD_CLASS_ID
403: and T.LANGUAGE = L.LANGUAGE_CODE);
404: end ADD_LANGUAGE;
405: