APPS.CS_KB_USED_SUM_DEFS_PKG dependencies on CS_KB_USED_SUM_DEFS_B

Line 179: from cs_kb_used_sum_defs_b

175: begin
176: if p_def_id is null or p_def_id <= 0 then return ERROR_STATUS; end if;
177:
178: select count(*) into l_count
179: from cs_kb_used_sum_defs_b
180: where def_id = p_def_id;
181: if(l_count <= 0) then return ERROR_STATUS; end if;
182:
183: CS_KB_USED_SUM_DEFS_PKG.Delete_Row(

Line 226: cursor C is select ROWID from CS_KB_USED_SUM_DEFS_B

222: X_LAST_UPDATE_DATE in DATE,
223: X_LAST_UPDATED_BY in NUMBER,
224: X_LAST_UPDATE_LOGIN in NUMBER
225: ) is
226: cursor C is select ROWID from CS_KB_USED_SUM_DEFS_B
227: where DEF_ID = X_DEF_ID
228: ;
229: begin
230: insert into CS_KB_USED_SUM_DEFS_B (

Line 230: insert into CS_KB_USED_SUM_DEFS_B (

226: cursor C is select ROWID from CS_KB_USED_SUM_DEFS_B
227: where DEF_ID = X_DEF_ID
228: ;
229: begin
230: insert into CS_KB_USED_SUM_DEFS_B (
231: DEF_ID,
232: DAYS,
233: DEFAULT_FLAG,
234: ACTIVATED_FLAG,

Line 368: from CS_KB_USED_SUM_DEFS_B

364: ATTRIBUTE12,
365: ATTRIBUTE13,
366: ATTRIBUTE14,
367: ATTRIBUTE15
368: from CS_KB_USED_SUM_DEFS_B
369: where DEF_ID = X_DEF_ID
370: for update of DEF_ID nowait;
371: recinfo c%rowtype;
372:

Line 480: update CS_KB_USED_SUM_DEFS_B set

476: X_LAST_UPDATED_BY in NUMBER,
477: X_LAST_UPDATE_LOGIN in NUMBER
478: ) is
479: begin
480: update CS_KB_USED_SUM_DEFS_B set
481: DAYS = X_DAYS,
482: DEFAULT_FLAG = X_DEFAULT_FLAG,
483: ACTIVATED_FLAG = X_ACTIVATED_FLAG,
484: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 535: delete from CS_KB_USED_SUM_DEFS_B

531: if (sql%notfound) then
532: raise no_data_found;
533: end if;
534:
535: delete from CS_KB_USED_SUM_DEFS_B
536: where DEF_ID = X_DEF_ID;
537:
538: if (sql%notfound) then
539: raise no_data_found;

Line 549: from CS_KB_USED_SUM_DEFS_B B

545: begin
546: delete from CS_KB_USED_SUM_DEFS_TL T
547: where not exists
548: (select NULL
549: from CS_KB_USED_SUM_DEFS_B B
550: where B.DEF_ID = T.DEF_ID
551: );
552:
553: update CS_KB_USED_SUM_DEFS_TL T set (