DBA Data[Home] [Help]

APPS.HZ_LOCATION_SERVICES_PUB dependencies on HZ_ADAPTER_LOGS

Line 1277: from HZ_ADAPTER_LOGS

1273: out_doc NCLOB;
1274:
1275: CURSOR get_xml(l_adapter_log_id NUMBER) IS
1276: select to_nclob(out_doc)
1277: from HZ_ADAPTER_LOGS
1278: where adapter_log_id = l_adapter_log_id;
1279:
1280: BEGIN
1281: null;

Line 1420: FROM HZ_ADAPTER_LOGS

1416:
1417: IF(l_adapter_log_id IS NOT NULL) THEN
1418: BEGIN
1419: SELECT rowid INTO l_rowid
1420: FROM HZ_ADAPTER_LOGS
1421: WHERE adapter_log_id = l_adapter_log_id;
1422: EXCEPTION
1423: WHEN NO_DATA_FOUND THEN
1424: log('Cannot find adapter log: '||l_adapter_log_id);

Line 1877: HZ_ADAPTER_LOGS_PKG.Insert_Row(

1873: p_inout_doc IN CLOB ) IS
1874: PRAGMA AUTONOMOUS_TRANSACTION;
1875: BEGIN
1876: IF(p_create_or_update = 'C') THEN
1877: HZ_ADAPTER_LOGS_PKG.Insert_Row(
1878: x_adapter_log_id => px_adapter_log_id,
1879: x_created_by_module => p_created_by_module,
1880: x_created_by_module_id => p_created_by_module_id,
1881: x_http_status_code => p_http_status_code,

Line 1885: UPDATE HZ_ADAPTER_LOGS

1881: x_http_status_code => p_http_status_code,
1882: x_request_id => p_request_id,
1883: x_object_version_number => p_object_version_number );
1884:
1885: UPDATE HZ_ADAPTER_LOGS
1886: SET out_doc = p_inout_doc
1887: WHERE adapter_log_id = px_adapter_log_id;
1888: ELSE
1889: HZ_ADAPTER_LOGS_PKG.Update_Row(

Line 1889: HZ_ADAPTER_LOGS_PKG.Update_Row(

1885: UPDATE HZ_ADAPTER_LOGS
1886: SET out_doc = p_inout_doc
1887: WHERE adapter_log_id = px_adapter_log_id;
1888: ELSE
1889: HZ_ADAPTER_LOGS_PKG.Update_Row(
1890: x_rowid => px_rowid,
1891: x_adapter_log_id => px_adapter_log_id,
1892: x_created_by_module => NULL,
1893: x_created_by_module_id => NULL,

Line 1898: UPDATE HZ_ADAPTER_LOGS

1894: x_http_status_code => p_http_status_code,
1895: x_request_id => NULL,
1896: x_OBJECT_VERSION_NUMBER => p_object_version_number );
1897:
1898: UPDATE HZ_ADAPTER_LOGS
1899: SET in_doc = p_inout_doc
1900: WHERE adapter_log_id = px_adapter_log_id;
1901: END IF;
1902: