[Home] [Help]
157: -- Define public procedures
158: -- ---------------------------------------------------------
159: -- *****************************************************************************
160: -- Start of Comments
161: -- This procedure Add_Template Add an additional template to the CS_TP_Templates_B Table
162: -- The user needs to pass in a template record which holds the template attributes.
163: -- User can leave the template id and last_updated_date field in the template
164: -- record blank. However, user needs to pass in the rest of the fields in
165: -- the template record. In addition, the mEndDate must be later than mStartDate
266:
267: -- *****************************************************************************
268: -- Start of Comments
269: --
270: -- Delete Template will delete the template with the passed in template id in the CS_TP_Templates_B and CS_TP_Templates_TL table with the passed in P_Template_ID
271: --
272: -- An exception will be raised if the template with passed in templated id cannot be found
273: -- @param P_Template_ID required
274: -- @param p_api_version_number required
322:
323: -- *****************************************************************************
324: -- Start of Comments
325: --
326: -- Update Template will update the template with a specific template id in the CS_TP_Templates_B and CS_TP_Templates_TL table with the new template attributes.
327: -- All fields inside the template are required
328: -- An exception is raised if template with template id cannot be found
329: -- @param P_One_Template required
330: -- @param p_api_version_number required
355: l_current_date DATE :=FND_API.G_MISS_DATE;
356: l_last_updated_by NUMBER :=FND_API.G_MISS_NUM;
357: l_login NUMBER :=FND_API.G_MISS_NUM;
358: CURSOR c IS
359: Select last_update_date From CS_TP_TEMPLATES_B
360: Where TEMPLATE_ID = p_one_template.mTemplateID;
361:
362: BEGIN
363: IF FND_API.to_Boolean( p_init_msg_list ) THEN
477: l_last_updated_date DATE;
478: l_attribute_id NUMBER;
479:
480: CURSOR C IS
481: Select count(*) From cs_tp_templates_b;
482:
483: CURSOR Last_Updated_Date_C (v_template_id NUMBER,
484: v_other_id NUMBER,
485: v_jtf_object_code VARCHAR2) IS
656: l_stmt VARCHAR2(100);
657: i NUMBER;
658: CURSOR C IS
659: Select count(*)
660: From CS_TP_TEMPLATES_B
661: Where template_id = P_Template_ID;
662: CURSOR Need_To_Be_Delete_Cursor (v_current_date DATE) IS
663: Select link_id
664: From CS_TP_TEMPLATE_LINKS
1182: l_Cursor_Statement :=
1183: ' select tb.template_id, ttl.name, tb.start_date_active, tb.end_date_active,'||
1184: ' tb.default_flag, tb.last_update_date, tb.attribute1,' ||
1185: ' tb.UNI_QUESTION_NOTE_FLAG, tb.UNI_QUESTION_NOTE_TYPE' ||
1186: ' from cs_tp_templates_b tb, cs_tp_templates_tl ttl ' ||
1187: ' where tB.TEMPLATE_ID = ttl.TEMPLATE_ID' ||
1188: ' and ttl.LANGUAGE = userenv(''LANG'') ' ||
1189: ' and exists ( '|| l_sel_template_stmt ||
1190: ' and a' || firstOne ||
3131: l_One_Template_Link Template_Link;
3132: i NUMBER;
3133: CURSOR C IS
3134: Select count(*)
3135: From CS_TP_TEMPLATES_B
3136: Where template_id = P_Template_ID;
3137:
3138: BEGIN
3139: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3202: l_stmt VARCHAR2(100);
3203: i NUMBER;
3204: CURSOR C IS
3205: Select count(*)
3206: From CS_TP_TEMPLATES_B
3207: Where template_id = P_Template_ID;
3208:
3209: BEGIN
3210: IF FND_API.to_Boolean( p_init_msg_list ) THEN