1: PACKAGE BODY CN_SRP_TOTAL_COMPS_pkg AS
2: /*$Header: cntmotcb.pls 115.3 2002/01/28 20:04:57 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
1: PACKAGE BODY CN_SRP_TOTAL_COMPS_pkg AS
2: /*$Header: cntmotcb.pls 115.3 2002/01/28 20:04:57 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
6: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,
2: /*$Header: cntmotcb.pls 115.3 2002/01/28 20:04:57 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
6: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
3:
4: PROCEDURE insert_row
5: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
6: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
11: p_percent IN cn_srp_total_comps.percent%TYPE,
4: PROCEDURE insert_row
5: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
6: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
11: p_percent IN cn_srp_total_comps.percent%TYPE,
12: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
5: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
6: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
11: p_percent IN cn_srp_total_comps.percent%TYPE,
12: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
13: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
6: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
11: p_percent IN cn_srp_total_comps.percent%TYPE,
12: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
13: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
14: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
7: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
11: p_percent IN cn_srp_total_comps.percent%TYPE,
12: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
13: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
14: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
15: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
11: p_percent IN cn_srp_total_comps.percent%TYPE,
12: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
13: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
14: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
15: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
16: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
11: p_percent IN cn_srp_total_comps.percent%TYPE,
12: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
13: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
14: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
15: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
16: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
17: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
11: p_percent IN cn_srp_total_comps.percent%TYPE,
12: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
13: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
14: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
15: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
16: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
17: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
18: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
11: p_percent IN cn_srp_total_comps.percent%TYPE,
12: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
13: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
14: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
15: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
16: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
17: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
18: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
19: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
12: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
13: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
14: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
15: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
16: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
17: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
18: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
19: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
20: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
13: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
14: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
15: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
16: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
17: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
18: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
19: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
20: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
21: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
14: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
15: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
16: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
17: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
18: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
19: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
20: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
21: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
22: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
15: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
16: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
17: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
18: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
19: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
20: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
21: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
22: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
23: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
16: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
17: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
18: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
19: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
20: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
21: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
22: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
23: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
24: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
17: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
18: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
19: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
20: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
21: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
22: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
23: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
24: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
25: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
18: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
19: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
20: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
21: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
22: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
23: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
24: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
25: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
26: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
19: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
20: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
21: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
22: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
23: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
24: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
25: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
26: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
27: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
20: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
21: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
22: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
23: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
24: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
25: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
26: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
27: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
28: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
21: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
22: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
23: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
24: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
25: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
26: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
27: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
28: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
29: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
22: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
23: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
24: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
25: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
26: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
27: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
28: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
29: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
30: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
23: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
24: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
25: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
26: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
27: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
28: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
29: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
30: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
31: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
24: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
25: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
26: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
27: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
28: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
29: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
30: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
31: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
32: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
25: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
26: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
27: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
28: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
29: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
30: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
31: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
32: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
33: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL)
26: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
27: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
28: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
29: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
30: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
31: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
32: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
33: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL)
34: IS
27: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
28: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
29: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
30: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
31: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
32: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
33: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL)
34: IS
35: MN NUMBER := FND_API.G_MISS_NUM;
28: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
29: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
30: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
31: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
32: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
33: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL)
34: IS
35: MN NUMBER := FND_API.G_MISS_NUM;
36: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
29: p_created_by IN cn_srp_total_comps.created_by%TYPE := NULL,
30: p_creation_date IN cn_srp_total_comps.creation_date%TYPE := NULL,
31: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
32: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
33: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE := NULL)
34: IS
35: MN NUMBER := FND_API.G_MISS_NUM;
36: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
37: MD DATE := FND_API.G_MISS_DATE;
36: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
37: MD DATE := FND_API.G_MISS_DATE;
38:
39: BEGIN
40: INSERT INTO cn_srp_total_comps(
41: SRP_TOTAL_COMP_ID,
42: srp_role_id,
43: role_model_id,
44: role_id,
69: LAST_UPDATED_BY,
70: object_version_number
71: )
72: SELECT
73: cn_srp_total_comps_s.nextval,
74: p_srp_role_id,
75: p_role_model_id,
76: decode(p_role_id,mn,null,p_role_id),
77: decode(p_attain_tier_id,mn,null,p_attain_tier_id),
104: END insert_row;
105:
106:
107: PROCEDURE update_row
108: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
109: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
110: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,
105:
106:
107: PROCEDURE update_row
108: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
109: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
110: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,
113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
106:
107: PROCEDURE update_row
108: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
109: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
110: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,
113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
114: p_percent IN cn_srp_total_comps.percent%TYPE,
107: PROCEDURE update_row
108: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
109: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
110: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,
113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
114: p_percent IN cn_srp_total_comps.percent%TYPE,
115: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
108: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
109: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
110: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,
113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
114: p_percent IN cn_srp_total_comps.percent%TYPE,
115: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
116: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
109: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
110: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,
113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
114: p_percent IN cn_srp_total_comps.percent%TYPE,
115: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
116: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
117: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
110: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,
113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
114: p_percent IN cn_srp_total_comps.percent%TYPE,
115: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
116: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
117: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
118: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,
113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
114: p_percent IN cn_srp_total_comps.percent%TYPE,
115: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
116: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
117: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
118: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
119: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,
113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
114: p_percent IN cn_srp_total_comps.percent%TYPE,
115: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
116: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
117: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
118: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
119: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
120: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,
114: p_percent IN cn_srp_total_comps.percent%TYPE,
115: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
116: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
117: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
118: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
119: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
120: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
121: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
114: p_percent IN cn_srp_total_comps.percent%TYPE,
115: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
116: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
117: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
118: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
119: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
120: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
121: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
122: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
115: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,
116: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
117: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
118: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
119: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
120: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
121: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
122: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
123: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
116: p_attribute_category IN cn_srp_total_comps.attribute_category%TYPE := NULL,
117: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
118: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
119: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
120: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
121: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
122: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
123: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
124: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
117: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,
118: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
119: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
120: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
121: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
122: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
123: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
124: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
125: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
118: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,
119: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
120: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
121: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
122: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
123: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
124: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
125: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
126: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
119: p_attribute3 IN cn_srp_total_comps.attribute3%TYPE := NULL,
120: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
121: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
122: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
123: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
124: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
125: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
126: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
127: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
120: p_attribute4 IN cn_srp_total_comps.attribute4%TYPE := NULL,
121: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
122: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
123: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
124: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
125: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
126: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
127: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
128: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
121: p_attribute5 IN cn_srp_total_comps.attribute5%TYPE := NULL,
122: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
123: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
124: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
125: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
126: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
127: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
128: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
129: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
122: p_attribute6 IN cn_srp_total_comps.attribute6%TYPE := NULL,
123: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
124: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
125: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
126: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
127: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
128: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
129: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
130: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
123: p_attribute7 IN cn_srp_total_comps.attribute7%TYPE := NULL,
124: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
125: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
126: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
127: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
128: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
129: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
130: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
131: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
124: p_attribute8 IN cn_srp_total_comps.attribute8%TYPE := NULL,
125: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
126: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
127: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
128: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
129: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
130: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
131: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
132: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
125: p_attribute9 IN cn_srp_total_comps.attribute9%TYPE := NULL,
126: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
127: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
128: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
129: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
130: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
131: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
132: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
133: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
126: p_attribute10 IN cn_srp_total_comps.attribute10%TYPE := NULL,
127: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
128: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
129: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
130: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
131: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
132: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
133: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
134: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
127: p_attribute11 IN cn_srp_total_comps.attribute11%TYPE := NULL,
128: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
129: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
130: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
131: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
132: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
133: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
134: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
135: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE) IS
128: p_attribute12 IN cn_srp_total_comps.attribute12%TYPE := NULL,
129: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
130: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
131: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
132: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
133: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
134: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
135: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE) IS
136:
129: p_attribute13 IN cn_srp_total_comps.attribute13%TYPE := NULL,
130: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
131: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
132: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
133: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
134: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
135: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE) IS
136:
137: CURSOR l_old_csr IS
130: p_attribute14 IN cn_srp_total_comps.attribute14%TYPE := NULL,
131: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
132: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
133: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
134: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
135: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE) IS
136:
137: CURSOR l_old_csr IS
138: SELECT *
131: p_attribute15 IN cn_srp_total_comps.attribute15%TYPE := NULL,
132: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,
133: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,
134: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,
135: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE) IS
136:
137: CURSOR l_old_csr IS
138: SELECT *
139: FROM cn_srp_total_comps
135: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE) IS
136:
137: CURSOR l_old_csr IS
138: SELECT *
139: FROM cn_srp_total_comps
140: WHERE srp_role_id = p_srp_role_id;
141:
142: l_old_rec l_old_csr%ROWTYPE;
143:
164: fnd_msg_pub.add;
165: raise fnd_api.g_exc_error;
166: END IF;
167:
168: UPDATE cn_srp_total_comps SET
169: (percent,
170: total_comp,
171: attribute_category,
172: attribute1,
219: END update_row;
220:
221:
222: PROCEDURE delete_row
223: (p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE) IS
224: BEGIN
225: DELETE FROM cn_srp_total_comps
226: WHERE srp_role_id = p_srp_role_id;
227:
221:
222: PROCEDURE delete_row
223: (p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE) IS
224: BEGIN
225: DELETE FROM cn_srp_total_comps
226: WHERE srp_role_id = p_srp_role_id;
227:
228: END delete_row;
229:
226: WHERE srp_role_id = p_srp_role_id;
227:
228: END delete_row;
229:
230: END CN_SRP_TOTAL_COMPS_pkg;