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