APPS.HZ_LOCATIONS_PKG dependencies on HZ_LOCATIONS

Line 1: PACKAGE BODY hz_locations_pkg AS

1: PACKAGE BODY hz_locations_pkg AS
2: /*$Header: ARHLOCTB.pls 120.3 2005/07/29 01:24:49 jhuang ship $ */
3:
4: g_miss_content_source_type CONSTANT VARCHAR2(30) := 'USER_ENTERED';
5:

Line 109: INSERT INTO hz_locations (

105: END IF;
106:
107: WHILE l_success = 'N' LOOP
108: BEGIN
109: INSERT INTO hz_locations (
110: location_id,
111: last_update_date,
112: last_updated_by,
113: creation_date,

Line 306: IF INSTRB(SQLERRM, 'HZ_LOCATIONS_U1') <> 0 OR

302: l_success := 'Y';
303:
304: EXCEPTION
305: WHEN DUP_VAL_ON_INDEX THEN
306: IF INSTRB(SQLERRM, 'HZ_LOCATIONS_U1') <> 0 OR
307: INSTRB(SQLERRM, 'HZ_LOCATIONS_PK') <> 0
308: THEN
309: IF l_primary_key_passed THEN
310: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 307: INSTRB(SQLERRM, 'HZ_LOCATIONS_PK') <> 0

303:
304: EXCEPTION
305: WHEN DUP_VAL_ON_INDEX THEN
306: IF INSTRB(SQLERRM, 'HZ_LOCATIONS_U1') <> 0 OR
307: INSTRB(SQLERRM, 'HZ_LOCATIONS_PK') <> 0
308: THEN
309: IF l_primary_key_passed THEN
310: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
311: fnd_message.set_token('COLUMN', 'location_id');

Line 329: FROM hz_locations hl

325:
326: BEGIN
327: SELECT 'Y'
328: INTO l_dummy
329: FROM hz_locations hl
330: WHERE hl.location_id = x_location_id;
331: l_count := 1;
332: EXCEPTION
333: WHEN NO_DATA_FOUND THEN

Line 416: UPDATE hz_locations

412: -- Bug 2670546
413: x_delivery_point_code IN VARCHAR2
414: ) IS
415: BEGIN
416: UPDATE hz_locations
417: SET location_id = DECODE(x_location_id,
418: NULL, location_id,
419: fnd_api.g_miss_num, NULL,
420: x_location_id),

Line 752: FROM hz_locations

748: ) IS
749:
750: CURSOR c IS
751: SELECT *
752: FROM hz_locations
753: WHERE ROWID = x_rowid
754: FOR UPDATE NOWAIT;
755:
756: recinfo c%ROWTYPE;

Line 1180: FROM hz_locations

1176: x_actual_content_source,
1177: x_geometry_status_code,
1178: -- Bug 2670546
1179: x_delivery_point_code
1180: FROM hz_locations
1181: WHERE location_id = x_location_id;
1182: EXCEPTION
1183: WHEN NO_DATA_FOUND THEN
1184: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

Line 1193: DELETE FROM hz_locations

1189: END select_row;
1190:
1191: PROCEDURE delete_row (x_location_id IN NUMBER) IS
1192: BEGIN
1193: DELETE FROM hz_locations
1194: WHERE location_id = x_location_id;
1195:
1196: IF (SQL%NOTFOUND) THEN
1197: RAISE NO_DATA_FOUND;

Line 1200: END hz_locations_pkg;

1196: IF (SQL%NOTFOUND) THEN
1197: RAISE NO_DATA_FOUND;
1198: END IF;
1199: END delete_row;
1200: END hz_locations_pkg;