The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO G_RUN_ID FROM dual;
SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO G_RUN_ID FROM dual;
INSERT INTO CZ_DB_LOGS
(RUN_ID,
LOGTIME,
LOGUSER,
URGENCY,
CALLER,
STATUSCODE,
MESSAGE)
VALUES (G_RUN_ID,
SYSDATE,
USER,
1,
p_caller,
l_status,
p_error_message);
l_attr_tbl.DELETE;
l_attr_tbl.DELETE;
l_attr_tbl.DELETE;
SELECT ISO_LANGUAGE||'-'||
ISO_TERRITORY
INTO l_lang
FROM FND_LANGUAGES_VL
WHERE language_code=USERENV('LANG');
FOR i IN(SELECT ui_def_id,NAME
FROM CZ_UI_DEFS
WHERE deleted_flag='0' AND
ui_style=G_OA_STYLE_UI AND seeded_flag='0')
LOOP
l_flag := FALSE;
FOR j IN(SELECT jrad_doc,NAME FROM CZ_UI_PAGES
WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')
LOOP
handle_Doc_Bad_Attributes
(p_doc_full_name => j.jrad_doc,
p_remove_bad_attributes => p_remove_bad_attributes,
x_bad_attributes_detected => l_bad_attributes_detected);
FOR i IN(SELECT ui_def_id,NAME
FROM CZ_UI_DEFS
WHERE ui_def_id=p_ui_def_id AND deleted_flag='0' AND
ui_style=G_OA_STYLE_UI AND seeded_flag='0')
LOOP
FOR j IN(SELECT jrad_doc,NAME FROM CZ_UI_PAGES
WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')
LOOP
l_bad_attributes_detected := FALSE;
FOR i IN(SELECT ui_def_id,NAME
FROM CZ_UI_DEFS
WHERE deleted_flag='0' AND
ui_style=G_OA_STYLE_UI AND seeded_flag='0')
LOOP
FOR j IN(SELECT jrad_doc,page_id,NAME FROM CZ_UI_PAGES
WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')
LOOP
handle_Bad_Element_Ids(p_doc_full_name => j.jrad_doc,
p_ui_def_id => j.page_id,
p_ui_page_id => i.ui_def_id);
UPDATE CZ_RULES
SET UI_PAGE_ELEMENT_ID=REPLACE(REPLACE(UI_PAGE_ELEMENT_ID,'_czt','_czn'),'_czc','_czn')
WHERE ui_def_id=i.ui_def_id;
UPDATE CZ_INTL_TEXTS
SET UI_PAGE_ELEMENT_ID=REPLACE(REPLACE(UI_PAGE_ELEMENT_ID,'_czt','_czn'),'_czc','_czn')
WHERE ui_def_id=i.ui_def_id;
FOR i IN(SELECT ui_def_id,NAME
FROM CZ_UI_DEFS
WHERE ui_def_id=p_ui_def_id AND deleted_flag='0' AND
ui_style=G_OA_STYLE_UI AND seeded_flag='0')
LOOP
FOR j IN(SELECT jrad_doc,page_id,NAME FROM CZ_UI_PAGES
WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')
LOOP
handle_Bad_Element_Ids(p_doc_full_name => j.jrad_doc,
p_ui_def_id => j.page_id,
p_ui_page_id => i.ui_def_id);
UPDATE CZ_RULES
SET UI_PAGE_ELEMENT_ID=REPLACE(REPLACE(UI_PAGE_ELEMENT_ID,'_czt','_czn'),'_czc','_czn')
WHERE ui_def_id=i.ui_def_id;
UPDATE CZ_INTL_TEXTS
SET UI_PAGE_ELEMENT_ID=REPLACE(REPLACE(UI_PAGE_ELEMENT_ID,'_czt','_czn'),'_czc','_czn')
WHERE ui_def_id=i.ui_def_id;
FOR i IN(SELECT jrad_doc,template_name
FROM CZ_UI_TEMPLATES
WHERE deleted_flag='0' AND
seeded_flag='0')
LOOP
handle_Doc_Bad_Attributes
(p_doc_full_name => i.jrad_doc,
p_remove_bad_attributes => p_remove_bad_attributes,
x_bad_attributes_detected => l_bad_attributes_detected);
FOR i IN(SELECT jrad_doc,template_name
FROM CZ_UI_TEMPLATES
WHERE template_id=p_template_id AND
deleted_flag='0' AND
seeded_flag='0')
LOOP
handle_Doc_Bad_Attributes
(p_doc_full_name => i.jrad_doc,
p_remove_bad_attributes => p_remove_bad_attributes,
x_bad_attributes_detected => l_bad_attributes_detected);
FOR i IN(SELECT * FROM CZ_UI_PAGES WHERE ui_def_id=p_ui_def_id AND deleted_flag='0')
LOOP
BEGIN
l_xmldoc := parse_JRAD_Document(i.jrad_doc);
FOR n IN(SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
WHERE ui_def_id=p_ui_def_id AND
page_id=p_page_id AND
element_id=l_element_id AND deleted_flag='0')
LOOP
UPDATE CZ_UI_PAGE_ELEMENTS
SET parent_element_id=l_element_id
WHERE ui_def_id=p_ui_def_id AND
page_id=p_page_id AND
element_id=p_element_id;
UPDATE CZ_UI_PAGE_ELEMENTS
SET deleted_flag='1'
WHERE ui_def_id=p_ui_def_id AND
page_id=p_page_id AND
element_id=p_element_id AND
NOT(element_type=523 AND
ctrl_template_id IS NULL) AND
deleted_flag='0';
FOR i IN(SELECT page_id, jrad_doc FROM CZ_UI_PAGES
WHERE ui_def_id=p_ui_def_id AND deleted_flag='0')
LOOP
l_xmldoc := parse_JRAD_Document(i.jrad_doc);
FOR j IN(SELECT element_id
FROM cz_ui_page_elements a
WHERE a.ui_def_id=p_ui_def_id AND a.page_id=i.page_id AND a.deleted_flag='0' AND
a.parent_element_id IS NOT NULL AND
EXISTS(SELECT NULL FROM CZ_RP_ENTRIES d
WHERE d.object_id IN(SELECT e.devl_project_id FROM CZ_UI_DEFS e
WHERE e.ui_def_id=p_ui_def_id AND
e.deleted_flag='0') AND d.object_type='PRJ' AND
d.deleted_flag='0') AND
EXISTS(SELECT NULL FROM CZ_UI_PAGES c
WHERE c.page_id=i.page_id AND c.ui_def_id=p_ui_def_id AND
c.deleted_flag='0') AND
NOT EXISTS(SELECT NULL FROM cz_ui_page_elements b WHERE b.ui_def_id=p_ui_def_id AND
b.page_id=i.page_id AND b.element_id=NVL(a.parent_element_id,'0')))
LOOP
restore_Elements_Hierarchy(l_xmldoc, p_ui_def_id, i.page_id, j.element_id);
FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND deleted_flag='0' AND seeded_flag='0')
LOOP
Open_Parser();
FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND deleted_flag='0' AND seeded_flag='0' AND
ui_def_id IN(
(SELECT ref_ui_def_id
FROM cz_ui_refs
START WITH ui_def_id = p_ui_def_id
CONNECT by PRIOR ref_ui_def_id = ui_def_id AND
deleted_flag = '0')
UNION
SELECT p_ui_def_id FROM dual) )
LOOP
Open_Parser();
FOR i IN(SELECT jrad_doc FROM CZ_UI_TEMPLATES
WHERE template_id=p_template_id AND ui_def_id IN(0,1) AND seeded_flag='0' AND deleted_flag='0')
LOOP
l_xmldoc := parse_JRAD_Document(i.jrad_doc);
FOR i IN(SELECT jrad_doc FROM CZ_UI_PAGES
WHERE ui_def_id=p_ui_def_id AND deleted_flag='0')
LOOP
l_xmldoc := parse_JRAD_Document(i.jrad_doc);
FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND seeded_flag='0' AND deleted_flag='0')
LOOP
Open_Parser();
FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS
WHERE ui_def_id=p_ui_def_id AND ui_style='7' AND seeded_flag='0' AND
deleted_flag='0')
LOOP
Open_Parser();
FOR i IN(SELECT template_id FROM CZ_UI_TEMPLATES WHERE seeded_flag='0' AND deleted_flag='0')
LOOP
Open_Parser();
FOR i IN(SELECT template_id FROM CZ_UI_TEMPLATES
WHERE template_id=p_template_id AND seeded_flag='0' AND
deleted_flag='0')
LOOP
Open_Parser();
SELECT element_id BULK COLLECT INTO l_arr_tbl FROM CZ_UI_PAGE_ELEMENTS
WHERE ui_def_id=p_ui_def_id AND deleted_flag='0';
FOR i IN(SELECT a.ui_def_id FROM CZ_UI_DEFS a
WHERE a.ui_style='7' AND a.deleted_flag='0' AND
EXISTS(SELECT NULL FROM CZ_RP_ENTRIES b WHERE b.object_id=a.devl_project_id AND
b.object_type='PRJ' AND b.deleted_flag='0')
)
LOOP
l_ui_def_id := i.ui_def_id;
l_ui_elements_tbl.DELETE;
FOR j IN(SELECT * FROM CZ_UI_PAGES WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')
LOOP
BEGIN
jdr_docbuilder.REFRESH;
SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS
WHERE ui_def_id=i.ui_def_id AND page_id=j.page_id AND element_id=l_parent_element_id;
SELECT CZ_UI_PAGE_ELEMENTS_S.NEXTVAL INTO l_element_id FROM dual;
FOR templ IN(SELECT template_id,template_name FROM CZ_UI_TEMPLATES
WHERE ui_def_id=0 AND jrad_doc=l_attribute_value AND deleted_flag='0')
LOOP
SELECT NVL(max(seq_nbr),0)+1 INTO l_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
WHERE ui_def_id=i.ui_def_id AND
page_id=j.page_id AND
parent_element_id=l_parent_element_id AND
deleted_flag='0';
INSERT INTO CZ_UI_PAGE_ELEMENTS
(
UI_DEF_ID
,PAGE_ID
,PERSISTENT_NODE_ID
,ELEMENT_ID
,PARENT_PERSISTENT_NODE_ID
,REGION_PERSISTENT_NODE_ID
,PAGEBASE_PERSISTENT_NODE_ID
,CTRL_TEMPLATE_ID
,BASE_PAGE_FLAG
,INSTANTIABLE_FLAG
,SEQ_NBR
,DELETED_FLAG
,CTRL_TEMPLATE_UI_DEF_ID
,MODEL_REF_EXPL_ID
,SUPPRESS_REFRESH_FLAG
,PARENT_ELEMENT_ID
,ELEMENT_TYPE
,NAME
,ELEMENT_SIGNATURE_ID
,TARGET_PAGE_UI_DEF_ID
,TARGET_PAGE_ID
)
VALUES
(
i.ui_def_id
,j.page_id
,NULL
,l_element_id
,l_ui_node.parent_persistent_node_id
,l_ui_node.region_persistent_node_id
,l_ui_node.pagebase_persistent_node_id
,templ.template_id
,'0'
,'0'
,l_seq_nbr
,'0'
,0
,NULL
,'0'
,l_parent_element_id
,NULL
,templ.template_name
,6011
,NULL
,NULL
);