DBA Data[Home] [Help]

APPS.CN_PMTPLAN_PVT dependencies on CN_PMT_PLANS

Line 5: ( org_id cn_pmt_plans.org_id%TYPE,

1: PACKAGE CN_PMTPLAN_PVT AUTHID CURRENT_USER as
2: -- $Header: cnvpplns.pls 120.5 2005/07/20 07:40:25 raramasa ship $
3:
4: TYPE PmtPlan_rec_type IS RECORD
5: ( org_id cn_pmt_plans.org_id%TYPE,
6: pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE,
7: name cn_pmt_plans.name%TYPE,
8: minimum_amount cn_pmt_plans.minimum_amount%TYPE,
9: maximum_amount cn_pmt_plans.maximum_amount%TYPE,

Line 6: pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE,

2: -- $Header: cnvpplns.pls 120.5 2005/07/20 07:40:25 raramasa ship $
3:
4: TYPE PmtPlan_rec_type IS RECORD
5: ( org_id cn_pmt_plans.org_id%TYPE,
6: pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE,
7: name cn_pmt_plans.name%TYPE,
8: minimum_amount cn_pmt_plans.minimum_amount%TYPE,
9: maximum_amount cn_pmt_plans.maximum_amount%TYPE,
10: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,

Line 7: name cn_pmt_plans.name%TYPE,

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

Line 8: minimum_amount cn_pmt_plans.minimum_amount%TYPE,

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

Line 9: maximum_amount cn_pmt_plans.maximum_amount%TYPE,

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

Line 10: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,

6: pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE,
7: name cn_pmt_plans.name%TYPE,
8: minimum_amount cn_pmt_plans.minimum_amount%TYPE,
9: maximum_amount cn_pmt_plans.maximum_amount%TYPE,
10: min_rec_flag cn_pmt_plans.min_rec_flag%TYPE,
11: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE,
12: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE,
13: credit_type_name cn_credit_types_all_tl.name%TYPE,
14: pay_interval_type_name cn_interval_types_all_tl.name%TYPE,

Line 11: max_rec_flag cn_pmt_plans.max_rec_flag%TYPE,

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

Line 12: max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE,

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

Line 15: start_date cn_pmt_plans.start_date%TYPE,

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

Line 16: end_date cn_pmt_plans.end_date%TYPE,

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

Line 19: pay_against_commission cn_pmt_plans.pay_against_commission%TYPE,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 36: payment_group_code cn_pmt_plans.payment_group_code%TYPE,

32: attribute12 cn_pmt_plans.attribute12%TYPE := NULL,
33: attribute13 cn_pmt_plans.attribute13%TYPE := NULL,
34: attribute14 cn_pmt_plans.attribute14%TYPE := NULL,
35: attribute15 cn_pmt_plans.attribute15%TYPE := NULL,
36: payment_group_code cn_pmt_plans.payment_group_code%TYPE,
37: operation_mode varchar2(30)
38: );
39:
40: