[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT qa_skiplot_log_id_s.nextval
FROM dual;
INSERT
INTO qa_skiplot_log
(
LOG_ID,
MODULE_NAME,
ERROR_MESSAGE,
COMMENTS,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN
)
VALUES
(
x_logid,
p_module_name,
p_error_message,
p_comments,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id
)
;
ELSIF (p_prefix = g_last_update_date_attribute) THEN
label := fnd_message.get_string('QA','QA_SS_ENTRY_DATE');
ELSIF (INSTR(p_code, g_last_update_date_attribute) <> 0) THEN
column_name := 'LAST_UPDATE_DATE';
select fc.width
from fnd_columns fc, fnd_tables ft
where fc.table_id = ft.table_id
and ft.table_name = 'QA_RESULTS_INTERFACE'
and ft.application_id = 250
and fc.user_column_name = p_column_name
and fc.application_id = 250; -- to use index
x_parents.delete();
SELECT char_id BULK COLLECT INTO elements_array
FROM (SELECT char_id
FROM QA_PLAN_CHARS
WHERE plan_id = p_plan_id
AND enabled_flag = 1
ORDER BY mandatory_flag, prompt_sequence)
WHERE rownum <=5;
(select 1 from
qa_plan_char_action_triggers pcat,
qa_plan_char_actions pca
where pcat.plan_id = p_plan_id
and pcat.plan_char_action_trigger_id = pca.plan_char_action_trigger_id
and action_id in (1, 2, 24)
and pcat.char_id = p_char_id) ;
IF (p_attribute_code = g_last_update_date_attribute) THEN
-- Assign a datatype of DATETIME to last_update_date.
l_data_type := convert_data_type(g_datetime_datatype);
PROCEDURE delete_old_top_document(
p_full_path IN VARCHAR2) IS
BEGIN
-- delete the document if it exists.
If jdr_docbuilder.documentExists(p_full_path) then
jdr_docbuilder.deleteDocument(p_full_path);
END delete_old_top_document;
SELECT qpc.char_id
FROM qa_plan_chars qpc,
qa_chars qc
WHERE qc.char_id = qpc.char_id
AND qpc.enabled_flag = 1
AND qpc.plan_id = p_plan_id
AND ((p_char_type = 'NonComments' AND qc.datatype <> g_comments_datatype) OR
(p_char_type = 'Comments' AND qc.datatype = g_comments_datatype))
ORDER BY QPC.prompt_sequence;
p_attribute_code => g_last_update_date_attribute,
p_item_style => l_item_style,
p_element_prefix => l_element_prefix);
jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false' );
jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false' );
jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false' );
jdr_docbuilder.setAttribute(special_elem, 'insertAllowed', 'false' );
jdr_docbuilder.setAttribute(special_elem, 'updateAllowed', 'false' );
jdr_docbuilder.setAttribute(special_elem, 'deleteAllowed', 'false' );
l_del_attr_set CONSTANT VARCHAR2(50) := '/oracle/apps/fnd/attributesets/Buttons/Delete';
l_label := fnd_message.get_string('QA','QA_TABLE_SELECT_MSG');
FUNCTION create_table_selection RETURN jdr_docbuilder.element IS
l_sing_select jdr_docbuilder.element := NULL;
l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_SELECTION';
l_sing_select := create_jrad_region_item('singleSelection');
jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
jdr_docbuilder.addchild(p_parent => l_sing_select,
p_groupingNS => JDR_DOCBUILDER.UI_NS,
p_groupingTagName => 'primaryClientAction',
p_child => ppr_event);
RETURN l_sing_select;
END create_table_selection;
jdr_docbuilder.setattribute(l_add_btn, 'autoInsertion', 'false');
PROCEDURE add_table_selection(p_prnt_elm IN jdr_docbuilder.element )IS
l_tbl_s_sel jdr_docbuilder.element := NULL;
l_tbl_s_sel := create_table_selection;
add_child_to_parent(p_prnt_elm, l_tbl_s_sel, 'tableSelection');
END add_table_selection;
SELECT qpc.char_id
FROM qa_plan_chars qpc,
qa_chars qc,
qa_device_info qdi
WHERE qc.char_id = qpc.char_id
AND nvl(qpc.enabled_flag, 2) = 1
AND nvl(qpc.device_flag, 2) = 1
AND nvl(qpc.displayed_flag, 2) = 1
AND qdi.device_id = qpc.device_id
AND qdi.enabled_flag = 1
AND qpc.plan_id = p_plan_id
ORDER BY qpc.prompt_sequence;
delete_old_top_document(g_jrad_region_path || l_top_region_code);
delete_old_top_document(g_jrad_region_path || l_top_region_code);
select upper(translate(qc.name,' ''*{}','_____'))
into l_vo_attr_name
from qa_chars qc,
qa_plan_chars qpc
where qc.char_id = qpc.char_id
and qpc.plan_id = p_plan_id
and qpc.char_id = p_char_id;
elsif p_attribute_name = g_last_update_date_attribute then
return 'LAST_UPDATE_DATE';
SELECT qpc.char_id
FROM qa_plan_chars qpc,
qa_chars qc
WHERE qc.char_id = qpc.char_id
AND qpc.enabled_flag = 1
AND qpc.plan_id = p_plan_id
AND ((p_char_type = 'NonComments' AND qc.datatype <> g_comments_datatype) OR
(p_char_type = 'Comments' AND qc.datatype = g_comments_datatype))
ORDER BY QPC.mandatory_flag, QPC.prompt_sequence;
delete_old_top_document(g_jrad_region_path || l_top_region_code);
create_special_item_mult_vqr(g_last_update_date_attribute, l_char_item, l_char_dtl_item);
delete_old_top_document(g_jrad_region_path || l_stk_region_code);
add_table_selection(l_table_region);
delete_old_top_document(g_jrad_region_path || l_stk_region_code);
add_table_selection(l_table_region);
SELECT template_plan_id
FROM qa_plans
WHERE plan_id = p_plan_id;
SELECT short_code
FROM qa_plan_char_value_lookups
WHERE plan_id = p_plan_id
AND char_id = c_char_id;
SELECT jrad_upgrade_ver
INTO l_jrad_upgrade_ver
FROM qa_plans
WHERE plan_id = p_plan_id
FOR UPDATE;
SELECT jrad_upgrade_ver
INTO l_seed_ver
FROM qa_plans
WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;
PROCEDURE delete_plan_jrad_region(p_plan_id IN NUMBER) IS
BEGIN
delete_old_top_document(g_jrad_region_path ||
construct_code(g_eqr_single_prefix, p_plan_id));
delete_old_top_document(g_jrad_region_path ||
construct_code(g_eqr_multiple_prefix, p_plan_id));
END delete_plan_jrad_region;
UPDATE qa_plans
SET jrad_upgrade_ver =
(SELECT nvl(jrad_upgrade_ver, 1)
FROM qa_plans
WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN)
WHERE plan_id = p_plan_id;