[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select primary_uom_code
from mtl_system_items_kfv
where inventory_item_id = p_inventory_item_id
and organization_id = cs_std.get_item_valdn_orgzn_id;
SELECT incident_date, creation_date, customer_id, account_id, customer_product_id, contract_id, contract_service_id
FROM cs_incidents_all_b
WHERE incident_id = p_incident_id;
SELECT uom_code
FROM mtl_uom_conversions
WHERE uom_class = 'Time' and conversion_rate = 1; */
Select cbtc.billing_category
From mtl_system_items_kfv kfv, cs_billing_type_categories cbtc
Where kfv.inventory_item_id = p_sbe_record.inventory_item_id
and kfv.material_billable_flag = cbtc.billing_type
and organization_id = cs_std.get_item_valdn_orgzn_id;
Select ctbt.txn_billing_type_id
from cs_txn_billing_types ctbt, cs_billing_type_categories cbtc
where ctbt.transaction_type_id = p_transaction_type_id
and ctbt.billing_type = cbtc.billing_type
and cbtc.billing_category = p_billing_category;
/*Select txn_billing_type_id
from cs_txn_billing_types
-where transaction_type_id = p_transaction_type_id
and billing_type = 'L';
Select ctbt.txn_billing_type_id
from cs_txn_billing_types ctbt, cs_billing_type_categories cbtc
where ctbt.transaction_type_id = p_transaction_type_id
and ctbt.billing_type = cbtc.billing_type
and cbtc.billing_category = 'L';
SELECT ro.contract_line_id
FROM csd_repairs ro
WHERE ro.repair_line_id = p_repair_line_id;
SELECT j.resource_id,j.task_id
FROM csf_debrief_headers h,
csf_debrief_lines l,
jtf_task_assignments_v j,
jtf_tasks_b jt
WHERE l.debrief_line_id = p_debrief_line_id
AND h.debrief_header_id = l.debrief_header_id
AND h.task_assignment_id = j.task_assignment_id
AND j.task_id = jt.task_id
AND jt.source_object_type_code = 'SR';
SELECT br.rate_code,
br.rate_uom,
br.rate_amount,
br.rate_percent
FROM oks_ent_txn_groups_v txn,
oks_ent_bill_rates_v br,
oks_ent_bill_types_v bt
WHERE bt.txn_group_id = txn.txn_group_id
AND br.billing_type_id = bt.contract_billing_type_id
AND bt.billing_type_id = p_txn_billing_type_id
AND txn.business_process_id = p_business_process_id
AND txn.contract_line_id = p_contract_line_id;
SELECT bc.billing_category
FROM cs_billing_type_categories bc,
cs_txn_billing_types bt
WHERE bt.billing_type = bc.billing_type
AND bt.txn_billing_type_id = p_txn_billing_type_id;
select nvl(create_cost_flag ,'N'),
nvl(create_charge_flag,'Y')
from cs_transaction_types_b
where transaction_type_id = p_transaction_type_id;
PROCEDURE Delete_In_Progress_Charges(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_incident_id IN NUMBER,
p_debrief_header_id IN NUMBER := NULL, -- Enhancement 2983340
p_debrief_line_id IN NUMBER := NULL, -- To make the API backward compatible
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_In_Progress_Charges';
SELECT estimate_detail_id
FROM cs_estimate_details
WHERE incident_id = p_incident_id
and source_code = 'SD' -- Enhancement 2983340
and source_id in (select debrief_line_id from csf_debrief_lines where debrief_header_id = nvl(p_debrief_header_id, debrief_header_id)) -- Enhancement 2983340
-- Fix bug 3137168 and generated_by_bca_engine_flag = 'Y'
and charge_line_type = 'IN_PROGRESS';
SELECT estimate_detail_id
FROM cs_estimate_details
WHERE incident_id = p_incident_id
and source_code = 'SD' -- Enhancement 2983340
and source_id in (select debrief_line_id from csf_debrief_lines where debrief_line_id = nvl(p_debrief_line_id, debrief_line_id)) -- Enhancement 2983340
and charge_line_type = 'IN_PROGRESS';
SAVEPOINT Delete_In_Progress_Charges;
cs_charge_details_pub.Delete_Charge_Details(
p_api_version => p_api_version_number,
p_init_msg_list => FND_API.G_FALSE,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_estimate_detail_id => l_estimate_detail_id,
p_delete_cost_detail =>'N');
( FND_LOG.level_statement, L_LOG_MODULE || 'Delete l_estimate_detail_id = '
, l_estimate_detail_id
);
--DBMS_OUTPUT.PUT_LINE('Delete l_estimate_detail_id = ' || l_estimate_detail_id);
cs_charge_details_pub.Delete_Charge_Details(
p_api_version => p_api_version_number,
p_init_msg_list => FND_API.G_FALSE,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_estimate_detail_id => l_estimate_detail_id,
p_delete_cost_detail =>'N');
Rollback to Delete_In_Progress_Charges;
Rollback to Delete_In_Progress_Charges;
END Delete_In_Progress_Charges;