DBA Data[Home] [Help]

APPS.CZ_PB_USG dependencies on CZ_MODEL_USAGES

Line 43: FROM cz_model_usages

39: usageId NUMBER;
40: answer NUMBER;
41: BEGIN
42: SELECT model_usage_id INTO usageId
43: FROM cz_model_usages
44: WHERE name = usage_name;
45: answer := MAP_HAS_USAGE_ID(usageId, usage_map);
46: RETURN answer;
47: EXCEPTION

Line 59: FROM cz_model_usages

55: usageId NUMBER;
56: outMap VARCHAR2(16);
57: BEGIN
58: SELECT model_usage_id INTO usageId
59: FROM cz_model_usages
60: WHERE name = usage_name;
61: outMap := MAP_LESS_USAGE_ID(usageId, usage_map);
62: RETURN outMap;
63: EXCEPTION

Line 90: FROM cz_model_usages

86: usageId NUMBER;
87: outMap VARCHAR2(16);
88: BEGIN
89: SELECT model_usage_id INTO usageId
90: FROM cz_model_usages
91: WHERE name = usage_name;
92: outMap := MAP_PLUS_USAGE_ID(usageId, usage_map);
93: RETURN outMap;
94: EXCEPTION

Line 195: UPDATE cz_model_usages

191: END;
192:
193:
194: BEGIN
195: UPDATE cz_model_usages
196: SET in_use = 'X'
197: WHERE model_usage_id = usageId;
198:
199: DELETE FROM cz_publication_usages