APPS.CN_PMTPLAN_PUB dependencies on CN_PMT_PLANS

Line 5: ( org_id cn_pmt_plans.org_id%TYPE,

1: PACKAGE CN_PMTPLAN_PUB AUTHID CURRENT_USER as
2: -- $Header: cnppplns.pls 120.4 2005/11/02 05:37:09 sjustina ship $
3:
4: TYPE PmtPlan_rec_type IS RECORD
5: ( org_id cn_pmt_plans.org_id%TYPE,
6: name cn_pmt_plans.name%TYPE,
7: minimum_amount cn_pmt_plans.minimum_amount%TYPE,
8: maximum_amount cn_pmt_plans.maximum_amount%TYPE,
9: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,

Line 6: name cn_pmt_plans.name%TYPE,

2: -- $Header: cnppplns.pls 120.4 2005/11/02 05:37:09 sjustina ship $
3:
4: TYPE PmtPlan_rec_type IS RECORD
5: ( org_id cn_pmt_plans.org_id%TYPE,
6: name cn_pmt_plans.name%TYPE,
7: minimum_amount cn_pmt_plans.minimum_amount%TYPE,
8: maximum_amount cn_pmt_plans.maximum_amount%TYPE,
9: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,
10: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE,

Line 7: minimum_amount cn_pmt_plans.minimum_amount%TYPE,

3:
4: TYPE PmtPlan_rec_type IS RECORD
5: ( org_id cn_pmt_plans.org_id%TYPE,
6: name cn_pmt_plans.name%TYPE,
7: minimum_amount cn_pmt_plans.minimum_amount%TYPE,
8: maximum_amount cn_pmt_plans.maximum_amount%TYPE,
9: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,
10: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE,
11: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE,

Line 8: maximum_amount cn_pmt_plans.maximum_amount%TYPE,

4: TYPE PmtPlan_rec_type IS RECORD
5: ( org_id cn_pmt_plans.org_id%TYPE,
6: name cn_pmt_plans.name%TYPE,
7: minimum_amount cn_pmt_plans.minimum_amount%TYPE,
8: maximum_amount cn_pmt_plans.maximum_amount%TYPE,
9: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,
10: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE,
11: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE,
12: credit_type_name cn_credit_types.name%TYPE,

Line 9: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,

5: ( org_id cn_pmt_plans.org_id%TYPE,
6: name cn_pmt_plans.name%TYPE,
7: minimum_amount cn_pmt_plans.minimum_amount%TYPE,
8: maximum_amount cn_pmt_plans.maximum_amount%TYPE,
9: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,
10: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE,
11: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE,
12: credit_type_name cn_credit_types.name%TYPE,
13: pay_interval_type_name cn_interval_types.name%TYPE,

Line 10: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE,

6: name cn_pmt_plans.name%TYPE,
7: minimum_amount cn_pmt_plans.minimum_amount%TYPE,
8: maximum_amount cn_pmt_plans.maximum_amount%TYPE,
9: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,
10: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE,
11: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE,
12: credit_type_name cn_credit_types.name%TYPE,
13: pay_interval_type_name cn_interval_types.name%TYPE,
14: start_date cn_pmt_plans.start_date%TYPE,

Line 11: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE,

7: minimum_amount cn_pmt_plans.minimum_amount%TYPE,
8: maximum_amount cn_pmt_plans.maximum_amount%TYPE,
9: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,
10: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE,
11: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE,
12: credit_type_name cn_credit_types.name%TYPE,
13: pay_interval_type_name cn_interval_types.name%TYPE,
14: start_date cn_pmt_plans.start_date%TYPE,
15: end_date cn_pmt_plans.end_date%TYPE,

Line 14: start_date cn_pmt_plans.start_date%TYPE,

10: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE,
11: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE,
12: credit_type_name cn_credit_types.name%TYPE,
13: pay_interval_type_name cn_interval_types.name%TYPE,
14: start_date cn_pmt_plans.start_date%TYPE,
15: end_date cn_pmt_plans.end_date%TYPE,
16: object_version_number NUMBER := null,
17: recoverable_interval_type cn_interval_types_all_tl.name%TYPE,
18: pay_against_commission cn_pmt_plans.pay_against_commission%TYPE,

Line 15: end_date cn_pmt_plans.end_date%TYPE,

11: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE,
12: credit_type_name cn_credit_types.name%TYPE,
13: pay_interval_type_name cn_interval_types.name%TYPE,
14: start_date cn_pmt_plans.start_date%TYPE,
15: end_date cn_pmt_plans.end_date%TYPE,
16: object_version_number NUMBER := null,
17: recoverable_interval_type cn_interval_types_all_tl.name%TYPE,
18: pay_against_commission cn_pmt_plans.pay_against_commission%TYPE,
19: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,

Line 18: pay_against_commission cn_pmt_plans.pay_against_commission%TYPE,

14: start_date cn_pmt_plans.start_date%TYPE,
15: end_date cn_pmt_plans.end_date%TYPE,
16: object_version_number NUMBER := null,
17: recoverable_interval_type cn_interval_types_all_tl.name%TYPE,
18: pay_against_commission cn_pmt_plans.pay_against_commission%TYPE,
19: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
20: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
21: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
22: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,

Line 19: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,

15: end_date cn_pmt_plans.end_date%TYPE,
16: object_version_number NUMBER := null,
17: recoverable_interval_type cn_interval_types_all_tl.name%TYPE,
18: pay_against_commission cn_pmt_plans.pay_against_commission%TYPE,
19: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
20: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
21: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
22: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
23: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,

Line 20: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,

16: object_version_number NUMBER := null,
17: recoverable_interval_type cn_interval_types_all_tl.name%TYPE,
18: pay_against_commission cn_pmt_plans.pay_against_commission%TYPE,
19: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
20: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
21: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
22: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
23: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
24: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,

Line 21: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,

17: recoverable_interval_type cn_interval_types_all_tl.name%TYPE,
18: pay_against_commission cn_pmt_plans.pay_against_commission%TYPE,
19: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
20: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
21: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
22: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
23: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
24: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
25: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,

Line 22: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,

18: pay_against_commission cn_pmt_plans.pay_against_commission%TYPE,
19: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
20: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
21: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
22: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
23: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
24: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
25: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
26: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,

Line 23: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,

19: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
20: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
21: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
22: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
23: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
24: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
25: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
26: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
27: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,

Line 24: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,

20: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
21: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
22: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
23: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
24: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
25: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
26: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
27: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
28: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,

Line 25: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,

21: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
22: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
23: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
24: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
25: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
26: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
27: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
28: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
29: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,

Line 26: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,

22: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
23: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
24: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
25: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
26: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
27: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
28: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
29: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
30: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,

Line 27: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,

23: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
24: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
25: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
26: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
27: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
28: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
29: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
30: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
31: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,

Line 28: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,

24: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
25: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
26: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
27: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
28: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
29: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
30: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
31: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
32: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,

Line 29: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,

25: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
26: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
27: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
28: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
29: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
30: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
31: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
32: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
33: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,

Line 30: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,

26: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
27: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
28: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
29: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
30: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
31: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
32: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
33: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
34: attribute15 cn_pmt_plans.attribute15%TYPE := NULL,

Line 31: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,

27: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
28: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
29: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
30: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
31: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
32: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
33: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
34: attribute15 cn_pmt_plans.attribute15%TYPE := NULL,
35: payment_group_code cn_pmt_plans.payment_group_code%TYPE := NULL

Line 32: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,

28: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
29: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
30: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
31: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
32: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
33: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
34: attribute15 cn_pmt_plans.attribute15%TYPE := NULL,
35: payment_group_code cn_pmt_plans.payment_group_code%TYPE := NULL
36: );

Line 33: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,

29: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
30: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
31: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
32: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
33: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
34: attribute15 cn_pmt_plans.attribute15%TYPE := NULL,
35: payment_group_code cn_pmt_plans.payment_group_code%TYPE := NULL
36: );
37:

Line 34: attribute15 cn_pmt_plans.attribute15%TYPE := NULL,

30: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
31: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
32: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
33: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
34: attribute15 cn_pmt_plans.attribute15%TYPE := NULL,
35: payment_group_code cn_pmt_plans.payment_group_code%TYPE := NULL
36: );
37:
38:

Line 35: payment_group_code cn_pmt_plans.payment_group_code%TYPE := NULL

31: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
32: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
33: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
34: attribute15 cn_pmt_plans.attribute15%TYPE := NULL,
35: payment_group_code cn_pmt_plans.payment_group_code%TYPE := NULL
36: );
37:
38:
39: /*

Line 41: ( name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char,

37:
38:
39: /*
40: TYPE PmtPlan_rec_type IS RECORD
41: ( name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char,
42: minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num,
43: maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num,
44: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char,
45: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char,

Line 42: minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num,

38:
39: /*
40: TYPE PmtPlan_rec_type IS RECORD
41: ( name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char,
42: minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num,
43: maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num,
44: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char,
45: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char,
46: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num,

Line 43: maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num,

39: /*
40: TYPE PmtPlan_rec_type IS RECORD
41: ( name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char,
42: minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num,
43: maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num,
44: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char,
45: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char,
46: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num,
47: credit_type_name cn_credit_types.name%TYPE := fnd_api.g_miss_num,

Line 44: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char,

40: TYPE PmtPlan_rec_type IS RECORD
41: ( name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char,
42: minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num,
43: maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num,
44: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char,
45: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char,
46: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num,
47: credit_type_name cn_credit_types.name%TYPE := fnd_api.g_miss_num,
48: pay_interval_type_name cn_interval_types.name%TYPE := fnd_api.g_miss_char,

Line 45: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char,

41: ( name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char,
42: minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num,
43: maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num,
44: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char,
45: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char,
46: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num,
47: credit_type_name cn_credit_types.name%TYPE := fnd_api.g_miss_num,
48: pay_interval_type_name cn_interval_types.name%TYPE := fnd_api.g_miss_char,
49: start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date,

Line 46: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num,

42: minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num,
43: maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num,
44: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char,
45: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char,
46: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num,
47: credit_type_name cn_credit_types.name%TYPE := fnd_api.g_miss_num,
48: pay_interval_type_name cn_interval_types.name%TYPE := fnd_api.g_miss_char,
49: start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date,
50: end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date,

Line 49: start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date,

45: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char,
46: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num,
47: credit_type_name cn_credit_types.name%TYPE := fnd_api.g_miss_num,
48: pay_interval_type_name cn_interval_types.name%TYPE := fnd_api.g_miss_char,
49: start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date,
50: end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date,
51: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
52: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
53: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,

Line 50: end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date,

46: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num,
47: credit_type_name cn_credit_types.name%TYPE := fnd_api.g_miss_num,
48: pay_interval_type_name cn_interval_types.name%TYPE := fnd_api.g_miss_char,
49: start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date,
50: end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date,
51: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
52: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
53: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
54: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,

Line 51: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,

47: credit_type_name cn_credit_types.name%TYPE := fnd_api.g_miss_num,
48: pay_interval_type_name cn_interval_types.name%TYPE := fnd_api.g_miss_char,
49: start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date,
50: end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date,
51: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
52: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
53: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
54: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
55: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,

Line 52: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,

48: pay_interval_type_name cn_interval_types.name%TYPE := fnd_api.g_miss_char,
49: start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date,
50: end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date,
51: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
52: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
53: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
54: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
55: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
56: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,

Line 53: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,

49: start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date,
50: end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date,
51: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
52: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
53: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
54: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
55: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
56: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
57: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,

Line 54: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,

50: end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date,
51: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
52: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
53: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
54: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
55: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
56: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
57: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
58: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,

Line 55: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,

51: attribute_category cn_pmt_plans.attribute_category%TYPE := NULL,
52: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
53: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
54: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
55: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
56: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
57: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
58: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
59: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,

Line 56: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,

52: attribute1 cn_pmt_plans.attribute1%TYPE := NULL,
53: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
54: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
55: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
56: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
57: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
58: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
59: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
60: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,

Line 57: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,

53: attribute2 cn_pmt_plans.attribute2%TYPE := NULL,
54: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
55: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
56: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
57: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
58: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
59: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
60: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
61: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,

Line 58: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,

54: attribute3 cn_pmt_plans.attribute3%TYPE := NULL,
55: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
56: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
57: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
58: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
59: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
60: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
61: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
62: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,

Line 59: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,

55: attribute4 cn_pmt_plans.attribute4%TYPE := NULL,
56: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
57: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
58: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
59: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
60: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
61: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
62: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
63: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,

Line 60: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,

56: attribute5 cn_pmt_plans.attribute5%TYPE := NULL,
57: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
58: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
59: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
60: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
61: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
62: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
63: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
64: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,

Line 61: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,

57: attribute6 cn_pmt_plans.attribute6%TYPE := NULL,
58: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
59: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
60: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
61: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
62: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
63: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
64: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
65: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,

Line 62: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,

58: attribute7 cn_pmt_plans.attribute7%TYPE := NULL,
59: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
60: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
61: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
62: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
63: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
64: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
65: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
66: attribute15 cn_pmt_plans.attribute15%TYPE := NULL

Line 63: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,

59: attribute8 cn_pmt_plans.attribute8%TYPE := NULL,
60: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
61: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
62: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
63: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
64: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
65: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
66: attribute15 cn_pmt_plans.attribute15%TYPE := NULL
67: );

Line 64: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,

60: attribute9 cn_pmt_plans.attribute9%TYPE := NULL,
61: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
62: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
63: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
64: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
65: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
66: attribute15 cn_pmt_plans.attribute15%TYPE := NULL
67: );
68: */

Line 65: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,

61: attribute10 cn_pmt_plans.attribute10%TYPE := NULL,
62: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
63: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
64: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
65: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
66: attribute15 cn_pmt_plans.attribute15%TYPE := NULL
67: );
68: */
69:

Line 66: attribute15 cn_pmt_plans.attribute15%TYPE := NULL

62: attribute11 cn_pmt_plans.attribute11%TYPE := NULL,
63: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
64: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
65: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
66: attribute15 cn_pmt_plans.attribute15%TYPE := NULL
67: );
68: */
69:
70: g_mode VARCHAR2(30); --global to indicate if operation is insert/update