68: -- 06-JUN-2000 mblum Created --+
69: -------------------------------------------------------------------------------+
70: PROCEDURE update_row
71: (SRP_QUOTA_RATE_ID IN NUMBER,
72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
69: -------------------------------------------------------------------------------+
70: PROCEDURE update_row
71: (SRP_QUOTA_RATE_ID IN NUMBER,
72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
70: PROCEDURE update_row
71: (SRP_QUOTA_RATE_ID IN NUMBER,
72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: (SRP_QUOTA_RATE_ID IN NUMBER,
72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: SRP_QUOTA_CATE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: ROLE_QUOTA_RATE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: QUOTA_CATEGORY_ID IN NUMBER := FND_API.G_MISS_NUM,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: RATE_TIER_ID IN NUMBER := FND_API.G_MISS_NUM,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: COMM_RATE IN NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS
86: ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS
94:
87: ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS
94:
95: l_srp_quota_rate_id number := srp_quota_rate_id;
88: ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS
94:
95: l_srp_quota_rate_id number := srp_quota_rate_id;
96: l_srp_quota_cate_id number;
89: ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR) IS
94:
95: l_srp_quota_rate_id number := srp_quota_rate_id;
96: l_srp_quota_cate_id number;
97: l_role_quota_rate_id number;
125: attribute13, attribute14, attribute15, object_version_number
126: FROM cn_srp_quota_rates r
127: WHERE r.srp_quota_rate_id = l_srp_quota_rate_id;
128:
129: MN NUMBER := FND_API.G_MISS_NUM;
130: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
131:
132: BEGIN
133: OPEN l_update_csr;
126: FROM cn_srp_quota_rates r
127: WHERE r.srp_quota_rate_id = l_srp_quota_rate_id;
128:
129: MN NUMBER := FND_API.G_MISS_NUM;
130: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
131:
132: BEGIN
133: OPEN l_update_csr;
134: FETCH l_update_csr INTO l_srp_quota_cate_id, l_quota_category_id,