PACKAGE: APPS.CSD_SERVICE_CODES_PKG

Source

1 package CSD_SERVICE_CODES_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtcscs.pls 115.2 2003/11/05 00:00:43 gilam noship $ */
3 
4 procedure INSERT_ROW (
5   PX_ROWID in out nocopy VARCHAR2,
6   PX_SERVICE_CODE_ID in out nocopy NUMBER,
7   P_OBJECT_VERSION_NUMBER in NUMBER,
8   P_CREATED_BY in NUMBER,
9   P_CREATION_DATE in DATE,
10   P_LAST_UPDATED_BY in NUMBER,
11   P_LAST_UPDATE_DATE in DATE,
12   P_LAST_UPDATE_LOGIN in NUMBER,
13   P_SERVICE_CODE in VARCHAR2,
14   P_NAME in VARCHAR2,
15   P_DESCRIPTION in VARCHAR2,
16   P_ACTIVE_FROM in DATE,
17   P_ACTIVE_TO in DATE,
18   P_ATTRIBUTE_CATEGORY in VARCHAR2,
19   P_ATTRIBUTE1 in VARCHAR2,
20   P_ATTRIBUTE2 in VARCHAR2,
21   P_ATTRIBUTE3 in VARCHAR2,
22   P_ATTRIBUTE4 in VARCHAR2,
23   P_ATTRIBUTE5 in VARCHAR2,
24   P_ATTRIBUTE6 in VARCHAR2,
25   P_ATTRIBUTE7 in VARCHAR2,
26   P_ATTRIBUTE8 in VARCHAR2,
27   P_ATTRIBUTE9 in VARCHAR2,
28   P_ATTRIBUTE10 in VARCHAR2,
29   P_ATTRIBUTE11 in VARCHAR2,
30   P_ATTRIBUTE12 in VARCHAR2,
31   P_ATTRIBUTE13 in VARCHAR2,
32   P_ATTRIBUTE14 in VARCHAR2,
33   P_ATTRIBUTE15 in VARCHAR2
34 );
35 
36 procedure LOCK_ROW (
37   PX_ROWID in out nocopy VARCHAR2,
38   P_SERVICE_CODE_ID in NUMBER,
39   P_OBJECT_VERSION_NUMBER in NUMBER
40 
41   --commented out the rest of the record
42   /*,
43   P_SERVICE_CODE in VARCHAR2,
44   P_NAME in VARCHAR2,
45   P_DESCRIPTION in VARCHAR2,
46   P_ACTIVE_FROM in DATE,
47   P_ACTIVE_TO in DATE,
48   P_ATTRIBUTE_CATEGORY in VARCHAR2,
49   P_ATTRIBUTE1 in VARCHAR2,
50   P_ATTRIBUTE2 in VARCHAR2,
51   P_ATTRIBUTE3 in VARCHAR2,
52   P_ATTRIBUTE4 in VARCHAR2,
53   P_ATTRIBUTE5 in VARCHAR2,
54   P_ATTRIBUTE6 in VARCHAR2,
55   P_ATTRIBUTE7 in VARCHAR2,
56   P_ATTRIBUTE8 in VARCHAR2,
57   P_ATTRIBUTE9 in VARCHAR2,
58   P_ATTRIBUTE10 in VARCHAR2,
59   P_ATTRIBUTE11 in VARCHAR2,
60   P_ATTRIBUTE12 in VARCHAR2,
61   P_ATTRIBUTE13 in VARCHAR2,
62   P_ATTRIBUTE14 in VARCHAR2,
63   P_ATTRIBUTE15 in VARCHAR2
64   */
65   --
66 );
67 
68 procedure UPDATE_ROW (
69   P_SERVICE_CODE_ID in NUMBER,
70   P_OBJECT_VERSION_NUMBER in NUMBER,
71   P_CREATED_BY in NUMBER,
72   P_CREATION_DATE in DATE,
73   P_LAST_UPDATED_BY in NUMBER,
74   P_LAST_UPDATE_DATE in DATE,
75   P_LAST_UPDATE_LOGIN in NUMBER,
76   P_SERVICE_CODE in VARCHAR2,
77   P_NAME in VARCHAR2,
78   P_DESCRIPTION in VARCHAR2,
79   P_ACTIVE_FROM in DATE,
80   P_ACTIVE_TO in DATE,
81   P_ATTRIBUTE_CATEGORY in VARCHAR2,
82   P_ATTRIBUTE1 in VARCHAR2,
83   P_ATTRIBUTE2 in VARCHAR2,
84   P_ATTRIBUTE3 in VARCHAR2,
85   P_ATTRIBUTE4 in VARCHAR2,
86   P_ATTRIBUTE5 in VARCHAR2,
87   P_ATTRIBUTE6 in VARCHAR2,
88   P_ATTRIBUTE7 in VARCHAR2,
89   P_ATTRIBUTE8 in VARCHAR2,
90   P_ATTRIBUTE9 in VARCHAR2,
91   P_ATTRIBUTE10 in VARCHAR2,
92   P_ATTRIBUTE11 in VARCHAR2,
93   P_ATTRIBUTE12 in VARCHAR2,
94   P_ATTRIBUTE13 in VARCHAR2,
95   P_ATTRIBUTE14 in VARCHAR2,
96   P_ATTRIBUTE15 in VARCHAR2
97 );
98 
99 procedure DELETE_ROW (
100   P_SERVICE_CODE_ID in NUMBER
101 );
102 procedure ADD_LANGUAGE;
103 end CSD_SERVICE_CODES_PKG;