APPS.BNE_STYLES_PKG dependencies on BNE_STYLES

Line 1: package body BNE_STYLES_PKG as

1: package body BNE_STYLES_PKG as
2: /* $Header: bnestyleb.pls 120.2 2005/06/29 03:41:08 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 20: cursor C is select ROWID from BNE_STYLES

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from BNE_STYLES
21: where APPLICATION_ID = X_APPLICATION_ID
22: and STYLE_CODE = X_STYLE_CODE
23: ;
24: begin

Line 25: insert into BNE_STYLES (

21: where APPLICATION_ID = X_APPLICATION_ID
22: and STYLE_CODE = X_STYLE_CODE
23: ;
24: begin
25: insert into BNE_STYLES (
26: PARENT_STYLE_CODE,
27: PARENT_STYLE_APP_ID,
28: APPLICATION_ID,
29: STYLE_CODE,

Line 82: from BNE_STYLES

78: OBJECT_VERSION_NUMBER,
79: STYLESHEET_APP_ID,
80: STYLESHEET_CODE,
81: STYLE_CLASS
82: from BNE_STYLES
83: where APPLICATION_ID = X_APPLICATION_ID
84: and STYLE_CODE = X_STYLE_CODE
85: for update of APPLICATION_ID nowait;
86: begin

Line 120: update BNE_STYLES set

116: X_LAST_UPDATED_BY in NUMBER,
117: X_LAST_UPDATE_LOGIN in NUMBER
118: ) is
119: begin
120: update BNE_STYLES set
121: PARENT_STYLE_CODE = X_PARENT_STYLE_CODE,
122: PARENT_STYLE_APP_ID = X_PARENT_STYLE_APP_ID,
123: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
124: STYLESHEET_APP_ID = X_STYLESHEET_APP_ID,

Line 143: delete from BNE_STYLES

139: X_APPLICATION_ID in NUMBER,
140: X_STYLE_CODE in VARCHAR2
141: ) is
142: begin
143: delete from BNE_STYLES
144: where APPLICATION_ID = X_APPLICATION_ID
145: and STYLE_CODE = X_STYLE_CODE;
146:
147: if (sql%notfound) then

Line 162: -- DESCRIPTION: Load a row into the BNE_STYLES entity. --

158:
159: --------------------------------------------------------------------------------
160: -- PROCEDURE: LOAD_ROW --
161: -- --
162: -- DESCRIPTION: Load a row into the BNE_STYLES entity. --
163: -- This proc is called from the apps loader. --
164: -- --
165: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
166: -- --

Line 209: from BNE_STYLES

205: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
206: begin
207: select LAST_UPDATED_BY, LAST_UPDATE_DATE
208: into db_luby, db_ludate
209: from BNE_STYLES
210: where APPLICATION_ID = l_app_id
211: and STYLE_CODE = x_style_code;
212:
213: -- Test for customization and version

Line 217: BNE_STYLES_PKG.Update_Row(

213: -- Test for customization and version
214: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
215: db_ludate, x_custom_mode)) then
216: -- Update existing row
217: BNE_STYLES_PKG.Update_Row(
218: X_APPLICATION_ID => l_app_id,
219: X_STYLE_CODE => x_style_code,
220: X_PARENT_STYLE_CODE => x_parent_style_code,
221: X_PARENT_STYLE_APP_ID => l_par_app_id,

Line 234: BNE_STYLES_PKG.Insert_Row(

230: end if;
231: exception
232: when no_data_found then
233: -- Record doesn't exist - insert in all cases
234: BNE_STYLES_PKG.Insert_Row(
235: X_ROWID => l_row_id,
236: X_APPLICATION_ID => l_app_id,
237: X_STYLE_CODE => x_style_code,
238: X_PARENT_STYLE_CODE => x_parent_style_code,

Line 254: end BNE_STYLES_PKG;

250: end;
251:
252: end LOAD_ROW;
253:
254: end BNE_STYLES_PKG;