APPS.HZ_ADAPTER_TERRITORIES_PKG dependencies on HZ_ADAPTER_TERRITORIES

Line 1: PACKAGE BODY HZ_ADAPTER_TERRITORIES_PKG AS

1: PACKAGE BODY HZ_ADAPTER_TERRITORIES_PKG AS
2: /*$Header: ARHADTTB.pls 115.0 2003/08/13 23:49:48 acng noship $ */
3:
4: PROCEDURE Insert_Row(
5: x_adapter_id IN NUMBER,

Line 14: INSERT INTO HZ_ADAPTER_TERRITORIES(

10: ) IS
11:
12: BEGIN
13:
14: INSERT INTO HZ_ADAPTER_TERRITORIES(
15: adapter_id,
16: territory_code,
17: enabled_flag,
18: default_flag,

Line 50: UPDATE HZ_ADAPTER_TERRITORIES

46: x_object_version_number IN NUMBER
47: ) IS
48:
49: BEGIN
50: UPDATE HZ_ADAPTER_TERRITORIES
51: SET adapter_id = DECODE(x_adapter_id, NULL, adapter_id,
52: fnd_api.g_miss_num, NULL, x_adapter_id),
53: territory_code = DECODE(x_territory_code, NULL, territory_code,
54: fnd_api.g_miss_char, NULL, x_territory_code),

Line 91: FROM hz_adapter_territories

87: ) IS
88:
89: CURSOR c IS
90: SELECT *
91: FROM hz_adapter_territories
92: WHERE ROWID = x_rowid
93: FOR UPDATE NOWAIT;
94:
95: recinfo c%ROWTYPE;

Line 148: DELETE FROM hz_adapter_territories

144: END Lock_Row;
145:
146: PROCEDURE delete_row (x_adapter_id IN NUMBER, x_territory_code IN VARCHAR2) IS
147: BEGIN
148: DELETE FROM hz_adapter_territories
149: WHERE adapter_id = x_adapter_id
150: AND territory_code = x_territory_code;
151:
152: IF (SQL%NOTFOUND) THEN

Line 157: END HZ_ADAPTER_TERRITORIES_PKG;

153: RAISE NO_DATA_FOUND;
154: END IF;
155: END delete_row;
156:
157: END HZ_ADAPTER_TERRITORIES_PKG;