eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_MODEL_USAGES_PKG dependencies on CZ_MODEL_USAGES

Line 1: PACKAGE BODY CZ_MODEL_USAGES_PKG AS

1: PACKAGE BODY CZ_MODEL_USAGES_PKG AS
2: /* $Header: czmdlugb.pls 120.4 2007/12/24 16:20:02 skudryav ship $ */
3:
4: PROCEDURE INSERT_ROW(x_rowid IN OUT NOCOPY VARCHAR2,
5: p_model_usage_id IN NUMBER,

Line 18: FROM cz_model_usages

14: p_last_update_login IN NUMBER) IS
15:
16: CURSOR l_rowid_cursor IS
17: SELECT rowid, description
18: FROM cz_model_usages
19: WHERE model_usage_id = p_model_usage_id;
20: l_model_usage_inserted BOOLEAN := FALSE;
21: l_description CZ_MODEL_USAGES.description%TYPE := p_description;
22: BEGIN

Line 21: l_description CZ_MODEL_USAGES.description%TYPE := p_description;

17: SELECT rowid, description
18: FROM cz_model_usages
19: WHERE model_usage_id = p_model_usage_id;
20: l_model_usage_inserted BOOLEAN := FALSE;
21: l_description CZ_MODEL_USAGES.description%TYPE := p_description;
22: BEGIN
23:
24: OPEN l_rowid_cursor;
25: FETCH l_rowid_cursor INTO x_rowid,l_description;

Line 32: INSERT INTO CZ_MODEL_USAGES

28: l_description := p_name;
29: END IF;
30:
31: IF l_rowid_cursor%NOTFOUND THEN
32: INSERT INTO CZ_MODEL_USAGES
33: (
34: MODEL_USAGE_ID
35: ,NAME
36: ,DESCRIPTION

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 100: l_in_use CZ_MODEL_USAGES.in_use%TYPE;

96: p_last_updated_by IN NUMBER,
97: p_last_update_date IN DATE,
98: p_last_update_login IN NUMBER)
99: IS
100: l_in_use CZ_MODEL_USAGES.in_use%TYPE;
101: BEGIN
102:
103: SELECT NVL(in_use,'X') INTO l_in_use FROM CZ_MODEL_USAGES
104: WHERE model_usage_id = p_model_usage_id;

Line 103: SELECT NVL(in_use,'X') INTO l_in_use FROM CZ_MODEL_USAGES

99: IS
100: l_in_use CZ_MODEL_USAGES.in_use%TYPE;
101: BEGIN
102:
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

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 112: UPDATE cz_model_usages

108: SET description = p_description
109: WHERE model_usage_id = p_model_usage_id AND
110: source_lang <> language;
111: ELSE
112: UPDATE cz_model_usages
113: SET name = p_name,
114: note = p_note,
115: last_updated_by = p_last_updated_by,
116: last_update_date = p_last_update_date,

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);

Line 249: END CZ_MODEL_USAGES_PKG;

245: CLOSE l_exists_cursor;
246:
247: END LOAD_ROW;
248:
249: END CZ_MODEL_USAGES_PKG;