APPS.CZ_MODEL_USAGES_PKG dependencies on CZ_MODEL_USAGES_TL

Line 61: INSERT INTO cz_model_usages_tl(MODEL_USAGE_ID

57: );
58: l_model_usage_inserted := TRUE;
59: END IF;
60:
61: INSERT INTO cz_model_usages_tl(MODEL_USAGE_ID
62: ,LANGUAGE
63: ,SOURCE_LANG
64: ,DESCRIPTION
65: )

Line 73: FROM cz_model_usages_tl T

69: ,l_description
70: FROM FND_LANGUAGES L
71: WHERE L.INSTALLED_FLAG IN ('I', 'B')
72: AND NOT EXISTS (SELECT NULL
73: FROM cz_model_usages_tl T
74: WHERE T.model_usage_id = p_model_usage_id
75: AND T.LANGUAGE = L.LANGUAGE_CODE);
76:
77: IF l_rowid_cursor%NOTFOUND AND l_model_usage_inserted=FALSE THEN

Line 107: UPDATE cz_model_usages_tl

103: SELECT NVL(in_use,'X') INTO l_in_use FROM CZ_MODEL_USAGES
104: WHERE model_usage_id = p_model_usage_id;
105:
106: IF l_in_use = '1' THEN
107: UPDATE cz_model_usages_tl
108: SET description = p_description
109: WHERE model_usage_id = p_model_usage_id AND
110: source_lang <> language;
111: ELSE

Line 119: UPDATE cz_model_usages_tl

115: last_updated_by = p_last_updated_by,
116: last_update_date = p_last_update_date,
117: last_update_login = p_last_update_login
118: WHERE model_usage_id = p_model_usage_id;
119: UPDATE cz_model_usages_tl
120: SET description = p_description
121: WHERE model_usage_id = p_model_usage_id;
122:
123: IF SQL%NOTFOUND THEN

Line 135: DELETE FROM cz_model_usages_tl

131: --------------------------------------------------------------------------------
132: PROCEDURE DELETE_ROW(p_model_usage_id IN NUMBER)
133: IS
134: BEGIN
135: DELETE FROM cz_model_usages_tl
136: WHERE model_usage_id = p_model_usage_id;
137:
138: IF SQL%NOTFOUND THEN
139: RAISE NO_DATA_FOUND;

Line 148: INSERT INTO cz_model_usages_tl(MODEL_USAGE_ID

144: PROCEDURE ADD_LANGUAGE
145: IS
146:
147: BEGIN
148: INSERT INTO cz_model_usages_tl(MODEL_USAGE_ID
149: ,LANGUAGE
150: ,SOURCE_LANG
151: ,DESCRIPTION
152: )

Line 157: FROM cz_model_usages_tl B,

153: SELECT B.model_usage_id
154: ,L.LANGUAGE_CODE
155: ,B.SOURCE_LANG
156: ,B.DESCRIPTION
157: FROM cz_model_usages_tl B,
158: FND_LANGUAGES L
159: WHERE L.INSTALLED_FLAG in ('I', 'B')
160: AND B.LANGUAGE = userenv('LANG')
161: AND NOT EXISTS (SELECT NULL

Line 162: FROM cz_model_usages_tl T

158: FND_LANGUAGES L
159: WHERE L.INSTALLED_FLAG in ('I', 'B')
160: AND B.LANGUAGE = userenv('LANG')
161: AND NOT EXISTS (SELECT NULL
162: FROM cz_model_usages_tl T
163: WHERE T.model_usage_id = B.model_usage_id
164: AND T.LANGUAGE = L.LANGUAGE_CODE);
165: COMMIT;
166: END ADD_LANGUAGE;

Line 179: UPDATE cz_model_usages_tl

175: --------------------------------------------------------------------------------
176: PROCEDURE TRANSLATE_ROW(p_model_usage_id IN NUMBER,
177: p_description IN VARCHAR2) IS
178: BEGIN
179: UPDATE cz_model_usages_tl
180: SET description = p_description,
181: source_lang = userenv('LANG')
182: WHERE model_usage_id = p_model_usage_id
183: AND userenv('LANG') IN (language, source_lang);

Line 203: FROM cz_model_usages_tl

199: p_last_update_date IN VARCHAR2
200: ) IS
201: CURSOR l_exists_cursor IS
202: SELECT '1'
203: FROM cz_model_usages_tl
204: WHERE model_usage_id = p_model_usage_id
205: AND language = userenv('LANG');
206: l_row_exists VARCHAR2(1);
207: l_rowid VARCHAR2(64);