Databases Reference
In-Depth Information
l crlf
|| ' ' || apex javascript.add attribute('ajaxIdentifier',
apex plugin.get ajax identifier(), FALSE, FALSE) || l crlf
|| '});';
apex javascript.add onload code (
p code => l onload code
);
RETURN l retval;
END calendar render;
FUNCTION calendar ajax (
p region IN APEX PLUGIN.T REGION,
p plugin IN APEX PLUGIN.T PLUGIN
)
RETURN APEX PLUGIN.T REGION AJAX RESULT
IS
l retval APEX PLUGIN.T REGION AJAX RESULT;
l column value list APEX PLUGIN UTIL.T COLUMN VALUE LIST;
l start date item VARCHAR2(32767) := p region.attribute 01;
l end date item VARCHAR2(32767) := p region.attribute 02;
l window start DATE;
l window end DATE;
l id PLS INTEGER;
l title VARCHAR2(32767);
l all day BOOLEAN;
l start VARCHAR2(50);
l end VARCHAR2(50);
l url VARCHAR2(32767);
l class name VARCHAR2(100);
BEGIN
IF l start date item IS NOT NULL
THEN
l window start := TO DATE(apex application.g x01, 'YYYYMMDD');
apex util.set session state(l start date item, l window start);
END IF;
IF l end date item IS NOT NULL
THEN
l window end := TO DATE(apex application.g x02, 'YYYYMMDD');
apex util.set session state(l end date item, l window end);
END IF;
l column value list := apex plugin util.get data(
p sql statement => p region.source,
