DBA Data[Home] [Help]

APPS.CSD_REFURBISH_IRO_GRP dependencies on CSD_REPAIRS

Line 219: l_rep_line_rec CSD_REPAIRS_PUB.Repln_Rec_Type;

215: -- Declare local record variables for SR, Notes, contacts and repair line records
216: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
217: l_notes_table CS_ServiceRequest_PUB.notes_table;
218: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
219: l_rep_line_rec CSD_REPAIRS_PUB.Repln_Rec_Type;
220:
221: l_inc_type_id Varchar2(255) ; -- Changed from number to Varchar2
222: l_inc_status_id Varchar2(255) ; -- Changed from number to Varchar2
223: l_inc_severity_id Varchar2(255) ; -- Changed from number to Varchar2

Line 239: l_repair_mode csd_repairs.repair_mode%Type;

235: l_error_count Number;
236: l_incident_id Number;
237: l_incident_number cs_incidents_all_b.Incident_Number%TYpe;
238: l_approval_flag Varchar2(1);
239: l_repair_mode csd_repairs.repair_mode%Type;
240:
241: l_repair_number csd_repairs.repair_number%Type;
242: l_repair_line_id csd_repairs.repair_line_id%Type;
243: l_msg_count Number;

Line 241: l_repair_number csd_repairs.repair_number%Type;

237: l_incident_number cs_incidents_all_b.Incident_Number%TYpe;
238: l_approval_flag Varchar2(1);
239: l_repair_mode csd_repairs.repair_mode%Type;
240:
241: l_repair_number csd_repairs.repair_number%Type;
242: l_repair_line_id csd_repairs.repair_line_id%Type;
243: l_msg_count Number;
244: l_msg_data Varchar2(2000);
245: l_return_status Varchar2(30);

Line 242: l_repair_line_id csd_repairs.repair_line_id%Type;

238: l_approval_flag Varchar2(1);
239: l_repair_mode csd_repairs.repair_mode%Type;
240:
241: l_repair_number csd_repairs.repair_number%Type;
242: l_repair_line_id csd_repairs.repair_line_id%Type;
243: l_msg_count Number;
244: l_msg_data Varchar2(2000);
245: l_return_status Varchar2(30);
246: l_serialized_flag Varchar2(1);

Line 975: --bug#6692459 always stored the move out item_id to supercession_inv_item_id on csd_repairs table

971: l_Rep_Line_Rec.Supercession_Inv_Item_Id := Null;
972:
973: End If;
974: */
975: --bug#6692459 always stored the move out item_id to supercession_inv_item_id on csd_repairs table
976: --always stored the move out quantity to the repair_yield_quantity on csd_repairs table
977: l_Rep_Line_Rec.Supercession_Inv_Item_Id := l_IRandISO_Out_Rec.Inventory_Item_Id;
978: l_Rep_Line_Rec.repair_yield_quantity := l_IRandISO_Out_Rec.quantity;
979:

Line 976: --always stored the move out quantity to the repair_yield_quantity on csd_repairs table

972:
973: End If;
974: */
975: --bug#6692459 always stored the move out item_id to supercession_inv_item_id on csd_repairs table
976: --always stored the move out quantity to the repair_yield_quantity on csd_repairs table
977: l_Rep_Line_Rec.Supercession_Inv_Item_Id := l_IRandISO_Out_Rec.Inventory_Item_Id;
978: l_Rep_Line_Rec.repair_yield_quantity := l_IRandISO_Out_Rec.quantity;
979:
980:

Line 994: csd_repairs_pvt.Create_Repair_Order(

990: l_IRandISO_In_Rec.Req_Line_Id);
991: Fetch get_req_org_id INTO l_Rep_Line_Rec.inventory_org_id;
992: Close get_req_org_id;
993:
994: csd_repairs_pvt.Create_Repair_Order(
995: P_Api_Version_Number => 1.0 ,
996: P_Init_Msg_List => FND_API.G_FALSE,
997: P_Commit => FND_API.G_FALSE,
998: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1173: csd_repairs_pvt.Create_Repair_Order(

1169: Fetch get_req_org_id INTO l_Rep_Line_Rec.inventory_org_id;
1170: Close get_req_org_id;
1171:
1172: ---Create Repair Order
1173: csd_repairs_pvt.Create_Repair_Order(
1174: P_Api_Version_Number => 1.0 ,
1175: P_Init_Msg_List => Fnd_Api.G_False,
1176: P_Commit => Fnd_Api.G_False,
1177: p_validation_level => Fnd_Api.G_Valid_Level_Full,

Line 1188: 'Error : While calling procedure csd_repairs_pvt.Create_Repair_Order ');

1184: X_Msg_Data => l_Msg_Data ) ;
1185: If l_Return_Status <> FND_API.G_RET_STS_SUCCESS Then
1186: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1187: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'Create_Repair_Order',
1188: 'Error : While calling procedure csd_repairs_pvt.Create_Repair_Order ');
1189: End If;
1190: Raise FND_API.G_EXC_ERROR ;
1191: Else
1192: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then

Line 1194: 'Success : While calling procedure csd_repairs_pvt.Create_Repair_Order ');

1190: Raise FND_API.G_EXC_ERROR ;
1191: Else
1192: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
1193: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || 'Create_Repair_Order',
1194: 'Success : While calling procedure csd_repairs_pvt.Create_Repair_Order ');
1195: End If;
1196: End If;
1197: l_Product_Trxn_Id := NULL ; -- This is just to make sure that new product trasaction id generated
1198: -- Insert into Product Transactions table , Insert a row for Action Type Move-In