DBA Data[Home] [Help]

APPS.CS_CP_SERVICES_PKG dependencies on CS_CP_SERVICES

Line 1: PACKAGE BODY CS_CP_SERVICES_PKG as

1: PACKAGE BODY CS_CP_SERVICES_PKG as
2: /* $Header: csxsicsb.pls 115.1 99/07/16 09:08:48 porting s $ */
3:
4: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
5: X_Cp_Service_Id NUMBER,

Line 75: FROM cs_cp_services

71:
72: ) IS
73: CURSOR C IS
74: SELECT *
75: FROM cs_cp_services
76: WHERE rowid = X_Rowid
77: FOR UPDATE of Cp_Service_Id NOWAIT;
78: Recinfo C%ROWTYPE;
79: BEGIN

Line 377: UPDATE cs_cp_services

373: X_Original_Service_Line_Id NUMBER
374:
375: ) IS
376: BEGIN
377: UPDATE cs_cp_services
378: SET
379: cp_service_id = X_Cp_Service_Id,
380: last_update_date = X_Last_Update_Date,
381: last_updated_by = X_Last_Updated_By,

Line 457: END CS_CP_SERVICES_PKG;

453:
454: END Update_Row;
455:
456:
457: END CS_CP_SERVICES_PKG;