6: ------------------ Public functions/procedures -------------------
7:
8: PROCEDURE delete_mcd_rec(
9: p_mcd_id IN
10: ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
11: p_form_name IN varchar2,
12: p_form_version IN varchar2
13: );
14:
13: );
14:
15: PROCEDURE insert_mcd_rec(
16: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
17: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
18: p_percent IN ar_misc_cash_distributions.percent%TYPE,
19: p_amount IN ar_misc_cash_distributions.amount%TYPE,
20: p_comments IN ar_misc_cash_distributions.comments%TYPE,
21: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
14:
15: PROCEDURE insert_mcd_rec(
16: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
17: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
18: p_percent IN ar_misc_cash_distributions.percent%TYPE,
19: p_amount IN ar_misc_cash_distributions.amount%TYPE,
20: p_comments IN ar_misc_cash_distributions.comments%TYPE,
21: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
22: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
15: PROCEDURE insert_mcd_rec(
16: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
17: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
18: p_percent IN ar_misc_cash_distributions.percent%TYPE,
19: p_amount IN ar_misc_cash_distributions.amount%TYPE,
20: p_comments IN ar_misc_cash_distributions.comments%TYPE,
21: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
22: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
23: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
16: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
17: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
18: p_percent IN ar_misc_cash_distributions.percent%TYPE,
19: p_amount IN ar_misc_cash_distributions.amount%TYPE,
20: p_comments IN ar_misc_cash_distributions.comments%TYPE,
21: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
22: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
23: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
24: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
17: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
18: p_percent IN ar_misc_cash_distributions.percent%TYPE,
19: p_amount IN ar_misc_cash_distributions.amount%TYPE,
20: p_comments IN ar_misc_cash_distributions.comments%TYPE,
21: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
22: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
23: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
24: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
25: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
18: p_percent IN ar_misc_cash_distributions.percent%TYPE,
19: p_amount IN ar_misc_cash_distributions.amount%TYPE,
20: p_comments IN ar_misc_cash_distributions.comments%TYPE,
21: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
22: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
23: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
24: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
25: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
26: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
19: p_amount IN ar_misc_cash_distributions.amount%TYPE,
20: p_comments IN ar_misc_cash_distributions.comments%TYPE,
21: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
22: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
23: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
24: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
25: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
26: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
27: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
20: p_comments IN ar_misc_cash_distributions.comments%TYPE,
21: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
22: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
23: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
24: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
25: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
26: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
27: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
28: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
21: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
22: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
23: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
24: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
25: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
26: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
27: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
28: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
29: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
22: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
23: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
24: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
25: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
26: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
27: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
28: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
29: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
30: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
23: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
24: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
25: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
26: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
27: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
28: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
29: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
30: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
31: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
24: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
25: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
26: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
27: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
28: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
29: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
30: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
31: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
32: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
25: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
26: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
27: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
28: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
29: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
30: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
31: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
32: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
33: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
26: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
27: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
28: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
29: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
30: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
31: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
32: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
33: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
34: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
27: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
28: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
29: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
30: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
31: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
32: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
33: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
34: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
35: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
28: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
29: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
30: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
31: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
32: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
33: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
34: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
35: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
36: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
29: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
30: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
31: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
32: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
33: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
34: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
35: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
36: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
37: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
30: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
31: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
32: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
33: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
34: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
35: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
36: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
37: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
38: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
31: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
32: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
33: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
34: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
35: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
36: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
37: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
38: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
39: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
32: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
33: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
34: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
35: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
36: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
37: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
38: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
39: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
40: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
33: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
34: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
35: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
36: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
37: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
38: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
39: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
40: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
41: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
34: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
35: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
36: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
37: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
38: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
39: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
40: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
41: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
42: p_form_name IN varchar2,
35: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
36: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
37: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
38: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
39: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
40: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
41: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
42: p_form_name IN varchar2,
43: p_form_version IN varchar2,
36: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
37: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
38: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
39: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
40: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
41: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
42: p_form_name IN varchar2,
43: p_form_version IN varchar2,
44: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
37: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
38: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
39: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
40: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
41: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
42: p_form_name IN varchar2,
43: p_form_version IN varchar2,
44: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
45: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
46: );
47:
48:
49: PROCEDURE update_mcd_rec(
50: p_misc_cash_distribution_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
51: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
52: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53: p_percent IN ar_misc_cash_distributions.percent%TYPE,
54: p_amount IN ar_misc_cash_distributions.amount%TYPE,
48:
49: PROCEDURE update_mcd_rec(
50: p_misc_cash_distribution_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
51: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
52: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53: p_percent IN ar_misc_cash_distributions.percent%TYPE,
54: p_amount IN ar_misc_cash_distributions.amount%TYPE,
55: p_comments IN ar_misc_cash_distributions.comments%TYPE,
56: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
49: PROCEDURE update_mcd_rec(
50: p_misc_cash_distribution_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
51: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
52: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53: p_percent IN ar_misc_cash_distributions.percent%TYPE,
54: p_amount IN ar_misc_cash_distributions.amount%TYPE,
55: p_comments IN ar_misc_cash_distributions.comments%TYPE,
56: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
57: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
50: p_misc_cash_distribution_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
51: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
52: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53: p_percent IN ar_misc_cash_distributions.percent%TYPE,
54: p_amount IN ar_misc_cash_distributions.amount%TYPE,
55: p_comments IN ar_misc_cash_distributions.comments%TYPE,
56: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
57: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
58: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
51: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
52: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53: p_percent IN ar_misc_cash_distributions.percent%TYPE,
54: p_amount IN ar_misc_cash_distributions.amount%TYPE,
55: p_comments IN ar_misc_cash_distributions.comments%TYPE,
56: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
57: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
58: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
59: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
52: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53: p_percent IN ar_misc_cash_distributions.percent%TYPE,
54: p_amount IN ar_misc_cash_distributions.amount%TYPE,
55: p_comments IN ar_misc_cash_distributions.comments%TYPE,
56: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
57: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
58: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
59: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
60: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
53: p_percent IN ar_misc_cash_distributions.percent%TYPE,
54: p_amount IN ar_misc_cash_distributions.amount%TYPE,
55: p_comments IN ar_misc_cash_distributions.comments%TYPE,
56: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
57: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
58: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
59: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
60: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
61: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
54: p_amount IN ar_misc_cash_distributions.amount%TYPE,
55: p_comments IN ar_misc_cash_distributions.comments%TYPE,
56: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
57: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
58: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
59: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
60: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
61: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
62: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
55: p_comments IN ar_misc_cash_distributions.comments%TYPE,
56: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
57: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
58: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
59: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
60: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
61: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
62: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
63: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
56: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
57: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
58: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
59: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
60: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
61: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
62: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
63: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
64: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
57: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
58: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
59: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
60: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
61: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
62: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
63: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
64: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
65: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
58: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
59: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
60: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
61: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
62: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
63: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
64: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
65: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
66: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
59: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
60: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
61: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
62: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
63: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
64: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
65: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
66: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
67: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
60: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
61: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
62: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
63: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
64: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
65: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
66: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
67: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
68: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
61: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
62: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
63: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
64: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
65: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
66: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
67: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
68: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
69: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
62: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
63: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
64: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
65: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
66: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
67: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
68: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
69: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
70: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
63: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
64: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
65: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
66: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
67: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
68: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
69: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
70: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
71: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
64: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
65: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
66: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
67: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
68: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
69: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
70: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
71: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
72: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
65: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
66: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
67: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
68: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
69: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
70: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
71: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
72: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
73: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
66: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
67: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
68: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
69: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
70: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
71: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
72: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
73: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
74: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
67: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
68: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
69: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
70: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
71: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
72: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
73: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
74: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
75: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
68: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
69: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
70: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
71: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
72: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
73: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
74: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
75: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
76: p_form_name IN varchar2,
69: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
70: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
71: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
72: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
73: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
74: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
75: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
76: p_form_name IN varchar2,
77: p_form_version IN varchar2,
70: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
71: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
72: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
73: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
74: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
75: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
76: p_form_name IN varchar2,
77: p_form_version IN varchar2,
78: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
71: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
72: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
73: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
74: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
75: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
76: p_form_name IN varchar2,
77: p_form_version IN varchar2,
78: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
79: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
80: );
81:
82: PROCEDURE lock_mcd_rec(
83: p_misc_cash_distribution_id
84: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
85: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
86: p_percent IN ar_misc_cash_distributions.percent%TYPE,
87: p_amount IN ar_misc_cash_distributions.amount%TYPE,
88: p_comments IN ar_misc_cash_distributions.comments%TYPE,
82: PROCEDURE lock_mcd_rec(
83: p_misc_cash_distribution_id
84: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
85: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
86: p_percent IN ar_misc_cash_distributions.percent%TYPE,
87: p_amount IN ar_misc_cash_distributions.amount%TYPE,
88: p_comments IN ar_misc_cash_distributions.comments%TYPE,
89: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
90: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
83: p_misc_cash_distribution_id
84: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
85: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
86: p_percent IN ar_misc_cash_distributions.percent%TYPE,
87: p_amount IN ar_misc_cash_distributions.amount%TYPE,
88: p_comments IN ar_misc_cash_distributions.comments%TYPE,
89: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
90: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
91: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
84: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
85: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
86: p_percent IN ar_misc_cash_distributions.percent%TYPE,
87: p_amount IN ar_misc_cash_distributions.amount%TYPE,
88: p_comments IN ar_misc_cash_distributions.comments%TYPE,
89: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
90: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
91: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
92: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
85: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
86: p_percent IN ar_misc_cash_distributions.percent%TYPE,
87: p_amount IN ar_misc_cash_distributions.amount%TYPE,
88: p_comments IN ar_misc_cash_distributions.comments%TYPE,
89: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
90: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
91: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
92: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
93: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
86: p_percent IN ar_misc_cash_distributions.percent%TYPE,
87: p_amount IN ar_misc_cash_distributions.amount%TYPE,
88: p_comments IN ar_misc_cash_distributions.comments%TYPE,
89: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
90: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
91: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
92: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
93: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
94: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
87: p_amount IN ar_misc_cash_distributions.amount%TYPE,
88: p_comments IN ar_misc_cash_distributions.comments%TYPE,
89: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
90: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
91: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
92: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
93: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
94: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
95: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
88: p_comments IN ar_misc_cash_distributions.comments%TYPE,
89: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
90: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
91: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
92: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
93: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
94: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
95: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
96: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
89: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
90: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
91: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
92: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
93: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
94: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
95: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
96: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
97: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
90: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
91: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
92: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
93: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
94: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
95: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
96: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
97: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
98: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
91: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
92: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
93: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
94: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
95: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
96: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
97: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
98: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
99: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
92: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
93: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
94: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
95: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
96: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
97: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
98: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
99: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
100: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
93: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
94: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
95: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
96: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
97: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
98: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
99: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
100: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
101: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
94: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
95: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
96: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
97: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
98: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
99: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
100: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
101: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
102: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
95: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
96: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
97: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
98: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
99: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
100: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
101: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
102: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
103: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
96: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
97: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
98: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
99: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
100: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
101: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
102: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
103: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
104: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
97: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
98: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
99: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
100: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
101: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
102: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
103: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
104: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
105: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
98: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
99: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
100: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
101: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
102: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
103: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
104: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
105: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
106: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
99: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
100: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
101: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
102: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
103: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
104: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
105: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
106: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
107: p_form_name IN varchar2,
100: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
101: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
102: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
103: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
104: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
105: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
106: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
107: p_form_name IN varchar2,
108: p_form_version IN varchar2,
101: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
102: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
103: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
104: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
105: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
106: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
107: p_form_name IN varchar2,
108: p_form_version IN varchar2,
109: p_gl_posted_date IN ar_misc_cash_distributions.gl_posted_date%TYPE,
102: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
103: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
104: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
105: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
106: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
107: p_form_name IN varchar2,
108: p_form_version IN varchar2,
109: p_gl_posted_date IN ar_misc_cash_distributions.gl_posted_date%TYPE,
110: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE /*Bug fix 3032059*/
105: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
106: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
107: p_form_name IN varchar2,
108: p_form_version IN varchar2,
109: p_gl_posted_date IN ar_misc_cash_distributions.gl_posted_date%TYPE,
110: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE /*Bug fix 3032059*/
111: );
112:
113: PROCEDURE round_correction_mcd_rec(