APPS.AMS_PROD_TEMPLATE_PVT dependencies on AMS_PROD_TEMPLATES_TL

Line 187: INSERT INTO AMS_PROD_TEMPLATES_TL(

183: ,DECODE( p_prod_template_rec.product_service_flag, FND_API.g_miss_char, NULL, p_prod_template_rec.product_service_flag)
184: );
185:
186:
187: INSERT INTO AMS_PROD_TEMPLATES_TL(
188: template_id
189: ,language
190: ,source_lang
191: ,last_update_date

Line 213: FROM AMS_PROD_TEMPLATES_TL t

209: FROM fnd_languages l
210: WHERE l.installed_flag IN ('I','B')
211: AND NOT EXISTS(
212: SELECT NULL
213: FROM AMS_PROD_TEMPLATES_TL t
214: WHERE t.template_id = DECODE( l_template_id, FND_API.g_miss_num, NULL, l_template_id)
215: AND t.language = l.language_code ) ;
216:
217: x_template_id := l_template_id;

Line 530: UPDATE AMS_PROD_TEMPLATES_TL

526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: End If;
528:
529:
530: UPDATE AMS_PROD_TEMPLATES_TL
531: SET template_name = DECODE( p_prod_template_rec.template_name, FND_API.g_miss_char, template_name, p_prod_template_rec.template_name)
532: ,description = DECODE(p_prod_template_rec.description,FND_API.g_miss_char,description,p_prod_template_rec.description)
533: ,last_update_date = sysdate
534: ,last_updated_by = fnd_global.user_id

Line 686: DELETE FROM AMS_PROD_TEMPLATES_TL

682: END IF;
683: RAISE FND_API.g_exc_error;
684: END IF;
685:
686: DELETE FROM AMS_PROD_TEMPLATES_TL
687: WHERE TEMPLATE_ID = p_TEMPLATE_ID;
688:
689: IF (SQL%NOTFOUND) THEN
690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 909: FROM ams_prod_templates_tl

905:
906: CURSOR c_check_unique(p_name IN VARCHAR2)
907: IS
908: SELECT 'Y'
909: FROM ams_prod_templates_tl
910: WHERE template_name = p_name;
911:
912:
913: CURSOR c_check_unik_upd(p_name IN VARCHAR2

Line 917: FROM ams_prod_templates_tl

913: CURSOR c_check_unik_upd(p_name IN VARCHAR2
914: ,p_template_id IN NUMBER)
915: IS
916: SELECT 'Y'
917: FROM ams_prod_templates_tl
918: WHERE template_name = p_name
919: AND template_id <> p_template_id;
920:
921: