DBA Data[Home] [Help]

APPS.CN_WKSHT_CT_UP_PUB dependencies on CN_SRP_PMT_PLANS

Line 8: START_DATE cn_srp_pmt_plans.start_date%TYPE

4: TYPE srp_pmt_plans_rec_type IS RECORD
5: (PMT_PLAN_NAME cn_pmt_plans.name%TYPE := CN_API.G_MISS_CHAR,
6: SALESREP_TYPE VARCHAR2(100) := CN_API.G_MISS_CHAR,
7: EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,
8: START_DATE cn_srp_pmt_plans.start_date%TYPE
9: := CN_API.G_MISS_DATE,
10: END_DATE cn_srp_pmt_plans.end_date%TYPE
11: := CN_API.G_MISS_DATE,
12: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE

Line 10: END_DATE cn_srp_pmt_plans.end_date%TYPE

6: SALESREP_TYPE VARCHAR2(100) := CN_API.G_MISS_CHAR,
7: EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,
8: START_DATE cn_srp_pmt_plans.start_date%TYPE
9: := CN_API.G_MISS_DATE,
10: END_DATE cn_srp_pmt_plans.end_date%TYPE
11: := CN_API.G_MISS_DATE,
12: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
13: := CN_API.G_MISS_NUM,
14: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE

Line 12: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE

8: START_DATE cn_srp_pmt_plans.start_date%TYPE
9: := CN_API.G_MISS_DATE,
10: END_DATE cn_srp_pmt_plans.end_date%TYPE
11: := CN_API.G_MISS_DATE,
12: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
13: := CN_API.G_MISS_NUM,
14: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
15: := CN_API.G_MISS_NUM,
16: MAX_RECOVERY_AMOUNT cn_srp_pmt_plans.max_recovery_amount%TYPE

Line 14: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE

10: END_DATE cn_srp_pmt_plans.end_date%TYPE
11: := CN_API.G_MISS_DATE,
12: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
13: := CN_API.G_MISS_NUM,
14: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
15: := CN_API.G_MISS_NUM,
16: MAX_RECOVERY_AMOUNT cn_srp_pmt_plans.max_recovery_amount%TYPE
17: := CN_API.G_MISS_NUM,
18: ATTRIBUTE_CATEGORY cn_srp_pmt_plans.attribute_category%TYPE

Line 16: MAX_RECOVERY_AMOUNT cn_srp_pmt_plans.max_recovery_amount%TYPE

12: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
13: := CN_API.G_MISS_NUM,
14: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
15: := CN_API.G_MISS_NUM,
16: MAX_RECOVERY_AMOUNT cn_srp_pmt_plans.max_recovery_amount%TYPE
17: := CN_API.G_MISS_NUM,
18: ATTRIBUTE_CATEGORY cn_srp_pmt_plans.attribute_category%TYPE
19: := CN_API.G_MISS_CHAR,
20: ATTRIBUTE1 cn_srp_pmt_plans.attribute1%TYPE

Line 18: ATTRIBUTE_CATEGORY cn_srp_pmt_plans.attribute_category%TYPE

14: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
15: := CN_API.G_MISS_NUM,
16: MAX_RECOVERY_AMOUNT cn_srp_pmt_plans.max_recovery_amount%TYPE
17: := CN_API.G_MISS_NUM,
18: ATTRIBUTE_CATEGORY cn_srp_pmt_plans.attribute_category%TYPE
19: := CN_API.G_MISS_CHAR,
20: ATTRIBUTE1 cn_srp_pmt_plans.attribute1%TYPE
21: := CN_API.G_MISS_CHAR,
22: ATTRIBUTE2 cn_srp_pmt_plans.attribute2%TYPE

Line 20: ATTRIBUTE1 cn_srp_pmt_plans.attribute1%TYPE

16: MAX_RECOVERY_AMOUNT cn_srp_pmt_plans.max_recovery_amount%TYPE
17: := CN_API.G_MISS_NUM,
18: ATTRIBUTE_CATEGORY cn_srp_pmt_plans.attribute_category%TYPE
19: := CN_API.G_MISS_CHAR,
20: ATTRIBUTE1 cn_srp_pmt_plans.attribute1%TYPE
21: := CN_API.G_MISS_CHAR,
22: ATTRIBUTE2 cn_srp_pmt_plans.attribute2%TYPE
23: := CN_API.G_MISS_CHAR,
24: ATTRIBUTE3 cn_srp_pmt_plans.attribute3%TYPE

Line 22: ATTRIBUTE2 cn_srp_pmt_plans.attribute2%TYPE

18: ATTRIBUTE_CATEGORY cn_srp_pmt_plans.attribute_category%TYPE
19: := CN_API.G_MISS_CHAR,
20: ATTRIBUTE1 cn_srp_pmt_plans.attribute1%TYPE
21: := CN_API.G_MISS_CHAR,
22: ATTRIBUTE2 cn_srp_pmt_plans.attribute2%TYPE
23: := CN_API.G_MISS_CHAR,
24: ATTRIBUTE3 cn_srp_pmt_plans.attribute3%TYPE
25: := CN_API.G_MISS_CHAR,
26: ATTRIBUTE4 cn_srp_pmt_plans.attribute4%TYPE

Line 24: ATTRIBUTE3 cn_srp_pmt_plans.attribute3%TYPE

20: ATTRIBUTE1 cn_srp_pmt_plans.attribute1%TYPE
21: := CN_API.G_MISS_CHAR,
22: ATTRIBUTE2 cn_srp_pmt_plans.attribute2%TYPE
23: := CN_API.G_MISS_CHAR,
24: ATTRIBUTE3 cn_srp_pmt_plans.attribute3%TYPE
25: := CN_API.G_MISS_CHAR,
26: ATTRIBUTE4 cn_srp_pmt_plans.attribute4%TYPE
27: := CN_API.G_MISS_CHAR,
28: ATTRIBUTE5 cn_srp_pmt_plans.attribute5%TYPE

Line 26: ATTRIBUTE4 cn_srp_pmt_plans.attribute4%TYPE

22: ATTRIBUTE2 cn_srp_pmt_plans.attribute2%TYPE
23: := CN_API.G_MISS_CHAR,
24: ATTRIBUTE3 cn_srp_pmt_plans.attribute3%TYPE
25: := CN_API.G_MISS_CHAR,
26: ATTRIBUTE4 cn_srp_pmt_plans.attribute4%TYPE
27: := CN_API.G_MISS_CHAR,
28: ATTRIBUTE5 cn_srp_pmt_plans.attribute5%TYPE
29: := CN_API.G_MISS_CHAR,
30: ATTRIBUTE6 cn_srp_pmt_plans.attribute6%TYPE

Line 28: ATTRIBUTE5 cn_srp_pmt_plans.attribute5%TYPE

24: ATTRIBUTE3 cn_srp_pmt_plans.attribute3%TYPE
25: := CN_API.G_MISS_CHAR,
26: ATTRIBUTE4 cn_srp_pmt_plans.attribute4%TYPE
27: := CN_API.G_MISS_CHAR,
28: ATTRIBUTE5 cn_srp_pmt_plans.attribute5%TYPE
29: := CN_API.G_MISS_CHAR,
30: ATTRIBUTE6 cn_srp_pmt_plans.attribute6%TYPE
31: := CN_API.G_MISS_CHAR,
32: ATTRIBUTE7 cn_srp_pmt_plans.attribute7%TYPE

Line 30: ATTRIBUTE6 cn_srp_pmt_plans.attribute6%TYPE

26: ATTRIBUTE4 cn_srp_pmt_plans.attribute4%TYPE
27: := CN_API.G_MISS_CHAR,
28: ATTRIBUTE5 cn_srp_pmt_plans.attribute5%TYPE
29: := CN_API.G_MISS_CHAR,
30: ATTRIBUTE6 cn_srp_pmt_plans.attribute6%TYPE
31: := CN_API.G_MISS_CHAR,
32: ATTRIBUTE7 cn_srp_pmt_plans.attribute7%TYPE
33: := CN_API.G_MISS_CHAR,
34: ATTRIBUTE8 cn_srp_pmt_plans.attribute8%TYPE

Line 32: ATTRIBUTE7 cn_srp_pmt_plans.attribute7%TYPE

28: ATTRIBUTE5 cn_srp_pmt_plans.attribute5%TYPE
29: := CN_API.G_MISS_CHAR,
30: ATTRIBUTE6 cn_srp_pmt_plans.attribute6%TYPE
31: := CN_API.G_MISS_CHAR,
32: ATTRIBUTE7 cn_srp_pmt_plans.attribute7%TYPE
33: := CN_API.G_MISS_CHAR,
34: ATTRIBUTE8 cn_srp_pmt_plans.attribute8%TYPE
35: := CN_API.G_MISS_CHAR,
36: ATTRIBUTE9 cn_srp_pmt_plans.attribute9%TYPE

Line 34: ATTRIBUTE8 cn_srp_pmt_plans.attribute8%TYPE

30: ATTRIBUTE6 cn_srp_pmt_plans.attribute6%TYPE
31: := CN_API.G_MISS_CHAR,
32: ATTRIBUTE7 cn_srp_pmt_plans.attribute7%TYPE
33: := CN_API.G_MISS_CHAR,
34: ATTRIBUTE8 cn_srp_pmt_plans.attribute8%TYPE
35: := CN_API.G_MISS_CHAR,
36: ATTRIBUTE9 cn_srp_pmt_plans.attribute9%TYPE
37: := CN_API.G_MISS_CHAR,
38: ATTRIBUTE10 cn_srp_pmt_plans.attribute10%TYPE

Line 36: ATTRIBUTE9 cn_srp_pmt_plans.attribute9%TYPE

32: ATTRIBUTE7 cn_srp_pmt_plans.attribute7%TYPE
33: := CN_API.G_MISS_CHAR,
34: ATTRIBUTE8 cn_srp_pmt_plans.attribute8%TYPE
35: := CN_API.G_MISS_CHAR,
36: ATTRIBUTE9 cn_srp_pmt_plans.attribute9%TYPE
37: := CN_API.G_MISS_CHAR,
38: ATTRIBUTE10 cn_srp_pmt_plans.attribute10%TYPE
39: := CN_API.G_MISS_CHAR,
40: ATTRIBUTE11 cn_srp_pmt_plans.attribute11%TYPE

Line 38: ATTRIBUTE10 cn_srp_pmt_plans.attribute10%TYPE

34: ATTRIBUTE8 cn_srp_pmt_plans.attribute8%TYPE
35: := CN_API.G_MISS_CHAR,
36: ATTRIBUTE9 cn_srp_pmt_plans.attribute9%TYPE
37: := CN_API.G_MISS_CHAR,
38: ATTRIBUTE10 cn_srp_pmt_plans.attribute10%TYPE
39: := CN_API.G_MISS_CHAR,
40: ATTRIBUTE11 cn_srp_pmt_plans.attribute11%TYPE
41: := CN_API.G_MISS_CHAR,
42: ATTRIBUTE12 cn_srp_pmt_plans.attribute12%TYPE

Line 40: ATTRIBUTE11 cn_srp_pmt_plans.attribute11%TYPE

36: ATTRIBUTE9 cn_srp_pmt_plans.attribute9%TYPE
37: := CN_API.G_MISS_CHAR,
38: ATTRIBUTE10 cn_srp_pmt_plans.attribute10%TYPE
39: := CN_API.G_MISS_CHAR,
40: ATTRIBUTE11 cn_srp_pmt_plans.attribute11%TYPE
41: := CN_API.G_MISS_CHAR,
42: ATTRIBUTE12 cn_srp_pmt_plans.attribute12%TYPE
43: := CN_API.G_MISS_CHAR,
44: ATTRIBUTE13 cn_srp_pmt_plans.attribute13%TYPE

Line 42: ATTRIBUTE12 cn_srp_pmt_plans.attribute12%TYPE

38: ATTRIBUTE10 cn_srp_pmt_plans.attribute10%TYPE
39: := CN_API.G_MISS_CHAR,
40: ATTRIBUTE11 cn_srp_pmt_plans.attribute11%TYPE
41: := CN_API.G_MISS_CHAR,
42: ATTRIBUTE12 cn_srp_pmt_plans.attribute12%TYPE
43: := CN_API.G_MISS_CHAR,
44: ATTRIBUTE13 cn_srp_pmt_plans.attribute13%TYPE
45: := CN_API.G_MISS_CHAR,
46: ATTRIBUTE14 cn_srp_pmt_plans.attribute14%TYPE

Line 44: ATTRIBUTE13 cn_srp_pmt_plans.attribute13%TYPE

40: ATTRIBUTE11 cn_srp_pmt_plans.attribute11%TYPE
41: := CN_API.G_MISS_CHAR,
42: ATTRIBUTE12 cn_srp_pmt_plans.attribute12%TYPE
43: := CN_API.G_MISS_CHAR,
44: ATTRIBUTE13 cn_srp_pmt_plans.attribute13%TYPE
45: := CN_API.G_MISS_CHAR,
46: ATTRIBUTE14 cn_srp_pmt_plans.attribute14%TYPE
47: := CN_API.G_MISS_CHAR,
48: ATTRIBUTE15 cn_srp_pmt_plans.attribute15%TYPE

Line 46: ATTRIBUTE14 cn_srp_pmt_plans.attribute14%TYPE

42: ATTRIBUTE12 cn_srp_pmt_plans.attribute12%TYPE
43: := CN_API.G_MISS_CHAR,
44: ATTRIBUTE13 cn_srp_pmt_plans.attribute13%TYPE
45: := CN_API.G_MISS_CHAR,
46: ATTRIBUTE14 cn_srp_pmt_plans.attribute14%TYPE
47: := CN_API.G_MISS_CHAR,
48: ATTRIBUTE15 cn_srp_pmt_plans.attribute15%TYPE
49: := CN_API.G_MISS_CHAR
50: );

Line 48: ATTRIBUTE15 cn_srp_pmt_plans.attribute15%TYPE

44: ATTRIBUTE13 cn_srp_pmt_plans.attribute13%TYPE
45: := CN_API.G_MISS_CHAR,
46: ATTRIBUTE14 cn_srp_pmt_plans.attribute14%TYPE
47: := CN_API.G_MISS_CHAR,
48: ATTRIBUTE15 cn_srp_pmt_plans.attribute15%TYPE
49: := CN_API.G_MISS_CHAR
50: );
51:
52: G_MISS_SRP_PMT_PLANS_REC srp_pmt_plans_rec_type;