APPS.CS_KB_ELEMENT_TYPES_PKG dependencies on CS_KB_ELEMENT_TYPES_B

Line 25: from cs_kb_element_types_b

21: is
22: l_count pls_integer;
23: begin
24: select count(*) into l_count
25: from cs_kb_element_types_b
26: where element_type_id = p_element_type_id;
27: if(l_count > 0) then return FND_API.G_TRUE; end if;
28: return FND_API.G_FALSE;
29:

Line 207: from cs_kb_element_types_b

203: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
204: return ERROR_STATUS; end if;
205:
206: select count(*) into l_count
207: from cs_kb_element_types_b
208: where element_type_id = p_element_type_id;
209: if(l_count <= 0) then
210: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
211: return ERROR_STATUS; end if;

Line 291: cursor C is select ROWID from CS_KB_ELEMENT_TYPES_B

287: X_START_DATE in DATE,
288: X_END_DATE in DATE
289:
290: ) is
291: cursor C is select ROWID from CS_KB_ELEMENT_TYPES_B
292: where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
293: ;
294: begin
295: insert into CS_KB_ELEMENT_TYPES_B (

Line 295: insert into CS_KB_ELEMENT_TYPES_B (

291: cursor C is select ROWID from CS_KB_ELEMENT_TYPES_B
292: where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
293: ;
294: begin
295: insert into CS_KB_ELEMENT_TYPES_B (
296: ELEMENT_TYPE_ID,
297: ELEMENT_TYPE_NAME,
298: CREATION_DATE,
299: CREATED_BY,

Line 434: from CS_KB_ELEMENT_TYPES_B

430: ATTRIBUTE14,
431: ATTRIBUTE15,
432: START_DATE_ACTIVE,
433: END_DATE_ACTIVE
434: from CS_KB_ELEMENT_TYPES_B
435: where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
436: for update of ELEMENT_TYPE_ID nowait;
437: recinfo c%rowtype;
438:

Line 549: update CS_KB_ELEMENT_TYPES_B set

545: X_START_DATE in DATE,
546: X_END_DATE in DATE
547: ) is
548: begin
549: update CS_KB_ELEMENT_TYPES_B set
550: ELEMENT_TYPE_NAME = X_ELEMENT_TYPE_NAME,
551: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
552: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
553: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 604: delete from CS_KB_ELEMENT_TYPES_B

600: if (sql%notfound) then
601: raise no_data_found;
602: end if;
603:
604: delete from CS_KB_ELEMENT_TYPES_B
605: where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID;
606:
607: if (sql%notfound) then
608: raise no_data_found;

Line 618: from CS_KB_ELEMENT_TYPES_B B

614: begin
615: delete from CS_KB_ELEMENT_TYPES_TL T
616: where not exists
617: (select NULL
618: from CS_KB_ELEMENT_TYPES_B B
619: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID
620: );
621:
622: update CS_KB_ELEMENT_TYPES_TL T set (