APPS.HZ_WORD_REPLACEMENT_PUB dependencies on HZ_WORD_REPLACEMENTS

Line 324: HZ_WORD_REPLACEMENTS_PKG.INSERT_ROW(

320: END IF;
321:
322: --Call table-handler.
323:
324: HZ_WORD_REPLACEMENTS_PKG.INSERT_ROW(
325: X_Rowid => l_Rowid,
326: X_ORIGINAL_WORD => p_word_replacement_rec.ORIGINAL_WORD,
327: X_REPLACEMENT_WORD => p_word_replacement_rec.REPLACEMENT_WORD,
328: X_TYPE => p_word_replacement_rec.TYPE,

Line 414: select rowid INTO l_rowid FROM hz_word_replacements

410: --Pass back last_update_date.
411: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
412:
413: --Select rowid.
414: select rowid INTO l_rowid FROM hz_word_replacements
415: WHERE original_word = p_word_replacement_rec.original_word
416: AND type = p_word_replacement_rec.type;
417:
418: --Call to table-handler.

Line 420: HZ_WORD_REPLACEMENTS_PKG.UPDATE_ROW(

416: AND type = p_word_replacement_rec.type;
417:
418: --Call to table-handler.
419:
420: HZ_WORD_REPLACEMENTS_PKG.UPDATE_ROW(
421: X_Rowid => l_Rowid,
422: X_ORIGINAL_WORD => p_word_replacement_rec.ORIGINAL_WORD,
423: X_REPLACEMENT_WORD => p_word_replacement_rec.REPLACEMENT_WORD,
424: X_TYPE => p_word_replacement_rec.TYPE,

Line 492: FROM hz_word_replacements

488: X_Type IN VARCHAR2
489: )
490: IS
491: SELECT 1
492: FROM hz_word_replacements
493: WHERE original_word = X_Original_Word
494: AND type = X_Type;
495: l_dup_rec c_dup_rec%ROWTYPE;
496: l_count NUMBER;

Line 656: FROM hz_word_replacements

652: x_word_replacement_rec.ATTRIBUTE12,
653: x_word_replacement_rec.ATTRIBUTE13,
654: x_word_replacement_rec.ATTRIBUTE14,
655: x_word_replacement_rec.ATTRIBUTE15
656: FROM hz_word_replacements
657: WHERE original_word = p_original_word
658: AND type = p_type;
659:
660: END;