33: IS
34: l_api_name CONSTANT VARCHAR2(30) := 'Create_repair_history';
35: l_api_version_number CONSTANT NUMBER := 1.0;
36: l_return_status_full VARCHAR2(1);
37: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT CREATE_REPAIR_HISTORY_PVT;
41:
385: */
386: l_api_name CONSTANT VARCHAR2(30) := 'Update_repair_history';
387: l_api_version_number CONSTANT NUMBER := 1.0;
388: -- Local Variables
389: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
390: l_ref_REPH_rec CSD_repair_history_PVT.REPH_Rec_Type;
391: l_tar_REPH_rec CSD_repair_history_PVT.REPH_Rec_Type := P_REPH_Rec;
392: l_rowid ROWID;
393:
743:
744: IS
745: l_api_name CONSTANT VARCHAR2(30) := 'Delete_repair_history';
746: l_api_version_number CONSTANT NUMBER := 1.0;
747: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
748: BEGIN
749: -- Standard Start of API savepoint
750: SAVEPOINT DELETE_REPAIR_HISTORY_PVT;
751:
1310: l_api_name CONSTANT VARCHAR2(30) := 'Get_repair_history';
1311: l_api_version_number CONSTANT NUMBER := 2.0;
1312:
1313: -- Local identity variables
1314: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1315:
1316: -- Local record counters
1317: l_returned_rec_count NUMBER := 0; -- number of records returned in x_X_REPH_Rec
1318: l_next_record_ptr NUMBER := 1;