3:
4: tlinfo PN_PAYMENT_TERMS_ALL%ROWTYPE;
5:
6: TYPE dist_rec IS RECORD(
7: distribution_id PN_DISTRIBUTIONS.distribution_id%TYPE,
8: account_id PN_DISTRIBUTIONS.account_id%TYPE,
9: account_class PN_DISTRIBUTIONS.account_class%TYPE,
10: percentage PN_DISTRIBUTIONS.percentage%TYPE,
11: line_number PN_DISTRIBUTIONS.line_number%TYPE,
4: tlinfo PN_PAYMENT_TERMS_ALL%ROWTYPE;
5:
6: TYPE dist_rec IS RECORD(
7: distribution_id PN_DISTRIBUTIONS.distribution_id%TYPE,
8: account_id PN_DISTRIBUTIONS.account_id%TYPE,
9: account_class PN_DISTRIBUTIONS.account_class%TYPE,
10: percentage PN_DISTRIBUTIONS.percentage%TYPE,
11: line_number PN_DISTRIBUTIONS.line_number%TYPE,
12: attribute_category PN_DISTRIBUTIONS.attribute_category%TYPE,
5:
6: TYPE dist_rec IS RECORD(
7: distribution_id PN_DISTRIBUTIONS.distribution_id%TYPE,
8: account_id PN_DISTRIBUTIONS.account_id%TYPE,
9: account_class PN_DISTRIBUTIONS.account_class%TYPE,
10: percentage PN_DISTRIBUTIONS.percentage%TYPE,
11: line_number PN_DISTRIBUTIONS.line_number%TYPE,
12: attribute_category PN_DISTRIBUTIONS.attribute_category%TYPE,
13: attribute1 PN_DISTRIBUTIONS.attribute1%TYPE,
6: TYPE dist_rec IS RECORD(
7: distribution_id PN_DISTRIBUTIONS.distribution_id%TYPE,
8: account_id PN_DISTRIBUTIONS.account_id%TYPE,
9: account_class PN_DISTRIBUTIONS.account_class%TYPE,
10: percentage PN_DISTRIBUTIONS.percentage%TYPE,
11: line_number PN_DISTRIBUTIONS.line_number%TYPE,
12: attribute_category PN_DISTRIBUTIONS.attribute_category%TYPE,
13: attribute1 PN_DISTRIBUTIONS.attribute1%TYPE,
14: attribute2 PN_DISTRIBUTIONS.attribute2%TYPE,
7: distribution_id PN_DISTRIBUTIONS.distribution_id%TYPE,
8: account_id PN_DISTRIBUTIONS.account_id%TYPE,
9: account_class PN_DISTRIBUTIONS.account_class%TYPE,
10: percentage PN_DISTRIBUTIONS.percentage%TYPE,
11: line_number PN_DISTRIBUTIONS.line_number%TYPE,
12: attribute_category PN_DISTRIBUTIONS.attribute_category%TYPE,
13: attribute1 PN_DISTRIBUTIONS.attribute1%TYPE,
14: attribute2 PN_DISTRIBUTIONS.attribute2%TYPE,
15: attribute3 PN_DISTRIBUTIONS.attribute3%TYPE,
8: account_id PN_DISTRIBUTIONS.account_id%TYPE,
9: account_class PN_DISTRIBUTIONS.account_class%TYPE,
10: percentage PN_DISTRIBUTIONS.percentage%TYPE,
11: line_number PN_DISTRIBUTIONS.line_number%TYPE,
12: attribute_category PN_DISTRIBUTIONS.attribute_category%TYPE,
13: attribute1 PN_DISTRIBUTIONS.attribute1%TYPE,
14: attribute2 PN_DISTRIBUTIONS.attribute2%TYPE,
15: attribute3 PN_DISTRIBUTIONS.attribute3%TYPE,
16: attribute4 PN_DISTRIBUTIONS.attribute4%TYPE,
9: account_class PN_DISTRIBUTIONS.account_class%TYPE,
10: percentage PN_DISTRIBUTIONS.percentage%TYPE,
11: line_number PN_DISTRIBUTIONS.line_number%TYPE,
12: attribute_category PN_DISTRIBUTIONS.attribute_category%TYPE,
13: attribute1 PN_DISTRIBUTIONS.attribute1%TYPE,
14: attribute2 PN_DISTRIBUTIONS.attribute2%TYPE,
15: attribute3 PN_DISTRIBUTIONS.attribute3%TYPE,
16: attribute4 PN_DISTRIBUTIONS.attribute4%TYPE,
17: attribute5 PN_DISTRIBUTIONS.attribute5%TYPE,
10: percentage PN_DISTRIBUTIONS.percentage%TYPE,
11: line_number PN_DISTRIBUTIONS.line_number%TYPE,
12: attribute_category PN_DISTRIBUTIONS.attribute_category%TYPE,
13: attribute1 PN_DISTRIBUTIONS.attribute1%TYPE,
14: attribute2 PN_DISTRIBUTIONS.attribute2%TYPE,
15: attribute3 PN_DISTRIBUTIONS.attribute3%TYPE,
16: attribute4 PN_DISTRIBUTIONS.attribute4%TYPE,
17: attribute5 PN_DISTRIBUTIONS.attribute5%TYPE,
18: attribute6 PN_DISTRIBUTIONS.attribute6%TYPE,
11: line_number PN_DISTRIBUTIONS.line_number%TYPE,
12: attribute_category PN_DISTRIBUTIONS.attribute_category%TYPE,
13: attribute1 PN_DISTRIBUTIONS.attribute1%TYPE,
14: attribute2 PN_DISTRIBUTIONS.attribute2%TYPE,
15: attribute3 PN_DISTRIBUTIONS.attribute3%TYPE,
16: attribute4 PN_DISTRIBUTIONS.attribute4%TYPE,
17: attribute5 PN_DISTRIBUTIONS.attribute5%TYPE,
18: attribute6 PN_DISTRIBUTIONS.attribute6%TYPE,
19: attribute7 PN_DISTRIBUTIONS.attribute7%TYPE,
12: attribute_category PN_DISTRIBUTIONS.attribute_category%TYPE,
13: attribute1 PN_DISTRIBUTIONS.attribute1%TYPE,
14: attribute2 PN_DISTRIBUTIONS.attribute2%TYPE,
15: attribute3 PN_DISTRIBUTIONS.attribute3%TYPE,
16: attribute4 PN_DISTRIBUTIONS.attribute4%TYPE,
17: attribute5 PN_DISTRIBUTIONS.attribute5%TYPE,
18: attribute6 PN_DISTRIBUTIONS.attribute6%TYPE,
19: attribute7 PN_DISTRIBUTIONS.attribute7%TYPE,
20: attribute8 PN_DISTRIBUTIONS.attribute8%TYPE,
13: attribute1 PN_DISTRIBUTIONS.attribute1%TYPE,
14: attribute2 PN_DISTRIBUTIONS.attribute2%TYPE,
15: attribute3 PN_DISTRIBUTIONS.attribute3%TYPE,
16: attribute4 PN_DISTRIBUTIONS.attribute4%TYPE,
17: attribute5 PN_DISTRIBUTIONS.attribute5%TYPE,
18: attribute6 PN_DISTRIBUTIONS.attribute6%TYPE,
19: attribute7 PN_DISTRIBUTIONS.attribute7%TYPE,
20: attribute8 PN_DISTRIBUTIONS.attribute8%TYPE,
21: attribute9 PN_DISTRIBUTIONS.attribute9%TYPE,
14: attribute2 PN_DISTRIBUTIONS.attribute2%TYPE,
15: attribute3 PN_DISTRIBUTIONS.attribute3%TYPE,
16: attribute4 PN_DISTRIBUTIONS.attribute4%TYPE,
17: attribute5 PN_DISTRIBUTIONS.attribute5%TYPE,
18: attribute6 PN_DISTRIBUTIONS.attribute6%TYPE,
19: attribute7 PN_DISTRIBUTIONS.attribute7%TYPE,
20: attribute8 PN_DISTRIBUTIONS.attribute8%TYPE,
21: attribute9 PN_DISTRIBUTIONS.attribute9%TYPE,
22: attribute10 PN_DISTRIBUTIONS.attribute10%TYPE,
15: attribute3 PN_DISTRIBUTIONS.attribute3%TYPE,
16: attribute4 PN_DISTRIBUTIONS.attribute4%TYPE,
17: attribute5 PN_DISTRIBUTIONS.attribute5%TYPE,
18: attribute6 PN_DISTRIBUTIONS.attribute6%TYPE,
19: attribute7 PN_DISTRIBUTIONS.attribute7%TYPE,
20: attribute8 PN_DISTRIBUTIONS.attribute8%TYPE,
21: attribute9 PN_DISTRIBUTIONS.attribute9%TYPE,
22: attribute10 PN_DISTRIBUTIONS.attribute10%TYPE,
23: attribute11 PN_DISTRIBUTIONS.attribute11%TYPE,
16: attribute4 PN_DISTRIBUTIONS.attribute4%TYPE,
17: attribute5 PN_DISTRIBUTIONS.attribute5%TYPE,
18: attribute6 PN_DISTRIBUTIONS.attribute6%TYPE,
19: attribute7 PN_DISTRIBUTIONS.attribute7%TYPE,
20: attribute8 PN_DISTRIBUTIONS.attribute8%TYPE,
21: attribute9 PN_DISTRIBUTIONS.attribute9%TYPE,
22: attribute10 PN_DISTRIBUTIONS.attribute10%TYPE,
23: attribute11 PN_DISTRIBUTIONS.attribute11%TYPE,
24: attribute12 PN_DISTRIBUTIONS.attribute12%TYPE,
17: attribute5 PN_DISTRIBUTIONS.attribute5%TYPE,
18: attribute6 PN_DISTRIBUTIONS.attribute6%TYPE,
19: attribute7 PN_DISTRIBUTIONS.attribute7%TYPE,
20: attribute8 PN_DISTRIBUTIONS.attribute8%TYPE,
21: attribute9 PN_DISTRIBUTIONS.attribute9%TYPE,
22: attribute10 PN_DISTRIBUTIONS.attribute10%TYPE,
23: attribute11 PN_DISTRIBUTIONS.attribute11%TYPE,
24: attribute12 PN_DISTRIBUTIONS.attribute12%TYPE,
25: attribute13 PN_DISTRIBUTIONS.attribute13%TYPE,
18: attribute6 PN_DISTRIBUTIONS.attribute6%TYPE,
19: attribute7 PN_DISTRIBUTIONS.attribute7%TYPE,
20: attribute8 PN_DISTRIBUTIONS.attribute8%TYPE,
21: attribute9 PN_DISTRIBUTIONS.attribute9%TYPE,
22: attribute10 PN_DISTRIBUTIONS.attribute10%TYPE,
23: attribute11 PN_DISTRIBUTIONS.attribute11%TYPE,
24: attribute12 PN_DISTRIBUTIONS.attribute12%TYPE,
25: attribute13 PN_DISTRIBUTIONS.attribute13%TYPE,
26: attribute14 PN_DISTRIBUTIONS.attribute14%TYPE,
19: attribute7 PN_DISTRIBUTIONS.attribute7%TYPE,
20: attribute8 PN_DISTRIBUTIONS.attribute8%TYPE,
21: attribute9 PN_DISTRIBUTIONS.attribute9%TYPE,
22: attribute10 PN_DISTRIBUTIONS.attribute10%TYPE,
23: attribute11 PN_DISTRIBUTIONS.attribute11%TYPE,
24: attribute12 PN_DISTRIBUTIONS.attribute12%TYPE,
25: attribute13 PN_DISTRIBUTIONS.attribute13%TYPE,
26: attribute14 PN_DISTRIBUTIONS.attribute14%TYPE,
27: attribute15 PN_DISTRIBUTIONS.attribute15%TYPE,
20: attribute8 PN_DISTRIBUTIONS.attribute8%TYPE,
21: attribute9 PN_DISTRIBUTIONS.attribute9%TYPE,
22: attribute10 PN_DISTRIBUTIONS.attribute10%TYPE,
23: attribute11 PN_DISTRIBUTIONS.attribute11%TYPE,
24: attribute12 PN_DISTRIBUTIONS.attribute12%TYPE,
25: attribute13 PN_DISTRIBUTIONS.attribute13%TYPE,
26: attribute14 PN_DISTRIBUTIONS.attribute14%TYPE,
27: attribute15 PN_DISTRIBUTIONS.attribute15%TYPE,
28: term_template_id PN_DISTRIBUTIONS.term_template_id%TYPE,
21: attribute9 PN_DISTRIBUTIONS.attribute9%TYPE,
22: attribute10 PN_DISTRIBUTIONS.attribute10%TYPE,
23: attribute11 PN_DISTRIBUTIONS.attribute11%TYPE,
24: attribute12 PN_DISTRIBUTIONS.attribute12%TYPE,
25: attribute13 PN_DISTRIBUTIONS.attribute13%TYPE,
26: attribute14 PN_DISTRIBUTIONS.attribute14%TYPE,
27: attribute15 PN_DISTRIBUTIONS.attribute15%TYPE,
28: term_template_id PN_DISTRIBUTIONS.term_template_id%TYPE,
29: org_id PN_DISTRIBUTIONS.org_id%TYPE);
22: attribute10 PN_DISTRIBUTIONS.attribute10%TYPE,
23: attribute11 PN_DISTRIBUTIONS.attribute11%TYPE,
24: attribute12 PN_DISTRIBUTIONS.attribute12%TYPE,
25: attribute13 PN_DISTRIBUTIONS.attribute13%TYPE,
26: attribute14 PN_DISTRIBUTIONS.attribute14%TYPE,
27: attribute15 PN_DISTRIBUTIONS.attribute15%TYPE,
28: term_template_id PN_DISTRIBUTIONS.term_template_id%TYPE,
29: org_id PN_DISTRIBUTIONS.org_id%TYPE);
30:
23: attribute11 PN_DISTRIBUTIONS.attribute11%TYPE,
24: attribute12 PN_DISTRIBUTIONS.attribute12%TYPE,
25: attribute13 PN_DISTRIBUTIONS.attribute13%TYPE,
26: attribute14 PN_DISTRIBUTIONS.attribute14%TYPE,
27: attribute15 PN_DISTRIBUTIONS.attribute15%TYPE,
28: term_template_id PN_DISTRIBUTIONS.term_template_id%TYPE,
29: org_id PN_DISTRIBUTIONS.org_id%TYPE);
30:
31: TYPE dist_type IS
24: attribute12 PN_DISTRIBUTIONS.attribute12%TYPE,
25: attribute13 PN_DISTRIBUTIONS.attribute13%TYPE,
26: attribute14 PN_DISTRIBUTIONS.attribute14%TYPE,
27: attribute15 PN_DISTRIBUTIONS.attribute15%TYPE,
28: term_template_id PN_DISTRIBUTIONS.term_template_id%TYPE,
29: org_id PN_DISTRIBUTIONS.org_id%TYPE);
30:
31: TYPE dist_type IS
32: TABLE OF dist_rec
25: attribute13 PN_DISTRIBUTIONS.attribute13%TYPE,
26: attribute14 PN_DISTRIBUTIONS.attribute14%TYPE,
27: attribute15 PN_DISTRIBUTIONS.attribute15%TYPE,
28: term_template_id PN_DISTRIBUTIONS.term_template_id%TYPE,
29: org_id PN_DISTRIBUTIONS.org_id%TYPE);
30:
31: TYPE dist_type IS
32: TABLE OF dist_rec
33: INDEX BY BINARY_INTEGER;