APPS.CS_TP_TEMPLATES_PKG dependencies on CS_TP_TEMPLATES_B

Line 59: cursor C is select ROWID from CS_TP_TEMPLATES_B

55: X_LAST_UPDATE_DATE in DATE,
56: X_LAST_UPDATED_BY in NUMBER,
57: X_LAST_UPDATE_LOGIN in NUMBER
58: ) is
59: cursor C is select ROWID from CS_TP_TEMPLATES_B
60: where TEMPLATE_ID = X_TEMPLATE_ID
61: ;
62: begin
63: insert into CS_TP_TEMPLATES_B (

Line 63: insert into CS_TP_TEMPLATES_B (

59: cursor C is select ROWID from CS_TP_TEMPLATES_B
60: where TEMPLATE_ID = X_TEMPLATE_ID
61: ;
62: begin
63: insert into CS_TP_TEMPLATES_B (
64: TEMPLATE_ID,
65: DEFAULT_FLAG,
66: START_DATE_ACTIVE,
67: END_DATE_ACTIVE,

Line 215: from CS_TP_TEMPLATES_B

211:
212: UNI_QUESTION_NOTE_FLAG ,
213: UNI_QUESTION_NOTE_TYPE
214:
215: from CS_TP_TEMPLATES_B
216: where TEMPLATE_ID = X_TEMPLATE_ID
217: for update of TEMPLATE_ID nowait;
218: recinfo c%rowtype;
219:

Line 338: update CS_TP_TEMPLATES_B set

334: X_LAST_UPDATE_LOGIN in NUMBER
335: ) is
336: begin
337: /*
338: update CS_TP_TEMPLATES_B set
339: DEFAULT_FLAG = X_DEFAULT_FLAG,
340: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
341: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
342: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 365: Update CS_TP_TEMPLATES_B set

361: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
362: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
363: where TEMPLATE_ID = X_TEMPLATE_ID;
364: */
365: Update CS_TP_TEMPLATES_B set
366: DEFAULT_FLAG = DECODE(NVL(X_DEFAULT_FLAG,FND_API.G_MISS_CHAR),
367: FND_API.G_MISS_CHAR, DEFAULT_FLAG, X_DEFAULT_FLAG),
368: START_DATE_ACTIVE = DECODE(NVL(X_START_DATE_ACTIVE, FND_API.G_MISS_DATE),
369: FND_API.G_MISS_DATE, START_DATE_ACTIVE, X_START_DATE_ACTIVE),

Line 452: delete from CS_TP_TEMPLATES_B

448: if (sql%notfound) then
449: raise no_data_found;
450: end if;
451:
452: delete from CS_TP_TEMPLATES_B
453: where TEMPLATE_ID = X_TEMPLATE_ID;
454:
455: if (sql%notfound) then
456: raise no_data_found;

Line 466: from CS_TP_TEMPLATES_B B

462: begin
463: delete from CS_TP_TEMPLATES_TL T
464: where not exists
465: (select NULL
466: from CS_TP_TEMPLATES_B B
467: where B.TEMPLATE_ID = T.TEMPLATE_ID
468: );
469:
470: update CS_TP_TEMPLATES_TL T set (