APPS.MTL_COUNTRY_ASSIGNMENTS_PKG dependencies on MTL_COUNTRY_ASSIGNMENTS

Line 1: PACKAGE BODY MTL_COUNTRY_ASSIGNMENTS_PKG AS

1: PACKAGE BODY MTL_COUNTRY_ASSIGNMENTS_PKG AS
2: -- $Header: INVGCTRB.pls 115.4 2002/12/03 21:15:23 vma ship $
3: --+=======================================================================+
4: --| Copyright (c) 1998 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 13: --| row, locking row and deleting row on tables MTL_COUNTRY_ASSIGNMENTS| |

9: --| INVGCTRB.pls |
10: --| |
11: --| DESCRIPTION |
12: --| Use this package to create procedure for inserting row, updateing |
13: --| row, locking row and deleting row on tables MTL_COUNTRY_ASSIGNMENTS| |
14: --| |
15: --| PROCEDURE LIST |
16: --| PROCEDURE Insert_Row |
17: --| PROCEDURE Update_Row |

Line 31: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_COUNTRY_ASSIGNMENTS_PKG';

27:
28: --==================
29: --CONSTANTS
30: --==================
31: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_COUNTRY_ASSIGNMENTS_PKG';
32:
33: --==================
34: --PUBLIC PROCEDURE
35: --==================

Line 60: mtl_country_assignments

56: CURSOR c IS
57: SELECT
58: rowid
59: FROM
60: mtl_country_assignments
61: WHERE zone_code = p_zone_code
62: AND territory_code = p_territory_code;
63:
64: BEGIN

Line 65: INSERT INTO mtl_country_assignments

61: WHERE zone_code = p_zone_code
62: AND territory_code = p_territory_code;
63:
64: BEGIN
65: INSERT INTO mtl_country_assignments
66: ( zone_code
67: , territory_code
68: , start_date
69: , end_date

Line 110: --COMMENT : table handler for locking table mtl_country_assignments

106:
107: --========================================================================
108: --PRECEDURE : Lock_Row Public
109: --PARAMETERS: see below
110: --COMMENT : table handler for locking table mtl_country_assignments
111: --EXCEPTION : record_changed
112: --========================================================================
113: PROCEDURE Lock_Row
114: ( p_rowid IN VARCHAR2

Line 124: mtl_country_assignments

120: IS
121: cursor c IS
122: SELECT *
123: FROM
124: mtl_country_assignments
125: WHERE
126: rowid = p_rowid
127: FOR UPDATE OF zone_code nowait;
128: recinfo c%ROWTYPE;

Line 184: UPDATE mtl_country_assignments

180: , p_last_update_login IN NUMBER
181: )
182: IS
183: BEGIN
184: UPDATE mtl_country_assignments
185: SET
186: zone_code = p_zone_code
187: , territory_code = p_territory_code
188: , start_date = p_start_date

Line 221: mtl_country_assignments

217: )
218: IS
219: BEGIN
220: DELETE FROM
221: mtl_country_assignments
222: WHERE
223: rowid = p_rowid;
224: IF (SQL%NOTFOUND)
225: THEN

Line 239: END MTL_COUNTRY_ASSIGNMENTS_PKG;

235: RAISE;
236:
237: END Delete_row;
238:
239: END MTL_COUNTRY_ASSIGNMENTS_PKG;