APPS.MTL_LE_ECONOMIC_ZONES_PKG dependencies on MTL_LE_ECONOMIC_ZONES

Line 1: PACKAGE BODY MTL_LE_ECONOMIC_ZONES_PKG AS

1: PACKAGE BODY MTL_LE_ECONOMIC_ZONES_PKG AS
2: -- $Header: INVGLEZB.pls 115.2 99/07/16 10:51:22 porting ship $
3: --+=======================================================================+
4: --| Copyright (c) 1998 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_LE_ECONOMIC_ZONES_PKG';

21:
22: --===================
23: -- CONSTANTS
24: --===================
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_LE_ECONOMIC_ZONES_PKG';
26: -- add your constants here if any
27:
28: --===================
29: -- GLOBAL VARIABLES

Line 62: MTL_LE_ECONOMIC_ZONES

58: CURSOR C IS
59: SELECT
60: rowid
61: FROM
62: MTL_LE_ECONOMIC_ZONES
63: WHERE Legal_Entity_ID = p_legal_entity_id
64: AND Zone_Code = p_zone_code;
65:
66: BEGIN

Line 73: MTL_LE_ECONOMIC_ZONES

69: COUNT(*)
70: INTO
71: l_count
72: FROM
73: MTL_LE_ECONOMIC_ZONES
74: WHERE Legal_Entity_id = p_legal_entity_id
75: AND Zone_Code = p_zone_code;
76:
77: IF l_count = 0 THEN

Line 78: INSERT INTO MTL_LE_ECONOMIC_ZONES(

74: WHERE Legal_Entity_id = p_legal_entity_id
75: AND Zone_Code = p_zone_code;
76:
77: IF l_count = 0 THEN
78: INSERT INTO MTL_LE_ECONOMIC_ZONES(
79: Legal_Entity_ID
80: , Zone_Code
81: , Last_Update_Date
82: , Last_Updated_By

Line 126: FROM MTL_LE_ECONOMIC_ZONES

122: )
123: IS
124: CURSOR C IS
125: SELECT *
126: FROM MTL_LE_ECONOMIC_ZONES
127: WHERE ROWID = p_rowid
128: FOR UPDATE OF Legal_Entity_ID NOWAIT;
129: Recinfo C%ROWTYPE;
130:

Line 179: UPDATE MTL_LE_ECONOMIC_ZONES

175: )
176: IS
177: BEGIN
178:
179: UPDATE MTL_LE_ECONOMIC_ZONES
180: SET
181: Legal_Entity_ID = p_legal_entity_id
182: , zone_code = p_zone_code
183: , last_update_date = p_last_update_date

Line 212: DELETE FROM MTL_LE_ECONOMIC_ZONES

208: )
209: IS
210: BEGIN
211:
212: DELETE FROM MTL_LE_ECONOMIC_ZONES
213: WHERE ROWID = p_rowid;
214:
215: IF (SQL%NOTFOUND) THEN
216: RAISE NO_DATA_FOUND;

Line 221: END MTL_LE_ECONOMIC_ZONES_PKG;

217: END IF;
218:
219: END Delete_Row;
220:
221: END MTL_LE_ECONOMIC_ZONES_PKG;