[Home] [Help]
PACKAGE: APPS.CN_SRP_QUOTA_RATES_PKG
Source
1 PACKAGE cn_srp_quota_rates_pkg AUTHID CURRENT_USER AS
2 /*$Header: cntsrqrs.pls 115.2 2002/01/28 20:06:14 pkm ship $*/
3
4 -------------------------------------------------------------------------------+
5 -- Procedure Name : Insert_Row --+
6 -- Purpose : Insert given fields into the cn_srp_quota_rates table; --+
7 -- also do a cascade insert into cn_srp_quota_rates if --+
8 -- required --+
9 -- History --+
10 -- 06-JUN-2000 mblum Created --+
11 -------------------------------------------------------------------------------+
12 PROCEDURE insert_row
13 (SRP_QUOTA_CATE_ID IN NUMBER,
14 ROLE_QUOTA_RATE_ID IN NUMBER,
15 SRP_ID IN NUMBER,
16 QUOTA_CATEGORY_ID IN NUMBER,
17 RATE_TIER_ID IN NUMBER,
18 COMM_RATE IN NUMBER,
19 ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
20 ATTRIBUTE1 IN VARCHAR2 := NULL,
21 ATTRIBUTE2 IN VARCHAR2 := NULL,
22 ATTRIBUTE3 IN VARCHAR2 := NULL,
23 ATTRIBUTE4 IN VARCHAR2 := NULL,
24 ATTRIBUTE5 IN VARCHAR2 := NULL,
25 ATTRIBUTE6 IN VARCHAR2 := NULL,
26 ATTRIBUTE7 IN VARCHAR2 := NULL,
27 ATTRIBUTE8 IN VARCHAR2 := NULL,
28 ATTRIBUTE9 IN VARCHAR2 := NULL,
29 ATTRIBUTE10 IN VARCHAR2 := NULL,
30 ATTRIBUTE11 IN VARCHAR2 := NULL,
31 ATTRIBUTE12 IN VARCHAR2 := NULL,
32 ATTRIBUTE13 IN VARCHAR2 := NULL,
33 ATTRIBUTE14 IN VARCHAR2 := NULL,
34 ATTRIBUTE15 IN VARCHAR2 := NULL);
35
36 -------------------------------------------------------------------------------+
37 -- Procedure Name : Update_Row --+
38 -- Purpose : Update given fields in the cn_srp_quota_rates table; --+
39 -- also do a cascade update into cn_srp_quota_rates if --+
40 -- required --+
41 -- History --+
42 -- 06-JUN-2000 mblum Created --+
43 -------------------------------------------------------------------------------+
44 PROCEDURE update_row
45 (SRP_QUOTA_RATE_ID IN NUMBER,
46 SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
47 ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
48 SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
49 QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
50 RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
51 COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
52 ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54 ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55 ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56 ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58 ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59 ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60 ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61 ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62 ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63 ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64 ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65 ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66 ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67 ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR);
68
69 -------------------------------------------------------------------------------+
70 -- Procedure Name : Delete_Row --+
71 -- Purpose : Delete the specified row in the cn_srp_quota_rates table;--+
72 -- also cascade delete in cn_srp_quota_rates if required --+
73 -- History --+
74 -- 06-JUN-2000 mblum Created --+
75 -------------------------------------------------------------------------------+
76 PROCEDURE delete_row
77 (SRP_QUOTA_RATE_ID IN NUMBER);
78
79 END cn_srp_quota_rates_pkg;