APPS.HZ_ADAPTER_LOGS_PKG dependencies on HZ_ADAPTER_LOGS

Line 1: PACKAGE BODY HZ_ADAPTER_LOGS_PKG AS

1: PACKAGE BODY HZ_ADAPTER_LOGS_PKG AS
2: /*$Header: ARHADLGB.pls 115.1 2003/08/15 22:23:17 acng noship $ */
3:
4: PROCEDURE Insert_Row(
5: x_adapter_log_id IN OUT NOCOPY NUMBER,

Line 29: INSERT INTO HZ_ADAPTER_LOGS (

25: END IF;
26:
27: WHILE l_success = 'N' LOOP
28: BEGIN
29: INSERT INTO HZ_ADAPTER_LOGS (
30: adapter_log_id,
31: created_by_module,
32: created_by_module_id,
33: http_status_code,

Line 44: fnd_api.g_miss_num, hz_adapter_logs_s.NEXTVAL,

40: last_update_date,
41: last_updated_by
42: ) VALUES (
43: DECODE(x_adapter_log_id,
44: fnd_api.g_miss_num, hz_adapter_logs_s.NEXTVAL,
45: NULL, hz_adapter_logs_s.NEXTVAL,
46: x_adapter_log_id),
47: DECODE(x_created_by_module, fnd_api.g_miss_char, NULL, x_created_by_module),
48: DECODE(x_created_by_module_id, fnd_api.g_miss_num, NULL, x_created_by_module_id),

Line 45: NULL, hz_adapter_logs_s.NEXTVAL,

41: last_updated_by
42: ) VALUES (
43: DECODE(x_adapter_log_id,
44: fnd_api.g_miss_num, hz_adapter_logs_s.NEXTVAL,
45: NULL, hz_adapter_logs_s.NEXTVAL,
46: x_adapter_log_id),
47: DECODE(x_created_by_module, fnd_api.g_miss_char, NULL, x_created_by_module),
48: DECODE(x_created_by_module_id, fnd_api.g_miss_num, NULL, x_created_by_module_id),
49: DECODE(x_http_status_code, fnd_api.g_miss_char, NULL, x_http_status_code),

Line 67: IF INSTRB(SQLERRM, 'HZ_ADAPTER_LOGS_U1') <> 0 OR

63: l_success := 'Y';
64:
65: EXCEPTION
66: WHEN DUP_VAL_ON_INDEX THEN
67: IF INSTRB(SQLERRM, 'HZ_ADAPTER_LOGS_U1') <> 0 OR
68: INSTRB(SQLERRM, 'HZ_ADAPTER_LOGS_PK') <> 0
69: THEN
70: IF l_primary_key_passed THEN
71: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 68: INSTRB(SQLERRM, 'HZ_ADAPTER_LOGS_PK') <> 0

64:
65: EXCEPTION
66: WHEN DUP_VAL_ON_INDEX THEN
67: IF INSTRB(SQLERRM, 'HZ_ADAPTER_LOGS_U1') <> 0 OR
68: INSTRB(SQLERRM, 'HZ_ADAPTER_LOGS_PK') <> 0
69: THEN
70: IF l_primary_key_passed THEN
71: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
72: fnd_message.set_token('COLUMN', 'adapter_log_id');

Line 83: FROM HZ_ADAPTER_LOGS;

79: l_max_adptlog_id NUMBER;
80: BEGIN
81: l_temp_adptlog_id := 0;
82: SELECT max(ADAPTER_LOG_ID) INTO l_max_adptlog_id
83: FROM HZ_ADAPTER_LOGS;
84: WHILE l_temp_adptlog_id < l_max_adptlog_id LOOP
85: SELECT HZ_ADAPTER_LOGS_S.NEXTVAL
86: INTO l_temp_adptlog_id FROM dual;
87: END LOOP;

Line 85: SELECT HZ_ADAPTER_LOGS_S.NEXTVAL

81: l_temp_adptlog_id := 0;
82: SELECT max(ADAPTER_LOG_ID) INTO l_max_adptlog_id
83: FROM HZ_ADAPTER_LOGS;
84: WHILE l_temp_adptlog_id < l_max_adptlog_id LOOP
85: SELECT HZ_ADAPTER_LOGS_S.NEXTVAL
86: INTO l_temp_adptlog_id FROM dual;
87: END LOOP;
88: END;
89: ELSE

Line 108: UPDATE HZ_ADAPTER_LOGS

104: --x_in_doc IN XMLTYPE,
105: x_object_version_number IN NUMBER
106: ) IS
107: BEGIN
108: UPDATE HZ_ADAPTER_LOGS
109: SET adapter_log_id = DECODE(x_adapter_log_id,
110: NULL, adapter_log_id,
111: fnd_api.g_miss_num, NULL,
112: x_adapter_log_id),

Line 164: FROM hz_adapter_logs

160: x_object_version_number IN NUMBER ) IS
161:
162: CURSOR c IS
163: SELECT *
164: FROM hz_adapter_logs
165: WHERE ROWID = x_rowid
166: FOR UPDATE NOWAIT;
167:
168: recinfo c%ROWTYPE;

Line 229: DELETE FROM hz_adapter_logs

225:
226: PROCEDURE delete_row (x_adapter_log_id IN NUMBER) IS
227: BEGIN
228:
229: DELETE FROM hz_adapter_logs
230: WHERE adapter_log_id = x_adapter_log_id;
231:
232: IF (SQL%NOTFOUND) THEN
233: RAISE NO_DATA_FOUND;

Line 239: END HZ_ADAPTER_LOGS_PKG;

235:
236: END delete_row;
237:
238:
239: END HZ_ADAPTER_LOGS_PKG;