APPS.BNE_STYLE_PROPERTIES_PKG dependencies on BNE_STYLE_PROPERTIES

Line 1: package body BNE_STYLE_PROPERTIES_PKG as

1: package body BNE_STYLE_PROPERTIES_PKG as
2: /* $Header: bnestylepb.pls 120.3 2005/08/18 07:28:40 dagroves noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 18: cursor C is select ROWID from BNE_STYLE_PROPERTIES

14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER,
16: X_DATA_TYPE in VARCHAR2
17: ) is
18: cursor C is select ROWID from BNE_STYLE_PROPERTIES
19: where APPLICATION_ID = X_APPLICATION_ID
20: and STYLE_CODE = X_STYLE_CODE
21: and STYLE_PROPERTY_NAME = X_STYLE_PROPERTY_NAME
22: ;

Line 24: insert into BNE_STYLE_PROPERTIES (

20: and STYLE_CODE = X_STYLE_CODE
21: and STYLE_PROPERTY_NAME = X_STYLE_PROPERTY_NAME
22: ;
23: begin
24: insert into BNE_STYLE_PROPERTIES (
25: APPLICATION_ID,
26: STYLE_CODE,
27: STYLE_PROPERTY_NAME,
28: OBJECT_VERSION_NUMBER,

Line 72: from BNE_STYLE_PROPERTIES

68: cursor c1 is select
69: OBJECT_VERSION_NUMBER,
70: VALUE,
71: DATA_TYPE
72: from BNE_STYLE_PROPERTIES
73: where APPLICATION_ID = X_APPLICATION_ID
74: and STYLE_CODE = X_STYLE_CODE
75: and STYLE_PROPERTY_NAME = X_STYLE_PROPERTY_NAME
76: for update of APPLICATION_ID nowait;

Line 105: update BNE_STYLE_PROPERTIES set

101: X_LAST_UPDATE_LOGIN in NUMBER,
102: X_DATA_TYPE in VARCHAR2
103: ) is
104: begin
105: update BNE_STYLE_PROPERTIES set
106: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
107: VALUE = X_VALUE,
108: DATA_TYPE = X_DATA_TYPE,
109: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 127: delete from BNE_STYLE_PROPERTIES

123: X_STYLE_CODE in VARCHAR2,
124: X_STYLE_PROPERTY_NAME in VARCHAR2
125: ) is
126: begin
127: delete from BNE_STYLE_PROPERTIES
128: where APPLICATION_ID = X_APPLICATION_ID
129: and STYLE_CODE = X_STYLE_CODE
130: and STYLE_PROPERTY_NAME = X_STYLE_PROPERTY_NAME;
131:

Line 174: from BNE_STYLE_PROPERTIES

170: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
171: begin
172: select LAST_UPDATED_BY, LAST_UPDATE_DATE
173: into db_luby, db_ludate
174: from BNE_STYLE_PROPERTIES
175: where APPLICATION_ID = l_app_id
176: and STYLE_CODE = x_style_code
177: and STYLE_PROPERTY_NAME = x_style_property_name;
178:

Line 183: BNE_STYLE_PROPERTIES_PKG.Update_Row(

179: -- Test for customization and version
180: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
181: db_ludate, x_custom_mode)) then
182: -- Update existing row
183: BNE_STYLE_PROPERTIES_PKG.Update_Row(
184: X_APPLICATION_ID => l_app_id,
185: X_STYLE_CODE => x_style_code,
186: X_STYLE_PROPERTY_NAME => x_style_property_name,
187: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 198: BNE_STYLE_PROPERTIES_PKG.Insert_Row(

194: end if;
195: exception
196: when no_data_found then
197: -- Record doesn't exist - insert in all cases
198: BNE_STYLE_PROPERTIES_PKG.Insert_Row(
199: X_ROWID => l_row_id,
200: X_APPLICATION_ID => l_app_id,
201: X_STYLE_CODE => x_style_code,
202: X_STYLE_PROPERTY_NAME => x_style_property_name,

Line 217: end BNE_STYLE_PROPERTIES_PKG;

213:
214: end LOAD_ROW;
215:
216:
217: end BNE_STYLE_PROPERTIES_PKG;