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.MTL_ECONOMIC_ZONES_PKG dependencies on MTL_ECONOMIC_ZONES_TL

Line 14: --| and MTL_ECONOMIC_ZONES_TL |

10: --| |
11: --| DESCRIPTION |
12: --| Use this package to create procedure for inserting rows, updateing|
13: --| rows, locking rows and deleting rows on tables MTL_ECONOMIC_ZONES |
14: --| and MTL_ECONOMIC_ZONES_TL |
15: --| |
16: --| PROCEDURE LIST |
17: --| PROCEDURE Insert_Row |
18: --| PROCEDURE Update_Row |

Line 46: -- _b and table mtl_economic_zones_tl

42: --=========================================================================
43: --PRECEDURE : Insert_Row Public
44: --PARAMETERS: see below
45: --COMMENT : table handler for inserting data into table mtl_economic_zones
46: -- _b and table mtl_economic_zones_tl
47: --==========================================================================
48: PROCEDURE Insert_Row
49: ( x_rowid IN OUT NOCOPY VARCHAR2
50: , p_zone_code IN VARCHAR2

Line 84: INSERT INTO MTL_ECONOMIC_ZONES_TL

80: , p_last_updated_by
81: , p_last_update_login
82: );
83:
84: INSERT INTO MTL_ECONOMIC_ZONES_TL
85: ( zone_code
86: , zone_display_name
87: , zone_description
88: , created_by

Line 114: MTL_ECONOMIC_ZONES_TL T

110: AND NOT EXISTS
111: (SELECT
112: NULL
113: FROM
114: MTL_ECONOMIC_ZONES_TL T
115: WHERE T.zone_code = p_zone_code
116: AND T.language = L.language_code);
117:
118: OPEN c;

Line 141: -- table mtl_economic_zones_tl

137: --=========================================================================
138: --PRECEDURE : Lock_Row Public
139: --PARAMETERS: see below
140: --COMMENT : table handler for locking table mtl_economic_zones_b and
141: -- table mtl_economic_zones_tl
142: --EXCEPTION : record_changed;
143: --==========================================================================
144: PROCEDURE Lock_Row
145: ( p_zone_code IN VARCHAR2

Line 164: MTL_ECONOMIC_ZONES_TL

160: zone_display_name
161: , zone_description
162: , decode(language, USERENV('LANG'), 'Y', 'N') baselang
163: FROM
164: MTL_ECONOMIC_ZONES_TL
165: WHERE zone_code = p_zone_code
166: FOR UPDATE OF zone_code NOWAIT;
167:
168: record_changed EXCEPTION;

Line 211: -- _b and table mtl_economic_zones_tl

207: --=========================================================================
208: --PRECEDURE : Update_Row Public
209: --PARAMETERS: see below
210: --COMMENT : table handler for updating data of table mtl_economic_zones
211: -- _b and table mtl_economic_zones_tl
212: --==========================================================================
213: PROCEDURE Update_Row
214: ( p_zone_code IN VARCHAR2
215: , p_zone_display_name IN VARCHAR2

Line 235: UPDATE MTL_ECONOMIC_ZONES_TL

231: THEN
232: RAISE NO_DATA_FOUND;
233: END IF;
234:
235: UPDATE MTL_ECONOMIC_ZONES_TL
236: SET
237: zone_display_name = p_zone_display_name
238: , zone_description = p_zone_description
239: , last_update_date = p_last_update_date

Line 265: -- _b and table mtl_economic_zones_tl

261: --=========================================================================
262: --PRECEDURE : Delete_Row Public
263: --PARAMETERS: see below
264: --COMMENT : table handler for deleting data from table mtl_economic_zones
265: -- _b and table mtl_economic_zones_tl
266: --==========================================================================
267: PROCEDURE Delete_Row
268: ( p_zone_code IN VARCHAR2
269: )

Line 272: DELETE FROM MTL_ECONOMIC_ZONES_TL

268: ( p_zone_code IN VARCHAR2
269: )
270: IS
271: BEGIN
272: DELETE FROM MTL_ECONOMIC_ZONES_TL
273: WHERE zone_code = p_zone_code;
274:
275: IF (SQL%NOTFOUND)
276: THEN

Line 307: DELETE FROM MTL_ECONOMIC_ZONES_TL T

303: --==========================================================================
304: PROCEDURE Add_Language
305: IS
306: BEGIN
307: DELETE FROM MTL_ECONOMIC_ZONES_TL T
308: WHERE NOT EXISTS
309: (SELECT
310: NULL
311: FROM

Line 316: UPDATE MTL_ECONOMIC_ZONES_TL T

312: MTL_ECONOMIC_ZONES_B B
313: WHERE B.zone_code = T.zone_code
314: );
315:
316: UPDATE MTL_ECONOMIC_ZONES_TL T
317: SET (zone_display_name
318: ,zone_description) =
319: (SELECT
320: B.zone_display_name

Line 323: MTL_ECONOMIC_ZONES_TL B

319: (SELECT
320: B.zone_display_name
321: , B.zone_description
322: FROM
323: MTL_ECONOMIC_ZONES_TL B
324: WHERE B.zone_code = T.zone_code
325: AND B.language = T.source_lang)
326: WHERE (T.zone_code
327: , T.language

Line 332: MTL_ECONOMIC_ZONES_TL SUBB

328: )IN (SELECT
329: SUBT.zone_code
330: , SUBT.language
331: FROM
332: MTL_ECONOMIC_ZONES_TL SUBB
333: , MTL_ECONOMIC_ZONES_TL SUBT
334: WHERE SUBB.zone_code = SUBT.zone_code
335: AND SUBB.language = SUBT.source_lang
336: AND (SUBB.zone_display_name <> SUBT.zone_display_name

Line 333: , MTL_ECONOMIC_ZONES_TL SUBT

329: SUBT.zone_code
330: , SUBT.language
331: FROM
332: MTL_ECONOMIC_ZONES_TL SUBB
333: , MTL_ECONOMIC_ZONES_TL SUBT
334: WHERE SUBB.zone_code = SUBT.zone_code
335: AND SUBB.language = SUBT.source_lang
336: AND (SUBB.zone_display_name <> SUBT.zone_display_name
337: OR SUBB.zone_description <> SUBT.zone_description));

Line 339: INSERT INTO MTL_ECONOMIC_ZONES_TL

335: AND SUBB.language = SUBT.source_lang
336: AND (SUBB.zone_display_name <> SUBT.zone_display_name
337: OR SUBB.zone_description <> SUBT.zone_description));
338:
339: INSERT INTO MTL_ECONOMIC_ZONES_TL
340: ( zone_code
341: , zone_display_name
342: , zone_description
343: , created_by

Line 363: MTL_ECONOMIC_ZONES_TL B

359: , B.last_update_login
360: , L.language_CODE
361: , B.source_lang
362: FROM
363: MTL_ECONOMIC_ZONES_TL B
364: , FND_LANGUAGES L
365: WHERE L.INSTALLED_FLAG IN ('I', 'B')
366: AND B.language = USERENV('LANG')
367: AND NOT EXISTS

Line 371: MTL_ECONOMIC_ZONES_TL T

367: AND NOT EXISTS
368: (SELECT
369: NULL
370: FROM
371: MTL_ECONOMIC_ZONES_TL T
372: WHERE T.zone_code = B.zone_code
373: AND T.language = L.language_CODE);
374:
375: EXCEPTION

Line 402: UPDATE mtl_economic_zones_tl

398: )
399: IS
400: BEGIN
401:
402: UPDATE mtl_economic_zones_tl
403: SET zone_display_name = p_zone_display_name
404: , zone_description = p_zone_description
405: , last_update_date = SYSDATE
406: , last_updated_by = DECODE(p_owner, 'SEED', 1, 0)