APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on HZ_STYLE_FMT_LOCALE_V2PUB

Line 101: p_update_field_rec IN HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE,

97: END check_greater_than_zero;
98:
99: PROCEDURE get_updated_record (
100: p_style_fmt_locale_id IN NUMBER,
101: p_update_field_rec IN HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE,
102: x_updated_rec OUT NOCOPY HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE
103: ) IS
104: BEGIN
105: SELECT

Line 102: x_updated_rec OUT NOCOPY HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE

98:
99: PROCEDURE get_updated_record (
100: p_style_fmt_locale_id IN NUMBER,
101: p_update_field_rec IN HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE,
102: x_updated_rec OUT NOCOPY HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE
103: ) IS
104: BEGIN
105: SELECT
106: style_fmt_locale_id,

Line 847: p_style_fmt_locale_rec IN HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE,

843: --
844:
845: PROCEDURE validate_style_fmt_locale(
846: p_create_update_flag IN VARCHAR2,
847: p_style_fmt_locale_rec IN HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE,
848: p_rowid IN ROWID,
849: x_return_status IN OUT NOCOPY VARCHAR2
850: ) IS
851:

Line 861: l_updated_stl_fmt_rec HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_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'
865: FROM hz_style_fmt_locales hsfl