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

Line 8: NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,

4: -- comp plan
5: TYPE comp_plan_rec_type IS RECORD
6: (
7: COMP_PLAN_ID CN_COMP_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
8: NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,
9: VERSION CN_COMP_PLANS.VERSION%TYPE := FND_API.G_MISS_CHAR,
10: DESCRIPTION CN_COMP_PLANS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
11: STATUS_CODE CN_COMP_PLANS.STATUS_CODE%TYPE := FND_API.G_MISS_CHAR,
12: COMPLETE_FLAG CN_COMP_PLANS.COMPLETE_FLAG%TYPE := FND_API.G_MISS_CHAR,

Line 9: VERSION CN_COMP_PLANS.VERSION%TYPE := FND_API.G_MISS_CHAR,

5: TYPE comp_plan_rec_type IS RECORD
6: (
7: COMP_PLAN_ID CN_COMP_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
8: NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,
9: VERSION CN_COMP_PLANS.VERSION%TYPE := FND_API.G_MISS_CHAR,
10: DESCRIPTION CN_COMP_PLANS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
11: STATUS_CODE CN_COMP_PLANS.STATUS_CODE%TYPE := FND_API.G_MISS_CHAR,
12: COMPLETE_FLAG CN_COMP_PLANS.COMPLETE_FLAG%TYPE := FND_API.G_MISS_CHAR,
13: ON_QUOTA_DATE CN_COMP_PLANS.ON_QUOTA_DATE%TYPE := FND_API.G_MISS_DATE,

Line 10: DESCRIPTION CN_COMP_PLANS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,

6: (
7: COMP_PLAN_ID CN_COMP_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
8: NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,
9: VERSION CN_COMP_PLANS.VERSION%TYPE := FND_API.G_MISS_CHAR,
10: DESCRIPTION CN_COMP_PLANS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
11: STATUS_CODE CN_COMP_PLANS.STATUS_CODE%TYPE := FND_API.G_MISS_CHAR,
12: COMPLETE_FLAG CN_COMP_PLANS.COMPLETE_FLAG%TYPE := FND_API.G_MISS_CHAR,
13: ON_QUOTA_DATE CN_COMP_PLANS.ON_QUOTA_DATE%TYPE := FND_API.G_MISS_DATE,
14: ALLOW_REV_CLASS_OVERLAP CN_COMP_PLANS.ALLOW_REV_CLASS_OVERLAP%TYPE := FND_API.G_MISS_CHAR,

Line 11: STATUS_CODE CN_COMP_PLANS.STATUS_CODE%TYPE := FND_API.G_MISS_CHAR,

7: COMP_PLAN_ID CN_COMP_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
8: NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,
9: VERSION CN_COMP_PLANS.VERSION%TYPE := FND_API.G_MISS_CHAR,
10: DESCRIPTION CN_COMP_PLANS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
11: STATUS_CODE CN_COMP_PLANS.STATUS_CODE%TYPE := FND_API.G_MISS_CHAR,
12: COMPLETE_FLAG CN_COMP_PLANS.COMPLETE_FLAG%TYPE := FND_API.G_MISS_CHAR,
13: ON_QUOTA_DATE CN_COMP_PLANS.ON_QUOTA_DATE%TYPE := FND_API.G_MISS_DATE,
14: ALLOW_REV_CLASS_OVERLAP CN_COMP_PLANS.ALLOW_REV_CLASS_OVERLAP%TYPE := FND_API.G_MISS_CHAR,
15: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,

Line 12: COMPLETE_FLAG CN_COMP_PLANS.COMPLETE_FLAG%TYPE := FND_API.G_MISS_CHAR,

8: NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,
9: VERSION CN_COMP_PLANS.VERSION%TYPE := FND_API.G_MISS_CHAR,
10: DESCRIPTION CN_COMP_PLANS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
11: STATUS_CODE CN_COMP_PLANS.STATUS_CODE%TYPE := FND_API.G_MISS_CHAR,
12: COMPLETE_FLAG CN_COMP_PLANS.COMPLETE_FLAG%TYPE := FND_API.G_MISS_CHAR,
13: ON_QUOTA_DATE CN_COMP_PLANS.ON_QUOTA_DATE%TYPE := FND_API.G_MISS_DATE,
14: ALLOW_REV_CLASS_OVERLAP CN_COMP_PLANS.ALLOW_REV_CLASS_OVERLAP%TYPE := FND_API.G_MISS_CHAR,
15: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
16: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,

Line 13: ON_QUOTA_DATE CN_COMP_PLANS.ON_QUOTA_DATE%TYPE := FND_API.G_MISS_DATE,

9: VERSION CN_COMP_PLANS.VERSION%TYPE := FND_API.G_MISS_CHAR,
10: DESCRIPTION CN_COMP_PLANS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
11: STATUS_CODE CN_COMP_PLANS.STATUS_CODE%TYPE := FND_API.G_MISS_CHAR,
12: COMPLETE_FLAG CN_COMP_PLANS.COMPLETE_FLAG%TYPE := FND_API.G_MISS_CHAR,
13: ON_QUOTA_DATE CN_COMP_PLANS.ON_QUOTA_DATE%TYPE := FND_API.G_MISS_DATE,
14: ALLOW_REV_CLASS_OVERLAP CN_COMP_PLANS.ALLOW_REV_CLASS_OVERLAP%TYPE := FND_API.G_MISS_CHAR,
15: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
16: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
17: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,

Line 14: ALLOW_REV_CLASS_OVERLAP CN_COMP_PLANS.ALLOW_REV_CLASS_OVERLAP%TYPE := FND_API.G_MISS_CHAR,

10: DESCRIPTION CN_COMP_PLANS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
11: STATUS_CODE CN_COMP_PLANS.STATUS_CODE%TYPE := FND_API.G_MISS_CHAR,
12: COMPLETE_FLAG CN_COMP_PLANS.COMPLETE_FLAG%TYPE := FND_API.G_MISS_CHAR,
13: ON_QUOTA_DATE CN_COMP_PLANS.ON_QUOTA_DATE%TYPE := FND_API.G_MISS_DATE,
14: ALLOW_REV_CLASS_OVERLAP CN_COMP_PLANS.ALLOW_REV_CLASS_OVERLAP%TYPE := FND_API.G_MISS_CHAR,
15: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
16: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
17: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
18: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,

Line 15: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,

11: STATUS_CODE CN_COMP_PLANS.STATUS_CODE%TYPE := FND_API.G_MISS_CHAR,
12: COMPLETE_FLAG CN_COMP_PLANS.COMPLETE_FLAG%TYPE := FND_API.G_MISS_CHAR,
13: ON_QUOTA_DATE CN_COMP_PLANS.ON_QUOTA_DATE%TYPE := FND_API.G_MISS_DATE,
14: ALLOW_REV_CLASS_OVERLAP CN_COMP_PLANS.ALLOW_REV_CLASS_OVERLAP%TYPE := FND_API.G_MISS_CHAR,
15: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
16: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
17: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
18: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,

Line 16: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,

12: COMPLETE_FLAG CN_COMP_PLANS.COMPLETE_FLAG%TYPE := FND_API.G_MISS_CHAR,
13: ON_QUOTA_DATE CN_COMP_PLANS.ON_QUOTA_DATE%TYPE := FND_API.G_MISS_DATE,
14: ALLOW_REV_CLASS_OVERLAP CN_COMP_PLANS.ALLOW_REV_CLASS_OVERLAP%TYPE := FND_API.G_MISS_CHAR,
15: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
16: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
17: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
18: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,

Line 17: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,

13: ON_QUOTA_DATE CN_COMP_PLANS.ON_QUOTA_DATE%TYPE := FND_API.G_MISS_DATE,
14: ALLOW_REV_CLASS_OVERLAP CN_COMP_PLANS.ALLOW_REV_CLASS_OVERLAP%TYPE := FND_API.G_MISS_CHAR,
15: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
16: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
17: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
18: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
21: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,

Line 18: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,

14: ALLOW_REV_CLASS_OVERLAP CN_COMP_PLANS.ALLOW_REV_CLASS_OVERLAP%TYPE := FND_API.G_MISS_CHAR,
15: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
16: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
17: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
18: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
21: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
22: ATTRIBUTE5 CN_COMP_PLANS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,

Line 19: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,

15: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
16: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
17: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
18: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
21: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
22: ATTRIBUTE5 CN_COMP_PLANS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
23: ATTRIBUTE6 CN_COMP_PLANS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,

Line 20: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,

16: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
17: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
18: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
21: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
22: ATTRIBUTE5 CN_COMP_PLANS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
23: ATTRIBUTE6 CN_COMP_PLANS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
24: ATTRIBUTE7 CN_COMP_PLANS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,

Line 21: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,

17: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
18: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
21: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
22: ATTRIBUTE5 CN_COMP_PLANS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
23: ATTRIBUTE6 CN_COMP_PLANS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
24: ATTRIBUTE7 CN_COMP_PLANS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
25: ATTRIBUTE8 CN_COMP_PLANS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,

Line 22: ATTRIBUTE5 CN_COMP_PLANS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,

18: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
21: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
22: ATTRIBUTE5 CN_COMP_PLANS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
23: ATTRIBUTE6 CN_COMP_PLANS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
24: ATTRIBUTE7 CN_COMP_PLANS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
25: ATTRIBUTE8 CN_COMP_PLANS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
26: ATTRIBUTE9 CN_COMP_PLANS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,

Line 23: ATTRIBUTE6 CN_COMP_PLANS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,

19: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
21: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
22: ATTRIBUTE5 CN_COMP_PLANS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
23: ATTRIBUTE6 CN_COMP_PLANS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
24: ATTRIBUTE7 CN_COMP_PLANS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
25: ATTRIBUTE8 CN_COMP_PLANS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
26: ATTRIBUTE9 CN_COMP_PLANS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
27: ATTRIBUTE10 CN_COMP_PLANS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,

Line 24: ATTRIBUTE7 CN_COMP_PLANS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,

20: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
21: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
22: ATTRIBUTE5 CN_COMP_PLANS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
23: ATTRIBUTE6 CN_COMP_PLANS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
24: ATTRIBUTE7 CN_COMP_PLANS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
25: ATTRIBUTE8 CN_COMP_PLANS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
26: ATTRIBUTE9 CN_COMP_PLANS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
27: ATTRIBUTE10 CN_COMP_PLANS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
28: ATTRIBUTE11 CN_COMP_PLANS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,

Line 25: ATTRIBUTE8 CN_COMP_PLANS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,

21: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
22: ATTRIBUTE5 CN_COMP_PLANS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
23: ATTRIBUTE6 CN_COMP_PLANS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
24: ATTRIBUTE7 CN_COMP_PLANS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
25: ATTRIBUTE8 CN_COMP_PLANS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
26: ATTRIBUTE9 CN_COMP_PLANS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
27: ATTRIBUTE10 CN_COMP_PLANS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
28: ATTRIBUTE11 CN_COMP_PLANS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
29: ATTRIBUTE12 CN_COMP_PLANS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,

Line 26: ATTRIBUTE9 CN_COMP_PLANS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,

22: ATTRIBUTE5 CN_COMP_PLANS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
23: ATTRIBUTE6 CN_COMP_PLANS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
24: ATTRIBUTE7 CN_COMP_PLANS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
25: ATTRIBUTE8 CN_COMP_PLANS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
26: ATTRIBUTE9 CN_COMP_PLANS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
27: ATTRIBUTE10 CN_COMP_PLANS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
28: ATTRIBUTE11 CN_COMP_PLANS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
29: ATTRIBUTE12 CN_COMP_PLANS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
30: ATTRIBUTE13 CN_COMP_PLANS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,

Line 27: ATTRIBUTE10 CN_COMP_PLANS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,

23: ATTRIBUTE6 CN_COMP_PLANS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
24: ATTRIBUTE7 CN_COMP_PLANS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
25: ATTRIBUTE8 CN_COMP_PLANS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
26: ATTRIBUTE9 CN_COMP_PLANS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
27: ATTRIBUTE10 CN_COMP_PLANS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
28: ATTRIBUTE11 CN_COMP_PLANS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
29: ATTRIBUTE12 CN_COMP_PLANS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
30: ATTRIBUTE13 CN_COMP_PLANS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
31: ATTRIBUTE14 CN_COMP_PLANS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,

Line 28: ATTRIBUTE11 CN_COMP_PLANS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,

24: ATTRIBUTE7 CN_COMP_PLANS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
25: ATTRIBUTE8 CN_COMP_PLANS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
26: ATTRIBUTE9 CN_COMP_PLANS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
27: ATTRIBUTE10 CN_COMP_PLANS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
28: ATTRIBUTE11 CN_COMP_PLANS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
29: ATTRIBUTE12 CN_COMP_PLANS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
30: ATTRIBUTE13 CN_COMP_PLANS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
31: ATTRIBUTE14 CN_COMP_PLANS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
32: ATTRIBUTE15 CN_COMP_PLANS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,

Line 29: ATTRIBUTE12 CN_COMP_PLANS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,

25: ATTRIBUTE8 CN_COMP_PLANS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
26: ATTRIBUTE9 CN_COMP_PLANS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
27: ATTRIBUTE10 CN_COMP_PLANS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
28: ATTRIBUTE11 CN_COMP_PLANS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
29: ATTRIBUTE12 CN_COMP_PLANS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
30: ATTRIBUTE13 CN_COMP_PLANS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
31: ATTRIBUTE14 CN_COMP_PLANS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
32: ATTRIBUTE15 CN_COMP_PLANS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
33: OBJECT_VERSION_NUMBER CN_COMP_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL,

Line 30: ATTRIBUTE13 CN_COMP_PLANS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,

26: ATTRIBUTE9 CN_COMP_PLANS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
27: ATTRIBUTE10 CN_COMP_PLANS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
28: ATTRIBUTE11 CN_COMP_PLANS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
29: ATTRIBUTE12 CN_COMP_PLANS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
30: ATTRIBUTE13 CN_COMP_PLANS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
31: ATTRIBUTE14 CN_COMP_PLANS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
32: ATTRIBUTE15 CN_COMP_PLANS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
33: OBJECT_VERSION_NUMBER CN_COMP_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL,
34: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */

Line 31: ATTRIBUTE14 CN_COMP_PLANS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,

27: ATTRIBUTE10 CN_COMP_PLANS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
28: ATTRIBUTE11 CN_COMP_PLANS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
29: ATTRIBUTE12 CN_COMP_PLANS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
30: ATTRIBUTE13 CN_COMP_PLANS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
31: ATTRIBUTE14 CN_COMP_PLANS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
32: ATTRIBUTE15 CN_COMP_PLANS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
33: OBJECT_VERSION_NUMBER CN_COMP_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL,
34: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */
35: ) ;

Line 32: ATTRIBUTE15 CN_COMP_PLANS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,

28: ATTRIBUTE11 CN_COMP_PLANS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
29: ATTRIBUTE12 CN_COMP_PLANS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
30: ATTRIBUTE13 CN_COMP_PLANS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
31: ATTRIBUTE14 CN_COMP_PLANS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
32: ATTRIBUTE15 CN_COMP_PLANS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
33: OBJECT_VERSION_NUMBER CN_COMP_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL,
34: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */
35: ) ;
36:

Line 51: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,

47: (
48: ROLE_PLAN_ID CN_ROLE_PLANS.ROLE_PLAN_ID%TYPE := CN_API.G_MISS_ID,
49: ROLE_ID CN_ROLE_PLANS.ROLE_ID%TYPE := CN_API.G_MISS_ID,
50: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
51: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
52: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
53: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
54: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
55: OBJECT_VERSION_NUMBER CN_ROLE_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL

Line 52: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,

48: ROLE_PLAN_ID CN_ROLE_PLANS.ROLE_PLAN_ID%TYPE := CN_API.G_MISS_ID,
49: ROLE_ID CN_ROLE_PLANS.ROLE_ID%TYPE := CN_API.G_MISS_ID,
50: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
51: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
52: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
53: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
54: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
55: OBJECT_VERSION_NUMBER CN_ROLE_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL
56: ) ;

Line 53: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,

49: ROLE_ID CN_ROLE_PLANS.ROLE_ID%TYPE := CN_API.G_MISS_ID,
50: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
51: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
52: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
53: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
54: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
55: OBJECT_VERSION_NUMBER CN_ROLE_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL
56: ) ;
57:

Line 54: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,

50: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
51: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
52: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
53: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
54: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
55: OBJECT_VERSION_NUMBER CN_ROLE_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL
56: ) ;
57:
58: TYPE sales_role_tbl_type IS

Line 88: -- Default = FND_API.G_FALSE

84: -- Pre-reqs : None.
85: -- Parameters :
86: -- IN : p_api_version IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional
88: -- Default = FND_API.G_FALSE
89: -- p_commit IN VARCHAR2 Optional
90: -- Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional
92: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 90: -- Default = FND_API.G_FALSE

86: -- IN : p_api_version IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional
88: -- Default = FND_API.G_FALSE
89: -- p_commit IN VARCHAR2 Optional
90: -- Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional
92: -- Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_comp_plan IN comp_plan_rec_type
94: -- OUT : x_return_status OUT VARCHAR2(1)

Line 92: -- Default = FND_API.G_VALID_LEVEL_FULL

88: -- Default = FND_API.G_FALSE
89: -- p_commit IN VARCHAR2 Optional
90: -- Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional
92: -- Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_comp_plan IN comp_plan_rec_type
94: -- OUT : x_return_status OUT VARCHAR2(1)
95: -- x_msg_count OUT NUMBER
96: -- x_msg_data OUT VARCHAR2(2000)

Line 104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

100: --
101: -- End of comments
102: PROCEDURE Create_Comp_Plan
103: (p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107: p_comp_plan IN OUT NOCOPY comp_plan_rec_type,
108: x_comp_plan_id OUT NOCOPY NUMBER,

Line 105: p_commit IN VARCHAR2 := FND_API.G_FALSE,

101: -- End of comments
102: PROCEDURE Create_Comp_Plan
103: (p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107: p_comp_plan IN OUT NOCOPY comp_plan_rec_type,
108: x_comp_plan_id OUT NOCOPY NUMBER,
109: x_return_status OUT NOCOPY VARCHAR2,

Line 106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

102: PROCEDURE Create_Comp_Plan
103: (p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107: p_comp_plan IN OUT NOCOPY comp_plan_rec_type,
108: x_comp_plan_id OUT NOCOPY NUMBER,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,

Line 121: -- Default = FND_API.G_FALSE

117: -- Pre-reqs : None.
118: -- Parameters :
119: -- IN : p_api_version IN NUMBER Required
120: -- p_init_msg_list IN VARCHAR2 Optional
121: -- Default = FND_API.G_FALSE
122: -- p_commit IN VARCHAR2 Optional
123: -- Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional
125: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 123: -- Default = FND_API.G_FALSE

119: -- IN : p_api_version IN NUMBER Required
120: -- p_init_msg_list IN VARCHAR2 Optional
121: -- Default = FND_API.G_FALSE
122: -- p_commit IN VARCHAR2 Optional
123: -- Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional
125: -- Default = FND_API.G_VALID_LEVEL_FULL
126: -- p_comp_plan IN comp_plan_rec_type
127: -- OUT : x_return_status OUT VARCHAR2(1)

Line 125: -- Default = FND_API.G_VALID_LEVEL_FULL

121: -- Default = FND_API.G_FALSE
122: -- p_commit IN VARCHAR2 Optional
123: -- Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional
125: -- Default = FND_API.G_VALID_LEVEL_FULL
126: -- p_comp_plan IN comp_plan_rec_type
127: -- OUT : x_return_status OUT VARCHAR2(1)
128: -- x_msg_count OUT NUMBER
129: -- x_msg_data OUT VARCHAR2(2000)

Line 136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

132: --
133: -- End of comments
134: PROCEDURE Update_Comp_Plan
135: (p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: p_comp_plan IN OUT NOCOPY comp_plan_rec_type,
140: x_return_status OUT NOCOPY VARCHAR2,

Line 137: p_commit IN VARCHAR2 := FND_API.G_FALSE,

133: -- End of comments
134: PROCEDURE Update_Comp_Plan
135: (p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: p_comp_plan IN OUT NOCOPY comp_plan_rec_type,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,

Line 138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

134: PROCEDURE Update_Comp_Plan
135: (p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: p_comp_plan IN OUT NOCOPY comp_plan_rec_type,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2 );

Line 152: -- Default = FND_API.G_FALSE

148: -- Pre-reqs : None.
149: -- Parameters :
150: -- IN : p_api_version IN NUMBER Required
151: -- p_init_msg_list IN VARCHAR2 Optional
152: -- Default = FND_API.G_FALSE
153: -- p_commit IN VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_validation_level IN NUMBER Optional
156: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 154: -- Default = FND_API.G_FALSE

150: -- IN : p_api_version IN NUMBER Required
151: -- p_init_msg_list IN VARCHAR2 Optional
152: -- Default = FND_API.G_FALSE
153: -- p_commit IN VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_validation_level IN NUMBER Optional
156: -- Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_comp_plan IN comp_plan_rec_type
158: -- OUT : x_return_status OUT VARCHAR2(1)

Line 156: -- Default = FND_API.G_VALID_LEVEL_FULL

152: -- Default = FND_API.G_FALSE
153: -- p_commit IN VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_validation_level IN NUMBER Optional
156: -- Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_comp_plan IN comp_plan_rec_type
158: -- OUT : x_return_status OUT VARCHAR2(1)
159: -- x_msg_count OUT NUMBER
160: -- x_msg_data OUT VARCHAR2(2000)

Line 167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

163: --
164: -- End of comments
165: PROCEDURE Delete_Comp_Plan
166: (p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
168: p_commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: p_comp_plan IN OUT NOCOPY comp_plan_rec_type,
171: x_return_status OUT NOCOPY VARCHAR2,

Line 168: p_commit IN VARCHAR2 := FND_API.G_FALSE,

164: -- End of comments
165: PROCEDURE Delete_Comp_Plan
166: (p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
168: p_commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: p_comp_plan IN OUT NOCOPY comp_plan_rec_type,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,

Line 169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

165: PROCEDURE Delete_Comp_Plan
166: (p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
168: p_commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: p_comp_plan IN OUT NOCOPY comp_plan_rec_type,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2);

Line 183: -- Default = FND_API.G_FALSE

179: -- Pre-reqs : None.
180: -- Parameters :
181: -- IN : p_api_version IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional
183: -- Default = FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Optional
185: -- Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional
187: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 185: -- Default = FND_API.G_FALSE

181: -- IN : p_api_version IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional
183: -- Default = FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Optional
185: -- Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional
187: -- Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_start_record IN NUMBER
189: -- Default = -1

Line 187: -- Default = FND_API.G_VALID_LEVEL_FULL

183: -- Default = FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Optional
185: -- Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional
187: -- Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_start_record IN NUMBER
189: -- Default = -1
190: -- p_fetch_size IN NUMBER
191: -- Default = -1

Line 195: -- Default = FND_API.G_MISS_DATE

191: -- Default = -1
192: -- p_search_name IN VARCHAR2
193: -- Default = '%'
194: -- p_search_date IN DATE
195: -- Default = FND_API.G_MISS_DATE
196: -- p_search_status IN VARCHAR2
197: -- Default = FND_API.G_MISS_CHAR
198: -- OUT : x_return_status OUT VARCHAR2(1)
199: -- x_msg_count OUT NUMBER

Line 197: -- Default = FND_API.G_MISS_CHAR

193: -- Default = '%'
194: -- p_search_date IN DATE
195: -- Default = FND_API.G_MISS_DATE
196: -- p_search_status IN VARCHAR2
197: -- Default = FND_API.G_MISS_CHAR
198: -- OUT : x_return_status OUT VARCHAR2(1)
199: -- x_msg_count OUT NUMBER
200: -- x_msg_data OUT VARCHAR2(2000)
201: -- x_comp_plan OUT comp_plan_tbl_type

Line 209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

205: --
206: -- End of comments
207: PROCEDURE Get_Comp_Plan_Sum
208: (p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: p_start_record IN NUMBER := -1,
213: p_fetch_size IN NUMBER := -1,

Line 210: p_commit IN VARCHAR2 := FND_API.G_FALSE,

206: -- End of comments
207: PROCEDURE Get_Comp_Plan_Sum
208: (p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: p_start_record IN NUMBER := -1,
213: p_fetch_size IN NUMBER := -1,
214: p_search_name IN VARCHAR2 := '%',

Line 211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

207: PROCEDURE Get_Comp_Plan_Sum
208: (p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: p_start_record IN NUMBER := -1,
213: p_fetch_size IN NUMBER := -1,
214: p_search_name IN VARCHAR2 := '%',
215: p_search_date IN DATE := FND_API.G_MISS_DATE,

Line 215: p_search_date IN DATE := FND_API.G_MISS_DATE,

211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: p_start_record IN NUMBER := -1,
213: p_fetch_size IN NUMBER := -1,
214: p_search_name IN VARCHAR2 := '%',
215: p_search_date IN DATE := FND_API.G_MISS_DATE,
216: p_search_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: x_comp_plan OUT NOCOPY comp_plan_tbl_type,
218: x_total_record OUT NOCOPY NUMBER,
219: x_return_status OUT NOCOPY VARCHAR2,

Line 216: p_search_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

212: p_start_record IN NUMBER := -1,
213: p_fetch_size IN NUMBER := -1,
214: p_search_name IN VARCHAR2 := '%',
215: p_search_date IN DATE := FND_API.G_MISS_DATE,
216: p_search_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: x_comp_plan OUT NOCOPY comp_plan_tbl_type,
218: x_total_record OUT NOCOPY NUMBER,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,

Line 232: -- Default = FND_API.G_FALSE

228: -- Pre-reqs : None.
229: -- Parameters :
230: -- IN : p_api_version IN NUMBER Required
231: -- p_init_msg_list IN VARCHAR2 Optional
232: -- Default = FND_API.G_FALSE
233: -- p_commit IN VARCHAR2 Optional
234: -- Default = FND_API.G_FALSE
235: -- p_validation_level IN NUMBER Optional
236: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 234: -- Default = FND_API.G_FALSE

230: -- IN : p_api_version IN NUMBER Required
231: -- p_init_msg_list IN VARCHAR2 Optional
232: -- Default = FND_API.G_FALSE
233: -- p_commit IN VARCHAR2 Optional
234: -- Default = FND_API.G_FALSE
235: -- p_validation_level IN NUMBER Optional
236: -- Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_comp_plan_id IN NUMBER
238: -- OUT : x_return_status OUT VARCHAR2(1)

Line 236: -- Default = FND_API.G_VALID_LEVEL_FULL

232: -- Default = FND_API.G_FALSE
233: -- p_commit IN VARCHAR2 Optional
234: -- Default = FND_API.G_FALSE
235: -- p_validation_level IN NUMBER Optional
236: -- Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_comp_plan_id IN NUMBER
238: -- OUT : x_return_status OUT VARCHAR2(1)
239: -- x_msg_count OUT NUMBER
240: -- x_msg_data OUT VARCHAR2(2000)

Line 248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

244: --
245: -- End of comments
246: PROCEDURE Get_Comp_Plan_Dtl
247: (p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: p_comp_plan_id IN NUMBER,
252: x_comp_plan OUT NOCOPY comp_plan_tbl_type,

Line 249: p_commit IN VARCHAR2 := FND_API.G_FALSE,

245: -- End of comments
246: PROCEDURE Get_Comp_Plan_Dtl
247: (p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: p_comp_plan_id IN NUMBER,
252: x_comp_plan OUT NOCOPY comp_plan_tbl_type,
253: x_return_status OUT NOCOPY VARCHAR2,

Line 250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

246: PROCEDURE Get_Comp_Plan_Dtl
247: (p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: p_comp_plan_id IN NUMBER,
252: x_comp_plan OUT NOCOPY comp_plan_tbl_type,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,

Line 266: -- Default = FND_API.G_FALSE

262: -- Pre-reqs : None.
263: -- Parameters :
264: -- IN : p_api_version IN NUMBER Required
265: -- p_init_msg_list IN VARCHAR2 Optional
266: -- Default = FND_API.G_FALSE
267: -- p_commit IN VARCHAR2 Optional
268: -- Default = FND_API.G_FALSE
269: -- p_validation_level IN NUMBER Optional
270: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 268: -- Default = FND_API.G_FALSE

264: -- IN : p_api_version IN NUMBER Required
265: -- p_init_msg_list IN VARCHAR2 Optional
266: -- Default = FND_API.G_FALSE
267: -- p_commit IN VARCHAR2 Optional
268: -- Default = FND_API.G_FALSE
269: -- p_validation_level IN NUMBER Optional
270: -- Default = FND_API.G_VALID_LEVEL_FULL
271: -- p_comp_plan_id IN NUMBER
272: -- OUT : x_return_status OUT VARCHAR2(1)

Line 270: -- Default = FND_API.G_VALID_LEVEL_FULL

266: -- Default = FND_API.G_FALSE
267: -- p_commit IN VARCHAR2 Optional
268: -- Default = FND_API.G_FALSE
269: -- p_validation_level IN NUMBER Optional
270: -- Default = FND_API.G_VALID_LEVEL_FULL
271: -- p_comp_plan_id IN NUMBER
272: -- OUT : x_return_status OUT VARCHAR2(1)
273: -- x_msg_count OUT NUMBER
274: -- x_msg_data OUT VARCHAR2(2000)

Line 282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

278: --
279: -- End of comments
280: PROCEDURE Get_Sales_Role
281: (p_api_version IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285: p_comp_plan_id IN NUMBER,
286: x_sales_role OUT NOCOPY sales_role_tbl_type,

Line 283: p_commit IN VARCHAR2 := FND_API.G_FALSE,

279: -- End of comments
280: PROCEDURE Get_Sales_Role
281: (p_api_version IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285: p_comp_plan_id IN NUMBER,
286: x_sales_role OUT NOCOPY sales_role_tbl_type,
287: x_return_status OUT NOCOPY VARCHAR2,

Line 284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

280: PROCEDURE Get_Sales_Role
281: (p_api_version IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285: p_comp_plan_id IN NUMBER,
286: x_sales_role OUT NOCOPY sales_role_tbl_type,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,

Line 299: -- Default = FND_API.G_FALSE

295: -- Pre-reqs : None.
296: -- Parameters :
297: -- IN : p_api_version IN NUMBER Required
298: -- p_init_msg_list IN VARCHAR2 Optional
299: -- Default = FND_API.G_FALSE
300: -- p_commit IN VARCHAR2 Optional
301: -- Default = FND_API.G_FALSE
302: -- p_validation_level IN NUMBER Optional
303: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 301: -- Default = FND_API.G_FALSE

297: -- IN : p_api_version IN NUMBER Required
298: -- p_init_msg_list IN VARCHAR2 Optional
299: -- Default = FND_API.G_FALSE
300: -- p_commit IN VARCHAR2 Optional
301: -- Default = FND_API.G_FALSE
302: -- p_validation_level IN NUMBER Optional
303: -- Default = FND_API.G_VALID_LEVEL_FULL
304: -- p_comp_plan IN comp_plan_rec_type
305: -- OUT : x_return_status OUT VARCHAR2(1)

Line 303: -- Default = FND_API.G_VALID_LEVEL_FULL

299: -- Default = FND_API.G_FALSE
300: -- p_commit IN VARCHAR2 Optional
301: -- Default = FND_API.G_FALSE
302: -- p_validation_level IN NUMBER Optional
303: -- Default = FND_API.G_VALID_LEVEL_FULL
304: -- p_comp_plan IN comp_plan_rec_type
305: -- OUT : x_return_status OUT VARCHAR2(1)
306: -- x_msg_count OUT NUMBER
307: -- x_msg_data OUT VARCHAR2(2000)

Line 314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

310: --
311: -- End of comments
312: PROCEDURE Validate_Comp_Plan
313: (p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317: p_comp_plan IN comp_plan_rec_type,
318: x_return_status OUT NOCOPY VARCHAR2,

Line 315: p_commit IN VARCHAR2 := FND_API.G_FALSE,

311: -- End of comments
312: PROCEDURE Validate_Comp_Plan
313: (p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317: p_comp_plan IN comp_plan_rec_type,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,

Line 316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

312: PROCEDURE Validate_Comp_Plan
313: (p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317: p_comp_plan IN comp_plan_rec_type,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2);

Line 357: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

353: -- || Compplan.
354: -- =====================================================
355: PROCEDURE duplicate_comp_plan (
356: p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
358: p_commit IN VARCHAR2 := FND_API.G_FALSE,
359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360: p_comp_plan_id IN CN_COMP_PLANS.COMP_PLAN_ID%TYPE,
361: p_org_id IN NUMBER,

Line 358: p_commit IN VARCHAR2 := FND_API.G_FALSE,

354: -- =====================================================
355: PROCEDURE duplicate_comp_plan (
356: p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
358: p_commit IN VARCHAR2 := FND_API.G_FALSE,
359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360: p_comp_plan_id IN CN_COMP_PLANS.COMP_PLAN_ID%TYPE,
361: p_org_id IN NUMBER,
362: x_return_status OUT NOCOPY VARCHAR2,

Line 359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

355: PROCEDURE duplicate_comp_plan (
356: p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
358: p_commit IN VARCHAR2 := FND_API.G_FALSE,
359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360: p_comp_plan_id IN CN_COMP_PLANS.COMP_PLAN_ID%TYPE,
361: p_org_id IN NUMBER,
362: x_return_status OUT NOCOPY VARCHAR2,
363: x_msg_count OUT NOCOPY NUMBER,