DBA Data[Home] [Help]

APPS.CZ_CF_API dependencies on CZ_MODEL_USAGES

Line 95: FROM CZ_MODEL_USAGES

91: IF p_usage_name IS NOT NULL THEN
92: BEGIN
93: SELECT model_usage_id
94: INTO v_usage_id
95: FROM CZ_MODEL_USAGES
96: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
97: AND cz_model_usages.in_use = '1';
98: EXCEPTION
99: WHEN OTHERS THEN

Line 96: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))

92: BEGIN
93: SELECT model_usage_id
94: INTO v_usage_id
95: FROM CZ_MODEL_USAGES
96: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
97: AND cz_model_usages.in_use = '1';
98: EXCEPTION
99: WHEN OTHERS THEN
100: v_usage_id := ANY_USAGE_ID;

Line 97: AND cz_model_usages.in_use = '1';

93: SELECT model_usage_id
94: INTO v_usage_id
95: FROM CZ_MODEL_USAGES
96: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
97: AND cz_model_usages.in_use = '1';
98: EXCEPTION
99: WHEN OTHERS THEN
100: v_usage_id := ANY_USAGE_ID;
101: END;