1: PACKAGE CN_SRP_TOTAL_COMPS_pkg AUTHID CURRENT_USER AS
2: -- $Header: cntmotcs.pls 115.3 2002/01/28 20:04:58 pkm ship $
3: -- +======================================================================|
4: -- | Copyright (c) 2000 Oracle Corporation |
5: -- | Redwood Shores, California, USA |
6: -- | All rights reserved. |
7: -- | Package Name |
8: -- | CN_SRP_TOT_COMPS_pkg |
9: -- | Purpose |
10: -- | This is the table handler for cn_srp_total_comps 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_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
19: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_total_comps.role_id%TYPE,
15: -- | 06-JUN-2001 sbadami Created |
16: -- +======================================================================|
17: PROCEDURE insert_row
18: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
19: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_total_comps.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
16: -- +======================================================================|
17: PROCEDURE insert_row
18: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
19: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_total_comps.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
24: p_percent IN cn_srp_total_comps.percent%TYPE,
17: PROCEDURE insert_row
18: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
19: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_total_comps.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
24: p_percent IN cn_srp_total_comps.percent%TYPE,
25: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
18: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
19: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_total_comps.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
24: p_percent IN cn_srp_total_comps.percent%TYPE,
25: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
26: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
19: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_total_comps.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
24: p_percent IN cn_srp_total_comps.percent%TYPE,
25: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
26: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
27: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
20: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_total_comps.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
24: p_percent IN cn_srp_total_comps.percent%TYPE,
25: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
26: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
27: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
28: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_total_comps.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
24: p_percent IN cn_srp_total_comps.percent%TYPE,
25: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
26: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
27: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
28: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
29: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
22: p_role_id IN cn_srp_total_comps.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
24: p_percent IN cn_srp_total_comps.percent%TYPE,
25: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
26: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
27: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
28: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
29: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
30: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
23: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
24: p_percent IN cn_srp_total_comps.percent%TYPE,
25: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
26: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
27: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
28: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
29: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
30: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
31: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
24: p_percent IN cn_srp_total_comps.percent%TYPE,
25: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
26: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
27: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
28: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
29: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
30: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
31: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
32: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
25: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
26: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
27: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
28: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
29: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
30: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
31: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
32: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
33: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
26: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
27: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
28: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
29: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
30: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
31: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
32: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
33: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
34: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
27: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
28: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
29: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
30: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
31: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
32: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
33: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
34: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
35: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
28: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
29: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
30: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
31: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
32: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
33: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
34: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
35: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
36: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
29: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
30: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
31: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
32: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
33: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
34: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
35: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
36: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
37: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
30: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
31: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
32: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
33: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
34: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
35: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
36: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
37: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
38: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
31: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
32: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
33: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
34: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
35: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
36: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
37: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
38: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
39: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
32: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
33: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
34: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
35: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
36: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
37: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
38: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
39: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
40: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
33: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
34: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
35: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
36: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
37: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
38: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
39: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
40: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
41: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
34: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
35: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
36: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
37: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
38: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
39: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
40: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
41: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
42: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
35: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
36: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
37: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
38: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
39: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
40: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
41: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
42: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
43: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
36: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
37: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
38: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
39: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
40: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
41: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
42: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
43: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
44: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
37: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
38: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
39: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
40: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
41: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
42: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
43: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
44: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
45: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
38: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
39: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
40: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
41: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
42: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
43: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
44: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
45: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
46: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL);
39: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
40: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
41: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
42: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
43: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
44: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
45: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
46: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL);
47:
40: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
41: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
42: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
43: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
44: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
45: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
46: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL);
47:
48: PROCEDURE update_row
41: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
42: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
43: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
44: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
45: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
46: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL);
47:
48: PROCEDURE update_row
49: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
42: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
43: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
44: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
45: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
46: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL);
47:
48: PROCEDURE update_row
49: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
50: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
45: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
46: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL);
47:
48: PROCEDURE update_row
49: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
50: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
51: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
52: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
53: p_role_id IN cn_srp_total_comps.role_id%TYPE,
46: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL);
47:
48: PROCEDURE update_row
49: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
50: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
51: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
52: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
53: p_role_id IN cn_srp_total_comps.role_id%TYPE,
54: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
47:
48: PROCEDURE update_row
49: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
50: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
51: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
52: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
53: p_role_id IN cn_srp_total_comps.role_id%TYPE,
54: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
55: p_percent IN cn_srp_total_comps.percent%TYPE,
48: PROCEDURE update_row
49: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
50: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
51: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
52: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
53: p_role_id IN cn_srp_total_comps.role_id%TYPE,
54: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
55: p_percent IN cn_srp_total_comps.percent%TYPE,
56: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
49: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
50: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
51: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
52: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
53: p_role_id IN cn_srp_total_comps.role_id%TYPE,
54: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
55: p_percent IN cn_srp_total_comps.percent%TYPE,
56: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
57: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
50: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
51: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
52: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
53: p_role_id IN cn_srp_total_comps.role_id%TYPE,
54: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
55: p_percent IN cn_srp_total_comps.percent%TYPE,
56: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
57: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
58: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
51: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
52: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
53: p_role_id IN cn_srp_total_comps.role_id%TYPE,
54: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
55: p_percent IN cn_srp_total_comps.percent%TYPE,
56: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
57: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
58: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
59: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
52: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
53: p_role_id IN cn_srp_total_comps.role_id%TYPE,
54: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
55: p_percent IN cn_srp_total_comps.percent%TYPE,
56: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
57: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
58: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
59: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
60: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
53: p_role_id IN cn_srp_total_comps.role_id%TYPE,
54: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
55: p_percent IN cn_srp_total_comps.percent%TYPE,
56: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
57: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
58: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
59: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
60: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
61: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
54: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
55: p_percent IN cn_srp_total_comps.percent%TYPE,
56: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
57: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
58: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
59: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
60: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
61: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
62: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
55: p_percent IN cn_srp_total_comps.percent%TYPE,
56: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
57: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
58: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
59: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
60: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
61: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
62: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
63: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
56: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
57: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
58: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
59: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
60: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
61: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
62: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
63: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
64: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
57: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
58: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
59: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
60: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
61: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
62: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
63: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
64: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
65: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
58: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
59: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
60: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
61: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
62: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
63: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
64: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
65: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
66: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
59: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
60: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
61: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
62: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
63: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
64: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
65: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
66: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
67: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
60: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
61: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
62: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
63: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
64: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
65: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
66: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
67: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
68: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
61: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
62: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
63: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
64: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
65: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
66: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
67: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
68: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
69: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
62: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
63: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
64: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
65: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
66: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
67: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
68: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
69: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
70: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
63: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
64: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
65: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
66: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
67: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
68: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
69: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
70: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
71: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
64: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
65: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
66: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
67: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
68: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
69: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
70: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
71: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
72: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
65: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
66: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
67: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
68: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
69: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
70: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
71: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
72: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
73: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
66: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
67: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
68: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
69: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
70: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
71: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
72: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
73: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
74: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
67: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
68: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
69: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
70: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
71: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
72: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
73: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
74: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
75: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
68: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
69: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
70: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
71: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
72: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
73: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
74: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
75: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
76: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE);
69: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
70: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
71: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
72: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
73: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
74: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
75: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
76: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE);
77:
70: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
71: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
72: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
73: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
74: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
75: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
76: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE);
77:
78: PROCEDURE delete_row
71: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
72: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
73: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
74: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
75: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
76: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE);
77:
78: PROCEDURE delete_row
79: (p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE);
72: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
73: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
74: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
75: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
76: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE);
77:
78: PROCEDURE delete_row
79: (p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE);
80:
75: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
76: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE);
77:
78: PROCEDURE delete_row
79: (p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE);
80:
81: END CN_SRP_TOTAL_COMPS_pkg;
77:
78: PROCEDURE delete_row
79: (p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE);
80:
81: END CN_SRP_TOTAL_COMPS_pkg;