6542:
6543: l_api_name CONSTANT VARCHAR2(30) := 'get_publication_id';
6544: l_api_version CONSTANT NUMBER := 1;
6545: l_product_key VARCHAR2(255);
6546: l_usage_name cz_model_usages.name%TYPE;
6547:
6548: CURSOR csr_model_usage_name IS
6549: SELECT name
6550: FROM cz_model_usages
6546: l_usage_name cz_model_usages.name%TYPE;
6547:
6548: CURSOR csr_model_usage_name IS
6549: SELECT name
6550: FROM cz_model_usages
6551: WHERE model_usage_id = -1 ; -- seeded for Any Usage
6552:
6553: CURSOR csr_template_key IS
6554: SELECT 'OKC:TEMPLATEMODEL:'||org_id||':'||intent||':'||template_id