APPS.HZ_STYLES_PKG dependencies on HZ_STYLES_B

Line 15: cursor C is select ROWID from HZ_STYLES_B

11: X_STYLE_NAME IN VARCHAR2,
12: X_DESCRIPTION IN VARCHAR2,
13: X_OBJECT_VERSION_NUMBER IN NUMBER
14: ) is
15: cursor C is select ROWID from HZ_STYLES_B
16: where STYLE_CODE = X_STYLE_CODE
17: ;
18: begin
19: insert into HZ_STYLES_B (

Line 19: insert into HZ_STYLES_B (

15: cursor C is select ROWID from HZ_STYLES_B
16: where STYLE_CODE = X_STYLE_CODE
17: ;
18: begin
19: insert into HZ_STYLES_B (
20: STYLE_CODE,
21: DATABASE_OBJECT_NAME,
22: CREATED_BY,
23: CREATION_DATE,

Line 87: from HZ_STYLES_B

83: X_DESCRIPTION in VARCHAR2
84: ) is
85: cursor c is select
86: DATABASE_OBJECT_NAME
87: from HZ_STYLES_B
88: where STYLE_CODE = X_STYLE_CODE
89: for update of STYLE_CODE nowait;
90: recinfo c%rowtype;
91:

Line 141: update HZ_STYLES_B set

137: X_DESCRIPTION IN VARCHAR2,
138: X_OBJECT_VERSION_NUMBER IN NUMBER
139: ) is
140: begin
141: update HZ_STYLES_B set
142: DATABASE_OBJECT_NAME = DECODE( X_DATABASE_OBJECT_NAME, NULL, DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, X_DATABASE_OBJECT_NAME ),
143: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
144: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
145: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

Line 187: FROM HZ_STYLES_B B, HZ_STYLES_TL T

183: INTO X_STYLE_CODE,
184: X_DATABASE_OBJECT_NAME,
185: X_STYLE_NAME,
186: X_DESCRIPTION
187: FROM HZ_STYLES_B B, HZ_STYLES_TL T
188: WHERE B.STYLE_CODE = X_STYLE_CODE
189: AND T.STYLE_CODE = X_STYLE_CODE
190: AND T.LANGUAGE = userenv('LANG');
191:

Line 214: delete from HZ_STYLES_B

210: if (sql%notfound) then
211: raise no_data_found;
212: end if;
213:
214: delete from HZ_STYLES_B
215: where STYLE_CODE = X_STYLE_CODE;
216:
217: if (sql%notfound) then
218: raise no_data_found;

Line 228: from HZ_STYLES_B B

224: begin
225: delete from HZ_STYLES_TL T
226: where not exists
227: (select NULL
228: from HZ_STYLES_B B
229: where B.STYLE_CODE = T.STYLE_CODE
230: );
231:
232: update HZ_STYLES_TL T set (

Line 319: from HZ_STYLES_B

315:
316: begin
317: select LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER
318: into l_db_luby, l_db_ludate, l_object_version_number
319: from HZ_STYLES_B
320: where STYLE_CODE = x_style_code;
321:
322: l_object_version_number := nvl(l_object_version_number, 1) + 1;
323: