APPS.CS_SERVICE_AVAILABILITY_PKG dependencies on CS_SERVICE_AVAILABILITY

Line 1: PACKAGE BODY CS_SERVICE_AVAILABILITY_PKG as

1: PACKAGE BODY CS_SERVICE_AVAILABILITY_PKG as
2: /* $Header: csxsisab.pls 115.0 99/07/16 09:08:56 porting ship $ */
3:
4:
5: PROCEDURE Lock_Row(X_Rowid VARCHAR2,

Line 39: FROM cs_service_availability

35: X_Service_Available_Flag VARCHAR2 DEFAULT NULL
36: ) IS
37: CURSOR C IS
38: SELECT *
39: FROM cs_service_availability
40: WHERE rowid = X_Rowid
41: FOR UPDATE NOWAIT;
42: Recinfo C%ROWTYPE;
43: BEGIN

Line 188: UPDATE cs_service_availability

184: X_Context VARCHAR2 DEFAULT NULL,
185: X_Service_Available_Flag VARCHAR2 DEFAULT NULL
186: ) IS
187: BEGIN
188: UPDATE cs_service_availability
189: SET
190: service_inventory_item_id = X_Service_Inventory_Item_Id,
191: service_manufacturing_org_id = X_Service_Manufacturing_Org_Id,
192: last_update_date = X_Last_Update_Date,

Line 231: DELETE FROM cs_service_availability

227: END Update_Row;
228:
229: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
230: BEGIN
231: DELETE FROM cs_service_availability
232: WHERE rowid = X_Rowid;
233: if (SQL%NOTFOUND) then
234: Raise NO_DATA_FOUND;
235: end if;

Line 275: INSERT INTO cs_service_availability

271: X_Context VARCHAR2 DEFAULT NULL,
272: X_Service_Available_Flag VARCHAR2 DEFAULT NULL
273: ) IS
274: BEGIN
275: INSERT INTO cs_service_availability
276: ( Service_Availability_id,
277: Service_Inventory_Item_Id,
278: Service_Manufacturing_Org_Id,
279: Last_Update_Date,

Line 356: FROM CS_SERVICE_AVAILABILITY

352: END IF;
353:
354: SELECT rowid
355: INTO X_rowid
356: FROM CS_SERVICE_AVAILABILITY
357: WHERE service_availability_id = X_service_availability_id;
358:
359: END Insert_Row;
360:

Line 361: END CS_SERVICE_AVAILABILITY_PKG;

357: WHERE service_availability_id = X_service_availability_id;
358:
359: END Insert_Row;
360:
361: END CS_SERVICE_AVAILABILITY_PKG;