APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on HZ_STYLE_FMT_LOCALES

Line 119: FROM HZ_STYLE_FMT_LOCALES

115: x_updated_rec.language_code,
116: x_updated_rec.territory_code,
117: x_updated_rec.start_date_active,
118: x_updated_rec.end_date_active
119: FROM HZ_STYLE_FMT_LOCALES
120: WHERE style_fmt_locale_id = p_style_fmt_locale_id;
121:
122:
123: END get_updated_record;

Line 853: l_style_fmt_locale_id HZ_STYLE_FMT_LOCALES.style_fmt_locale_id%TYPE;

849: x_return_status IN OUT NOCOPY VARCHAR2
850: ) IS
851:
852: l_dummy VARCHAR2(1);
853: l_style_fmt_locale_id HZ_STYLE_FMT_LOCALES.style_fmt_locale_id%TYPE;
854: l_style_format_code HZ_STYLE_FMT_LOCALES.style_format_code%TYPE;
855: l_language_code HZ_STYLE_FMT_LOCALES.language_code%TYPE;
856: l_territory_code HZ_STYLE_FMT_LOCALES.territory_code%TYPE;
857: l_start_date_active date;

Line 854: l_style_format_code HZ_STYLE_FMT_LOCALES.style_format_code%TYPE;

850: ) IS
851:
852: l_dummy VARCHAR2(1);
853: l_style_fmt_locale_id HZ_STYLE_FMT_LOCALES.style_fmt_locale_id%TYPE;
854: l_style_format_code HZ_STYLE_FMT_LOCALES.style_format_code%TYPE;
855: l_language_code HZ_STYLE_FMT_LOCALES.language_code%TYPE;
856: l_territory_code HZ_STYLE_FMT_LOCALES.territory_code%TYPE;
857: l_start_date_active date;
858: l_end_date_active date;

Line 855: l_language_code HZ_STYLE_FMT_LOCALES.language_code%TYPE;

851:
852: l_dummy VARCHAR2(1);
853: l_style_fmt_locale_id HZ_STYLE_FMT_LOCALES.style_fmt_locale_id%TYPE;
854: l_style_format_code HZ_STYLE_FMT_LOCALES.style_format_code%TYPE;
855: l_language_code HZ_STYLE_FMT_LOCALES.language_code%TYPE;
856: l_territory_code HZ_STYLE_FMT_LOCALES.territory_code%TYPE;
857: l_start_date_active date;
858: l_end_date_active date;
859: l_debug_prefix VARCHAR2(30) := '';

Line 856: l_territory_code HZ_STYLE_FMT_LOCALES.territory_code%TYPE;

852: l_dummy VARCHAR2(1);
853: l_style_fmt_locale_id HZ_STYLE_FMT_LOCALES.style_fmt_locale_id%TYPE;
854: l_style_format_code HZ_STYLE_FMT_LOCALES.style_format_code%TYPE;
855: l_language_code HZ_STYLE_FMT_LOCALES.language_code%TYPE;
856: l_territory_code HZ_STYLE_FMT_LOCALES.territory_code%TYPE;
857: l_start_date_active date;
858: l_end_date_active date;
859: l_debug_prefix VARCHAR2(30) := '';
860: l_dup_style_fmt_locale_id HZ_STYLE_FMT_LOCALES.style_fmt_locale_id%TYPE;

Line 860: l_dup_style_fmt_locale_id HZ_STYLE_FMT_LOCALES.style_fmt_locale_id%TYPE;

856: l_territory_code HZ_STYLE_FMT_LOCALES.territory_code%TYPE;
857: l_start_date_active date;
858: l_end_date_active date;
859: l_debug_prefix VARCHAR2(30) := '';
860: l_dup_style_fmt_locale_id HZ_STYLE_FMT_LOCALES.style_fmt_locale_id%TYPE;
861: l_updated_stl_fmt_rec HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE;
862:
863: CURSOR c_dup (p_style_fmt_locale_id IN NUMBER) IS
864: SELECT 'Y'

Line 865: FROM hz_style_fmt_locales hsfl

861: l_updated_stl_fmt_rec HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE;
862:
863: CURSOR c_dup (p_style_fmt_locale_id IN NUMBER) IS
864: SELECT 'Y'
865: FROM hz_style_fmt_locales hsfl
866: WHERE hsfl.style_fmt_locale_id = p_style_fmt_locale_id;
867:
868:
869: BEGIN

Line 895: FROM HZ_STYLE_FMT_LOCALES

891: l_language_code,
892: l_territory_code,
893: l_start_date_active,
894: l_end_date_active
895: FROM HZ_STYLE_FMT_LOCALES
896: WHERE ROWID = p_rowid;
897: END IF;
898:
899: -------------------------------

Line 1237: from HZ_STYLE_FMT_LOCALES

1233: p_style_fmt_locale_rec.territory_code IS NOT NULL )
1234: THEN
1235: BEGIN
1236: select style_fmt_locale_id into l_dup_style_fmt_locale_id
1237: from HZ_STYLE_FMT_LOCALES
1238: where style_format_code = p_style_fmt_locale_rec.style_format_code AND
1239: decode(language_code, null, fnd_api.g_miss_char, language_code) = NVL( p_style_fmt_locale_rec.language_code, fnd_api.g_miss_char) AND
1240: decode(territory_code, null, fnd_api.g_miss_char, territory_code) = NVL(p_style_fmt_locale_rec.territory_code, fnd_api.g_miss_char) AND
1241: NOT ( ( p_style_fmt_locale_rec.end_date_active is not null and

Line 1275: from HZ_STYLE_FMT_LOCALES

1271: x_updated_rec => l_updated_stl_fmt_rec );
1272:
1273: BEGIN
1274: select style_fmt_locale_id into l_dup_style_fmt_locale_id
1275: from HZ_STYLE_FMT_LOCALES
1276: where style_fmt_locale_id <> l_updated_stl_fmt_rec.style_fmt_locale_id AND
1277: style_format_code = l_updated_stl_fmt_rec.style_format_code AND
1278: decode(language_code, null, fnd_api.g_miss_char, language_code) = NVL( l_updated_stl_fmt_rec.language_code, fnd_api.g_miss_char) AND
1279: decode(territory_code, null, fnd_api.g_miss_char, territory_code) = NVL(l_updated_stl_fmt_rec.territory_code, fnd_api.g_miss_char) AND