APPS.HZ_STYLE_FORMAT_V2PUB dependencies on HZ_STYLE_FORMATS_B

Line 132: from HZ_STYLE_FORMATS_B

128:
129: BEGIN
130: -- find the original default style
131: select rowid into l_default_rowid
132: from HZ_STYLE_FORMATS_B
133: where style_code = p_style_format_rec.style_code AND
134: default_flag = 'Y';
135:
136: -- unset the original default record before create a new default record for a particular style_format_code

Line 138: update HZ_STYLE_FORMATS_B

134: default_flag = 'Y';
135:
136: -- unset the original default record before create a new default record for a particular style_format_code
137: IF p_style_format_rec.default_flag = 'Y' THEN
138: update HZ_STYLE_FORMATS_B
139: set default_flag = 'N'
140: where rowid = l_default_rowid;
141: END IF;
142:

Line 202: l_default_flag HZ_STYLE_FORMATS_B.default_flag%TYPE;

198: l_object_version_number NUMBER;
199: l_debug_prefix VARCHAR2(30) := '';
200: l_rowid ROWID;
201: l_default_rowid ROWID := null;
202: l_default_flag HZ_STYLE_FORMATS_B.default_flag%TYPE;
203: l_style_code HZ_STYLE_FORMATS_B.style_code%TYPE;
204: BEGIN
205:
206: -- Debug info.

Line 203: l_style_code HZ_STYLE_FORMATS_B.style_code%TYPE;

199: l_debug_prefix VARCHAR2(30) := '';
200: l_rowid ROWID;
201: l_default_rowid ROWID := null;
202: l_default_flag HZ_STYLE_FORMATS_B.default_flag%TYPE;
203: l_style_code HZ_STYLE_FORMATS_B.style_code%TYPE;
204: BEGIN
205:
206: -- Debug info.
207:

Line 219: FROM HZ_STYLE_FORMATS_B

215: BEGIN
216: -- check last update date.
217: SELECT object_version_number, default_flag, style_code, rowid
218: INTO l_object_version_number, l_default_flag, l_style_code, l_rowid
219: FROM HZ_STYLE_FORMATS_B
220: WHERE style_format_code = p_style_format_rec.style_format_code
221: FOR UPDATE of style_format_code NOWAIT;
222:
223: IF NOT (

Line 263: from HZ_STYLE_FORMATS_B

259: THEN
260: BEGIN
261: -- find the default style record
262: select rowid into l_default_rowid
263: from HZ_STYLE_FORMATS_B
264: where style_code = l_style_code AND
265: default_flag = 'Y';
266:
267: -- unset the original default record before create a new default record for a particular style_format_code

Line 268: update HZ_STYLE_FORMATS_B

264: where style_code = l_style_code AND
265: default_flag = 'Y';
266:
267: -- unset the original default record before create a new default record for a particular style_format_code
268: update HZ_STYLE_FORMATS_B
269: set default_flag = 'N'
270: where rowid = l_default_rowid;
271: EXCEPTION
272: WHEN NO_DATA_FOUND THEN