APPS.CZ_CF_API dependencies on CZ_MODEL_POOL_MAPPINGS

Line 1520: l_pool_identifier cz_model_pool_mappings.pool_identifier%TYPE := NULL;

1516: l_publication_id NUMBER;
1517: l_product_key cz_devl_projects.product_key%TYPE;
1518: l_index NUMBER;
1519: l_init_message VARCHAR2(32767);
1520: l_pool_identifier cz_model_pool_mappings.pool_identifier%TYPE := NULL;
1521: -- vsingava 18th Dec '10. bug10410329
1522: l_calling_appl_id VARCHAR2(10) := NULL;
1523: l_model_routing_enabled_for_bv BOOLEAN := FALSE;
1524: l_calling_appl_ids VARCHAR2(255) := NULL;

Line 3962: v_pool_token cz_model_pool_mappings.pool_identifier%TYPE := NULL;

3958: END product_key_for_saved_config;
3959: --------------------------------------------------------------------------------
3960: FUNCTION pool_token_for_product_key(p_product_key IN VARCHAR2)
3961: RETURN VARCHAR2 IS
3962: v_pool_token cz_model_pool_mappings.pool_identifier%TYPE := NULL;
3963: -- vsingava 03 Feb '11. Bug11693636
3964: -- If we do not find any pool-token set up for the product-key,
3965: -- as a fail-over, read the setting value from cz_db_settings
3966:

Line 3969: SELECT pool_identifier INTO v_pool_token FROM cz_model_pool_mappings WHERE model_product_key = p_product_key;

3965: -- as a fail-over, read the setting value from cz_db_settings
3966:
3967: BEGIN
3968: IF p_product_key IS NOT NULL THEN
3969: SELECT pool_identifier INTO v_pool_token FROM cz_model_pool_mappings WHERE model_product_key = p_product_key;
3970: END IF;
3971: RETURN v_pool_token;
3972: EXCEPTION WHEN NO_DATA_FOUND THEN
3973: BEGIN

Line 4059: FROM cz_model_pool_mappings

4055: -- Added the check as a result of bug 13103351 to avoid
4056: -- duplicates for model pool affinity
4057: SELECT COUNT(*)
4058: INTO v_count
4059: FROM cz_model_pool_mappings
4060: WHERE model_product_key = p_model_product_key ;
4061:
4062: IF v_count > 0 THEN
4063: RAISE MODEL_POOL_EFFINITY_EXC ;

Line 4065: INSERT INTO cz_model_pool_mappings(pool_identifier, model_product_key)

4061:
4062: IF v_count > 0 THEN
4063: RAISE MODEL_POOL_EFFINITY_EXC ;
4064: ELSE
4065: INSERT INTO cz_model_pool_mappings(pool_identifier, model_product_key)
4066: VALUES(p_pool_identifier, p_model_product_key);
4067: COMMIT;
4068: END IF;
4069:

Line 4150: DELETE FROM cz_model_pool_mappings WHERE pool_identifier = p_pool_identifier

4146: PRAGMA AUTONOMOUS_TRANSACTION;
4147: nRet BOOLEAN := FALSE;
4148:
4149: BEGIN
4150: DELETE FROM cz_model_pool_mappings WHERE pool_identifier = p_pool_identifier
4151: AND model_product_key = p_model_product_key;
4152: COMMIT;
4153: EXCEPTION
4154: WHEN OTHERS THEN

Line 4190: DELETE FROM cz_model_pool_mappings WHERE pool_identifier = p_pool_identifier;

4186:
4187: nRet BOOLEAN := FALSE;
4188:
4189: BEGIN
4190: DELETE FROM cz_model_pool_mappings WHERE pool_identifier = p_pool_identifier;
4191: COMMIT;
4192: EXCEPTION
4193: WHEN OTHERS THEN
4194: retcode:=2;