The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT description
INTO l_element_desc
FROM cs_kb_elements_vl
WHERE element_id = p_element_id;
SELECT 'x'
FROM jtf_tasks_b TASK, jtf_task_statuses_b status
WHERE TASK.source_object_id = p_repair_line_id
AND TASK.source_object_type_code = 'DR'
AND TASK.task_status_id = status.task_status_id
AND NVL(status.closed_flag,'N') <> 'Y'
AND ROWNUM =1;
SELECT 'x' /* crx.repair_job_xref_id */
FROM csd_repair_job_xref crx, wip_discrete_jobs wdj
WHERE crx.repair_line_id = p_repair_line_id
AND crx.wip_entity_id = wdj.wip_entity_id
AND wdj.status_type NOT IN (4,5,7,12)
/* 4: Complete,5: Complete-No charges,7: Cancelled,12: Closed */
UNION ALL
SELECT 'x' /* repair_job_xref_id*/
FROM csd_repair_job_xref
WHERE repair_line_id = p_repair_line_id
AND wip_entity_id IS NULL;
SELECT repair_mode FROM csd_repairs
WHERE repair_line_id = p_repair_line_id;
SELECT REPAIR_LINE_ID
FROM CSD_REPAIRS
WHERE repair_number = p_repair_number;
SELECT FLOW_STATUS_ID
FROM CSD_FLOW_STATUSES_B
WHERE FLOW_STATUS_CODE = p_repair_status;
l_sql_str := 'Select ''x'' from csd_repairs ro '
|| ' Where ro.repair_line_id = :1 and '
|| l_predicate ;
l_sql_str := ' Select ''x'' from csd_repairs_v ro, csd_product_txns_v prd, '
+ ' cs_estimate_details csd Where ro.repair_line_id = :1'
+ ' And prd.repair_line_id = ro.repair_line_id '
+ ' And prd.action_code = :2 '
+ ' And prd.action_type = :3 '
+ ' And csd.estimate_detail_id = prd.estimate_detail_id '
+ ' And ' + l_predicate
;
l_sql_str := ' Select ''x'' from csd_repairs_v ro, csd_product_txns_v prd, '
+ ' cs_estimate_details csd Where ro.repair_line_id = :1'
+ ' And prd.repair_line_id = ro.repair_line_id '
+ ' And prd.action_code = :2 '
+ ' And prd.action_type = :3 '
+ ' And csd.estimate_detail_id = prd.estimate_detail_id '
+ ' And ' + l_predicate ;
Select instance_party_id,
object_version_number
from csi_i_parties
where instance_id = p_instance_id
and relationship_type_code = 'OWNER'
and sysdate between nvl(active_start_date, sysdate-1)
and nvl(active_end_date, sysdate+1);
Select object_version_number from csi_item_instances
where instance_id = p_instance_id;
Select ip_account_id,
object_version_number
from csi_ip_accounts
where instance_party_id = p_instance_party_id;
Select party_type
from hz_parties
where party_id = p_party_id;
Select count(relationship_id)
from hz_relationships
where subject_id = p_subject_id
and subject_type = p_subject_type
and subject_table_name = 'HZ_PARTIES'
and object_id = p_object_id
and object_type = p_object_type
and object_table_name = 'HZ_PARTIES'
and relationship_code = p_relationship_code
and sysdate between nvl(start_date, sysdate-1)
and nvl(end_date, sysdate+1);
csi_item_instance_pub.update_item_instance
(
p_api_version => 1.0,
p_commit => fnd_api.g_false,
p_init_msg_list => fnd_api.g_true,
p_validation_level => fnd_api.g_valid_level_full,
p_instance_rec => l_instance_rec,
p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
p_party_tbl => l_party_tbl,
p_account_tbl => l_account_tbl,
p_pricing_attrib_tbl => l_pricing_attrib_tbl,
p_org_assignments_tbl => l_org_assignments_tbl,
p_asset_assignment_tbl => l_asset_assignment_tbl,
p_txn_rec => l_txn_rec,
x_instance_id_lst => x_instance_id_lst,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
SELECT user_profile_option_name
FROM fnd_profile_options_tl
WHERE profile_option_name = p_profile_name
AND language = userenv('lang');
procedure auto_update_ro_status(
p_api_version in number,
p_commit in varchar2,
p_init_msg_list in varchar2,
p_repair_line_id in number,
x_return_status out nocopy varchar2,
x_msg_count out nocopy number,
x_msg_data out nocopy varchar2,
p_event in varchar2,
p_reason_code in varchar2 default null,
p_comments in varchar2 default null,
p_validation_level in number)
is
l_from_flow_status_id number;
lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.auto_update_ro_status';
lc_api_name varchar2(60) := 'auto_update_ro_status';
fnd_log.string(lc_log_level,lc_mod_name,'Begin auto_update_ro_status');
fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Enable Auto Update of Repair
Order Status upon Receiving is not set to yes.');
select 'x'
into l_un_rcvd_lines_exists
from (
select 'x'
from csd_product_transactions cpt
where cpt.repair_line_id = p_repair_line_id and
cpt.action_type = 'RMA' and
cpt.action_code in ('CUST_PROD','EXCHANGE') and
cpt.prod_txn_status <> 'RECEIVED'
and rownum < 2
) where rownum < 2 ;
select distinct cr.flow_status_id,
cr.repair_type_id,
cr.object_version_number
into l_from_flow_status_id,
l_repair_type_id,
l_object_version_number
from csd_repairs cr
where cr.repair_line_id = p_repair_line_id;
fnd_log.string(lc_log_level,lc_mod_name,'the new status is same as the old status. Do not update the status');
fnd_log.string(lc_log_level,lc_mod_name,'calling csd_repairs_pvt.update_flow_status API');
csd_repairs_pvt.update_flow_status(p_api_version => 1,
p_commit => fnd_api.g_false,
p_init_msg_list => fnd_api.g_false,
p_validation_level => fnd_api.g_valid_level_full,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_repair_line_id => p_repair_line_id,
p_repair_type_id => l_repair_type_id,
p_from_flow_status_id => l_from_flow_status_id,
p_to_flow_status_id => l_to_flow_status_id,
p_reason_code => p_reason_code,
p_comments => p_comments,
p_check_access_flag => 'Y',
p_object_version_number => l_object_version_number,
x_object_version_number => x_object_version_number );
fnd_log.string(lc_log_level,lc_mod_name,'Error in csd_repairs_pvt.update_flow_status
['||x_msg_data||']');
end auto_update_ro_status;
select distinct repair_mode, nvl(auto_process_rma,'N')
from csd_repair_types_vl
where repair_type_id = p_repair_type_id;
select customer_id,
account_id,
bill_to_site_use_id,
ship_to_site_use_id,
inventory_item_id,
category_id,
contract_id,
problem_code,
customer_product_id
from CS_INCIDENTS_ALL_VL
where incident_id = p_incident_id;