APPS.CS_SR_TYPE_CATEGORIES_PKG dependencies on CS_SR_TYPE_CATEGORIES_B

Line 35: cursor C is select ROWID from CS_SR_TYPE_CATEGORIES_B

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from CS_SR_TYPE_CATEGORIES_B
36: where SR_TYPE_CATEGORY_ID = X_SR_TYPE_CATEGORY_ID
37: ;
38: begin
39: insert into CS_SR_TYPE_CATEGORIES_B (

Line 39: insert into CS_SR_TYPE_CATEGORIES_B (

35: cursor C is select ROWID from CS_SR_TYPE_CATEGORIES_B
36: where SR_TYPE_CATEGORY_ID = X_SR_TYPE_CATEGORY_ID
37: ;
38: begin
39: insert into CS_SR_TYPE_CATEGORIES_B (
40: SR_TYPE_CATEGORY_ID,
41: DISPLAY_ORDER,
42: IMAGE_FILE_NAME,
43: START_DATE,

Line 187: from CS_SR_TYPE_CATEGORIES_B

183: ATTRIBUTE13,
184: ATTRIBUTE14,
185: ATTRIBUTE15,
186: ATTRIBUTE_CATEGORY
187: from CS_SR_TYPE_CATEGORIES_B
188: where SR_TYPE_CATEGORY_ID = X_SR_TYPE_CATEGORY_ID
189: for update of SR_TYPE_CATEGORY_ID nowait;
190: recinfo c%rowtype;
191:

Line 304: update CS_SR_TYPE_CATEGORIES_B set

300: X_LAST_UPDATED_BY in NUMBER,
301: X_LAST_UPDATE_LOGIN in NUMBER
302: ) is
303: begin
304: update CS_SR_TYPE_CATEGORIES_B set
305: DISPLAY_ORDER = X_DISPLAY_ORDER,
306: IMAGE_FILE_NAME = X_IMAGE_FILE_NAME,
307: START_DATE = X_START_DATE,
308: END_DATE = X_END_DATE,

Line 361: delete from CS_SR_TYPE_CATEGORIES_B

357: if (sql%notfound) then
358: raise no_data_found;
359: end if;
360:
361: delete from CS_SR_TYPE_CATEGORIES_B
362: where SR_TYPE_CATEGORY_ID = X_SR_TYPE_CATEGORY_ID;
363:
364: if (sql%notfound) then
365: raise no_data_found;

Line 375: from CS_SR_TYPE_CATEGORIES_B B

371: begin
372: delete from CS_SR_TYPE_CATEGORIES_TL T
373: where not exists
374: (select NULL
375: from CS_SR_TYPE_CATEGORIES_B B
376: where B.SR_TYPE_CATEGORY_ID = T.SR_TYPE_CATEGORY_ID
377: );
378:
379: update CS_SR_TYPE_CATEGORIES_TL T set (