DBA Data[Home] [Help]

APPS.CZ_FCE_COMPILE dependencies on CZ_LOCALIZED_TEXTS

Line 5012: l_text cz_localized_texts.localized_str%TYPE;

5008:
5009: PROCEDURE set_reason_id IS
5010:
5011: l_id NUMBER;
5012: l_text cz_localized_texts.localized_str%TYPE;
5013:
5014: BEGIN
5015:
5016: --reason_id for constraints, for which we call this procedure, cannot be null, so

Line 5023: SELECT persistent_intl_text_id, localized_str INTO l_id, l_text FROM cz_localized_texts

5019: IF ( this_reason_id IS NOT NULL ) THEN
5020:
5021: --Bug #6899574. Need to get the persistent id of localized text record.
5022:
5023: SELECT persistent_intl_text_id, localized_str INTO l_id, l_text FROM cz_localized_texts
5024: WHERE deleted_flag = '0' AND language = USERENV ('LANG') AND intl_text_id = this_reason_id;
5025:
5026: comment ( 'Set rule violation message: "' || l_text || '"' );
5027: