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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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: -------------------------------------------------------------------------------+
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 --+
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;--+