[Home] [Help]
PACKAGE: APPS.CN_ROLLOVER_QUOTAS_PKG
Source
1 PACKAGE CN_ROLLOVER_QUOTAS_PKG AUTHID CURRENT_USER as
2 /* $Header: cnrqpkgs.pls 115.1 2002/12/04 02:12:46 fting noship $ */
3
4 -- -------------------------------------------------------------------------+
5 -- Procedure Name
6 -- INSERT_ROW
7 -- Purpose
8 --
9 -- History
10 --
11 -- -------------------------------------------------------------------------+
12 PROCEDURE INSERT_ROW
13 (X_ROWID in out NOCOPY VARCHAR2,
14 X_ROLLOVER_QUOTA_ID IN OUT NOCOPY NUMBER,
15 X_QUOTA_ID IN NUMBER,
16 X_SOURCE_QUOTA_ID IN NUMBER,
17 X_ROLLOVER IN NUMBER,
18 X_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
19 X_ATTRIBUTE1 IN VARCHAR2 := NULL,
20 X_ATTRIBUTE2 IN VARCHAR2 := NULL,
21 X_ATTRIBUTE3 IN VARCHAR2 := NULL,
22 X_ATTRIBUTE4 IN VARCHAR2 := NULL,
23 X_ATTRIBUTE5 IN VARCHAR2 := NULL,
24 X_ATTRIBUTE6 IN VARCHAR2 := NULL,
25 X_ATTRIBUTE7 IN VARCHAR2 := NULL,
26 X_ATTRIBUTE8 IN VARCHAR2 := NULL,
27 X_ATTRIBUTE9 IN VARCHAR2 := NULL,
28 X_ATTRIBUTE10 IN VARCHAR2 := NULL,
29 X_ATTRIBUTE11 IN VARCHAR2 := NULL,
30 X_ATTRIBUTE12 IN VARCHAR2 := NULL,
31 X_ATTRIBUTE13 IN VARCHAR2 := NULL,
32 X_ATTRIBUTE14 IN VARCHAR2 := NULL,
33 X_ATTRIBUTE15 IN VARCHAR2 := NULL,
34 X_CREATED_BY IN NUMBER,
35 X_CREATION_DATE IN DATE,
36 X_LAST_UPDATE_DATE IN DATE,
37 X_LAST_UPDATED_BY IN NUMBER,
38 X_LAST_UPDATE_LOGIN IN NUMBER
39 );
40
41
42 -- -------------------------------------------------------------------------+
43 -- Procedure Name
44 -- UPDATE_ROW
45 -- Purpose
46 --
47 -- History
48 --
49 -- -------------------------------------------------------------------------+
50 PROCEDURE UPDATE_ROW
51 (X_ROLLOVER_QUOTA_ID IN NUMBER,
52 X_QUOTA_ID IN NUMBER,
53 X_SOURCE_QUOTA_ID IN NUMBER,
54 X_ROLLOVER IN NUMBER,
55 X_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
56 X_ATTRIBUTE1 IN VARCHAR2 := NULL,
57 X_ATTRIBUTE2 IN VARCHAR2 := NULL,
58 X_ATTRIBUTE3 IN VARCHAR2 := NULL,
59 X_ATTRIBUTE4 IN VARCHAR2 := NULL,
60 X_ATTRIBUTE5 IN VARCHAR2 := NULL,
61 X_ATTRIBUTE6 IN VARCHAR2 := NULL,
62 X_ATTRIBUTE7 IN VARCHAR2 := NULL,
63 X_ATTRIBUTE8 IN VARCHAR2 := NULL,
64 X_ATTRIBUTE9 IN VARCHAR2 := NULL,
65 X_ATTRIBUTE10 IN VARCHAR2 := NULL,
66 X_ATTRIBUTE11 IN VARCHAR2 := NULL,
67 X_ATTRIBUTE12 IN VARCHAR2 := NULL,
68 X_ATTRIBUTE13 IN VARCHAR2 := NULL,
69 X_ATTRIBUTE14 IN VARCHAR2 := NULL,
70 X_ATTRIBUTE15 IN VARCHAR2 := NULL,
71 X_CREATED_BY IN NUMBER,
72 X_CREATION_DATE IN DATE,
73 X_LAST_UPDATE_DATE IN DATE,
74 X_LAST_UPDATED_BY IN NUMBER,
75 X_LAST_UPDATE_LOGIN IN NUMBER
76 );
77
78
79
80 -- -------------------------------------------------------------------------+
81 -- Procedure Name
82 -- DELETE_ROW
83 -- Purpose
84 --
85 -- History
86 --
87 -- -------------------------------------------------------------------------+
88 PROCEDURE DELETE_ROW
89 (X_ROLLOVER_QUOTA_ID IN NUMBER
90
91 );
92
93
94
95 END CN_ROLLOVER_QUOTAS_PKG;