[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT crtv.name
from csd_repair_types_vl crtv, csd_repairs cr
where cr.repair_line_id = p_original_repair_line_id and crtv.repair_type_id = cr.repair_type_id;
CSD_REPAIRS_PVT.Update_Repair_Order
(p_API_version_number => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_commit => FND_API.G_FALSE,
p_validation_level => null,
p_repair_line_id => p_original_repair_line_id,
p_Repln_Rec => l_original_rep_line_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');
CSD_REPAIRS_PVT.Update_Repair_Order
(p_API_version_number => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_commit => FND_API.G_FALSE,
p_validation_level => null,
p_repair_line_id => p_original_repair_line_id,
p_Repln_Rec => l_original_rep_line_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');
SELECT
repair_number
,incident_id
,inventory_item_id
,customer_product_id
,unit_of_measure
,repair_type_id
,resource_id
,instance_id
,project_id
,task_id
,unit_number
,contract_line_id
,quantity
,status
,approval_required_flag
,date_closed
,quantity_in_wip
,approval_status
,quantity_rcvd
,quantity_shipped
,serial_number
,promise_date
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,security_group_id
,order_line_id
,original_source_reference
,status_reason_code
,auto_process_rma
,repair_mode
,item_revision
,repair_group_id
,ro_txn_status
,currency_code
,default_po_num
,original_source_header_id
,original_source_line_id
,price_list_header_id
,problem_description -- swai: bug 4666344
,ro_priority_code -- swai: R12
,resolve_by_date -- rfieldma: 5355051
,object_version_number
,attribute16 --bug#7497907, 12.1 FP, subhat
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
FROM csd_repairs
where repair_line_id = p_repair_line_id;
SELECT
estimate_detail_id
,action_type
,action_code
,interface_to_om_flag
,book_sales_order_flag
,release_sales_order_flag
,ship_sales_order_flag
,sub_inventory
,lot_number
,context
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,prod_txn_status
,prod_txn_code
--,shipped_serial_number This column is not used in 11.5.10
,object_version_number
,req_header_id
,req_line_id
,order_header_id
,order_line_id
,quantity_received
,quantity_shipped
,source_serial_number
,source_instance_id
,non_source_serial_number
,non_source_instance_id
,locator_id
,sub_inventory_rcvd
,lot_number_rcvd
,picking_rule_id -- Add for R12 pickrule id change.Vijay.
,project_id
,task_id
,unit_number
,internal_po_header_id -- swai: bug 6148019
FROM csd_product_transactions
where product_transaction_id = p_product_txn_id;
SELECT cptv.action_type, cptv.interface_to_om_flag, cptv.repair_quantity, cptv.quantity_in_wip, cptv.quantity_rcvd, cptv.status,
cptv.serial_number_control_code, crtv.repair_type_ref, msiv.comms_nl_trackable_flag, crtv.repair_mode
FROM csd_product_txns_v cptv, csd_repair_types_vl crtv, mtl_system_items_vl msiv
WHERE repair_line_id = p_repair_line_id and crtv.repair_type_id = cptv.repair_type_id and action_type = 'RMA'
and msiv.inventory_item_id = cptv.inventory_item_id and msiv.organization_id = cs_std.get_item_valdn_orgzn_id;
SELECT interface_to_om_flag
FROM csd_product_txns_v
WHERE repair_line_id = p_repair_line_id and action_type = 'SHIP';
SELECT crtv.repair_type_ref
FROM csd_repairs_v crv, csd_repair_types_vl crtv
WHERE repair_line_id = p_repair_line_id and crv.repair_type_id = crtv.repair_type_id;
SELECT count(*)
FROM csd_repair_job_xref
WHERE repair_line_id = p_repair_line_id;
SELECT product_transaction_id
FROM csd_product_txns_v
WHERE repair_line_id = p_original_repair_line_id and ACTION_TYPE = 'RMA';
CSD_PRODUCT_TRANSACTIONS_PKG.INSERT_ROW
( px_PRODUCT_TRANSACTION_ID => l_original_product_txn_rec.PRODUCT_TRANSACTION_ID,
p_REPAIR_LINE_ID => l_repair_line_id,
p_ESTIMATE_DETAIL_ID => l_original_product_txn_rec.estimate_detail_id,
p_ACTION_TYPE => l_original_product_txn_rec.ACTION_TYPE,
p_ACTION_CODE => l_original_product_txn_rec.ACTION_CODE,
p_LOT_NUMBER => l_original_product_txn_rec.LOT_NUMBER,
p_SUB_INVENTORY => l_original_product_txn_rec.SUB_INVENTORY,
p_INTERFACE_TO_OM_FLAG => l_original_product_txn_rec.INTERFACE_TO_OM_FLAG,
p_BOOK_SALES_ORDER_FLAG => l_original_product_txn_rec.BOOK_SALES_ORDER_FLAG,
p_RELEASE_SALES_ORDER_FLAG => l_original_product_txn_rec.RELEASE_SALES_ORDER_FLAG,
p_SHIP_SALES_ORDER_FLAG => l_original_product_txn_rec.SHIP_SALES_ORDER_FLAG ,
p_PROD_TXN_STATUS => l_original_product_txn_rec.PROD_TXN_STATUS,
p_PROD_TXN_CODE => l_original_product_txn_rec.PROD_TXN_CODE,
p_LAST_UPDATE_DATE => SYSDATE,
p_CREATION_DATE => SYSDATE,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_CREATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID,
p_ATTRIBUTE1 => l_original_product_txn_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_original_product_txn_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_original_product_txn_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_original_product_txn_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_original_product_txn_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_original_product_txn_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_original_product_txn_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_original_product_txn_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_original_product_txn_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_original_product_txn_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_original_product_txn_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_original_product_txn_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_original_product_txn_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_original_product_txn_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_original_product_txn_rec.ATTRIBUTE15,
p_CONTEXT => l_original_product_txn_rec.CONTEXT ,
p_OBJECT_VERSION_NUMBER => 1,
-- p_SHIPPED_SERIAL_NUMBER => l_original_product_txn_rec.SHIPPED_SERIAL_NUMBER
p_Req_Header_Id => l_original_product_txn_rec.Req_Header_Id,
p_Req_Line_Id => l_original_product_txn_rec.Req_Line_Id,
p_Order_Header_Id => l_original_product_txn_rec.Order_Header_Id,
p_Order_Line_Id => l_original_product_txn_rec.Order_Line_Id,
p_Prd_txn_Qty_Received => l_original_product_txn_rec.Prd_Txn_Qty_Received,
p_Prd_Txn_Qty_Shipped => l_original_product_txn_rec.Prd_Txn_Qty_Shipped,
p_Source_Serial_Number => l_original_product_txn_rec.Source_Serial_Number,
p_Source_Instance_Id => l_original_product_txn_rec.Source_Instance_Id,
p_Non_Source_Serial_Number => l_original_product_txn_rec.Non_Source_Serial_Number,
p_Non_Source_Instance_Id => l_original_product_txn_rec.Non_Source_Instance_Id,
p_Locator_Id => l_original_product_txn_rec.Locator_Id,
p_Sub_Inventory_Rcvd => l_original_product_txn_rec.Sub_Inventory_Rcvd,
p_Lot_Number_Rcvd => l_original_product_txn_rec.Lot_Number_Rcvd,
p_picking_rule_id => l_original_product_txn_rec.picking_rule_id, -- Add for R12 pickrule id change.Vijay.
p_project_id => l_original_product_txn_rec.project_id,
p_task_id => l_original_product_txn_rec.task_id,
p_unit_number => l_original_product_txn_rec.unit_number,
p_internal_po_header_id => l_original_product_txn_rec.internal_po_header_id -- swai: bug 6148019
);
SELECT repair_history_id
FROM CSD_REPAIR_HISTORY
WHERE repair_line_id = p_original_repair_line_id;
SELECT request_id, program_id, program_application_id, program_update_date, event_code, event_date, quantity
,paramn1, paramn2, paramn3, paramn4, paramn5, paramn6, paramn7, paramn8, paramn9, paramn10
, paramc1, paramc2, paramc3, paramc4, paramc5, paramc6, paramc7, paramc8, paramc9, paramc10
, paramd1, paramd2, paramd3, paramd4, paramd5, paramd6, paramd7, paramd8, paramd9, paramd10
, attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6
, attribute7, attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15
FROM csd_repair_history
WHERE repair_history_id = p_original_repair_history_id;
x_repair_history_Rec.program_update_date, x_repair_history_Rec.event_code, x_repair_history_Rec.event_date,
x_repair_history_Rec.quantity,x_repair_history_Rec.paramn1, x_repair_history_Rec.paramn2, x_repair_history_Rec.paramn3,
x_repair_history_Rec.paramn4, x_repair_history_Rec.paramn5, x_repair_history_Rec.paramn6, x_repair_history_Rec.paramn7,
x_repair_history_Rec.paramn8, x_repair_history_Rec.paramn9, x_repair_history_Rec.paramn10, x_repair_history_Rec.paramc1,
x_repair_history_Rec.paramc2, x_repair_history_Rec.paramc3, x_repair_history_Rec.paramc4, x_repair_history_Rec.paramc5,
x_repair_history_Rec.paramc6, x_repair_history_Rec.paramc7, x_repair_history_Rec.paramc8, x_repair_history_Rec.paramc9,
x_repair_history_Rec.paramc10, x_repair_history_Rec.paramd1, x_repair_history_Rec.paramd2, x_repair_history_Rec.paramd3,
x_repair_history_Rec.paramd4, x_repair_history_Rec.paramd5, x_repair_history_Rec.paramd6, x_repair_history_Rec.paramd7,
x_repair_history_Rec.paramd8, x_repair_history_Rec.paramd9, x_repair_history_Rec.paramd10, x_repair_history_Rec.attribute_category,
x_repair_history_Rec.attribute1, x_repair_history_Rec.attribute2, x_repair_history_Rec.attribute3, x_repair_history_Rec.attribute4,
x_repair_history_Rec.attribute5, x_repair_history_Rec.attribute6, x_repair_history_Rec.attribute7, x_repair_history_Rec.attribute8,
x_repair_history_Rec.attribute9, x_repair_history_Rec.attribute10, x_repair_history_Rec.attribute11, x_repair_history_Rec.attribute12,
x_repair_history_Rec.attribute13, x_repair_history_Rec.attribute14, x_repair_history_Rec.attribute15;
x_repair_history_Rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
x_repair_history_Rec.LAST_UPDATE_DATE := sysdate;
x_repair_history_Rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
SELECT notes, note_status, note_type, entered_by, entered_date, creation_date, created_by,
last_update_date, last_updated_by, last_update_login,
ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, CONTEXT
FROM jtf_notes_vl
WHERE source_object_id = p_original_repair_line_id and source_object_code = 'DR';
, p_last_update_date => C.last_update_date
, p_last_updated_by => C.last_updated_by
, p_last_update_login => C.last_update_login
, p_attribute1 => C.ATTRIBUTE1
, p_attribute2 => C.ATTRIBUTE2
, p_attribute3 => C.ATTRIBUTE3
, p_attribute4 => C.ATTRIBUTE4
, p_attribute5 => C.ATTRIBUTE5
, p_attribute6 => C.ATTRIBUTE6
, p_attribute7 => C.ATTRIBUTE7
, p_attribute8 => C.ATTRIBUTE8
, p_attribute9 => C.ATTRIBUTE9
, p_attribute10 => C.ATTRIBUTE10
, p_attribute11 => C.ATTRIBUTE11
, p_attribute12 => C.ATTRIBUTE12
, p_attribute13 => C.ATTRIBUTE13
, p_attribute14 => C.ATTRIBUTE14
, p_attribute15 => C.ATTRIBUTE15
, p_context => C.CONTEXT
, p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
);
SELECT
crt.repair_type_ref,
cr.auto_process_rma,
cr.inventory_item_id,
cr.item_revision,
cr.contract_line_id,
cr.unit_of_measure,
cr.quantity,
cr.customer_product_id,
cr.serial_number,
crt.cps_txn_billing_type_id ,
crt.cpr_txn_billing_type_id ,
crt.ls_txn_billing_type_id ,
crt.lr_txn_billing_type_id ,
crt.price_list_header_id ,
crt.business_process_id,
cr.incident_id,
cr.default_po_num,
cr.inventory_org_id,
cr.project_id,
cr.task_id,
cr.unit_number
FROM csd_repairs cr,
csd_repair_types_vl crt
WHERE cr.repair_type_id = crt.repair_type_id
and cr.repair_line_id = p_rep_line_id;
SELECT
revision
FROM mtl_item_revisions
WHERE inventory_item_id = p_inv_item_id
and organization_id = p_org_id;
x_prod_txn_tbl.delete;
x_prod_txn_tbl(1).last_update_date := sysdate ;
x_prod_txn_tbl(1).last_updated_by := FND_GLOBAL.USER_ID;
x_prod_txn_tbl(1).last_update_login := FND_GLOBAL.USER_ID;