APPS.CS_TP_QUESTIONS_PKG dependencies on CS_TP_QUESTIONS_B

Line 40: cursor C is select ROWID from CS_TP_QUESTIONS_B

36: X_LAST_UPDATE_DATE in DATE,
37: X_LAST_UPDATED_BY in NUMBER,
38: X_LAST_UPDATE_LOGIN in NUMBER
39: ) is
40: cursor C is select ROWID from CS_TP_QUESTIONS_B
41: where QUESTION_ID = X_QUESTION_ID
42: ;
43: begin
44: insert into CS_TP_QUESTIONS_B (

Line 44: insert into CS_TP_QUESTIONS_B (

40: cursor C is select ROWID from CS_TP_QUESTIONS_B
41: where QUESTION_ID = X_QUESTION_ID
42: ;
43: begin
44: insert into CS_TP_QUESTIONS_B (
45: QUESTION_ID,
46: LOOKUP_ID,
47: MANDTORY_FLAG,
48: SCORING_FLAG,

Line 208: from CS_TP_QUESTIONS_B

204: SHOW_ON_CREATION_FLAG,
205:
206: START_DATE_ACTIVE,
207: END_DATE_ACTIVE
208: from CS_TP_QUESTIONS_B
209: where QUESTION_ID = X_QUESTION_ID
210: for update of QUESTION_ID nowait;
211: recinfo c%rowtype;
212:

Line 338: update CS_TP_QUESTIONS_B set

334: X_LAST_UPDATED_BY in NUMBER,
335: X_LAST_UPDATE_LOGIN in NUMBER
336: ) is
337: begin
338: update CS_TP_QUESTIONS_B set
339: lookup_id = decode(nvl(x_lookup_id,fnd_api.g_miss_num), fnd_api.g_miss_num, lookup_id, x_lookup_id),
340: mandtory_flag = decode(nvl(x_mandtory_flag, fnd_api.g_miss_char), fnd_api.g_miss_char , mandtory_flag, x_mandtory_flag),
341: scoring_flag = decode(nvl(x_scoring_flag,fnd_api.g_miss_char), fnd_api.g_miss_char , scoring_flag, x_scoring_flag),
342: attribute_category = decode(nvl(x_attribute_category,fnd_api.g_miss_char),

Line 402: delete from CS_TP_QUESTIONS_B

398: if (sql%notfound) then
399: raise no_data_found;
400: end if;
401:
402: delete from CS_TP_QUESTIONS_B
403: where QUESTION_ID = X_QUESTION_ID;
404:
405: if (sql%notfound) then
406: raise no_data_found;

Line 416: from CS_TP_QUESTIONS_B B

412: begin
413: delete from CS_TP_QUESTIONS_TL T
414: where not exists
415: (select NULL
416: from CS_TP_QUESTIONS_B B
417: where B.QUESTION_ID = T.QUESTION_ID
418: );
419:
420: update CS_TP_QUESTIONS_TL T set (