APPS.CS_TP_CHOICES_PKG dependencies on CS_TP_CHOICES_B

Line 35: cursor C is select ROWID from CS_TP_CHOICES_B

31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ,X_DEFAULT_FLAG in VARCHAR2 DEFAULT NULL
34: ) is
35: cursor C is select ROWID from CS_TP_CHOICES_B
36: where CHOICE_ID = X_CHOICE_ID
37: ;
38: begin
39: insert into CS_TP_CHOICES_B (

Line 39: insert into CS_TP_CHOICES_B (

35: cursor C is select ROWID from CS_TP_CHOICES_B
36: where CHOICE_ID = X_CHOICE_ID
37: ;
38: begin
39: insert into CS_TP_CHOICES_B (
40: CHOICE_ID,
41: LOOKUP_ID,
42: SEQUENCE_NUMBER,
43: START_DATE_ACTIVE,

Line 188: from CS_TP_CHOICES_B

184: ATTRIBUTE15,
185: SCORE
186:
187: ,default_choice_flag
188: from CS_TP_CHOICES_B
189: where CHOICE_ID = X_CHOICE_ID
190: for update of CHOICE_ID nowait;
191: recinfo c%rowtype;
192:

Line 305: update CS_TP_CHOICES_B set

301:
302: ,X_DEFAULT_FLAG in VARCHAR2 DEFAULT NULL
303: ) is
304: begin
305: update CS_TP_CHOICES_B set
306: LOOKUP_ID = X_LOOKUP_ID,
307: SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,
308: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
309: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 363: delete from CS_TP_CHOICES_B

359: if (sql%notfound) then
360: raise no_data_found;
361: end if;
362:
363: delete from CS_TP_CHOICES_B
364: where CHOICE_ID = X_CHOICE_ID;
365:
366: if (sql%notfound) then
367: raise no_data_found;

Line 377: from CS_TP_CHOICES_B B

373: begin
374: delete from CS_TP_CHOICES_TL T
375: where not exists
376: (select NULL
377: from CS_TP_CHOICES_B B
378: where B.CHOICE_ID = T.CHOICE_ID
379: );
380:
381: update CS_TP_CHOICES_TL T set (