eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on HZ_STYLE_FMT_LAYOUTS_B

Line 170: FROM HZ_STYLE_FMT_LAYOUTS_B b , HZ_STYLE_FMT_LAYOUTS_TL t

166: x_updated_rec.blank_lines_after,
167: x_updated_rec.prompt,
168: x_updated_rec.start_date_active,
169: x_updated_rec.end_date_active
170: FROM HZ_STYLE_FMT_LAYOUTS_B b , HZ_STYLE_FMT_LAYOUTS_TL t
171: WHERE b.style_fmt_layout_id =t.style_fmt_layout_id AND
172: t.style_fmt_layout_id = p_style_fmt_layout_id AND
173: t.language=userenv('LANG'); ---Bug No. 5178007
174:

Line 1766: l_style_fmt_layout_id HZ_STYLE_FMT_LAYOUTS_B.style_fmt_layout_id%TYPE;

1762: x_return_status IN OUT NOCOPY VARCHAR2
1763: ) IS
1764:
1765: l_dummy VARCHAR2(1);
1766: l_style_fmt_layout_id HZ_STYLE_FMT_LAYOUTS_B.style_fmt_layout_id%TYPE;
1767: l_style_format_code HZ_STYLE_FMT_LAYOUTS_B.style_format_code%TYPE;
1768: l_variation_number HZ_STYLE_FMT_LAYOUTS_B.variation_number%TYPE;
1769: l_attribute_code HZ_STYLE_FMT_LAYOUTS_B.attribute_code%TYPE;
1770: l_attribute_application_id HZ_STYLE_FMT_LAYOUTS_B.attribute_application_id%TYPE;

Line 1767: l_style_format_code HZ_STYLE_FMT_LAYOUTS_B.style_format_code%TYPE;

1763: ) IS
1764:
1765: l_dummy VARCHAR2(1);
1766: l_style_fmt_layout_id HZ_STYLE_FMT_LAYOUTS_B.style_fmt_layout_id%TYPE;
1767: l_style_format_code HZ_STYLE_FMT_LAYOUTS_B.style_format_code%TYPE;
1768: l_variation_number HZ_STYLE_FMT_LAYOUTS_B.variation_number%TYPE;
1769: l_attribute_code HZ_STYLE_FMT_LAYOUTS_B.attribute_code%TYPE;
1770: l_attribute_application_id HZ_STYLE_FMT_LAYOUTS_B.attribute_application_id%TYPE;
1771: l_line_number HZ_STYLE_FMT_LAYOUTS_B.line_number%TYPE;

Line 1768: l_variation_number HZ_STYLE_FMT_LAYOUTS_B.variation_number%TYPE;

1764:
1765: l_dummy VARCHAR2(1);
1766: l_style_fmt_layout_id HZ_STYLE_FMT_LAYOUTS_B.style_fmt_layout_id%TYPE;
1767: l_style_format_code HZ_STYLE_FMT_LAYOUTS_B.style_format_code%TYPE;
1768: l_variation_number HZ_STYLE_FMT_LAYOUTS_B.variation_number%TYPE;
1769: l_attribute_code HZ_STYLE_FMT_LAYOUTS_B.attribute_code%TYPE;
1770: l_attribute_application_id HZ_STYLE_FMT_LAYOUTS_B.attribute_application_id%TYPE;
1771: l_line_number HZ_STYLE_FMT_LAYOUTS_B.line_number%TYPE;
1772: l_position HZ_STYLE_FMT_LAYOUTS_B.position%TYPE;

Line 1769: l_attribute_code HZ_STYLE_FMT_LAYOUTS_B.attribute_code%TYPE;

1765: l_dummy VARCHAR2(1);
1766: l_style_fmt_layout_id HZ_STYLE_FMT_LAYOUTS_B.style_fmt_layout_id%TYPE;
1767: l_style_format_code HZ_STYLE_FMT_LAYOUTS_B.style_format_code%TYPE;
1768: l_variation_number HZ_STYLE_FMT_LAYOUTS_B.variation_number%TYPE;
1769: l_attribute_code HZ_STYLE_FMT_LAYOUTS_B.attribute_code%TYPE;
1770: l_attribute_application_id HZ_STYLE_FMT_LAYOUTS_B.attribute_application_id%TYPE;
1771: l_line_number HZ_STYLE_FMT_LAYOUTS_B.line_number%TYPE;
1772: l_position HZ_STYLE_FMT_LAYOUTS_B.position%TYPE;
1773: l_mandatory_flag HZ_STYLE_FMT_LAYOUTS_B.mandatory_flag%TYPE;

Line 1770: l_attribute_application_id HZ_STYLE_FMT_LAYOUTS_B.attribute_application_id%TYPE;

1766: l_style_fmt_layout_id HZ_STYLE_FMT_LAYOUTS_B.style_fmt_layout_id%TYPE;
1767: l_style_format_code HZ_STYLE_FMT_LAYOUTS_B.style_format_code%TYPE;
1768: l_variation_number HZ_STYLE_FMT_LAYOUTS_B.variation_number%TYPE;
1769: l_attribute_code HZ_STYLE_FMT_LAYOUTS_B.attribute_code%TYPE;
1770: l_attribute_application_id HZ_STYLE_FMT_LAYOUTS_B.attribute_application_id%TYPE;
1771: l_line_number HZ_STYLE_FMT_LAYOUTS_B.line_number%TYPE;
1772: l_position HZ_STYLE_FMT_LAYOUTS_B.position%TYPE;
1773: l_mandatory_flag HZ_STYLE_FMT_LAYOUTS_B.mandatory_flag%TYPE;
1774: l_use_initial_flag HZ_STYLE_FMT_LAYOUTS_B.use_initial_flag%TYPE;

Line 1771: l_line_number HZ_STYLE_FMT_LAYOUTS_B.line_number%TYPE;

1767: l_style_format_code HZ_STYLE_FMT_LAYOUTS_B.style_format_code%TYPE;
1768: l_variation_number HZ_STYLE_FMT_LAYOUTS_B.variation_number%TYPE;
1769: l_attribute_code HZ_STYLE_FMT_LAYOUTS_B.attribute_code%TYPE;
1770: l_attribute_application_id HZ_STYLE_FMT_LAYOUTS_B.attribute_application_id%TYPE;
1771: l_line_number HZ_STYLE_FMT_LAYOUTS_B.line_number%TYPE;
1772: l_position HZ_STYLE_FMT_LAYOUTS_B.position%TYPE;
1773: l_mandatory_flag HZ_STYLE_FMT_LAYOUTS_B.mandatory_flag%TYPE;
1774: l_use_initial_flag HZ_STYLE_FMT_LAYOUTS_B.use_initial_flag%TYPE;
1775: l_uppercase_flag HZ_STYLE_FMT_LAYOUTS_B.uppercase_flag%TYPE;

Line 1772: l_position HZ_STYLE_FMT_LAYOUTS_B.position%TYPE;

1768: l_variation_number HZ_STYLE_FMT_LAYOUTS_B.variation_number%TYPE;
1769: l_attribute_code HZ_STYLE_FMT_LAYOUTS_B.attribute_code%TYPE;
1770: l_attribute_application_id HZ_STYLE_FMT_LAYOUTS_B.attribute_application_id%TYPE;
1771: l_line_number HZ_STYLE_FMT_LAYOUTS_B.line_number%TYPE;
1772: l_position HZ_STYLE_FMT_LAYOUTS_B.position%TYPE;
1773: l_mandatory_flag HZ_STYLE_FMT_LAYOUTS_B.mandatory_flag%TYPE;
1774: l_use_initial_flag HZ_STYLE_FMT_LAYOUTS_B.use_initial_flag%TYPE;
1775: l_uppercase_flag HZ_STYLE_FMT_LAYOUTS_B.uppercase_flag%TYPE;
1776: l_blank_lines_before HZ_STYLE_FMT_LAYOUTS_B.blank_lines_before%TYPE;

Line 1773: l_mandatory_flag HZ_STYLE_FMT_LAYOUTS_B.mandatory_flag%TYPE;

1769: l_attribute_code HZ_STYLE_FMT_LAYOUTS_B.attribute_code%TYPE;
1770: l_attribute_application_id HZ_STYLE_FMT_LAYOUTS_B.attribute_application_id%TYPE;
1771: l_line_number HZ_STYLE_FMT_LAYOUTS_B.line_number%TYPE;
1772: l_position HZ_STYLE_FMT_LAYOUTS_B.position%TYPE;
1773: l_mandatory_flag HZ_STYLE_FMT_LAYOUTS_B.mandatory_flag%TYPE;
1774: l_use_initial_flag HZ_STYLE_FMT_LAYOUTS_B.use_initial_flag%TYPE;
1775: l_uppercase_flag HZ_STYLE_FMT_LAYOUTS_B.uppercase_flag%TYPE;
1776: l_blank_lines_before HZ_STYLE_FMT_LAYOUTS_B.blank_lines_before%TYPE;
1777: l_blank_lines_after HZ_STYLE_FMT_LAYOUTS_B.blank_lines_after%TYPE;

Line 1774: l_use_initial_flag HZ_STYLE_FMT_LAYOUTS_B.use_initial_flag%TYPE;

1770: l_attribute_application_id HZ_STYLE_FMT_LAYOUTS_B.attribute_application_id%TYPE;
1771: l_line_number HZ_STYLE_FMT_LAYOUTS_B.line_number%TYPE;
1772: l_position HZ_STYLE_FMT_LAYOUTS_B.position%TYPE;
1773: l_mandatory_flag HZ_STYLE_FMT_LAYOUTS_B.mandatory_flag%TYPE;
1774: l_use_initial_flag HZ_STYLE_FMT_LAYOUTS_B.use_initial_flag%TYPE;
1775: l_uppercase_flag HZ_STYLE_FMT_LAYOUTS_B.uppercase_flag%TYPE;
1776: l_blank_lines_before HZ_STYLE_FMT_LAYOUTS_B.blank_lines_before%TYPE;
1777: l_blank_lines_after HZ_STYLE_FMT_LAYOUTS_B.blank_lines_after%TYPE;
1778: l_start_date_active date;

Line 1775: l_uppercase_flag HZ_STYLE_FMT_LAYOUTS_B.uppercase_flag%TYPE;

1771: l_line_number HZ_STYLE_FMT_LAYOUTS_B.line_number%TYPE;
1772: l_position HZ_STYLE_FMT_LAYOUTS_B.position%TYPE;
1773: l_mandatory_flag HZ_STYLE_FMT_LAYOUTS_B.mandatory_flag%TYPE;
1774: l_use_initial_flag HZ_STYLE_FMT_LAYOUTS_B.use_initial_flag%TYPE;
1775: l_uppercase_flag HZ_STYLE_FMT_LAYOUTS_B.uppercase_flag%TYPE;
1776: l_blank_lines_before HZ_STYLE_FMT_LAYOUTS_B.blank_lines_before%TYPE;
1777: l_blank_lines_after HZ_STYLE_FMT_LAYOUTS_B.blank_lines_after%TYPE;
1778: l_start_date_active date;
1779: l_end_date_active date;

Line 1776: l_blank_lines_before HZ_STYLE_FMT_LAYOUTS_B.blank_lines_before%TYPE;

1772: l_position HZ_STYLE_FMT_LAYOUTS_B.position%TYPE;
1773: l_mandatory_flag HZ_STYLE_FMT_LAYOUTS_B.mandatory_flag%TYPE;
1774: l_use_initial_flag HZ_STYLE_FMT_LAYOUTS_B.use_initial_flag%TYPE;
1775: l_uppercase_flag HZ_STYLE_FMT_LAYOUTS_B.uppercase_flag%TYPE;
1776: l_blank_lines_before HZ_STYLE_FMT_LAYOUTS_B.blank_lines_before%TYPE;
1777: l_blank_lines_after HZ_STYLE_FMT_LAYOUTS_B.blank_lines_after%TYPE;
1778: l_start_date_active date;
1779: l_end_date_active date;
1780: l_debug_prefix VARCHAR2(30) := '';

Line 1777: l_blank_lines_after HZ_STYLE_FMT_LAYOUTS_B.blank_lines_after%TYPE;

1773: l_mandatory_flag HZ_STYLE_FMT_LAYOUTS_B.mandatory_flag%TYPE;
1774: l_use_initial_flag HZ_STYLE_FMT_LAYOUTS_B.use_initial_flag%TYPE;
1775: l_uppercase_flag HZ_STYLE_FMT_LAYOUTS_B.uppercase_flag%TYPE;
1776: l_blank_lines_before HZ_STYLE_FMT_LAYOUTS_B.blank_lines_before%TYPE;
1777: l_blank_lines_after HZ_STYLE_FMT_LAYOUTS_B.blank_lines_after%TYPE;
1778: l_start_date_active date;
1779: l_end_date_active date;
1780: l_debug_prefix VARCHAR2(30) := '';
1781: l_dup_style_fmt_layout_id HZ_STYLE_FMT_LAYOUTS_B.style_fmt_layout_id%TYPE;

Line 1781: l_dup_style_fmt_layout_id HZ_STYLE_FMT_LAYOUTS_B.style_fmt_layout_id%TYPE;

1777: l_blank_lines_after HZ_STYLE_FMT_LAYOUTS_B.blank_lines_after%TYPE;
1778: l_start_date_active date;
1779: l_end_date_active date;
1780: l_debug_prefix VARCHAR2(30) := '';
1781: l_dup_style_fmt_layout_id HZ_STYLE_FMT_LAYOUTS_B.style_fmt_layout_id%TYPE;
1782: l_updated_stl_fmt_layout_rec HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_TYPE;
1783: l_max_line_number NUMBER;
1784: l_min_line_number NUMBER;
1785: l_database_object_name VARCHAR2(30);

Line 1789: FROM hz_style_fmt_layouts_b hsfl

1785: l_database_object_name VARCHAR2(30);
1786:
1787: CURSOR c_dup (p_style_fmt_layout_id IN NUMBER) IS
1788: SELECT 'Y'
1789: FROM hz_style_fmt_layouts_b hsfl
1790: WHERE hsfl.style_fmt_layout_id = p_style_fmt_layout_id;
1791:
1792: BEGIN
1793: --enable_debug;

Line 1835: FROM HZ_STYLE_FMT_LAYOUTS_B

1831: l_blank_lines_before,
1832: l_blank_lines_after,
1833: l_start_date_active,
1834: l_end_date_active
1835: FROM HZ_STYLE_FMT_LAYOUTS_B
1836: WHERE ROWID = p_rowid;
1837:
1838: get_updated_record (
1839: p_style_fmt_layout_id => p_style_fmt_layout_rec.style_fmt_layout_id,

Line 2208: from HZ_STYLE_FMT_LAYOUTS_B

2204: p_style_fmt_layout_rec.attribute_application_id IS NOT NULL
2205: THEN
2206: BEGIN
2207: select style_fmt_layout_id into l_dup_style_fmt_layout_id
2208: from HZ_STYLE_FMT_LAYOUTS_B
2209: where style_format_code = p_style_fmt_layout_rec.style_format_code AND
2210: variation_number = p_style_fmt_layout_rec.variation_number AND
2211: attribute_code = p_style_fmt_layout_rec.attribute_code AND
2212: attribute_application_id = p_style_fmt_layout_rec.attribute_application_id AND

Line 2243: from HZ_STYLE_FMT_LAYOUTS_B

2239: THEN
2240:
2241: BEGIN
2242: select style_fmt_layout_id into l_dup_style_fmt_layout_id
2243: from HZ_STYLE_FMT_LAYOUTS_B
2244: where style_fmt_layout_id <> l_updated_stl_fmt_layout_rec.style_fmt_layout_id AND
2245: style_format_code = l_updated_stl_fmt_layout_rec.style_format_code AND
2246: variation_number = l_updated_stl_fmt_layout_rec.variation_number AND
2247: attribute_code = l_updated_stl_fmt_layout_rec.attribute_code AND

Line 2389: from HZ_STYLE_FMT_LAYOUTS_B

2385: p_style_fmt_layout_rec.position IS NOT NULL
2386: THEN
2387: BEGIN
2388: select style_fmt_layout_id into l_dup_style_fmt_layout_id
2389: from HZ_STYLE_FMT_LAYOUTS_B
2390: where style_format_code = p_style_fmt_layout_rec.style_format_code AND
2391: variation_number = p_style_fmt_layout_rec.variation_number AND
2392: line_number = p_style_fmt_layout_rec.line_number AND
2393: position = p_style_fmt_layout_rec.position AND

Line 2424: from HZ_STYLE_FMT_LAYOUTS_B

2420: THEN
2421:
2422: BEGIN
2423: select style_fmt_layout_id into l_dup_style_fmt_layout_id
2424: from HZ_STYLE_FMT_LAYOUTS_B
2425: where style_fmt_layout_id <> l_updated_stl_fmt_layout_rec.style_fmt_layout_id AND
2426: style_format_code = l_updated_stl_fmt_layout_rec.style_format_code AND
2427: variation_number = l_updated_stl_fmt_layout_rec.variation_number AND
2428: line_number = l_updated_stl_fmt_layout_rec.line_number AND