[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure UPDATE_COPIES (
X_CANVAS_PROPERTY_ID in NUMBER,
X_FORM_CANVAS_ID in NUMBER,
X_TEMPLATE_CANVAS_ID in NUMBER,
X_HEIGHT in NUMBER,
X_VISIBLE in NUMBER,
X_WIDTH in NUMBER,
X_X_POSITION in NUMBER,
X_Y_POSITION in NUMBER,
X_INFORMATION_CATEGORY in VARCHAR2,
X_INFORMATION1 in VARCHAR2,
X_INFORMATION2 in VARCHAR2,
X_INFORMATION3 in VARCHAR2,
X_INFORMATION4 in VARCHAR2,
X_INFORMATION5 in VARCHAR2,
X_INFORMATION6 in VARCHAR2,
X_INFORMATION7 in VARCHAR2,
X_INFORMATION8 in VARCHAR2,
X_INFORMATION9 in VARCHAR2,
X_INFORMATION10 in VARCHAR2,
X_INFORMATION11 in VARCHAR2,
X_INFORMATION12 in VARCHAR2,
X_INFORMATION13 in VARCHAR2,
X_INFORMATION14 in VARCHAR2,
X_INFORMATION15 in VARCHAR2,
X_INFORMATION16 in VARCHAR2,
X_INFORMATION17 in VARCHAR2,
X_INFORMATION18 in VARCHAR2,
X_INFORMATION19 in VARCHAR2,
X_INFORMATION20 in VARCHAR2,
X_INFORMATION21 in VARCHAR2,
X_INFORMATION22 in VARCHAR2,
X_INFORMATION23 in VARCHAR2,
X_INFORMATION24 in VARCHAR2,
X_INFORMATION25 in VARCHAR2,
X_INFORMATION26 in VARCHAR2,
X_INFORMATION27 in VARCHAR2,
X_INFORMATION28 in VARCHAR2,
X_INFORMATION29 in VARCHAR2,
X_INFORMATION30 in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) is
cursor csr_original is
select *
from HR_CANVAS_PROPERTIES
where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID;
select cnp.canvas_property_id
from HR_CANVAS_PROPERTIES cnp
,HR_TEMPLATE_CANVASES_B tcn
,HR_TEMPLATE_WINDOWS_B twn
,HR_TEMPLATE_CANVASES_B tco
where cnp.TEMPLATE_CANVAS_ID = tcn.TEMPLATE_CANVAS_ID
and tcn.TEMPLATE_WINDOW_ID = twn.TEMPLATE_WINDOW_ID
and twn.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO
from HR_SOURCE_FORM_TEMPLATES sft
start with sft.FORM_TEMPLATE_ID_FROM = (select tw1.FORM_TEMPLATE_ID
from HR_TEMPLATE_WINDOWS tw1
where tw1.TEMPLATE_WINDOW_ID = tco.TEMPLATE_WINDOW_ID)
connect by sft.FORM_TEMPLATE_ID_FROM = prior sft.FORM_TEMPLATE_ID_TO)
and tcn.FORM_CANVAS_ID = tco.FORM_CANVAS_ID
and tco.TEMPLATE_CANVAS_ID = X_TEMPLATE_CANVAS_ID;
update HR_CANVAS_PROPERTIES set
HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),
Y_POSITION = decode(nvl(Y_POSITION,hr_api.g_number),nvl(l_original.Y_POSITION,hr_api.g_number),X_Y_POSITION,Y_POSITION),
INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),
INFORMATION3 = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),
INFORMATION4 = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),
INFORMATION5 = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),
INFORMATION6 = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),
INFORMATION7 = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),
INFORMATION8 = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),
INFORMATION9 = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),
INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),
INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),
INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),
INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),
INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),
INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),
INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),
INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),
INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),
INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),
INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),
INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),
INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),
INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),
INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),
INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),
INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),
INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),
INFORMATION28 = decode(nvl(INFORMATION28,hr_api.g_varchar2),nvl(l_original.INFORMATION28,hr_api.g_varchar2),X_INFORMATION28,INFORMATION28),
INFORMATION29 = decode(nvl(INFORMATION29,hr_api.g_varchar2),nvl(l_original.INFORMATION29,hr_api.g_varchar2),X_INFORMATION29,INFORMATION29),
INFORMATION30 = decode(nvl(INFORMATION30,hr_api.g_varchar2),nvl(l_original.INFORMATION30,hr_api.g_varchar2),X_INFORMATION30,INFORMATION30),
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
where CANVAS_PROPERTY_ID = l_copy.CANVAS_PROPERTY_ID;
end UPDATE_COPIES;
X_LAST_UPDATE_DATE out nocopy DATE,
X_LAST_UPDATED_BY out nocopy NUMBER,
X_LAST_UPDATE_LOGIN out nocopy NUMBER
) is
begin
if X_OWNER = 'SEED' then
X_CREATED_BY := 1;
X_LAST_UPDATED_BY := 1;
X_LAST_UPDATED_BY := 0;
X_LAST_UPDATE_DATE := sysdate;
X_LAST_UPDATE_LOGIN := 0;
X_LAST_UPDATE_DATE := null;
X_LAST_UPDATED_BY := null;
X_LAST_UPDATE_LOGIN := null;
PROCEDURE Insert_row (x_rowid IN OUT NOCOPY VARCHAR2,
x_canvas_property_id IN NUMBER,
x_information13 IN VARCHAR2,
x_information14 IN VARCHAR2,
x_information15 IN VARCHAR2,
x_information16 IN VARCHAR2,
x_information17 IN VARCHAR2,
x_information18 IN VARCHAR2,
x_information19 IN VARCHAR2,
x_information20 IN VARCHAR2,
x_information21 IN VARCHAR2,
x_information22 IN VARCHAR2,
x_information23 IN VARCHAR2,
x_information24 IN VARCHAR2,
x_information25 IN VARCHAR2,
x_information26 IN VARCHAR2,
x_information27 IN VARCHAR2,
x_information28 IN VARCHAR2,
x_information29 IN VARCHAR2,
x_information30 IN VARCHAR2,
x_form_canvas_id IN NUMBER,
x_template_canvas_id IN NUMBER,
x_height IN NUMBER,
x_visible IN NUMBER,
x_width IN NUMBER,
x_x_position IN NUMBER,
x_y_position IN NUMBER,
x_information_category IN VARCHAR2,
x_information1 IN VARCHAR2,
x_information2 IN VARCHAR2,
x_information3 IN VARCHAR2,
x_information4 IN VARCHAR2,
x_information5 IN VARCHAR2,
x_information6 IN VARCHAR2,
x_information7 IN VARCHAR2,
x_information8 IN VARCHAR2,
x_information9 IN VARCHAR2,
x_information10 IN VARCHAR2,
x_information11 IN VARCHAR2,
x_information12 IN VARCHAR2,
x_creation_date IN DATE,
x_created_by IN NUMBER,
x_last_update_date IN DATE,
x_last_updated_by IN NUMBER,
x_last_update_login IN NUMBER)
IS
CURSOR c IS
SELECT ROWID
FROM hr_canvas_properties
WHERE canvas_property_id = x_canvas_property_id;
INSERT INTO hr_canvas_properties
(information13,
information14,
information15,
information16,
information17,
information18,
information19,
information20,
information21,
information22,
information23,
information24,
information25,
information26,
information27,
information28,
information29,
information30,
last_update_date,
last_updated_by,
last_update_login,
created_by,
creation_date,
canvas_property_id,
form_canvas_id,
template_canvas_id,
height,
visible,
width,
x_position,
y_position,
information_category,
information1,
information2,
information3,
information4,
information5,
information6,
information7,
information8,
information9,
information10,
information11,
information12)
VALUES ( x_information13,
x_information14,
x_information15,
x_information16,
x_information17,
x_information18,
x_information19,
x_information20,
x_information21,
x_information22,
x_information23,
x_information24,
x_information25,
x_information26,
x_information27,
x_information28,
x_information29,
x_information30,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_created_by,
x_creation_date,
x_canvas_property_id,
x_form_canvas_id,
x_template_canvas_id,
x_height,
x_visible,
x_width,
x_x_position,
x_y_position,
x_information_category,
x_information1,
x_information2,
x_information3,
x_information4,
x_information5,
x_information6,
x_information7,
x_information8,
x_information9,
x_information10,
x_information11,
x_information12);
END insert_row;
cursor c1 is select
INFORMATION13,
INFORMATION14,
INFORMATION15,
INFORMATION16,
INFORMATION17,
INFORMATION18,
INFORMATION19,
INFORMATION20,
INFORMATION21,
INFORMATION22,
INFORMATION23,
INFORMATION24,
INFORMATION25,
INFORMATION26,
INFORMATION27,
INFORMATION28,
INFORMATION29,
INFORMATION30,
FORM_CANVAS_ID,
TEMPLATE_CANVAS_ID,
HEIGHT,
VISIBLE,
WIDTH,
X_POSITION,
Y_POSITION,
INFORMATION_CATEGORY,
INFORMATION1,
INFORMATION2,
INFORMATION3,
INFORMATION4,
INFORMATION5,
INFORMATION6,
INFORMATION7,
INFORMATION8,
INFORMATION9,
INFORMATION10,
INFORMATION11,
INFORMATION12
from HR_CANVAS_PROPERTIES
where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID
for update of CANVAS_PROPERTY_ID nowait;
procedure UPDATE_ROW (
X_CANVAS_PROPERTY_ID in NUMBER,
X_INFORMATION13 in VARCHAR2,
X_INFORMATION14 in VARCHAR2,
X_INFORMATION15 in VARCHAR2,
X_INFORMATION16 in VARCHAR2,
X_INFORMATION17 in VARCHAR2,
X_INFORMATION18 in VARCHAR2,
X_INFORMATION19 in VARCHAR2,
X_INFORMATION20 in VARCHAR2,
X_INFORMATION21 in VARCHAR2,
X_INFORMATION22 in VARCHAR2,
X_INFORMATION23 in VARCHAR2,
X_INFORMATION24 in VARCHAR2,
X_INFORMATION25 in VARCHAR2,
X_INFORMATION26 in VARCHAR2,
X_INFORMATION27 in VARCHAR2,
X_INFORMATION28 in VARCHAR2,
X_INFORMATION29 in VARCHAR2,
X_INFORMATION30 in VARCHAR2,
X_FORM_CANVAS_ID in NUMBER,
X_TEMPLATE_CANVAS_ID in NUMBER,
X_HEIGHT in NUMBER,
X_VISIBLE in NUMBER,
X_WIDTH in NUMBER,
X_X_POSITION in NUMBER,
X_Y_POSITION in NUMBER,
X_INFORMATION_CATEGORY in VARCHAR2,
X_INFORMATION1 in VARCHAR2,
X_INFORMATION2 in VARCHAR2,
X_INFORMATION3 in VARCHAR2,
X_INFORMATION4 in VARCHAR2,
X_INFORMATION5 in VARCHAR2,
X_INFORMATION6 in VARCHAR2,
X_INFORMATION7 in VARCHAR2,
X_INFORMATION8 in VARCHAR2,
X_INFORMATION9 in VARCHAR2,
X_INFORMATION10 in VARCHAR2,
X_INFORMATION11 in VARCHAR2,
X_INFORMATION12 in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
update HR_CANVAS_PROPERTIES set
INFORMATION13 = X_INFORMATION13,
INFORMATION14 = X_INFORMATION14,
INFORMATION15 = X_INFORMATION15,
INFORMATION16 = X_INFORMATION16,
INFORMATION17 = X_INFORMATION17,
INFORMATION18 = X_INFORMATION18,
INFORMATION19 = X_INFORMATION19,
INFORMATION20 = X_INFORMATION20,
INFORMATION21 = X_INFORMATION21,
INFORMATION22 = X_INFORMATION22,
INFORMATION23 = X_INFORMATION23,
INFORMATION24 = X_INFORMATION24,
INFORMATION25 = X_INFORMATION25,
INFORMATION26 = X_INFORMATION26,
INFORMATION27 = X_INFORMATION27,
INFORMATION28 = X_INFORMATION28,
INFORMATION29 = X_INFORMATION29,
INFORMATION30 = X_INFORMATION30,
FORM_CANVAS_ID = X_FORM_CANVAS_ID,
TEMPLATE_CANVAS_ID = X_TEMPLATE_CANVAS_ID,
HEIGHT = X_HEIGHT,
VISIBLE = X_VISIBLE,
WIDTH = X_WIDTH,
X_POSITION = X_X_POSITION,
Y_POSITION = X_Y_POSITION,
INFORMATION_CATEGORY = X_INFORMATION_CATEGORY,
INFORMATION1 = X_INFORMATION1,
INFORMATION2 = X_INFORMATION2,
INFORMATION3 = X_INFORMATION3,
INFORMATION4 = X_INFORMATION4,
INFORMATION5 = X_INFORMATION5,
INFORMATION6 = X_INFORMATION6,
INFORMATION7 = X_INFORMATION7,
INFORMATION8 = X_INFORMATION8,
INFORMATION9 = X_INFORMATION9,
INFORMATION10 = X_INFORMATION10,
INFORMATION11 = X_INFORMATION11,
INFORMATION12 = X_INFORMATION12,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID;
end UPDATE_ROW;
procedure DELETE_ROW (
X_CANVAS_PROPERTY_ID in NUMBER
) is
begin
delete from HR_CANVAS_PROPERTIES
where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID;
end DELETE_ROW;
X_LAST_UPDATE_DATE DATE;
X_LAST_UPDATED_BY NUMBER;
X_LAST_UPDATE_LOGIN NUMBER;
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
select application_id
into x_application_id
from fnd_application
where application_short_name = x_application_short_name;
select form_id
into x_form_id
from fnd_form
where form_name = x_form_name
and application_id = x_application_id;
select hfc.form_canvas_id, hfw.form_window_id
into x_form_canvas_id,x_form_window_id
from hr_form_canvases_b hfc
, hr_form_windows_b hfw
where hfc.canvas_name = x_canvas_name
and hfw.form_window_id = hfc.form_window_id
and hfw.application_id = x_application_id
and hfw.form_id = x_form_id
and hfw.window_name = x_window_name;
select htc.template_canvas_id
into x_template_canvas_id
from hr_template_canvases_b htc
,hr_template_windows_b htw
, hr_form_templates hft
where htc.form_canvas_id = x_form_canvas_id
and htc.template_window_id = htw.template_window_id
and htw.form_window_id = x_form_window_id
and htw.form_template_id = hft.form_template_id
and hft.application_id = x_application_id
and hft.form_id = x_form_id
and hft.template_name = x_template_name
and ( (hft.legislation_code is null and x_territory_short_name is null)
or (hft.legislation_code = x_territory_short_name) );
select canvas_property_id
into x_canvas_property_id
from hr_canvas_properties
where nvl(form_canvas_id,hr_api.g_number) = nvl(x_form_canvas_id,hr_api.g_number)
and nvl(template_canvas_id,hr_api.g_number) = nvl(x_template_canvas_id,hr_api.g_number);
select hr_canvas_properties_s.nextval
into x_canvas_property_id
from dual;
UPDATE_COPIES (
X_CANVAS_PROPERTY_ID,
X_FORM_CANVAS_ID,
X_TEMPLATE_CANVAS_ID,
to_number(X_HEIGHT),
to_number(X_VISIBLE),
to_number(X_WIDTH),
to_number(X_X_POSITION),
to_number(X_Y_POSITION),
X_INFORMATION_CATEGORY,
X_INFORMATION1,
X_INFORMATION2,
X_INFORMATION3,
X_INFORMATION4,
X_INFORMATION5,
X_INFORMATION6,
X_INFORMATION7,
X_INFORMATION8,
X_INFORMATION9,
X_INFORMATION10,
X_INFORMATION11,
X_INFORMATION12,
X_INFORMATION13,
X_INFORMATION14,
X_INFORMATION15,
X_INFORMATION16,
X_INFORMATION17,
X_INFORMATION18,
X_INFORMATION19,
X_INFORMATION20,
X_INFORMATION21,
X_INFORMATION22,
X_INFORMATION23,
X_INFORMATION24,
X_INFORMATION25,
X_INFORMATION26,
X_INFORMATION27,
X_INFORMATION28,
X_INFORMATION29,
X_INFORMATION30,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
UPDATE_ROW (
X_CANVAS_PROPERTY_ID,
X_INFORMATION13,
X_INFORMATION14,
X_INFORMATION15,
X_INFORMATION16,
X_INFORMATION17,
X_INFORMATION18,
X_INFORMATION19,
X_INFORMATION20,
X_INFORMATION21,
X_INFORMATION22,
X_INFORMATION23,
X_INFORMATION24,
X_INFORMATION25,
X_INFORMATION26,
X_INFORMATION27,
X_INFORMATION28,
X_INFORMATION29,
X_INFORMATION30,
X_FORM_CANVAS_ID,
X_TEMPLATE_CANVAS_ID,
to_number(X_HEIGHT),
to_number(X_VISIBLE),
to_number(X_WIDTH),
to_number(X_X_POSITION),
to_number(X_Y_POSITION),
X_INFORMATION_CATEGORY,
X_INFORMATION1,
X_INFORMATION2,
X_INFORMATION3,
X_INFORMATION4,
X_INFORMATION5,
X_INFORMATION6,
X_INFORMATION7,
X_INFORMATION8,
X_INFORMATION9,
X_INFORMATION10,
X_INFORMATION11,
X_INFORMATION12,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
INSERT_ROW (
X_ROWID,
X_CANVAS_PROPERTY_ID,
X_INFORMATION13,
X_INFORMATION14,
X_INFORMATION15,
X_INFORMATION16,
X_INFORMATION17,
X_INFORMATION18,
X_INFORMATION19,
X_INFORMATION20,
X_INFORMATION21,
X_INFORMATION22,
X_INFORMATION23,
X_INFORMATION24,
X_INFORMATION25,
X_INFORMATION26,
X_INFORMATION27,
X_INFORMATION28,
X_INFORMATION29,
X_INFORMATION30,
X_FORM_CANVAS_ID,
X_TEMPLATE_CANVAS_ID,
to_number(X_HEIGHT),
to_number(X_VISIBLE),
to_number(X_WIDTH),
to_number(X_X_POSITION),
to_number(X_Y_POSITION),
X_INFORMATION_CATEGORY,
X_INFORMATION1,
X_INFORMATION2,
X_INFORMATION3,
X_INFORMATION4,
X_INFORMATION5,
X_INFORMATION6,
X_INFORMATION7,
X_INFORMATION8,
X_INFORMATION9,
X_INFORMATION10,
X_INFORMATION11,
X_INFORMATION12,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN);