APPS.HZ_STYLE_FORMATS_PKG dependencies on HZ_STYLE_FORMATS_B

Line 16: cursor C is select ROWID from HZ_STYLE_FORMATS_B

12: X_STYLE_FORMAT_NAME in VARCHAR2,
13: X_DESCRIPTION in VARCHAR2,
14: X_OBJECT_VERSION_NUMBER IN NUMBER
15: ) is
16: cursor C is select ROWID from HZ_STYLE_FORMATS_B
17: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
18: ;
19: begin
20: insert into HZ_STYLE_FORMATS_B (

Line 20: insert into HZ_STYLE_FORMATS_B (

16: cursor C is select ROWID from HZ_STYLE_FORMATS_B
17: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
18: ;
19: begin
20: insert into HZ_STYLE_FORMATS_B (
21: STYLE_FORMAT_CODE,
22: STYLE_CODE,
23: DEFAULT_FLAG,
24: CREATED_BY,

Line 92: from HZ_STYLE_FORMATS_B

88: ) is
89: cursor c is select
90: STYLE_CODE,
91: DEFAULT_FLAG
92: from HZ_STYLE_FORMATS_B
93: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
94: for update of STYLE_FORMAT_CODE nowait;
95: recinfo c%rowtype;
96:

Line 148: update HZ_STYLE_FORMATS_B set

144: X_DESCRIPTION in VARCHAR2,
145: X_OBJECT_VERSION_NUMBER IN NUMBER
146: ) is
147: begin
148: update HZ_STYLE_FORMATS_B set
149: STYLE_CODE = DECODE( X_STYLE_CODE, NULL, STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
150: DEFAULT_FLAG = DECODE( X_DEFAULT_FLAG, NULL, DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, X_DEFAULT_FLAG ),
151: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
152: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),

Line 197: FROM HZ_STYLE_FORMATS_B B, HZ_STYLE_FORMATS_TL T

193: X_STYLE_CODE,
194: X_DEFAULT_FLAG,
195: X_STYLE_FORMAT_NAME,
196: X_DESCRIPTION
197: FROM HZ_STYLE_FORMATS_B B, HZ_STYLE_FORMATS_TL T
198: WHERE B.STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
199: AND T.STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
200: AND T.LANGUAGE = userenv('LANG');
201:

Line 223: delete from HZ_STYLE_FORMATS_B

219: if (sql%notfound) then
220: raise no_data_found;
221: end if;
222:
223: delete from HZ_STYLE_FORMATS_B
224: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE;
225:
226: if (sql%notfound) then
227: raise no_data_found;

Line 237: from HZ_STYLE_FORMATS_B B

233: begin
234: delete from HZ_STYLE_FORMATS_TL T
235: where not exists
236: (select NULL
237: from HZ_STYLE_FORMATS_B B
238: where B.STYLE_FORMAT_CODE = T.STYLE_FORMAT_CODE
239: );
240:
241: update HZ_STYLE_FORMATS_TL T set (

Line 329: from HZ_STYLE_FORMATS_B

325:
326: begin
327: select LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER
328: into l_db_luby, l_db_ludate, l_object_version_number
329: from HZ_STYLE_FORMATS_B
330: where STYLE_FORMAT_CODE = x_style_format_code;
331:
332: -- Update record, honoring customization mode.
333: -- Record should be updated only if: