APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on HZ_STYLE_FMT_VARIATIONS

Line 1357: l_style_format_code HZ_STYLE_FMT_VARIATIONS.style_format_code%TYPE;

1353: p_style_fmt_variation_rec IN HZ_STYLE_FMT_VARIATION_V2PUB.STYLE_FMT_VARIATION_REC_TYPE,
1354: p_rowid IN ROWID,
1355: x_return_status IN OUT NOCOPY VARCHAR2
1356: )IS
1357: l_style_format_code HZ_STYLE_FMT_VARIATIONS.style_format_code%TYPE;
1358: l_variation_number HZ_STYLE_FMT_VARIATIONS.variation_number%TYPE;
1359: l_variation_rank HZ_STYLE_FMT_VARIATIONS.variation_rank%TYPE;
1360: l_start_date_active HZ_STYLE_FMT_VARIATIONS.start_date_active%TYPE;
1361: l_end_date_active HZ_STYLE_FMT_VARIATIONS.end_date_active%TYPE;

Line 1358: l_variation_number HZ_STYLE_FMT_VARIATIONS.variation_number%TYPE;

1354: p_rowid IN ROWID,
1355: x_return_status IN OUT NOCOPY VARCHAR2
1356: )IS
1357: l_style_format_code HZ_STYLE_FMT_VARIATIONS.style_format_code%TYPE;
1358: l_variation_number HZ_STYLE_FMT_VARIATIONS.variation_number%TYPE;
1359: l_variation_rank HZ_STYLE_FMT_VARIATIONS.variation_rank%TYPE;
1360: l_start_date_active HZ_STYLE_FMT_VARIATIONS.start_date_active%TYPE;
1361: l_end_date_active HZ_STYLE_FMT_VARIATIONS.end_date_active%TYPE;
1362: l_dummy VARCHAR2(1);

Line 1359: l_variation_rank HZ_STYLE_FMT_VARIATIONS.variation_rank%TYPE;

1355: x_return_status IN OUT NOCOPY VARCHAR2
1356: )IS
1357: l_style_format_code HZ_STYLE_FMT_VARIATIONS.style_format_code%TYPE;
1358: l_variation_number HZ_STYLE_FMT_VARIATIONS.variation_number%TYPE;
1359: l_variation_rank HZ_STYLE_FMT_VARIATIONS.variation_rank%TYPE;
1360: l_start_date_active HZ_STYLE_FMT_VARIATIONS.start_date_active%TYPE;
1361: l_end_date_active HZ_STYLE_FMT_VARIATIONS.end_date_active%TYPE;
1362: l_dummy VARCHAR2(1);
1363: l_debug_prefix VARCHAR2(30) := '';

Line 1360: l_start_date_active HZ_STYLE_FMT_VARIATIONS.start_date_active%TYPE;

1356: )IS
1357: l_style_format_code HZ_STYLE_FMT_VARIATIONS.style_format_code%TYPE;
1358: l_variation_number HZ_STYLE_FMT_VARIATIONS.variation_number%TYPE;
1359: l_variation_rank HZ_STYLE_FMT_VARIATIONS.variation_rank%TYPE;
1360: l_start_date_active HZ_STYLE_FMT_VARIATIONS.start_date_active%TYPE;
1361: l_end_date_active HZ_STYLE_FMT_VARIATIONS.end_date_active%TYPE;
1362: l_dummy VARCHAR2(1);
1363: l_debug_prefix VARCHAR2(30) := '';
1364:

Line 1361: l_end_date_active HZ_STYLE_FMT_VARIATIONS.end_date_active%TYPE;

1357: l_style_format_code HZ_STYLE_FMT_VARIATIONS.style_format_code%TYPE;
1358: l_variation_number HZ_STYLE_FMT_VARIATIONS.variation_number%TYPE;
1359: l_variation_rank HZ_STYLE_FMT_VARIATIONS.variation_rank%TYPE;
1360: l_start_date_active HZ_STYLE_FMT_VARIATIONS.start_date_active%TYPE;
1361: l_end_date_active HZ_STYLE_FMT_VARIATIONS.end_date_active%TYPE;
1362: l_dummy VARCHAR2(1);
1363: l_debug_prefix VARCHAR2(30) := '';
1364:
1365: BEGIN

Line 1391: FROM HZ_STYLE_FMT_VARIATIONS

1387: l_variation_number,
1388: l_variation_rank,
1389: l_start_date_active,
1390: l_end_date_active
1391: FROM HZ_STYLE_FMT_VARIATIONS
1392: WHERE ROWID = p_rowid;
1393: END IF;
1394:
1395: -----------------------------

Line 1509: from HZ_STYLE_FMT_VARIATIONS

1505: IF p_create_update_flag = 'C'
1506: THEN
1507: BEGIN
1508: select 'Y' into l_dummy
1509: from HZ_STYLE_FMT_VARIATIONS
1510: where variation_number = p_style_fmt_variation_rec.variation_number
1511: and style_format_code = p_style_fmt_variation_rec.style_format_code;
1512:
1513: FND_MESSAGE.SET_NAME('AR', 'HZ_VARIATION_NO_DUP');

Line 1576: from HZ_STYLE_FMT_VARIATIONS

1572: p_style_fmt_variation_rec.variation_rank <> l_variation_rank)
1573: THEN
1574: BEGIN
1575: select 'Y' into l_dummy
1576: from HZ_STYLE_FMT_VARIATIONS
1577: where variation_rank = p_style_fmt_variation_rec.variation_rank
1578: and style_format_code = p_style_fmt_variation_rec.style_format_code;
1579:
1580: FND_MESSAGE.SET_NAME('AR', 'HZ_VARIATION_RANK_DUP');

Line 1994: FROM HZ_STYLE_FMT_VARIATIONS

1990: THEN
1991: BEGIN
1992: SELECT 'Y'
1993: INTO l_dummy
1994: FROM HZ_STYLE_FMT_VARIATIONS
1995: WHERE style_format_code = p_style_fmt_layout_rec.style_format_code AND
1996: variation_number = p_style_fmt_layout_rec.variation_number;
1997:
1998: -- Start date and end date should be within the time range of the corresponding style format variation

Line 2002: FROM HZ_STYLE_FMT_VARIATIONS

1998: -- Start date and end date should be within the time range of the corresponding style format variation
1999: BEGIN
2000: SELECT 'Y'
2001: INTO l_dummy
2002: FROM HZ_STYLE_FMT_VARIATIONS
2003: WHERE style_format_code = p_style_fmt_layout_rec.style_format_code AND
2004: variation_number = p_style_fmt_layout_rec.variation_number AND
2005: p_style_fmt_layout_rec.start_date_active
2006: BETWEEN start_date_active AND NVL(end_date_active, to_date('12/31/4712','MM/DD/YYYY')) AND

Line 2033: hz_utility_v2pub.debug(p_message=>'style_format_code and variation_number are foreign key of table hz_style_fmt_variations .' ||

2029: fnd_msg_pub.add;
2030: x_return_status := fnd_api.g_ret_sts_error;
2031: END;
2032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2033: hz_utility_v2pub.debug(p_message=>'style_format_code and variation_number are foreign key of table hz_style_fmt_variations .' ||
2034: 'x_return_status = ' || x_return_status,
2035: p_prefix =>l_debug_prefix,
2036: p_msg_level=>fnd_log.level_statement);
2037: END IF;

Line 2045: FROM HZ_STYLE_FMT_VARIATIONS

2041: THEN
2042: BEGIN
2043: SELECT 'Y'
2044: INTO l_dummy
2045: FROM HZ_STYLE_FMT_VARIATIONS
2046: WHERE style_format_code = l_updated_stl_fmt_layout_rec.style_format_code AND
2047: variation_number = l_updated_stl_fmt_layout_rec.variation_number AND
2048: l_updated_stl_fmt_layout_rec.start_date_active BETWEEN start_date_active
2049: AND NVL(end_date_active, to_date('12/31/4712','MM/DD/YYYY')) AND