PACKAGE: APPS.CN_SRP_ROLLOVER_QUOTA_PVT

Source

1 PACKAGE CN_SRP_ROLLOVER_QUOTA_PVT AUTHID CURRENT_USER AS
2   /*$Header: cnvsrs.pls 115.2 2002/12/04 02:37:01 fting noship $*/
3 
4 -- DEFINE PACKAGE_NAME="CN_SRP_ROLLOVER_QUOTA_PVT";
5 -- plan element
6 TYPE srp_rollover_quota_rec_type IS RECORD
7   (
8     SRP_ROLLOVER_QUOTA_ID  NUMBER := FND_API.G_MISS_NUM,
9     SRP_QUOTA_ASSIGN_ID  NUMBER := FND_API.G_MISS_NUM,
10     ROLLOVER_QUOTA_ID  NUMBER := FND_API.G_MISS_NUM,
11     QUOTA_ID            NUMBER := FND_API.G_MISS_NUM,
12     SOURCE_QUOTA_ID      NUMBER := FND_API.G_MISS_NUM,
13     ROLLOVER             cn_srp_rollover_quotas.rollover%TYPE := FND_API.G_MISS_NUM,
14     ATTRIBUTE_CATEGORY        cn_srp_rollover_quotas.attribute_category%TYPE      := cn_api.g_miss_char,
15     ATTRIBUTE1  cn_srp_rollover_quotas.attribute1%TYPE := cn_api.g_miss_char,
16     ATTRIBUTE2  cn_srp_rollover_quotas.attribute2%TYPE := cn_api.g_miss_char,
17     ATTRIBUTE3  cn_srp_rollover_quotas.attribute3%TYPE := cn_api.g_miss_char,
18     ATTRIBUTE4  cn_srp_rollover_quotas.attribute4%TYPE := cn_api.g_miss_char,
19     ATTRIBUTE5  cn_srp_rollover_quotas.attribute5%TYPE := cn_api.g_miss_char,
20     ATTRIBUTE6  cn_srp_rollover_quotas.attribute6%TYPE := cn_api.g_miss_char,
21     ATTRIBUTE7  cn_srp_rollover_quotas.attribute7%TYPE := cn_api.g_miss_char,
22     ATTRIBUTE8  cn_srp_rollover_quotas.attribute8%TYPE := cn_api.g_miss_char,
23     ATTRIBUTE9  cn_srp_rollover_quotas.attribute9%TYPE := cn_api.g_miss_char,
24     ATTRIBUTE10  cn_srp_rollover_quotas.attribute10%TYPE := cn_api.g_miss_char,
25     ATTRIBUTE11  cn_srp_rollover_quotas.attribute11%TYPE := cn_api.g_miss_char,
26     ATTRIBUTE12  cn_srp_rollover_quotas.attribute12%TYPE := cn_api.g_miss_char,
27     ATTRIBUTE13  cn_srp_rollover_quotas.attribute13%TYPE := cn_api.g_miss_char,
28     ATTRIBUTE14  cn_srp_rollover_quotas.attribute14%TYPE := cn_api.g_miss_char,
29     ATTRIBUTE15  cn_srp_rollover_quotas.attribute15%TYPE := cn_api.g_miss_char,
30 
31     OBJECT_VERSION_NUMBER   CN_SRP_ROLLOVER_QUOTAS.OBJECT_VERSION_NUMBER%TYPE := NULL
32     ) ;
33 
34 TYPE srp_rollover_quota_tbl_type IS
35    TABLE OF srp_rollover_quota_rec_type INDEX BY BINARY_INTEGER ;
36 
37 -- Global variable that represent missing values.
38 
39 G_MISS_SRP_ROLL_QUOTA_REC  srp_rollover_quota_rec_type;
40 G_MISS_SRP_ROLL_QUOTA_REC_TB  srp_rollover_quota_tbl_type;
41 
42 
43 -- Start of comments
44 --      API name        : Update_SRP_ROLLOVER_QUOTA
45 --      Type            : Private.
46 --      Function        :
47 --      Pre-reqs        : None.
48 --      Parameters      :
49 -- End of comments
50 
51 PROCEDURE Update_Srp_Rollover_Quota
52   (p_api_version                 IN      NUMBER,
53    p_init_msg_list               IN      VARCHAR2 := FND_API.G_FALSE,
54    p_commit                      IN      VARCHAR2 := FND_API.G_FALSE,
55    p_validation_level            IN      NUMBER  := FND_API.G_VALID_LEVEL_FULL,
56    p_srp_rollover_quota              IN      srp_rollover_quota_rec_type,
57    x_return_status               OUT NOCOPY    VARCHAR2,
58    x_msg_count                   OUT NOCOPY    NUMBER,
59    x_msg_data                    OUT NOCOPY    VARCHAR2 );
60 
61 
62 
63 
64 END CN_SRP_ROLLOVER_QUOTA_PVT;
65