The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
FROM qa_plan_transactions
WHERE plan_id = c_plan_id
AND transaction_number = c_txn_no
AND enabled_flag = 1;
SELECT 1
FROM qa_pc_plan_relationship
WHERE parent_plan_id = p_plan_id
OR child_plan_id = p_plan_id;
SELECT prompt
FROM qa_plan_chars
WHERE plan_id = p_plan_id
AND char_id = p_element_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 'TRUE'
FROM qa_txn_collection_triggers
WHERE transaction_number = p_txn_number
--AND search_flag = 1
AND enabled_flag = 1
AND collection_trigger_id = p_element_id;
x_parents.delete();
SELECT 1
FROM qa_plan_char_actions
WHERE assigned_char_id = p_char_id
AND plan_char_action_trigger_id
IN (SELECT plan_char_action_trigger_id
FROM qa_plan_char_action_triggers
WHERE plan_id = p_plan_id);
SELECT NAME from qa_plans
WHERE plan_id = p_plan_id;
SELECT displayed_flag, mandatory_flag, prompt, read_only_flag
FROM qa_plan_chars
WHERE plan_id = p_plan_id
AND char_id = p_char_id;
SELECT name, datatype
FROM qa_chars
WHERE char_id = p_char_id;
l_update_flag VARCHAR2(1) DEFAULT 'Y';
IF (p_attribute_code = g_update_attribute) THEN
-- dbms_output.put_line('Display Sequence: ' || l_display_sequence);
l_label_long := fnd_message.get_string('QA', 'QA_SS_JRAD_UPDATE');
l_image_file_name := 'updateicon_enabled.gif';
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(qa_ss_const.datetime_datatype);
jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false');
jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');
jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');
SELECT char_id
FROM qa_plan_chars
WHERE plan_id = p_plan_id
AND enabled_flag = 1 ORDER BY displayed_flag, prompt_sequence;
jdr_docbuilder.deleteDocument(l_old_doc_name);
SELECT char_id
FROM qa_plan_chars
WHERE plan_id = p_plan_id
AND enabled_flag = 1
ORDER BY PROMPT_SEQUENCE;
child1 := add_special_region_item (p_attribute_code => g_last_update_date_attribute,
p_plan_id => p_plan_id,
p_prefix => p_prefix,
p_region_code => l_region_code);
child1 := add_special_region_item (p_attribute_code => g_update_attribute,
p_plan_id => p_plan_id,
p_prefix => p_prefix,
p_region_code => l_region_code);
jdr_docbuilder.deleteDocument(l_old_doc_name);
SELECT jrad_doc_ver
FROM QA_PLANS
WHERE PLAN_ID = p_plan_id;
UPDATE QA_PLANS
SET JRAD_DOC_VER = l_jrad_doc_ver
WHERE PLAN_ID = p_plan_id;
NULL; --dont update here...calling procedure will update
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;
SELECT jrad_doc_ver
INTO l_jrad_doc_ver
FROM qa_plans
WHERE plan_id = p_plan_id;
SELECT 1
FROM qa_txn_collection_triggers qtct
WHERE qtct.transaction_number = txn_number
AND qtct.collection_trigger_id = element_id;