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_ROLE_MODELS_PKG dependencies on FND_API

Line 5: (P_ROLE_MODEL_ID IN NUMBER := FND_API.G_MISS_NUM,

1: PACKAGE BODY cn_role_models_pkg AS
2: /*$Header: cntrlmlb.pls 115.3 2002/01/28 20:05:31 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (P_ROLE_MODEL_ID IN NUMBER := FND_API.G_MISS_NUM,
6: P_ROLE_ID IN NUMBER,
7: P_NAME IN VARCHAR2,
8: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,

Line 8: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,

4: PROCEDURE insert_row
5: (P_ROLE_MODEL_ID IN NUMBER := FND_API.G_MISS_NUM,
6: P_ROLE_ID IN NUMBER,
7: P_NAME IN VARCHAR2,
8: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
10: P_STATUS IN VARCHAR2,
11: P_ACTIVATE_STATUS IN VARCHAR2,
12: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 9: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,

5: (P_ROLE_MODEL_ID IN NUMBER := FND_API.G_MISS_NUM,
6: P_ROLE_ID IN NUMBER,
7: P_NAME IN VARCHAR2,
8: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
10: P_STATUS IN VARCHAR2,
11: P_ACTIVATE_STATUS IN VARCHAR2,
12: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_OTE IN NUMBER := FND_API.G_MISS_NUM,

Line 12: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,

8: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
10: P_STATUS IN VARCHAR2,
11: P_ACTIVATE_STATUS IN VARCHAR2,
12: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
14: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
15: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
16: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

Line 13: P_OTE IN NUMBER := FND_API.G_MISS_NUM,

9: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
10: P_STATUS IN VARCHAR2,
11: P_ACTIVATE_STATUS IN VARCHAR2,
12: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
14: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
15: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
16: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
17: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,

Line 14: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,

10: P_STATUS IN VARCHAR2,
11: P_ACTIVATE_STATUS IN VARCHAR2,
12: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
14: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
15: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
16: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
17: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
18: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,

Line 15: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,

11: P_ACTIVATE_STATUS IN VARCHAR2,
12: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
14: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
15: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
16: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
17: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
18: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
19: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,

Line 16: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

12: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
14: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
15: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
16: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
17: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
18: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
19: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
20: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 17: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,

13: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
14: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
15: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
16: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
17: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
18: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
19: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
20: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
21: P_START_DATE IN DATE,

Line 18: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,

14: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
15: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
16: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
17: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
18: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
19: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
20: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
21: P_START_DATE IN DATE,
22: P_END_DATE IN DATE := FND_API.G_MISS_DATE,

Line 19: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,

15: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
16: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
17: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
18: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
19: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
20: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
21: P_START_DATE IN DATE,
22: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
23: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 20: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,

16: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
17: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
18: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
19: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
20: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
21: P_START_DATE IN DATE,
22: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
23: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 22: P_END_DATE IN DATE := FND_API.G_MISS_DATE,

18: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
19: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
20: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
21: P_START_DATE IN DATE,
22: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
23: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 23: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

19: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
20: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
21: P_START_DATE IN DATE,
22: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
23: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 24: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,

20: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
21: P_START_DATE IN DATE,
22: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
23: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 25: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

21: P_START_DATE IN DATE,
22: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
23: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 26: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

22: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
23: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 27: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

23: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 28: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

24: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 29: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

25: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 30: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

26: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 31: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

27: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 32: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

28: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 33: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

29: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 34: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

30: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 35: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

31: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 36: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

32: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)

Line 37: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

33: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
41: IS

Line 38: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

34: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
41: IS
42: MN NUMBER := FND_API.G_MISS_NUM;

Line 39: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

35: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
41: IS
42: MN NUMBER := FND_API.G_MISS_NUM;
43: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

Line 40: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)

36: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
41: IS
42: MN NUMBER := FND_API.G_MISS_NUM;
43: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
44: MD DATE := FND_API.G_MISS_DATE;

Line 42: MN NUMBER := FND_API.G_MISS_NUM;

38: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
41: IS
42: MN NUMBER := FND_API.G_MISS_NUM;
43: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
44: MD DATE := FND_API.G_MISS_DATE;
45:
46: BEGIN

Line 43: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

39: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
41: IS
42: MN NUMBER := FND_API.G_MISS_NUM;
43: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
44: MD DATE := FND_API.G_MISS_DATE;
45:
46: BEGIN
47:

Line 44: MD DATE := FND_API.G_MISS_DATE;

40: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
41: IS
42: MN NUMBER := FND_API.G_MISS_NUM;
43: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
44: MD DATE := FND_API.G_MISS_DATE;
45:
46: BEGIN
47:
48: INSERT INTO cn_role_models(

Line 144: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,

140:
141:
142: PROCEDURE Update_Row
143: (P_ROLE_MODEL_ID IN NUMBER,
144: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
145: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
148: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 145: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,

141:
142: PROCEDURE Update_Row
143: (P_ROLE_MODEL_ID IN NUMBER,
144: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
145: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
148: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 146: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,

142: PROCEDURE Update_Row
143: (P_ROLE_MODEL_ID IN NUMBER,
144: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
145: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
148: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 147: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,

143: (P_ROLE_MODEL_ID IN NUMBER,
144: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
145: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
148: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: P_OTE IN NUMBER := FND_API.G_MISS_NUM,

Line 148: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

144: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
145: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
148: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
152: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,

Line 149: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

145: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
148: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
152: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
153: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 150: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,

146: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
148: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
152: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
153: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
154: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

Line 151: P_OTE IN NUMBER := FND_API.G_MISS_NUM,

147: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
148: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
152: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
153: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
154: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
155: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,

Line 152: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,

148: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
152: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
153: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
154: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
155: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
156: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,

Line 153: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,

149: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
152: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
153: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
154: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
155: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
156: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
157: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,

Line 154: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

150: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
152: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
153: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
154: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
155: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
156: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
157: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
158: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 155: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,

151: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
152: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
153: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
154: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
155: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
156: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
157: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
158: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
159: P_START_DATE IN DATE := FND_API.G_MISS_DATE,

Line 156: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,

152: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
153: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
154: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
155: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
156: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
157: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
158: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
159: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
160: P_END_DATE IN DATE := FND_API.G_MISS_DATE,

Line 157: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,

153: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
154: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
155: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
156: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
157: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
158: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
159: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
160: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
161: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 158: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,

154: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
155: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
156: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
157: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
158: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
159: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
160: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
161: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 159: P_START_DATE IN DATE := FND_API.G_MISS_DATE,

155: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
156: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
157: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
158: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
159: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
160: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
161: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
163: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 160: P_END_DATE IN DATE := FND_API.G_MISS_DATE,

156: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
157: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
158: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
159: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
160: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
161: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
163: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 161: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

157: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
158: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
159: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
160: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
161: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
163: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 162: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,

158: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
159: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
160: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
161: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
163: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 163: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

159: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
160: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
161: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
163: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 164: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

160: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
161: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
163: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 165: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

161: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
163: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 166: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

162: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
163: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 167: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

163: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 168: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

164: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 169: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

165: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 170: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

166: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 171: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

167: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 172: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

168: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 173: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

169: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 174: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

170: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 175: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

171: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )

Line 176: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

172: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )
180: IS

Line 177: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

173: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )
180: IS
181:

Line 178: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

174: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )
180: IS
181:
182: CURSOR l_old_csr IS

Line 179: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )

175: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )
180: IS
181:
182: CURSOR l_old_csr IS
183: SELECT *

Line 189: MN NUMBER := FND_API.G_MISS_NUM;

185: WHERE role_model_id = p_role_model_id;
186:
187: l_old_rec l_old_csr%ROWTYPE;
188:
189: MN NUMBER := FND_API.G_MISS_NUM;
190: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
191: MD DATE := FND_API.G_MISS_DATE;
192:
193: l_object_version_number NUMBER;

Line 190: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

186:
187: l_old_rec l_old_csr%ROWTYPE;
188:
189: MN NUMBER := FND_API.G_MISS_NUM;
190: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
191: MD DATE := FND_API.G_MISS_DATE;
192:
193: l_object_version_number NUMBER;
194:

Line 191: MD DATE := FND_API.G_MISS_DATE;

187: l_old_rec l_old_csr%ROWTYPE;
188:
189: MN NUMBER := FND_API.G_MISS_NUM;
190: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
191: MD DATE := FND_API.G_MISS_DATE;
192:
193: l_object_version_number NUMBER;
194:
195: BEGIN

Line 210: raise fnd_api.g_exc_error;

206: -- check object version number
207: IF l_object_version_number <> l_old_rec.object_version_number THEN
208: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
209: fnd_msg_pub.add;
210: raise fnd_api.g_exc_error;
211: END IF;
212:
213: UPDATE cn_role_models SET
214: (role_id,