1: PACKAGE CN_SRP_PAYOUT_DTLS_PKG AUTHID CURRENT_USER AS
2: -- $Header: cntmdtls.pls 115.0 2003/08/25 21:52:01 nkodkani noship $
3: -- +======================================================================|
4: -- | Copyright (c) 2000 Oracle Corporation |
5: -- | Redwood Shores, California, USA |
4: -- | Copyright (c) 2000 Oracle Corporation |
5: -- | Redwood Shores, California, USA |
6: -- | All rights reserved. |
7: -- | Package Name |
8: -- | CN_SRP_PAYOUT_DTLS_pkg |
9: -- | Purpose |
10: -- | This is the table handler for cn_srp_payout_dtls table; it takes |
11: -- | care of the insert, update and delete on the table. Refer high level|
12: -- | design documentation for the business perspective. |
6: -- | All rights reserved. |
7: -- | Package Name |
8: -- | CN_SRP_PAYOUT_DTLS_pkg |
9: -- | Purpose |
10: -- | This is the table handler for cn_srp_payout_dtls table; it takes |
11: -- | care of the insert, update and delete on the table. Refer high level|
12: -- | design documentation for the business perspective. |
13: -- | |
14: -- |History |
14: -- |History |
15: -- | 06-JUN-2001 sbadami Created |
16: -- +======================================================================|
17: PROCEDURE insert_row
18: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
15: -- | 06-JUN-2001 sbadami Created |
16: -- +======================================================================|
17: PROCEDURE insert_row
18: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
16: -- +======================================================================|
17: PROCEDURE insert_row
18: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
17: PROCEDURE insert_row
18: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
18: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
49: PROCEDURE update_row
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
48:
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79:
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79:
80: PROCEDURE delete_row
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79:
80: PROCEDURE delete_row
81: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE);
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79:
80: PROCEDURE delete_row
81: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE);
82:
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79:
80: PROCEDURE delete_row
81: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE);
82:
83: END CN_SRP_payout_dtlS_pkg;
79:
80: PROCEDURE delete_row
81: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE);
82:
83: END CN_SRP_payout_dtlS_pkg;