APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on HZ_STYLES_B

Line 222: l_style_code HZ_STYLES_B.style_code%TYPE;

218: x_return_status IN OUT NOCOPY VARCHAR2
219: ) IS
220:
221: l_dummy VARCHAR2(1);
222: l_style_code HZ_STYLES_B.style_code%TYPE;
223: l_style_name HZ_STYLES_TL.style_name%TYPE;
224: l_database_object_name HZ_STYLES_B.database_object_name%TYPE;
225: l_debug_prefix VARCHAR2(30) := '';
226:

Line 224: l_database_object_name HZ_STYLES_B.database_object_name%TYPE;

220:
221: l_dummy VARCHAR2(1);
222: l_style_code HZ_STYLES_B.style_code%TYPE;
223: l_style_name HZ_STYLES_TL.style_name%TYPE;
224: l_database_object_name HZ_STYLES_B.database_object_name%TYPE;
225: l_debug_prefix VARCHAR2(30) := '';
226:
227: BEGIN
228:

Line 246: FROM HZ_STYLES_B b , HZ_STYLES_TL t

242: b.database_object_name
243: INTO l_style_code,
244: l_style_name,
245: l_database_object_name
246: FROM HZ_STYLES_B b , HZ_STYLES_TL t
247: WHERE b.ROWID = p_rowid
248: AND t.style_code = b.style_code
249: AND t.language = userenv('LANG');
250:

Line 297: from HZ_STYLES_B

293: p_style_rec.style_code IS NOT NULL
294: THEN
295: BEGIN
296: select 'Y' into l_dummy
297: from HZ_STYLES_B
298: where style_code = p_style_rec.style_code;
299:
300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
301: FND_MESSAGE.SET_TOKEN('COLUMN', 'style_code');

Line 638: -- style_code is foreign key of hz_styles_b

634: p_msg_level=>fnd_log.level_statement);
635: END IF;
636: END IF;
637:
638: -- style_code is foreign key of hz_styles_b
639: -- Do not need to check during update because style_code is
640: -- non-updateable.
641: IF p_create_update_flag = 'C'
642: AND

Line 650: FROM HZ_STYLES_B

646: THEN
647: BEGIN
648: SELECT 'Y'
649: INTO l_dummy
650: FROM HZ_STYLES_B
651: WHERE style_code = p_style_format_rec.style_code;
652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
654: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 657: fnd_message.set_token('TABLE', 'hz_styles_b');

653: WHEN NO_DATA_FOUND THEN
654: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
655: fnd_message.set_token('FK', 'style_code');
656: fnd_message.set_token('COLUMN', 'style_code');
657: fnd_message.set_token('TABLE', 'hz_styles_b');
658: fnd_msg_pub.add;
659: x_return_status := fnd_api.g_ret_sts_error;
660: END;
661:

Line 663: hz_utility_v2pub.debug(p_message=>'style_code is foreign key of hz_styles_b. ' ||

659: x_return_status := fnd_api.g_ret_sts_error;
660: END;
661:
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'style_code is foreign key of hz_styles_b. ' ||
664: 'x_return_status = ' || x_return_status,
665: p_prefix =>l_debug_prefix,
666: p_msg_level=>fnd_log.level_statement);
667: END IF;

Line 2163: FROM hz_style_formats_b sf, hz_styles_b s

2159: THEN
2160: BEGIN
2161: SELECT database_object_name
2162: INTO l_database_object_name
2163: FROM hz_style_formats_b sf, hz_styles_b s
2164: WHERE sf.style_format_code = p_style_fmt_layout_rec.style_format_code AND
2165: s.style_code = sf.style_code;
2166:
2167: SELECT 'Y'