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_PMT_PLANS_PKG dependencies on CN_PMT_PLANS

Line 1: PACKAGE BODY CN_PMT_PLANS_PKG as

1: PACKAGE BODY CN_PMT_PLANS_PKG as
2: -- $Header: cnpplntb.pls 120.2 2005/10/06 00:38:29 raramasa ship $
3:
4:
5: g_temp_status_code VARCHAR2(30) := NULL;

Line 17: SELECT cn_pmt_plans_s.nextval

13: PROCEDURE Get_UID( X_pmt_plan_id IN OUT NOCOPY NUMBER) IS
14:
15: BEGIN
16:
17: SELECT cn_pmt_plans_s.nextval
18: INTO X_pmt_plan_id
19: FROM sys.dual;
20:
21: END Get_UID;

Line 31: ,x_org_id cn_pmt_plans.org_id%TYPE

27: --*****************************************************************************
28:
29: PROCEDURE Insert_Record(
30: x_Rowid IN OUT NOCOPY VARCHAR2
31: ,x_org_id cn_pmt_plans.org_id%TYPE
32: ,x_pmt_plan_id IN OUT NOCOPY NUMBER
33: ,x_name cn_pmt_plans.name%TYPE
34: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
35: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE

Line 33: ,x_name cn_pmt_plans.name%TYPE

29: PROCEDURE Insert_Record(
30: x_Rowid IN OUT NOCOPY VARCHAR2
31: ,x_org_id cn_pmt_plans.org_id%TYPE
32: ,x_pmt_plan_id IN OUT NOCOPY NUMBER
33: ,x_name cn_pmt_plans.name%TYPE
34: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
35: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
36: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE

Line 34: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE

30: x_Rowid IN OUT NOCOPY VARCHAR2
31: ,x_org_id cn_pmt_plans.org_id%TYPE
32: ,x_pmt_plan_id IN OUT NOCOPY NUMBER
33: ,x_name cn_pmt_plans.name%TYPE
34: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
35: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
36: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE

Line 35: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE

31: ,x_org_id cn_pmt_plans.org_id%TYPE
32: ,x_pmt_plan_id IN OUT NOCOPY NUMBER
33: ,x_name cn_pmt_plans.name%TYPE
34: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
35: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
36: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE

Line 36: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE

32: ,x_pmt_plan_id IN OUT NOCOPY NUMBER
33: ,x_name cn_pmt_plans.name%TYPE
34: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
35: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
36: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE

Line 37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE

33: ,x_name cn_pmt_plans.name%TYPE
34: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
35: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
36: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
41: ,x_start_date cn_pmt_plans.start_date%TYPE

Line 38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE

34: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
35: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
36: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
41: ,x_start_date cn_pmt_plans.start_date%TYPE
42: ,x_end_date cn_pmt_plans.end_date%TYPE

Line 39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE

35: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
36: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
41: ,x_start_date cn_pmt_plans.start_date%TYPE
42: ,x_end_date cn_pmt_plans.end_date%TYPE
43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE

Line 40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE

36: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
41: ,x_start_date cn_pmt_plans.start_date%TYPE
42: ,x_end_date cn_pmt_plans.end_date%TYPE
43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE

Line 41: ,x_start_date cn_pmt_plans.start_date%TYPE

37: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
41: ,x_start_date cn_pmt_plans.start_date%TYPE
42: ,x_end_date cn_pmt_plans.end_date%TYPE
43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE

Line 42: ,x_end_date cn_pmt_plans.end_date%TYPE

38: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
41: ,x_start_date cn_pmt_plans.start_date%TYPE
42: ,x_end_date cn_pmt_plans.end_date%TYPE
43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
46: ,x_attribute1 cn_pmt_plans.attribute1%TYPE

Line 43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE

39: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
41: ,x_start_date cn_pmt_plans.start_date%TYPE
42: ,x_end_date cn_pmt_plans.end_date%TYPE
43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
46: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
47: ,x_attribute2 cn_pmt_plans.attribute2%TYPE

Line 44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE

40: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
41: ,x_start_date cn_pmt_plans.start_date%TYPE
42: ,x_end_date cn_pmt_plans.end_date%TYPE
43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
46: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
47: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
48: ,x_attribute3 cn_pmt_plans.attribute3%TYPE

Line 45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE

41: ,x_start_date cn_pmt_plans.start_date%TYPE
42: ,x_end_date cn_pmt_plans.end_date%TYPE
43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
46: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
47: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
48: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
49: ,x_attribute4 cn_pmt_plans.attribute4%TYPE

Line 46: ,x_attribute1 cn_pmt_plans.attribute1%TYPE

42: ,x_end_date cn_pmt_plans.end_date%TYPE
43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
46: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
47: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
48: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
49: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
50: ,x_attribute5 cn_pmt_plans.attribute5%TYPE

Line 47: ,x_attribute2 cn_pmt_plans.attribute2%TYPE

43: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
46: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
47: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
48: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
49: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
50: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
51: ,x_attribute6 cn_pmt_plans.attribute6%TYPE

Line 48: ,x_attribute3 cn_pmt_plans.attribute3%TYPE

44: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
46: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
47: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
48: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
49: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
50: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
51: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
52: ,x_attribute7 cn_pmt_plans.attribute7%TYPE

Line 49: ,x_attribute4 cn_pmt_plans.attribute4%TYPE

45: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
46: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
47: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
48: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
49: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
50: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
51: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
52: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
53: ,x_attribute8 cn_pmt_plans.attribute8%TYPE

Line 50: ,x_attribute5 cn_pmt_plans.attribute5%TYPE

46: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
47: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
48: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
49: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
50: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
51: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
52: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
53: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
54: ,x_attribute9 cn_pmt_plans.attribute9%TYPE

Line 51: ,x_attribute6 cn_pmt_plans.attribute6%TYPE

47: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
48: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
49: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
50: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
51: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
52: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
53: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
54: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
55: ,x_attribute10 cn_pmt_plans.attribute10%TYPE

Line 52: ,x_attribute7 cn_pmt_plans.attribute7%TYPE

48: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
49: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
50: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
51: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
52: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
53: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
54: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
55: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
56: ,x_attribute11 cn_pmt_plans.attribute11%TYPE

Line 53: ,x_attribute8 cn_pmt_plans.attribute8%TYPE

49: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
50: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
51: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
52: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
53: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
54: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
55: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
56: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
57: ,x_attribute12 cn_pmt_plans.attribute12%TYPE

Line 54: ,x_attribute9 cn_pmt_plans.attribute9%TYPE

50: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
51: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
52: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
53: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
54: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
55: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
56: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
57: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
58: ,x_attribute13 cn_pmt_plans.attribute13%TYPE

Line 55: ,x_attribute10 cn_pmt_plans.attribute10%TYPE

51: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
52: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
53: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
54: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
55: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
56: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
57: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
58: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
59: ,x_attribute14 cn_pmt_plans.attribute14%TYPE

Line 56: ,x_attribute11 cn_pmt_plans.attribute11%TYPE

52: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
53: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
54: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
55: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
56: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
57: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
58: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
59: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
60: ,x_attribute15 cn_pmt_plans.attribute15%TYPE

Line 57: ,x_attribute12 cn_pmt_plans.attribute12%TYPE

53: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
54: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
55: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
56: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
57: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
58: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
59: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
60: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
61: ,x_Created_By cn_pmt_plans.created_by%TYPE

Line 58: ,x_attribute13 cn_pmt_plans.attribute13%TYPE

54: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
55: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
56: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
57: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
58: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
59: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
60: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
61: ,x_Created_By cn_pmt_plans.created_by%TYPE
62: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE

Line 59: ,x_attribute14 cn_pmt_plans.attribute14%TYPE

55: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
56: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
57: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
58: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
59: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
60: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
61: ,x_Created_By cn_pmt_plans.created_by%TYPE
62: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
63: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE

Line 60: ,x_attribute15 cn_pmt_plans.attribute15%TYPE

56: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
57: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
58: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
59: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
60: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
61: ,x_Created_By cn_pmt_plans.created_by%TYPE
62: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
63: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
64: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE

Line 61: ,x_Created_By cn_pmt_plans.created_by%TYPE

57: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
58: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
59: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
60: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
61: ,x_Created_By cn_pmt_plans.created_by%TYPE
62: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
63: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
64: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
65: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE

Line 62: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE

58: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
59: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
60: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
61: ,x_Created_By cn_pmt_plans.created_by%TYPE
62: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
63: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
64: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
65: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
66: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE

Line 63: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE

59: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
60: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
61: ,x_Created_By cn_pmt_plans.created_by%TYPE
62: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
63: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
64: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
65: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
66: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE
67: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE

Line 64: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE

60: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
61: ,x_Created_By cn_pmt_plans.created_by%TYPE
62: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
63: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
64: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
65: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
66: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE
67: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
68: )

Line 65: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE

61: ,x_Created_By cn_pmt_plans.created_by%TYPE
62: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
63: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
64: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
65: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
66: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE
67: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
68: )
69: IS

Line 66: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE

62: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
63: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
64: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
65: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
66: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE
67: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
68: )
69: IS
70:

Line 67: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE

63: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
64: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
65: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
66: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE
67: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
68: )
69: IS
70:
71: BEGIN

Line 80: INSERT INTO cn_pmt_plans(

76: END IF;
77:
78: x_object_version_number := 1;
79:
80: INSERT INTO cn_pmt_plans(
81: org_id
82: ,pmt_plan_id
83: ,name
84: ,minimum_amount

Line 172: FROM cn_pmt_plans

168: ,x_pmt_plan_id NUMBER) IS
169:
170: CURSOR C IS
171: SELECT *
172: FROM cn_pmt_plans
173: WHERE pmt_plan_id = x_pmt_plan_id
174: FOR UPDATE of pmt_plan_id NOWAIT;
175: Recinfo C%ROWTYPE;
176:

Line 205: x_org_id cn_pmt_plans.org_id%TYPE

201: -- Purpose : To Update the Payment Plans
202: --*****************************************************************************
203:
204: PROCEDURE Update_Record(
205: x_org_id cn_pmt_plans.org_id%TYPE
206: ,x_pmt_plan_id NUMBER
207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num

Line 207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char

203:
204: PROCEDURE Update_Record(
205: x_org_id cn_pmt_plans.org_id%TYPE
206: ,x_pmt_plan_id NUMBER
207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char

Line 208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num

204: PROCEDURE Update_Record(
205: x_org_id cn_pmt_plans.org_id%TYPE
206: ,x_pmt_plan_id NUMBER
207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char

Line 209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num

205: x_org_id cn_pmt_plans.org_id%TYPE
206: ,x_pmt_plan_id NUMBER
207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id

Line 210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num

206: ,x_pmt_plan_id NUMBER
207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id

Line 211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char

207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date

Line 212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char

208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date

Line 213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id

209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE

Line 214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id

210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char

Line 215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date

211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char

Line 216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date

212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char

Line 217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE

213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char

Line 218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char

214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char

Line 219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char

215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char

Line 220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char

216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char

Line 221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char

217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char

Line 222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char

218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char

Line 223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char

219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char

Line 224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char

220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char

Line 225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char

221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char

Line 226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char

222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char

Line 227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char

223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char

Line 228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char

224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char

Line 229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char

225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char

Line 230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char

226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char

Line 231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char

227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char

Line 232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char

228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE

Line 233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char

229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE

Line 234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char

230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE

Line 235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char

231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char

Line 236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE

232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char
240: ) IS

Line 237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE

233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char
240: ) IS
241:

Line 238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE

234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char
240: ) IS
241:
242: l_org_id cn_pmt_plans.org_id%TYPE;

Line 239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char

235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char
240: ) IS
241:
242: l_org_id cn_pmt_plans.org_id%TYPE;
243: l_name cn_pmt_plans.name%TYPE;

Line 242: l_org_id cn_pmt_plans.org_id%TYPE;

238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char
240: ) IS
241:
242: l_org_id cn_pmt_plans.org_id%TYPE;
243: l_name cn_pmt_plans.name%TYPE;
244: l_minimum_amount cn_pmt_plans.minimum_amount%TYPE;
245: l_maximum_amount cn_pmt_plans.maximum_amount%TYPE;
246: l_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE;

Line 243: l_name cn_pmt_plans.name%TYPE;

239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char
240: ) IS
241:
242: l_org_id cn_pmt_plans.org_id%TYPE;
243: l_name cn_pmt_plans.name%TYPE;
244: l_minimum_amount cn_pmt_plans.minimum_amount%TYPE;
245: l_maximum_amount cn_pmt_plans.maximum_amount%TYPE;
246: l_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE;
247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;

Line 244: l_minimum_amount cn_pmt_plans.minimum_amount%TYPE;

240: ) IS
241:
242: l_org_id cn_pmt_plans.org_id%TYPE;
243: l_name cn_pmt_plans.name%TYPE;
244: l_minimum_amount cn_pmt_plans.minimum_amount%TYPE;
245: l_maximum_amount cn_pmt_plans.maximum_amount%TYPE;
246: l_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE;
247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;
248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;

Line 245: l_maximum_amount cn_pmt_plans.maximum_amount%TYPE;

241:
242: l_org_id cn_pmt_plans.org_id%TYPE;
243: l_name cn_pmt_plans.name%TYPE;
244: l_minimum_amount cn_pmt_plans.minimum_amount%TYPE;
245: l_maximum_amount cn_pmt_plans.maximum_amount%TYPE;
246: l_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE;
247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;
248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;
249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;

Line 246: l_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE;

242: l_org_id cn_pmt_plans.org_id%TYPE;
243: l_name cn_pmt_plans.name%TYPE;
244: l_minimum_amount cn_pmt_plans.minimum_amount%TYPE;
245: l_maximum_amount cn_pmt_plans.maximum_amount%TYPE;
246: l_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE;
247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;
248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;
249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;
250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;

Line 247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;

243: l_name cn_pmt_plans.name%TYPE;
244: l_minimum_amount cn_pmt_plans.minimum_amount%TYPE;
245: l_maximum_amount cn_pmt_plans.maximum_amount%TYPE;
246: l_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE;
247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;
248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;
249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;
250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;
251: l_start_date cn_pmt_plans.start_date%TYPE;

Line 248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;

244: l_minimum_amount cn_pmt_plans.minimum_amount%TYPE;
245: l_maximum_amount cn_pmt_plans.maximum_amount%TYPE;
246: l_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE;
247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;
248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;
249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;
250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;
251: l_start_date cn_pmt_plans.start_date%TYPE;
252: l_end_date cn_pmt_plans.end_date%TYPE;

Line 249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;

245: l_maximum_amount cn_pmt_plans.maximum_amount%TYPE;
246: l_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE;
247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;
248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;
249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;
250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;
251: l_start_date cn_pmt_plans.start_date%TYPE;
252: l_end_date cn_pmt_plans.end_date%TYPE;
253: l_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE;

Line 250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;

246: l_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE;
247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;
248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;
249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;
250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;
251: l_start_date cn_pmt_plans.start_date%TYPE;
252: l_end_date cn_pmt_plans.end_date%TYPE;
253: l_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE;
254: l_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE;

Line 251: l_start_date cn_pmt_plans.start_date%TYPE;

247: l_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE;
248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;
249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;
250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;
251: l_start_date cn_pmt_plans.start_date%TYPE;
252: l_end_date cn_pmt_plans.end_date%TYPE;
253: l_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE;
254: l_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE;
255: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;

Line 252: l_end_date cn_pmt_plans.end_date%TYPE;

248: l_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE;
249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;
250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;
251: l_start_date cn_pmt_plans.start_date%TYPE;
252: l_end_date cn_pmt_plans.end_date%TYPE;
253: l_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE;
254: l_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE;
255: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
256:

Line 253: l_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE;

249: l_credit_type_id cn_pmt_plans.credit_type_id%TYPE;
250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;
251: l_start_date cn_pmt_plans.start_date%TYPE;
252: l_end_date cn_pmt_plans.end_date%TYPE;
253: l_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE;
254: l_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE;
255: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
256:
257: l_attribute_category cn_pmt_plans.attribute_category%TYPE;

Line 254: l_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE;

250: l_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE;
251: l_start_date cn_pmt_plans.start_date%TYPE;
252: l_end_date cn_pmt_plans.end_date%TYPE;
253: l_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE;
254: l_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE;
255: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
256:
257: l_attribute_category cn_pmt_plans.attribute_category%TYPE;
258: l_attribute1 cn_pmt_plans.attribute1%TYPE;

Line 255: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;

251: l_start_date cn_pmt_plans.start_date%TYPE;
252: l_end_date cn_pmt_plans.end_date%TYPE;
253: l_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE;
254: l_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE;
255: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
256:
257: l_attribute_category cn_pmt_plans.attribute_category%TYPE;
258: l_attribute1 cn_pmt_plans.attribute1%TYPE;
259: l_attribute2 cn_pmt_plans.attribute2%TYPE;

Line 257: l_attribute_category cn_pmt_plans.attribute_category%TYPE;

253: l_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE;
254: l_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE;
255: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
256:
257: l_attribute_category cn_pmt_plans.attribute_category%TYPE;
258: l_attribute1 cn_pmt_plans.attribute1%TYPE;
259: l_attribute2 cn_pmt_plans.attribute2%TYPE;
260: l_attribute3 cn_pmt_plans.attribute3%TYPE;
261: l_attribute4 cn_pmt_plans.attribute4%TYPE;

Line 258: l_attribute1 cn_pmt_plans.attribute1%TYPE;

254: l_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE;
255: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
256:
257: l_attribute_category cn_pmt_plans.attribute_category%TYPE;
258: l_attribute1 cn_pmt_plans.attribute1%TYPE;
259: l_attribute2 cn_pmt_plans.attribute2%TYPE;
260: l_attribute3 cn_pmt_plans.attribute3%TYPE;
261: l_attribute4 cn_pmt_plans.attribute4%TYPE;
262: l_attribute5 cn_pmt_plans.attribute5%TYPE;

Line 259: l_attribute2 cn_pmt_plans.attribute2%TYPE;

255: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
256:
257: l_attribute_category cn_pmt_plans.attribute_category%TYPE;
258: l_attribute1 cn_pmt_plans.attribute1%TYPE;
259: l_attribute2 cn_pmt_plans.attribute2%TYPE;
260: l_attribute3 cn_pmt_plans.attribute3%TYPE;
261: l_attribute4 cn_pmt_plans.attribute4%TYPE;
262: l_attribute5 cn_pmt_plans.attribute5%TYPE;
263: l_attribute6 cn_pmt_plans.attribute6%TYPE;

Line 260: l_attribute3 cn_pmt_plans.attribute3%TYPE;

256:
257: l_attribute_category cn_pmt_plans.attribute_category%TYPE;
258: l_attribute1 cn_pmt_plans.attribute1%TYPE;
259: l_attribute2 cn_pmt_plans.attribute2%TYPE;
260: l_attribute3 cn_pmt_plans.attribute3%TYPE;
261: l_attribute4 cn_pmt_plans.attribute4%TYPE;
262: l_attribute5 cn_pmt_plans.attribute5%TYPE;
263: l_attribute6 cn_pmt_plans.attribute6%TYPE;
264: l_attribute7 cn_pmt_plans.attribute7%TYPE;

Line 261: l_attribute4 cn_pmt_plans.attribute4%TYPE;

257: l_attribute_category cn_pmt_plans.attribute_category%TYPE;
258: l_attribute1 cn_pmt_plans.attribute1%TYPE;
259: l_attribute2 cn_pmt_plans.attribute2%TYPE;
260: l_attribute3 cn_pmt_plans.attribute3%TYPE;
261: l_attribute4 cn_pmt_plans.attribute4%TYPE;
262: l_attribute5 cn_pmt_plans.attribute5%TYPE;
263: l_attribute6 cn_pmt_plans.attribute6%TYPE;
264: l_attribute7 cn_pmt_plans.attribute7%TYPE;
265: l_attribute8 cn_pmt_plans.attribute8%TYPE;

Line 262: l_attribute5 cn_pmt_plans.attribute5%TYPE;

258: l_attribute1 cn_pmt_plans.attribute1%TYPE;
259: l_attribute2 cn_pmt_plans.attribute2%TYPE;
260: l_attribute3 cn_pmt_plans.attribute3%TYPE;
261: l_attribute4 cn_pmt_plans.attribute4%TYPE;
262: l_attribute5 cn_pmt_plans.attribute5%TYPE;
263: l_attribute6 cn_pmt_plans.attribute6%TYPE;
264: l_attribute7 cn_pmt_plans.attribute7%TYPE;
265: l_attribute8 cn_pmt_plans.attribute8%TYPE;
266: l_attribute9 cn_pmt_plans.attribute9%TYPE;

Line 263: l_attribute6 cn_pmt_plans.attribute6%TYPE;

259: l_attribute2 cn_pmt_plans.attribute2%TYPE;
260: l_attribute3 cn_pmt_plans.attribute3%TYPE;
261: l_attribute4 cn_pmt_plans.attribute4%TYPE;
262: l_attribute5 cn_pmt_plans.attribute5%TYPE;
263: l_attribute6 cn_pmt_plans.attribute6%TYPE;
264: l_attribute7 cn_pmt_plans.attribute7%TYPE;
265: l_attribute8 cn_pmt_plans.attribute8%TYPE;
266: l_attribute9 cn_pmt_plans.attribute9%TYPE;
267: l_attribute10 cn_pmt_plans.attribute10%TYPE;

Line 264: l_attribute7 cn_pmt_plans.attribute7%TYPE;

260: l_attribute3 cn_pmt_plans.attribute3%TYPE;
261: l_attribute4 cn_pmt_plans.attribute4%TYPE;
262: l_attribute5 cn_pmt_plans.attribute5%TYPE;
263: l_attribute6 cn_pmt_plans.attribute6%TYPE;
264: l_attribute7 cn_pmt_plans.attribute7%TYPE;
265: l_attribute8 cn_pmt_plans.attribute8%TYPE;
266: l_attribute9 cn_pmt_plans.attribute9%TYPE;
267: l_attribute10 cn_pmt_plans.attribute10%TYPE;
268: l_attribute11 cn_pmt_plans.attribute11%TYPE;

Line 265: l_attribute8 cn_pmt_plans.attribute8%TYPE;

261: l_attribute4 cn_pmt_plans.attribute4%TYPE;
262: l_attribute5 cn_pmt_plans.attribute5%TYPE;
263: l_attribute6 cn_pmt_plans.attribute6%TYPE;
264: l_attribute7 cn_pmt_plans.attribute7%TYPE;
265: l_attribute8 cn_pmt_plans.attribute8%TYPE;
266: l_attribute9 cn_pmt_plans.attribute9%TYPE;
267: l_attribute10 cn_pmt_plans.attribute10%TYPE;
268: l_attribute11 cn_pmt_plans.attribute11%TYPE;
269: l_attribute12 cn_pmt_plans.attribute12%TYPE;

Line 266: l_attribute9 cn_pmt_plans.attribute9%TYPE;

262: l_attribute5 cn_pmt_plans.attribute5%TYPE;
263: l_attribute6 cn_pmt_plans.attribute6%TYPE;
264: l_attribute7 cn_pmt_plans.attribute7%TYPE;
265: l_attribute8 cn_pmt_plans.attribute8%TYPE;
266: l_attribute9 cn_pmt_plans.attribute9%TYPE;
267: l_attribute10 cn_pmt_plans.attribute10%TYPE;
268: l_attribute11 cn_pmt_plans.attribute11%TYPE;
269: l_attribute12 cn_pmt_plans.attribute12%TYPE;
270: l_attribute13 cn_pmt_plans.attribute13%TYPE;

Line 267: l_attribute10 cn_pmt_plans.attribute10%TYPE;

263: l_attribute6 cn_pmt_plans.attribute6%TYPE;
264: l_attribute7 cn_pmt_plans.attribute7%TYPE;
265: l_attribute8 cn_pmt_plans.attribute8%TYPE;
266: l_attribute9 cn_pmt_plans.attribute9%TYPE;
267: l_attribute10 cn_pmt_plans.attribute10%TYPE;
268: l_attribute11 cn_pmt_plans.attribute11%TYPE;
269: l_attribute12 cn_pmt_plans.attribute12%TYPE;
270: l_attribute13 cn_pmt_plans.attribute13%TYPE;
271: l_attribute14 cn_pmt_plans.attribute14%TYPE;

Line 268: l_attribute11 cn_pmt_plans.attribute11%TYPE;

264: l_attribute7 cn_pmt_plans.attribute7%TYPE;
265: l_attribute8 cn_pmt_plans.attribute8%TYPE;
266: l_attribute9 cn_pmt_plans.attribute9%TYPE;
267: l_attribute10 cn_pmt_plans.attribute10%TYPE;
268: l_attribute11 cn_pmt_plans.attribute11%TYPE;
269: l_attribute12 cn_pmt_plans.attribute12%TYPE;
270: l_attribute13 cn_pmt_plans.attribute13%TYPE;
271: l_attribute14 cn_pmt_plans.attribute14%TYPE;
272: l_attribute15 cn_pmt_plans.attribute15%TYPE;

Line 269: l_attribute12 cn_pmt_plans.attribute12%TYPE;

265: l_attribute8 cn_pmt_plans.attribute8%TYPE;
266: l_attribute9 cn_pmt_plans.attribute9%TYPE;
267: l_attribute10 cn_pmt_plans.attribute10%TYPE;
268: l_attribute11 cn_pmt_plans.attribute11%TYPE;
269: l_attribute12 cn_pmt_plans.attribute12%TYPE;
270: l_attribute13 cn_pmt_plans.attribute13%TYPE;
271: l_attribute14 cn_pmt_plans.attribute14%TYPE;
272: l_attribute15 cn_pmt_plans.attribute15%TYPE;
273:

Line 270: l_attribute13 cn_pmt_plans.attribute13%TYPE;

266: l_attribute9 cn_pmt_plans.attribute9%TYPE;
267: l_attribute10 cn_pmt_plans.attribute10%TYPE;
268: l_attribute11 cn_pmt_plans.attribute11%TYPE;
269: l_attribute12 cn_pmt_plans.attribute12%TYPE;
270: l_attribute13 cn_pmt_plans.attribute13%TYPE;
271: l_attribute14 cn_pmt_plans.attribute14%TYPE;
272: l_attribute15 cn_pmt_plans.attribute15%TYPE;
273:
274: CURSOR pmt_plan_cur IS

Line 271: l_attribute14 cn_pmt_plans.attribute14%TYPE;

267: l_attribute10 cn_pmt_plans.attribute10%TYPE;
268: l_attribute11 cn_pmt_plans.attribute11%TYPE;
269: l_attribute12 cn_pmt_plans.attribute12%TYPE;
270: l_attribute13 cn_pmt_plans.attribute13%TYPE;
271: l_attribute14 cn_pmt_plans.attribute14%TYPE;
272: l_attribute15 cn_pmt_plans.attribute15%TYPE;
273:
274: CURSOR pmt_plan_cur IS
275: SELECT *

Line 272: l_attribute15 cn_pmt_plans.attribute15%TYPE;

268: l_attribute11 cn_pmt_plans.attribute11%TYPE;
269: l_attribute12 cn_pmt_plans.attribute12%TYPE;
270: l_attribute13 cn_pmt_plans.attribute13%TYPE;
271: l_attribute14 cn_pmt_plans.attribute14%TYPE;
272: l_attribute15 cn_pmt_plans.attribute15%TYPE;
273:
274: CURSOR pmt_plan_cur IS
275: SELECT *
276: FROM cn_pmt_plans

Line 276: FROM cn_pmt_plans

272: l_attribute15 cn_pmt_plans.attribute15%TYPE;
273:
274: CURSOR pmt_plan_cur IS
275: SELECT *
276: FROM cn_pmt_plans
277: WHERE pmt_plan_id = x_pmt_plan_id;
278:
279: l_pmt_plan_rec pmt_plan_cur%ROWTYPE;
280:

Line 404: UPDATE cn_pmt_plans

400: l_attribute15,
401: l_payment_group_code
402: FROM dual;
403:
404: UPDATE cn_pmt_plans
405: SET
406: name = l_name,
407: minimum_amount = l_minimum_amount,
408: maximum_amount = l_maximum_amount,

Line 460: DELETE FROM cn_pmt_plans

456:
457: PROCEDURE Delete_Record( x_pmt_plan_id NUMBER ) IS
458: BEGIN
459:
460: DELETE FROM cn_pmt_plans
461: WHERE pmt_plan_id = x_pmt_plan_id;
462:
463:
464: END Delete_Record;

Line 479: ,x_org_id cn_pmt_plans.org_id%TYPE

475:
476: PROCEDURE Begin_Record(
477: x_Operation VARCHAR2
478: ,x_Rowid IN OUT NOCOPY VARCHAR2
479: ,x_org_id cn_pmt_plans.org_id%TYPE
480: ,x_pmt_plan_id IN OUT NOCOPY NUMBER
481: ,x_name cn_pmt_plans.name%TYPE
482: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
483: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE

Line 481: ,x_name cn_pmt_plans.name%TYPE

477: x_Operation VARCHAR2
478: ,x_Rowid IN OUT NOCOPY VARCHAR2
479: ,x_org_id cn_pmt_plans.org_id%TYPE
480: ,x_pmt_plan_id IN OUT NOCOPY NUMBER
481: ,x_name cn_pmt_plans.name%TYPE
482: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
483: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
484: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE

Line 482: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE

478: ,x_Rowid IN OUT NOCOPY VARCHAR2
479: ,x_org_id cn_pmt_plans.org_id%TYPE
480: ,x_pmt_plan_id IN OUT NOCOPY NUMBER
481: ,x_name cn_pmt_plans.name%TYPE
482: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
483: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
484: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE

Line 483: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE

479: ,x_org_id cn_pmt_plans.org_id%TYPE
480: ,x_pmt_plan_id IN OUT NOCOPY NUMBER
481: ,x_name cn_pmt_plans.name%TYPE
482: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
483: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
484: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
487: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE

Line 484: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE

480: ,x_pmt_plan_id IN OUT NOCOPY NUMBER
481: ,x_name cn_pmt_plans.name%TYPE
482: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
483: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
484: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
487: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
488: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE

Line 485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE

481: ,x_name cn_pmt_plans.name%TYPE
482: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
483: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
484: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
487: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
488: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
489: ,x_start_date cn_pmt_plans.start_date%TYPE

Line 486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE

482: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE
483: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
484: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
487: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
488: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
489: ,x_start_date cn_pmt_plans.start_date%TYPE
490: ,x_end_date cn_pmt_plans.end_date%TYPE

Line 487: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE

483: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE
484: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
487: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
488: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
489: ,x_start_date cn_pmt_plans.start_date%TYPE
490: ,x_end_date cn_pmt_plans.end_date%TYPE
491: ,x_object_version_number IN OUT NOCOPY

Line 488: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE

484: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE
485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
487: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
488: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
489: ,x_start_date cn_pmt_plans.start_date%TYPE
490: ,x_end_date cn_pmt_plans.end_date%TYPE
491: ,x_object_version_number IN OUT NOCOPY
492: cn_pmt_plans.object_version_number%TYPE

Line 489: ,x_start_date cn_pmt_plans.start_date%TYPE

485: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE
486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
487: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
488: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
489: ,x_start_date cn_pmt_plans.start_date%TYPE
490: ,x_end_date cn_pmt_plans.end_date%TYPE
491: ,x_object_version_number IN OUT NOCOPY
492: cn_pmt_plans.object_version_number%TYPE
493: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE

Line 490: ,x_end_date cn_pmt_plans.end_date%TYPE

486: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE
487: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE
488: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
489: ,x_start_date cn_pmt_plans.start_date%TYPE
490: ,x_end_date cn_pmt_plans.end_date%TYPE
491: ,x_object_version_number IN OUT NOCOPY
492: cn_pmt_plans.object_version_number%TYPE
493: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
494: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE

Line 492: cn_pmt_plans.object_version_number%TYPE

488: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE
489: ,x_start_date cn_pmt_plans.start_date%TYPE
490: ,x_end_date cn_pmt_plans.end_date%TYPE
491: ,x_object_version_number IN OUT NOCOPY
492: cn_pmt_plans.object_version_number%TYPE
493: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
494: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
495: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
496: ,x_attribute1 cn_pmt_plans.attribute1%TYPE

Line 493: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE

489: ,x_start_date cn_pmt_plans.start_date%TYPE
490: ,x_end_date cn_pmt_plans.end_date%TYPE
491: ,x_object_version_number IN OUT NOCOPY
492: cn_pmt_plans.object_version_number%TYPE
493: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
494: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
495: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
496: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
497: ,x_attribute2 cn_pmt_plans.attribute2%TYPE

Line 494: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE

490: ,x_end_date cn_pmt_plans.end_date%TYPE
491: ,x_object_version_number IN OUT NOCOPY
492: cn_pmt_plans.object_version_number%TYPE
493: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
494: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
495: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
496: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
497: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
498: ,x_attribute3 cn_pmt_plans.attribute3%TYPE

Line 495: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE

491: ,x_object_version_number IN OUT NOCOPY
492: cn_pmt_plans.object_version_number%TYPE
493: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
494: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
495: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
496: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
497: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
498: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
499: ,x_attribute4 cn_pmt_plans.attribute4%TYPE

Line 496: ,x_attribute1 cn_pmt_plans.attribute1%TYPE

492: cn_pmt_plans.object_version_number%TYPE
493: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
494: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
495: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
496: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
497: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
498: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
499: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
500: ,x_attribute5 cn_pmt_plans.attribute5%TYPE

Line 497: ,x_attribute2 cn_pmt_plans.attribute2%TYPE

493: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE
494: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
495: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
496: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
497: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
498: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
499: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
500: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
501: ,x_attribute6 cn_pmt_plans.attribute6%TYPE

Line 498: ,x_attribute3 cn_pmt_plans.attribute3%TYPE

494: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE
495: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
496: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
497: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
498: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
499: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
500: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
501: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
502: ,x_attribute7 cn_pmt_plans.attribute7%TYPE

Line 499: ,x_attribute4 cn_pmt_plans.attribute4%TYPE

495: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE
496: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
497: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
498: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
499: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
500: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
501: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
502: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
503: ,x_attribute8 cn_pmt_plans.attribute8%TYPE

Line 500: ,x_attribute5 cn_pmt_plans.attribute5%TYPE

496: ,x_attribute1 cn_pmt_plans.attribute1%TYPE
497: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
498: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
499: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
500: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
501: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
502: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
503: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
504: ,x_attribute9 cn_pmt_plans.attribute9%TYPE

Line 501: ,x_attribute6 cn_pmt_plans.attribute6%TYPE

497: ,x_attribute2 cn_pmt_plans.attribute2%TYPE
498: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
499: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
500: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
501: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
502: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
503: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
504: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
505: ,x_attribute10 cn_pmt_plans.attribute10%TYPE

Line 502: ,x_attribute7 cn_pmt_plans.attribute7%TYPE

498: ,x_attribute3 cn_pmt_plans.attribute3%TYPE
499: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
500: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
501: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
502: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
503: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
504: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
505: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
506: ,x_attribute11 cn_pmt_plans.attribute11%TYPE

Line 503: ,x_attribute8 cn_pmt_plans.attribute8%TYPE

499: ,x_attribute4 cn_pmt_plans.attribute4%TYPE
500: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
501: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
502: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
503: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
504: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
505: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
506: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
507: ,x_attribute12 cn_pmt_plans.attribute12%TYPE

Line 504: ,x_attribute9 cn_pmt_plans.attribute9%TYPE

500: ,x_attribute5 cn_pmt_plans.attribute5%TYPE
501: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
502: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
503: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
504: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
505: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
506: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
507: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
508: ,x_attribute13 cn_pmt_plans.attribute13%TYPE

Line 505: ,x_attribute10 cn_pmt_plans.attribute10%TYPE

501: ,x_attribute6 cn_pmt_plans.attribute6%TYPE
502: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
503: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
504: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
505: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
506: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
507: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
508: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
509: ,x_attribute14 cn_pmt_plans.attribute14%TYPE

Line 506: ,x_attribute11 cn_pmt_plans.attribute11%TYPE

502: ,x_attribute7 cn_pmt_plans.attribute7%TYPE
503: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
504: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
505: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
506: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
507: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
508: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
509: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
510: ,x_attribute15 cn_pmt_plans.attribute15%TYPE

Line 507: ,x_attribute12 cn_pmt_plans.attribute12%TYPE

503: ,x_attribute8 cn_pmt_plans.attribute8%TYPE
504: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
505: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
506: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
507: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
508: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
509: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
510: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
511: ,x_Created_By cn_pmt_plans.created_by%TYPE

Line 508: ,x_attribute13 cn_pmt_plans.attribute13%TYPE

504: ,x_attribute9 cn_pmt_plans.attribute9%TYPE
505: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
506: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
507: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
508: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
509: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
510: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
511: ,x_Created_By cn_pmt_plans.created_by%TYPE
512: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE

Line 509: ,x_attribute14 cn_pmt_plans.attribute14%TYPE

505: ,x_attribute10 cn_pmt_plans.attribute10%TYPE
506: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
507: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
508: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
509: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
510: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
511: ,x_Created_By cn_pmt_plans.created_by%TYPE
512: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
513: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE

Line 510: ,x_attribute15 cn_pmt_plans.attribute15%TYPE

506: ,x_attribute11 cn_pmt_plans.attribute11%TYPE
507: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
508: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
509: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
510: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
511: ,x_Created_By cn_pmt_plans.created_by%TYPE
512: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
513: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
514: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE

Line 511: ,x_Created_By cn_pmt_plans.created_by%TYPE

507: ,x_attribute12 cn_pmt_plans.attribute12%TYPE
508: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
509: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
510: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
511: ,x_Created_By cn_pmt_plans.created_by%TYPE
512: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
513: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
514: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
515: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE

Line 512: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE

508: ,x_attribute13 cn_pmt_plans.attribute13%TYPE
509: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
510: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
511: ,x_Created_By cn_pmt_plans.created_by%TYPE
512: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
513: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
514: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
515: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
516: ,x_Program_Type VARCHAR2

Line 513: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE

509: ,x_attribute14 cn_pmt_plans.attribute14%TYPE
510: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
511: ,x_Created_By cn_pmt_plans.created_by%TYPE
512: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
513: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
514: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
515: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
516: ,x_Program_Type VARCHAR2
517: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE

Line 514: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE

510: ,x_attribute15 cn_pmt_plans.attribute15%TYPE
511: ,x_Created_By cn_pmt_plans.created_by%TYPE
512: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
513: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
514: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
515: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
516: ,x_Program_Type VARCHAR2
517: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE
518: ) IS

Line 515: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE

511: ,x_Created_By cn_pmt_plans.created_by%TYPE
512: ,x_Creation_Date cn_pmt_plans.creation_date%TYPE
513: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
514: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
515: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
516: ,x_Program_Type VARCHAR2
517: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE
518: ) IS
519:

Line 517: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE

513: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
514: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
515: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
516: ,x_Program_Type VARCHAR2
517: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE
518: ) IS
519:
520: BEGIN
521:

Line 624: END CN_PMT_PLANS_PKG;

620:
621:
622: END Begin_Record;
623:
624: END CN_PMT_PLANS_PKG;