1: package body CZ_LOCALIZED_TEXTS_PKG as
2: /* $Header: cziloctb.pls 120.4.12020000.2 2012/08/22 11:14:58 vigramak ship $ */
3:
4: NO_MODEL_ID NUMBER := -1;
5:
309: fetch c_lktx into s_intlid;
310:
311: if (c_lktx%notfound) then
312: -- No matching rows
313: CZ_LOCALIZED_TEXTS_PKG.INSERT_ROW(
314: X_ROWID => row_id,
315: X_INTL_TEXT_ID => X_INTL_TEXT_ID,
316: X_LOCALIZED_STR => X_LOCALIZED_STR,
317: X_ORIG_SYS_REF => X_ORIG_SYS_REF,
331: );
332: else
333: loop
334: -- Update row in all matching locales
335: CZ_LOCALIZED_TEXTS_PKG.UPDATE_ROW (
336: X_INTL_TEXT_ID => X_INTL_TEXT_ID,
337: X_LOCALIZED_STR => X_LOCALIZED_STR,
338: X_ORIG_SYS_REF => X_ORIG_SYS_REF,
339: X_CREATION_DATE => SYSDATE,
402: fetch c_lktx into s_intlid;
403:
404: if (c_lktx%notfound) then
405: -- No matching rows
406: CZ_LOCALIZED_TEXTS_PKG.INSERT_ROW(
407: X_ROWID => row_id,
408: X_INTL_TEXT_ID => X_INTL_TEXT_ID,
409: X_LOCALIZED_STR => X_LOCALIZED_STR,
410: X_ORIG_SYS_REF => X_ORIG_SYS_REF,
424: );
425: else
426: loop
427: -- Update row in all matching locales
428: CZ_LOCALIZED_TEXTS_PKG.UPDATE_ROW (
429: X_INTL_TEXT_ID => X_INTL_TEXT_ID,
430: X_LOCALIZED_STR => X_LOCALIZED_STR,
431: X_ORIG_SYS_REF => X_ORIG_SYS_REF,
432: X_DELETED_FLAG => X_DELETED_FLAG);
439:
440: end LOAD_ROW;
441:
442:
443: end CZ_LOCALIZED_TEXTS_PKG;