APPS.HZ_STYLE_FMT_LAYOUTS_PKG dependencies on HZ_STYLE_FMT_LAYOUTS_B

Line 28: cursor C is select ROWID from HZ_STYLE_FMT_LAYOUTS_B

24: X_START_DATE_ACTIVE in DATE,
25: X_END_DATE_ACTIVE in DATE,
26: X_OBJECT_VERSION_NUMBER IN NUMBER
27: ) is
28: cursor C is select ROWID from HZ_STYLE_FMT_LAYOUTS_B
29: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
30: ;
31: begin
32: insert into HZ_STYLE_FMT_LAYOUTS_B (

Line 32: insert into HZ_STYLE_FMT_LAYOUTS_B (

28: cursor C is select ROWID from HZ_STYLE_FMT_LAYOUTS_B
29: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
30: ;
31: begin
32: insert into HZ_STYLE_FMT_LAYOUTS_B (
33: STYLE_FMT_LAYOUT_ID,
34: STYLE_FORMAT_CODE,
35: VARIATION_NUMBER,
36: ATTRIBUTE_CODE,

Line 156: from HZ_STYLE_FMT_LAYOUTS_B

152: DELIMITER_BEFORE,
153: DELIMITER_AFTER,
154: BLANK_LINES_BEFORE,
155: BLANK_LINES_AFTER
156: from HZ_STYLE_FMT_LAYOUTS_B
157: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
158: for update of STYLE_FMT_LAYOUT_ID nowait;
159: recinfo c%rowtype;
160:

Line 240: update HZ_STYLE_FMT_LAYOUTS_B set

236: X_END_DATE_ACTIVE in DATE,
237: X_OBJECT_VERSION_NUMBER IN NUMBER
238: ) is
239: begin
240: update HZ_STYLE_FMT_LAYOUTS_B set
241: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
242: VARIATION_NUMBER = DECODE( X_VARIATION_NUMBER, NULL, VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
243: ATTRIBUTE_CODE = DECODE( X_ATTRIBUTE_CODE, NULL, ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
244: ATTRIBUTE_APPLICATION_ID = DECODE( X_ATTRIBUTE_APPLICATION_ID, NULL, ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),

Line 342: FROM HZ_STYLE_FMT_LAYOUTS_B B, HZ_STYLE_FMT_LAYOUTS_TL T

338: X_BLANK_LINES_AFTER ,
339: X_PROMPT,
340: X_START_DATE_ACTIVE ,
341: X_END_DATE_ACTIVE
342: FROM HZ_STYLE_FMT_LAYOUTS_B B, HZ_STYLE_FMT_LAYOUTS_TL T
343: WHERE B.STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
344: AND T.STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
345: AND T.LANGUAGE = userenv('LANG');
346:

Line 368: delete from HZ_STYLE_FMT_LAYOUTS_B

364: if (sql%notfound) then
365: raise no_data_found;
366: end if;
367:
368: delete from HZ_STYLE_FMT_LAYOUTS_B
369: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID;
370:
371: if (sql%notfound) then
372: raise no_data_found;

Line 382: from HZ_STYLE_FMT_LAYOUTS_B B

378: begin
379: delete from HZ_STYLE_FMT_LAYOUTS_TL T
380: where not exists
381: (select NULL
382: from HZ_STYLE_FMT_LAYOUTS_B B
383: where B.STYLE_FMT_LAYOUT_ID = T.STYLE_FMT_LAYOUT_ID
384: );
385:
386: update HZ_STYLE_FMT_LAYOUTS_TL T set (

Line 490: from HZ_STYLE_FMT_LAYOUTS_B

486:
487: begin
488: select STYLE_FMT_LAYOUT_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER
489: into l_id, l_db_luby, l_db_ludate, l_object_version_number
490: from HZ_STYLE_FMT_LAYOUTS_B
491: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
492: and VARIATION_NUMBER = X_VARIATION_NUMBER
493: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
494: and ATTRIBUTE_APPLICATION_ID = l_app_id;

Line 595: from HZ_STYLE_FMT_LAYOUTS_B

591: l_f_ludate := nvl(x_last_update_date, sysdate);
592:
593: begin
594: select STYLE_FMT_LAYOUT_ID into l_id
595: from HZ_STYLE_FMT_LAYOUTS_B
596: where STYLE_FORMAT_CODE = x_style_format_code
597: and VARIATION_NUMBER = x_variation_number
598: and ATTRIBUTE_CODE = x_attribute_code
599: and ATTRIBUTE_APPLICATION_ID = l_app_id;