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 cn_role_models_pkg AUTHID CURRENT_USER AS
2: /*$Header: cntrlmls.pls 115.2 2002/01/28 20:05:33 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:

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:
42: PROCEDURE update_row

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:
42: PROCEDURE update_row
43: (P_ROLE_MODEL_ID IN NUMBER,

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:
42: PROCEDURE update_row
43: (P_ROLE_MODEL_ID IN NUMBER,
44: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,

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

40: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR);
41:
42: PROCEDURE update_row
43: (P_ROLE_MODEL_ID IN NUMBER,
44: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
45: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
48: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

41:
42: PROCEDURE update_row
43: (P_ROLE_MODEL_ID IN NUMBER,
44: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
45: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
48: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

42: PROCEDURE update_row
43: (P_ROLE_MODEL_ID IN NUMBER,
44: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
45: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
48: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

43: (P_ROLE_MODEL_ID IN NUMBER,
44: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
45: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
48: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: P_OTE IN NUMBER := FND_API.G_MISS_NUM,

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

44: P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
45: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
48: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
52: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,

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

45: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
48: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
52: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
53: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,

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

46: P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
48: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
52: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
53: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

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

47: P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
48: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
52: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
53: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
55: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,

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

48: P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
52: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
53: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
55: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
56: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,

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

49: P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
52: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
53: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
55: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
56: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
57: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,

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

50: P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
52: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
53: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
55: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
56: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
57: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
58: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,

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

51: P_OTE IN NUMBER := FND_API.G_MISS_NUM,
52: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
53: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
55: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
56: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
57: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
58: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
59: P_START_DATE IN DATE := FND_API.G_MISS_DATE,

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

52: P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
53: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
55: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
56: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
57: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
58: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
59: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
60: P_END_DATE IN DATE := FND_API.G_MISS_DATE,

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

53: P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
55: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
56: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
57: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
58: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
59: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
60: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
61: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

54: P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
55: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
56: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
57: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
58: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
59: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
60: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
61: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,

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

55: P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
56: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
57: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
58: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
59: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
60: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
61: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
63: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

56: P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
57: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
58: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
59: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
60: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
61: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
63: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

57: P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
58: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
59: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
60: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
61: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
63: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

58: P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
59: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
60: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
61: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
63: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

59: P_START_DATE IN DATE := FND_API.G_MISS_DATE,
60: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
61: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
63: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

60: P_END_DATE IN DATE := FND_API.G_MISS_DATE,
61: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
63: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

61: P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
63: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

62: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
63: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

63: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

64: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

65: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

66: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

67: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

68: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

69: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

70: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

71: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );

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

72: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );
80:

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

73: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );
80:
81: PROCEDURE delete_row

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

74: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );
80:
81: PROCEDURE delete_row
82: (P_ROLE_MODEL_ID IN NUMBER);

Line 79: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );

75: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );
80:
81: PROCEDURE delete_row
82: (P_ROLE_MODEL_ID IN NUMBER);
83: