APPS.CS_KB_HISTORIES_PKG dependencies on CS_KB_HISTORIES_B

Line 92: from cs_kb_histories_b

88: begin
89: if p_history_id is null or p_history_id <= 0 then return ERROR_STATUS; end if;
90:
91: select count(*) into l_count
92: from cs_kb_histories_b
93: where history_id = p_history_id;
94: if(l_count <= 0) then return ERROR_STATUS; end if;
95:
96: CS_KB_HISTORIES_PKG.Delete_Row(

Line 140: cursor C is select ROWID from CS_KB_HISTORIES_B

136: X_ATTRIBUTE13 in VARCHAR2,
137: X_ATTRIBUTE14 in VARCHAR2,
138: X_ATTRIBUTE15 in VARCHAR2
139: ) is
140: cursor C is select ROWID from CS_KB_HISTORIES_B
141: where HISTORY_ID = X_HISTORY_ID
142: ;
143: begin
144: insert into CS_KB_HISTORIES_B (

Line 144: insert into CS_KB_HISTORIES_B (

140: cursor C is select ROWID from CS_KB_HISTORIES_B
141: where HISTORY_ID = X_HISTORY_ID
142: ;
143: begin
144: insert into CS_KB_HISTORIES_B (
145: HISTORY_ID,
146: HISTORY_NAME,
147: USER_ID,
148: ENTRY_DATE,

Line 283: from CS_KB_HISTORIES_B

279: ATTRIBUTE12,
280: ATTRIBUTE13,
281: ATTRIBUTE14,
282: ATTRIBUTE15
283: from CS_KB_HISTORIES_B
284: where HISTORY_ID = X_HISTORY_ID
285: for update of HISTORY_ID nowait;
286: recinfo c%rowtype;
287:

Line 398: update CS_KB_HISTORIES_B set

394: X_ATTRIBUTE14 in VARCHAR2,
395: X_ATTRIBUTE15 in VARCHAR2
396: ) is
397: begin
398: update CS_KB_HISTORIES_B set
399: HISTORY_NAME = X_HISTORY_NAME,
400: USER_ID = X_USER_ID,
401: ENTRY_DATE = X_ENTRY_DATE,
402: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 453: delete from CS_KB_HISTORIES_B

449: if (sql%notfound) then
450: raise no_data_found;
451: end if;
452:
453: delete from CS_KB_HISTORIES_B
454: where HISTORY_ID = X_HISTORY_ID;
455:
456: if (sql%notfound) then
457: raise no_data_found;

Line 467: from CS_KB_HISTORIES_B B

463: begin
464: delete from CS_KB_HISTORIES_TL T
465: where not exists
466: (select NULL
467: from CS_KB_HISTORIES_B B
468: where B.HISTORY_ID = T.HISTORY_ID
469: );
470:
471: update CS_KB_HISTORIES_TL T set (