DBA Data[Home] [Help]

APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on HZ_STYLE_FMT_LAYOUT_V2PUB

Line 127: p_update_field_rec IN HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_TYPE,

123: END get_updated_record;
124:
125: PROCEDURE get_updated_record (
126: p_style_fmt_layout_id IN NUMBER,
127: p_update_field_rec IN HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_TYPE,
128: x_updated_rec OUT NOCOPY HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_TYPE
129: ) IS
130: BEGIN
131:

Line 128: x_updated_rec OUT NOCOPY HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_TYPE

124:
125: PROCEDURE get_updated_record (
126: p_style_fmt_layout_id IN NUMBER,
127: p_update_field_rec IN HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_TYPE,
128: x_updated_rec OUT NOCOPY HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_TYPE
129: ) IS
130: BEGIN
131:
132: SELECT

Line 1760: p_style_fmt_layout_rec IN HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_TYPE,

1756: --
1757:
1758: PROCEDURE validate_style_fmt_layout(
1759: p_create_update_flag IN VARCHAR2,
1760: p_style_fmt_layout_rec IN HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_TYPE,
1761: p_rowid IN ROWID,
1762: x_return_status IN OUT NOCOPY VARCHAR2
1763: ) IS
1764:

Line 1782: l_updated_stl_fmt_layout_rec HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_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);
1786: