eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_TOTAL_COMPS_PKG dependencies on CN_SRP_TOTAL_COMPS

Line 1: PACKAGE BODY CN_SRP_TOTAL_COMPS_pkg AS

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,

Line 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,

Line 6: p_srp_role_id IN cn_srp_total_comps.srp_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,

Line 7: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,

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,

Line 8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%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,

Line 9: p_role_id IN cn_srp_total_comps.role_id%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,

Line 10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_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,
14: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,

Line 11: p_percent IN cn_srp_total_comps.percent%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,
15: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,

Line 12: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,

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,

Line 13: p_attribute_category IN cn_srp_total_comps.attribute_category%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,

Line 14: p_attribute1 IN cn_srp_total_comps.attribute1%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,

Line 15: p_attribute2 IN cn_srp_total_comps.attribute2%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,

Line 16: p_attribute3 IN cn_srp_total_comps.attribute3%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,

Line 17: p_attribute4 IN cn_srp_total_comps.attribute4%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,

Line 18: p_attribute5 IN cn_srp_total_comps.attribute5%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,

Line 19: p_attribute6 IN cn_srp_total_comps.attribute6%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,

Line 20: p_attribute7 IN cn_srp_total_comps.attribute7%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,

Line 21: p_attribute8 IN cn_srp_total_comps.attribute8%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,

Line 22: p_attribute9 IN cn_srp_total_comps.attribute9%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,

Line 23: p_attribute10 IN cn_srp_total_comps.attribute10%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,

Line 24: p_attribute11 IN cn_srp_total_comps.attribute11%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,

Line 25: p_attribute12 IN cn_srp_total_comps.attribute12%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,

Line 26: p_attribute13 IN cn_srp_total_comps.attribute13%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,

Line 27: p_attribute14 IN cn_srp_total_comps.attribute14%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,

Line 28: p_attribute15 IN cn_srp_total_comps.attribute15%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,

Line 29: p_created_by IN cn_srp_total_comps.created_by%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)

Line 30: p_creation_date IN cn_srp_total_comps.creation_date%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

Line 31: p_last_update_login IN cn_srp_total_comps.last_update_login%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
35: MN NUMBER := FND_API.G_MISS_NUM;

Line 32: p_last_update_date IN cn_srp_total_comps.last_update_date%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;
36: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

Line 33: p_last_updated_by IN cn_srp_total_comps.last_updated_by%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;
37: MD DATE := FND_API.G_MISS_DATE;

Line 40: INSERT INTO cn_srp_total_comps(

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,

Line 73: cn_srp_total_comps_s.nextval,

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),

Line 108: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,

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,

Line 109: p_srp_role_id IN cn_srp_total_comps.srp_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,

Line 110: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,

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,

Line 111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%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,

Line 112: p_role_id IN cn_srp_total_comps.role_id%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,

Line 113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_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,
117: p_attribute1 IN cn_srp_total_comps.attribute1%TYPE := NULL,

Line 114: p_percent IN cn_srp_total_comps.percent%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,
118: p_attribute2 IN cn_srp_total_comps.attribute2%TYPE := NULL,

Line 115: p_total_comp IN cn_srp_total_comps.total_comp%TYPE,

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,

Line 116: p_attribute_category IN cn_srp_total_comps.attribute_category%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,

Line 117: p_attribute1 IN cn_srp_total_comps.attribute1%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,

Line 118: p_attribute2 IN cn_srp_total_comps.attribute2%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,

Line 119: p_attribute3 IN cn_srp_total_comps.attribute3%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,

Line 120: p_attribute4 IN cn_srp_total_comps.attribute4%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,

Line 121: p_attribute5 IN cn_srp_total_comps.attribute5%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,

Line 122: p_attribute6 IN cn_srp_total_comps.attribute6%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,

Line 123: p_attribute7 IN cn_srp_total_comps.attribute7%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,

Line 124: p_attribute8 IN cn_srp_total_comps.attribute8%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,

Line 125: p_attribute9 IN cn_srp_total_comps.attribute9%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,

Line 126: p_attribute10 IN cn_srp_total_comps.attribute10%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,

Line 127: p_attribute11 IN cn_srp_total_comps.attribute11%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,

Line 128: p_attribute12 IN cn_srp_total_comps.attribute12%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,

Line 129: p_attribute13 IN cn_srp_total_comps.attribute13%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,
133: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,

Line 130: p_attribute14 IN cn_srp_total_comps.attribute14%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,
134: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,

Line 131: p_attribute15 IN cn_srp_total_comps.attribute15%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,
135: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE) IS

Line 132: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE,

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:

Line 133: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE,

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

Line 134: p_last_updated_by IN cn_srp_total_comps.last_updated_by%TYPE,

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 *

Line 135: p_object_version_number IN cn_srp_total_comps.object_version_number%TYPE) IS

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

Line 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:

Line 168: UPDATE cn_srp_total_comps SET

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,

Line 223: (p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE) IS

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:

Line 225: DELETE FROM cn_srp_total_comps

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:

Line 230: END CN_SRP_TOTAL_COMPS_pkg;

226: WHERE srp_role_id = p_srp_role_id;
227:
228: END delete_row;
229:
230: END CN_SRP_TOTAL_COMPS_pkg;