[Home] [Help]
PACKAGE: APPS.CN_ROLLOVER_QUOTA_PVT
Source
1 PACKAGE CN_ROLLOVER_QUOTA_PVT AUTHID CURRENT_USER AS
2 /*$Header: cnvrqs.pls 115.1 2002/12/04 02:23:01 fting noship $*/
3
4 -- plan element
5 TYPE rollover_quota_rec_type IS RECORD
6 (
7 ROLLOVER_QUOTA_ID NUMBER := FND_API.G_MISS_NUM,
8 QUOTA_ID NUMBER := FND_API.G_MISS_NUM,
9 SOURCE_QUOTA_ID NUMBER := FND_API.G_MISS_NUM,
10 ROLLOVER cn_rollover_quotas.rollover%TYPE := FND_API.G_MISS_NUM,
11 ATTRIBUTE_CATEGORY cn_rollover_quotas.attribute_category%TYPE := cn_api.g_miss_char,
12 ATTRIBUTE1 cn_rollover_quotas.attribute1%TYPE := cn_api.g_miss_char,
13 ATTRIBUTE2 cn_rollover_quotas.attribute2%TYPE := cn_api.g_miss_char,
14 ATTRIBUTE3 cn_rollover_quotas.attribute3%TYPE := cn_api.g_miss_char,
15 ATTRIBUTE4 cn_rollover_quotas.attribute4%TYPE := cn_api.g_miss_char,
16 ATTRIBUTE5 cn_rollover_quotas.attribute5%TYPE := cn_api.g_miss_char,
17 ATTRIBUTE6 cn_rollover_quotas.attribute6%TYPE := cn_api.g_miss_char,
18 ATTRIBUTE7 cn_rollover_quotas.attribute7%TYPE := cn_api.g_miss_char,
19 ATTRIBUTE8 cn_rollover_quotas.attribute8%TYPE := cn_api.g_miss_char,
20 ATTRIBUTE9 cn_rollover_quotas.attribute9%TYPE := cn_api.g_miss_char,
21 ATTRIBUTE10 cn_rollover_quotas.attribute10%TYPE := cn_api.g_miss_char,
22 ATTRIBUTE11 cn_rollover_quotas.attribute11%TYPE := cn_api.g_miss_char,
23 ATTRIBUTE12 cn_rollover_quotas.attribute12%TYPE := cn_api.g_miss_char,
24 ATTRIBUTE13 cn_rollover_quotas.attribute13%TYPE := cn_api.g_miss_char,
25 ATTRIBUTE14 cn_rollover_quotas.attribute14%TYPE := cn_api.g_miss_char,
26 ATTRIBUTE15 cn_rollover_quotas.attribute15%TYPE := cn_api.g_miss_char,
27
28 OBJECT_VERSION_NUMBER CN_ROLLOVER_QUOTAS.OBJECT_VERSION_NUMBER%TYPE := NULL
29 ) ;
30
31 TYPE rollover_quota_tbl_type IS
32 TABLE OF rollover_quota_rec_type INDEX BY BINARY_INTEGER ;
33
34 -- Global variable that represent missing values.
35
36 G_MISS_ROLLOVER_QUOTA_REC rollover_quota_rec_type;
37 G_MISS_ROLLOVER_QUOTA_REC_TB rollover_quota_tbl_type;
38
39
40 -- Start of comments
41 -- API name : Create_ROLLOVER_QUOTA
42 -- Type : Private.
43 -- Function :
44 -- Pre-reqs : None.
45 -- Parameters :
46 -- End of comments
47 PROCEDURE Create_Rollover_Quota
48 (p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50 p_commit IN VARCHAR2 := FND_API.G_FALSE,
51 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52 p_rollover_quota IN rollover_quota_rec_type,
53 x_rollover_quota_id OUT NOCOPY NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2);
57
58 -- Start of comments
59 -- API name : Update_ROLLOVER_QUOTA
60 -- Type : Private.
61 -- Function :
62 -- Pre-reqs : None.
63 -- Parameters :
64 -- End of comments
65
66 PROCEDURE Update_ROLLOVER_QUOTA
67 (p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69 p_commit IN VARCHAR2 := FND_API.G_FALSE,
70 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71 p_rollover_quota IN rollover_quota_rec_type,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2 );
75
76 -- Start of comments
77 -- API name : Delete_ROLLOVER_QUOTA
78 -- Type : Private.
79 -- Function :
80 -- Pre-reqs : None.
81 -- Parameters :
82 -- End of comments
83 PROCEDURE Delete_ROLLOVER_QUOTA
84 (p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86 p_commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88 p_rollover_quota IN rollover_quota_rec_type,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2);
92
93
94
95
96 END CN_ROLLOVER_QUOTA_PVT;
97