6344:
6345: l_api_name CONSTANT VARCHAR2(30) := 'get_publication_id';
6346: l_api_version CONSTANT NUMBER := 1;
6347: l_product_key VARCHAR2(255);
6348: l_usage_name cz_model_usages.name%TYPE;
6349:
6350: CURSOR csr_model_usage_name IS
6351: SELECT name
6352: FROM cz_model_usages
6348: l_usage_name cz_model_usages.name%TYPE;
6349:
6350: CURSOR csr_model_usage_name IS
6351: SELECT name
6352: FROM cz_model_usages
6353: WHERE model_usage_id = -1 ; -- seeded for Any Usage
6354:
6355: CURSOR csr_template_key IS
6356: SELECT 'OKC:TEMPLATEMODEL:'||org_id||':'||intent||':'||template_id