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: SUM_TRX_FLAG CN_COMP_PLANS.SUM_TRX_FLAG%TYPE := FND_API.G_MISS_CHAR,

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: SUM_TRX_FLAG CN_COMP_PLANS.SUM_TRX_FLAG%TYPE := FND_API.G_MISS_CHAR,
16: START_DATE CN_COMP_PLANS.START_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: SUM_TRX_FLAG CN_COMP_PLANS.SUM_TRX_FLAG%TYPE := FND_API.G_MISS_CHAR,
16: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
17: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,

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: SUM_TRX_FLAG CN_COMP_PLANS.SUM_TRX_FLAG%TYPE := FND_API.G_MISS_CHAR,
16: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
17: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
18: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,

Line 15: SUM_TRX_FLAG CN_COMP_PLANS.SUM_TRX_FLAG%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: SUM_TRX_FLAG CN_COMP_PLANS.SUM_TRX_FLAG%TYPE := FND_API.G_MISS_CHAR,
16: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
17: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
18: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,

Line 16: START_DATE CN_COMP_PLANS.START_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: SUM_TRX_FLAG CN_COMP_PLANS.SUM_TRX_FLAG%TYPE := FND_API.G_MISS_CHAR,
16: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
17: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
18: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,

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

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: SUM_TRX_FLAG CN_COMP_PLANS.SUM_TRX_FLAG%TYPE := FND_API.G_MISS_CHAR,
16: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
17: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
18: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
21: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,

Line 18: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%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: SUM_TRX_FLAG CN_COMP_PLANS.SUM_TRX_FLAG%TYPE := FND_API.G_MISS_CHAR,
16: START_DATE CN_COMP_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
17: END_DATE CN_COMP_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
18: ATTRIBUTE_CATEGORY CN_COMP_PLANS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
19: ATTRIBUTE1 CN_COMP_PLANS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
20: ATTRIBUTE2 CN_COMP_PLANS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
21: ATTRIBUTE3 CN_COMP_PLANS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
22: ATTRIBUTE4 CN_COMP_PLANS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 89: -- Default = FND_API.G_FALSE

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

Line 91: -- Default = FND_API.G_FALSE

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

Line 93: -- Default = FND_API.G_VALID_LEVEL_FULL

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

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

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

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

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

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

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

Line 122: -- Default = FND_API.G_FALSE

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

Line 124: -- Default = FND_API.G_FALSE

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

Line 126: -- Default = FND_API.G_VALID_LEVEL_FULL

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

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

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

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

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

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

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

Line 153: -- Default = FND_API.G_FALSE

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

Line 155: -- Default = FND_API.G_FALSE

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

Line 157: -- Default = FND_API.G_VALID_LEVEL_FULL

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

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

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

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

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

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

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

Line 184: -- Default = FND_API.G_FALSE

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

Line 186: -- Default = FND_API.G_FALSE

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

Line 188: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 196: -- Default = FND_API.G_MISS_DATE

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

Line 198: -- Default = FND_API.G_MISS_CHAR

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

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

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

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

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

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

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

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

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

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

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

Line 233: -- Default = FND_API.G_FALSE

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

Line 235: -- Default = FND_API.G_FALSE

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

Line 237: -- Default = FND_API.G_VALID_LEVEL_FULL

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

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

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

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

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

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

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

Line 267: -- Default = FND_API.G_FALSE

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

Line 269: -- Default = FND_API.G_FALSE

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

Line 271: -- Default = FND_API.G_VALID_LEVEL_FULL

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

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

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

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

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

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

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

Line 300: -- Default = FND_API.G_FALSE

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

Line 302: -- Default = FND_API.G_FALSE

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

Line 304: -- Default = FND_API.G_VALID_LEVEL_FULL

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

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

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

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

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

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

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

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

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

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

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

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

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