DBA Data[Home] [Help]

APPS.HZ_ADAPTER_LOGS_PKG dependencies on HZ_ADAPTER_LOGS_S

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 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