APPS.CS_KB_SET_TYPES_PKG dependencies on CS_KB_SET_TYPES_B

Line 194: from cs_kb_set_types_b

190:
191: --
192: --
193: select count(*) into l_count
194: from cs_kb_set_types_b
195: where set_type_id = p_set_type_id;
196: if(l_count <= 0) then
197: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');
198: return ERROR_STATUS;

Line 282: cursor C is select ROWID from CS_KB_SET_TYPES_B

278: X_ATTRIBUTE15 in VARCHAR2,
279: X_START_DATE in DATE,
280: X_END_DATE in DATE
281: ) is
282: cursor C is select ROWID from CS_KB_SET_TYPES_B
283: where SET_TYPE_ID = X_SET_TYPE_ID
284: ;
285: begin
286: insert into CS_KB_SET_TYPES_B (

Line 286: insert into CS_KB_SET_TYPES_B (

282: cursor C is select ROWID from CS_KB_SET_TYPES_B
283: where SET_TYPE_ID = X_SET_TYPE_ID
284: ;
285: begin
286: insert into CS_KB_SET_TYPES_B (
287: SET_TYPE_ID,
288: SET_TYPE_NAME,
289: CREATION_DATE,
290: CREATED_BY,

Line 425: from CS_KB_SET_TYPES_B

421: ATTRIBUTE14,
422: ATTRIBUTE15,
423: START_DATE_ACTIVE,
424: END_DATE_ACTIVE
425: from CS_KB_SET_TYPES_B
426: where SET_TYPE_ID = X_SET_TYPE_ID
427: for update of SET_TYPE_ID nowait;
428: recinfo c%rowtype;
429:

Line 540: update CS_KB_SET_TYPES_B set

536: X_START_DATE in DATE,
537: X_END_DATE in DATE
538: ) is
539: begin
540: update CS_KB_SET_TYPES_B set
541: SET_TYPE_NAME = X_SET_TYPE_NAME,
542: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
543: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
544: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 595: delete from CS_KB_SET_TYPES_B

591: if (sql%notfound) then
592: raise no_data_found;
593: end if;
594:
595: delete from CS_KB_SET_TYPES_B
596: where SET_TYPE_ID = X_SET_TYPE_ID;
597:
598: if (sql%notfound) then
599: raise no_data_found;

Line 609: from CS_KB_SET_TYPES_B B

605: begin
606: delete from CS_KB_SET_TYPES_TL T
607: where not exists
608: (select NULL
609: from CS_KB_SET_TYPES_B B
610: where B.SET_TYPE_ID = T.SET_TYPE_ID
611: );
612:
613: update CS_KB_SET_TYPES_TL T set (