1: PACKAGE BODY CN_SRP_PAYOUT_DTLS_PKG AS
2: /*$Header: cntmdtlb.pls 115.0 2003/08/25 21:47:57 nkodkani noship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
1: PACKAGE BODY CN_SRP_PAYOUT_DTLS_PKG AS
2: /*$Header: cntmdtlb.pls 115.0 2003/08/25 21:47:57 nkodkani noship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
2: /*$Header: cntmdtlb.pls 115.0 2003/08/25 21:47:57 nkodkani noship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
3:
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)
35: IS
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)
35: IS
36: MN NUMBER := FND_API.G_MISS_NUM;
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)
35: IS
36: MN NUMBER := FND_API.G_MISS_NUM;
37: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)
35: IS
36: MN NUMBER := FND_API.G_MISS_NUM;
37: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
38: MD DATE := FND_API.G_MISS_DATE;
38: MD DATE := FND_API.G_MISS_DATE;
39:
40: BEGIN
41:
42: INSERT INTO cn_srp_payout_dtls(
43: SRP_payout_dtl_ID,
44: srp_role_id,
45: role_model_id,
46: role_id,
72: LAST_UPDATED_BY,
73: object_version_number
74: )
75: SELECT
76: cn_srp_payout_dtls_s.nextval,
77: p_srp_role_id,
78: p_role_model_id,
79: decode(p_role_id,mn,null,p_role_id),
80: decode(p_attain_tier_id,mn,null,p_attain_tier_id),
109: END insert_row;
110:
111:
112: PROCEDURE update_row
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
110:
111:
112: PROCEDURE update_row
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
111:
112: PROCEDURE update_row
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
112: PROCEDURE update_row
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
142:
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
142:
143: CURSOR l_old_csr IS
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
142:
143: CURSOR l_old_csr IS
144: SELECT *
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
142:
143: CURSOR l_old_csr IS
144: SELECT *
145: FROM cn_srp_payout_dtls
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
142:
143: CURSOR l_old_csr IS
144: SELECT *
145: FROM cn_srp_payout_dtls
146: WHERE srp_role_id = p_srp_role_id;
147:
148: l_old_rec l_old_csr%ROWTYPE;
149:
170: fnd_msg_pub.add;
171: raise fnd_api.g_exc_error;
172: END IF;
173:
174: UPDATE cn_srp_payout_dtls SET
175: (percent,
176: payout,
177: quota_category_id,
178: attribute_category,
227: END update_row;
228:
229:
230: PROCEDURE delete_row
231: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE) IS
232: BEGIN
233: DELETE FROM cn_srp_payout_dtls
234: WHERE srp_role_id = p_srp_role_id;
235:
229:
230: PROCEDURE delete_row
231: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE) IS
232: BEGIN
233: DELETE FROM cn_srp_payout_dtls
234: WHERE srp_role_id = p_srp_role_id;
235:
236: END delete_row;
237:
234: WHERE srp_role_id = p_srp_role_id;
235:
236: END delete_row;
237:
238: END CN_SRP_payout_dtlS_pkg;