DBA Data[Home] [Help]

APPS.AMS_PROD_TEMPLATE_PKG dependencies on FND_API

Line 201: WHERE t.template_id = DECODE( l_template_id, FND_API.g_miss_num, NULL, l_template_id)

197: WHERE l.installed_flag IN ('I','B')
198: AND NOT EXISTS(
199: SELECT NULL
200: FROM AMS_PROD_TEMPLATES_TL t
201: WHERE t.template_id = DECODE( l_template_id, FND_API.g_miss_num, NULL, l_template_id)
202: AND t.language = l.language_code ) ;
203:
204: else
205: close c_chk_temp_exists;