APPS.HZ_STYLE_FMT_VARIATIONS_PKG dependencies on HZ_STYLE_FMT_VARIATIONS

Line 1: package body HZ_STYLE_FMT_VARIATIONS_PKG as

1: package body HZ_STYLE_FMT_VARIATIONS_PKG as
2: /* $Header: ARHPSFVB.pls 115.7 2004/02/25 23:15:47 geliu noship $ */
3:
4: L_USER_ID_FOR_SEED NUMBER := NULL;
5:

Line 16: cursor C is select ROWID from HZ_STYLE_FMT_VARIATIONS

12: X_START_DATE_ACTIVE in DATE,
13: X_END_DATE_ACTIVE in DATE,
14: X_OBJECT_VERSION_NUMBER in NUMBER
15: ) is
16: cursor C is select ROWID from HZ_STYLE_FMT_VARIATIONS
17: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE and
18: VARIATION_NUMBER = X_VARIATION_NUMBER
19: ;
20: begin

Line 23: from HZ_STYLE_FMT_VARIATIONS where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE;

19: ;
20: begin
21: if X_VARIATION_NUMBER is null then
22: select nvl(max(VARIATION_NUMBER),0)+1 into X_VARIATION_NUMBER
23: from HZ_STYLE_FMT_VARIATIONS where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE;
24: end if;
25: insert into HZ_STYLE_FMT_VARIATIONS (
26: STYLE_FORMAT_CODE,
27: VARIATION_NUMBER,

Line 25: insert into HZ_STYLE_FMT_VARIATIONS (

21: if X_VARIATION_NUMBER is null then
22: select nvl(max(VARIATION_NUMBER),0)+1 into X_VARIATION_NUMBER
23: from HZ_STYLE_FMT_VARIATIONS where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE;
24: end if;
25: insert into HZ_STYLE_FMT_VARIATIONS (
26: STYLE_FORMAT_CODE,
27: VARIATION_NUMBER,
28: VARIATION_RANK,
29: SELECTION_CONDITION,

Line 72: from HZ_STYLE_FMT_VARIATIONS

68: ) is
69: cursor c is select
70: VARIATION_RANK,
71: SELECTION_CONDITION
72: from HZ_STYLE_FMT_VARIATIONS
73: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
74: and VARIATION_NUMBER = X_VARIATION_NUMBER
75: for update of VARIATION_RANK nowait;
76: recinfo c%rowtype;

Line 110: update HZ_STYLE_FMT_VARIATIONS set

106: X_OBJECT_VERSION_NUMBER in NUMBER
107: ) is
108: begin
109:
110: update HZ_STYLE_FMT_VARIATIONS set
111: VARIATION_RANK = DECODE( X_VARIATION_RANK, NULL, VARIATION_RANK, FND_API.G_MISS_CHAR, NULL, X_VARIATION_RANK ),
112: SELECTION_CONDITION = DECODE( X_SELECTION_CONDITION, NULL, SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
113: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
114: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),

Line 152: FROM HZ_STYLE_FMT_VARIATIONS

148: X_VARIATION_RANK,
149: X_SELECTION_CONDITION,
150: X_START_DATE_ACTIVE,
151: X_END_DATE_ACTIVE
152: FROM HZ_STYLE_FMT_VARIATIONS
153: WHERE STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
154: AND VARIATION_NUMBER = X_VARIATION_NUMBER ;
155:
156: EXCEPTION

Line 173: delete from HZ_STYLE_FMT_VARIATIONS

169: X_STYLE_FORMAT_CODE in VARCHAR2,
170: X_VARIATION_NUMBER in NUMBER
171: ) is
172: begin
173: delete from HZ_STYLE_FMT_VARIATIONS
174: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
175: and VARIATION_NUMBER = X_VARIATION_NUMBER;
176:
177: if (sql%notfound) then

Line 222: from HZ_STYLE_FMT_VARIATIONS

218:
219: begin
220: select LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER
221: into l_db_luby, l_db_ludate, l_object_version_number
222: from HZ_STYLE_FMT_VARIATIONS
223: where STYLE_FORMAT_CODE = x_style_format_code
224: and VARIATION_NUMBER = x_variation_number;
225:
226: -- Update record, honoring customization mode.

Line 236: hz_style_fmt_variations_pkg.update_row (

232: if ((x_custom_mode = 'FORCE') or
233: ((l_f_luby = 0) and (l_db_luby = 1)) or
234: ((l_f_luby = l_db_luby) and (l_f_ludate > l_db_ludate)))
235: then
236: hz_style_fmt_variations_pkg.update_row (
237: X_STYLE_FORMAT_CODE => X_STYLE_FORMAT_CODE,
238: X_VARIATION_NUMBER => X_VARIATION_NUMBER,
239: X_VARIATION_RANK => X_VARIATION_RANK,
240: X_SELECTION_CONDITION => X_SELECTION_CONDITION,

Line 250: hz_style_fmt_variations_pkg.insert_row(

246:
247: exception
248: when no_data_found then
249: -- record not found, insert in all cases
250: hz_style_fmt_variations_pkg.insert_row(
251: x_rowid => l_rowid,
252: x_style_format_code => X_STYLE_FORMAT_CODE,
253: x_variation_number => l_variation_number,
254: x_variation_rank => X_VARIATION_RANK,

Line 264: end HZ_STYLE_FMT_VARIATIONS_PKG;

260: end;
261:
262: end LOAD_ROW;
263:
264: end HZ_STYLE_FMT_VARIATIONS_PKG;