APPS.MTL_ECONOMIC_ZONES_PKG dependencies on MTL_ECONOMIC_ZONES_B

Line 64: MTL_ECONOMIC_ZONES_B

60: CURSOR c IS
61: SELECT
62: rowid
63: FROM
64: MTL_ECONOMIC_ZONES_B
65: WHERE zone_code = p_zone_code;
66: BEGIN
67: INSERT INTO MTL_ECONOMIC_ZONES_B
68: ( zone_code

Line 67: INSERT INTO MTL_ECONOMIC_ZONES_B

63: FROM
64: MTL_ECONOMIC_ZONES_B
65: WHERE zone_code = p_zone_code;
66: BEGIN
67: INSERT INTO MTL_ECONOMIC_ZONES_B
68: ( zone_code
69: , creation_date
70: , created_by
71: , last_update_date

Line 140: --COMMENT : table handler for locking table mtl_economic_zones_b and

136:
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

Line 153: MTL_ECONOMIC_ZONES_B

149: IS
150: CURSOR c IS
151: SELECT *
152: FROM
153: MTL_ECONOMIC_ZONES_B
154: WHERE zone_code = p_zone_code
155: FOR UPDATE OF zone_code NOWAIT;
156: recinfo c%ROWTYPE;
157:

Line 223: UPDATE MTL_ECONOMIC_ZONES_B

219: , p_last_update_login IN NUMBER
220: )
221: IS
222: BEGIN
223: UPDATE MTL_ECONOMIC_ZONES_B
224: SET
225: last_update_date = p_last_update_date
226: , last_updated_by = p_last_updated_by
227: , last_update_login = p_last_update_login

Line 280: DELETE FROM MTL_ECONOMIC_ZONES_B

276: THEN
277: RAISE NO_DATA_FOUND;
278: END IF;
279:
280: DELETE FROM MTL_ECONOMIC_ZONES_B
281: WHERE zone_code = p_zone_code;
282:
283: IF (SQL%NOTFOUND)
284: THEN

Line 312: MTL_ECONOMIC_ZONES_B B

308: WHERE NOT EXISTS
309: (SELECT
310: NULL
311: FROM
312: MTL_ECONOMIC_ZONES_B B
313: WHERE B.zone_code = T.zone_code
314: );
315:
316: UPDATE MTL_ECONOMIC_ZONES_TL T