3:
4: TYPE r_dset_line_info IS RECORD
5: (
6: dist_code_combination_id
7: AP_DISTRIBUTION_SET_LINES.dist_code_combination_id%TYPE
8: ,percent_distribution AP_DISTRIBUTION_SET_LINES.percent_distribution%TYPE
9: ,type_1099 AP_DISTRIBUTION_SET_LINES.type_1099%TYPE
10: ,description AP_DISTRIBUTION_SET_LINES.description%TYPE
11: ,distribution_set_line_number
4: TYPE r_dset_line_info IS RECORD
5: (
6: dist_code_combination_id
7: AP_DISTRIBUTION_SET_LINES.dist_code_combination_id%TYPE
8: ,percent_distribution AP_DISTRIBUTION_SET_LINES.percent_distribution%TYPE
9: ,type_1099 AP_DISTRIBUTION_SET_LINES.type_1099%TYPE
10: ,description AP_DISTRIBUTION_SET_LINES.description%TYPE
11: ,distribution_set_line_number
12: AP_DISTRIBUTION_SET_LINES.distribution_set_line_number%TYPE
5: (
6: dist_code_combination_id
7: AP_DISTRIBUTION_SET_LINES.dist_code_combination_id%TYPE
8: ,percent_distribution AP_DISTRIBUTION_SET_LINES.percent_distribution%TYPE
9: ,type_1099 AP_DISTRIBUTION_SET_LINES.type_1099%TYPE
10: ,description AP_DISTRIBUTION_SET_LINES.description%TYPE
11: ,distribution_set_line_number
12: AP_DISTRIBUTION_SET_LINES.distribution_set_line_number%TYPE
13: ,attribute_category AP_DISTRIBUTION_SET_LINES.attribute_category%TYPE
6: dist_code_combination_id
7: AP_DISTRIBUTION_SET_LINES.dist_code_combination_id%TYPE
8: ,percent_distribution AP_DISTRIBUTION_SET_LINES.percent_distribution%TYPE
9: ,type_1099 AP_DISTRIBUTION_SET_LINES.type_1099%TYPE
10: ,description AP_DISTRIBUTION_SET_LINES.description%TYPE
11: ,distribution_set_line_number
12: AP_DISTRIBUTION_SET_LINES.distribution_set_line_number%TYPE
13: ,attribute_category AP_DISTRIBUTION_SET_LINES.attribute_category%TYPE
14: ,attribute1 AP_DISTRIBUTION_SET_LINES.attribute1%TYPE
8: ,percent_distribution AP_DISTRIBUTION_SET_LINES.percent_distribution%TYPE
9: ,type_1099 AP_DISTRIBUTION_SET_LINES.type_1099%TYPE
10: ,description AP_DISTRIBUTION_SET_LINES.description%TYPE
11: ,distribution_set_line_number
12: AP_DISTRIBUTION_SET_LINES.distribution_set_line_number%TYPE
13: ,attribute_category AP_DISTRIBUTION_SET_LINES.attribute_category%TYPE
14: ,attribute1 AP_DISTRIBUTION_SET_LINES.attribute1%TYPE
15: ,attribute2 AP_DISTRIBUTION_SET_LINES.attribute2%TYPE
16: ,attribute3 AP_DISTRIBUTION_SET_LINES.attribute3%TYPE
9: ,type_1099 AP_DISTRIBUTION_SET_LINES.type_1099%TYPE
10: ,description AP_DISTRIBUTION_SET_LINES.description%TYPE
11: ,distribution_set_line_number
12: AP_DISTRIBUTION_SET_LINES.distribution_set_line_number%TYPE
13: ,attribute_category AP_DISTRIBUTION_SET_LINES.attribute_category%TYPE
14: ,attribute1 AP_DISTRIBUTION_SET_LINES.attribute1%TYPE
15: ,attribute2 AP_DISTRIBUTION_SET_LINES.attribute2%TYPE
16: ,attribute3 AP_DISTRIBUTION_SET_LINES.attribute3%TYPE
17: ,attribute4 AP_DISTRIBUTION_SET_LINES.attribute4%TYPE
10: ,description AP_DISTRIBUTION_SET_LINES.description%TYPE
11: ,distribution_set_line_number
12: AP_DISTRIBUTION_SET_LINES.distribution_set_line_number%TYPE
13: ,attribute_category AP_DISTRIBUTION_SET_LINES.attribute_category%TYPE
14: ,attribute1 AP_DISTRIBUTION_SET_LINES.attribute1%TYPE
15: ,attribute2 AP_DISTRIBUTION_SET_LINES.attribute2%TYPE
16: ,attribute3 AP_DISTRIBUTION_SET_LINES.attribute3%TYPE
17: ,attribute4 AP_DISTRIBUTION_SET_LINES.attribute4%TYPE
18: ,attribute5 AP_DISTRIBUTION_SET_LINES.attribute5%TYPE
11: ,distribution_set_line_number
12: AP_DISTRIBUTION_SET_LINES.distribution_set_line_number%TYPE
13: ,attribute_category AP_DISTRIBUTION_SET_LINES.attribute_category%TYPE
14: ,attribute1 AP_DISTRIBUTION_SET_LINES.attribute1%TYPE
15: ,attribute2 AP_DISTRIBUTION_SET_LINES.attribute2%TYPE
16: ,attribute3 AP_DISTRIBUTION_SET_LINES.attribute3%TYPE
17: ,attribute4 AP_DISTRIBUTION_SET_LINES.attribute4%TYPE
18: ,attribute5 AP_DISTRIBUTION_SET_LINES.attribute5%TYPE
19: ,attribute6 AP_DISTRIBUTION_SET_LINES.attribute6%TYPE
12: AP_DISTRIBUTION_SET_LINES.distribution_set_line_number%TYPE
13: ,attribute_category AP_DISTRIBUTION_SET_LINES.attribute_category%TYPE
14: ,attribute1 AP_DISTRIBUTION_SET_LINES.attribute1%TYPE
15: ,attribute2 AP_DISTRIBUTION_SET_LINES.attribute2%TYPE
16: ,attribute3 AP_DISTRIBUTION_SET_LINES.attribute3%TYPE
17: ,attribute4 AP_DISTRIBUTION_SET_LINES.attribute4%TYPE
18: ,attribute5 AP_DISTRIBUTION_SET_LINES.attribute5%TYPE
19: ,attribute6 AP_DISTRIBUTION_SET_LINES.attribute6%TYPE
20: ,attribute7 AP_DISTRIBUTION_SET_LINES.attribute7%TYPE
13: ,attribute_category AP_DISTRIBUTION_SET_LINES.attribute_category%TYPE
14: ,attribute1 AP_DISTRIBUTION_SET_LINES.attribute1%TYPE
15: ,attribute2 AP_DISTRIBUTION_SET_LINES.attribute2%TYPE
16: ,attribute3 AP_DISTRIBUTION_SET_LINES.attribute3%TYPE
17: ,attribute4 AP_DISTRIBUTION_SET_LINES.attribute4%TYPE
18: ,attribute5 AP_DISTRIBUTION_SET_LINES.attribute5%TYPE
19: ,attribute6 AP_DISTRIBUTION_SET_LINES.attribute6%TYPE
20: ,attribute7 AP_DISTRIBUTION_SET_LINES.attribute7%TYPE
21: ,attribute8 AP_DISTRIBUTION_SET_LINES.attribute8%TYPE
14: ,attribute1 AP_DISTRIBUTION_SET_LINES.attribute1%TYPE
15: ,attribute2 AP_DISTRIBUTION_SET_LINES.attribute2%TYPE
16: ,attribute3 AP_DISTRIBUTION_SET_LINES.attribute3%TYPE
17: ,attribute4 AP_DISTRIBUTION_SET_LINES.attribute4%TYPE
18: ,attribute5 AP_DISTRIBUTION_SET_LINES.attribute5%TYPE
19: ,attribute6 AP_DISTRIBUTION_SET_LINES.attribute6%TYPE
20: ,attribute7 AP_DISTRIBUTION_SET_LINES.attribute7%TYPE
21: ,attribute8 AP_DISTRIBUTION_SET_LINES.attribute8%TYPE
22: ,attribute9 AP_DISTRIBUTION_SET_LINES.attribute9%TYPE
15: ,attribute2 AP_DISTRIBUTION_SET_LINES.attribute2%TYPE
16: ,attribute3 AP_DISTRIBUTION_SET_LINES.attribute3%TYPE
17: ,attribute4 AP_DISTRIBUTION_SET_LINES.attribute4%TYPE
18: ,attribute5 AP_DISTRIBUTION_SET_LINES.attribute5%TYPE
19: ,attribute6 AP_DISTRIBUTION_SET_LINES.attribute6%TYPE
20: ,attribute7 AP_DISTRIBUTION_SET_LINES.attribute7%TYPE
21: ,attribute8 AP_DISTRIBUTION_SET_LINES.attribute8%TYPE
22: ,attribute9 AP_DISTRIBUTION_SET_LINES.attribute9%TYPE
23: ,attribute10 AP_DISTRIBUTION_SET_LINES.attribute10%TYPE
16: ,attribute3 AP_DISTRIBUTION_SET_LINES.attribute3%TYPE
17: ,attribute4 AP_DISTRIBUTION_SET_LINES.attribute4%TYPE
18: ,attribute5 AP_DISTRIBUTION_SET_LINES.attribute5%TYPE
19: ,attribute6 AP_DISTRIBUTION_SET_LINES.attribute6%TYPE
20: ,attribute7 AP_DISTRIBUTION_SET_LINES.attribute7%TYPE
21: ,attribute8 AP_DISTRIBUTION_SET_LINES.attribute8%TYPE
22: ,attribute9 AP_DISTRIBUTION_SET_LINES.attribute9%TYPE
23: ,attribute10 AP_DISTRIBUTION_SET_LINES.attribute10%TYPE
24: ,attribute11 AP_DISTRIBUTION_SET_LINES.attribute11%TYPE
17: ,attribute4 AP_DISTRIBUTION_SET_LINES.attribute4%TYPE
18: ,attribute5 AP_DISTRIBUTION_SET_LINES.attribute5%TYPE
19: ,attribute6 AP_DISTRIBUTION_SET_LINES.attribute6%TYPE
20: ,attribute7 AP_DISTRIBUTION_SET_LINES.attribute7%TYPE
21: ,attribute8 AP_DISTRIBUTION_SET_LINES.attribute8%TYPE
22: ,attribute9 AP_DISTRIBUTION_SET_LINES.attribute9%TYPE
23: ,attribute10 AP_DISTRIBUTION_SET_LINES.attribute10%TYPE
24: ,attribute11 AP_DISTRIBUTION_SET_LINES.attribute11%TYPE
25: ,attribute12 AP_DISTRIBUTION_SET_LINES.attribute12%TYPE
18: ,attribute5 AP_DISTRIBUTION_SET_LINES.attribute5%TYPE
19: ,attribute6 AP_DISTRIBUTION_SET_LINES.attribute6%TYPE
20: ,attribute7 AP_DISTRIBUTION_SET_LINES.attribute7%TYPE
21: ,attribute8 AP_DISTRIBUTION_SET_LINES.attribute8%TYPE
22: ,attribute9 AP_DISTRIBUTION_SET_LINES.attribute9%TYPE
23: ,attribute10 AP_DISTRIBUTION_SET_LINES.attribute10%TYPE
24: ,attribute11 AP_DISTRIBUTION_SET_LINES.attribute11%TYPE
25: ,attribute12 AP_DISTRIBUTION_SET_LINES.attribute12%TYPE
26: ,attribute13 AP_DISTRIBUTION_SET_LINES.attribute13%TYPE
19: ,attribute6 AP_DISTRIBUTION_SET_LINES.attribute6%TYPE
20: ,attribute7 AP_DISTRIBUTION_SET_LINES.attribute7%TYPE
21: ,attribute8 AP_DISTRIBUTION_SET_LINES.attribute8%TYPE
22: ,attribute9 AP_DISTRIBUTION_SET_LINES.attribute9%TYPE
23: ,attribute10 AP_DISTRIBUTION_SET_LINES.attribute10%TYPE
24: ,attribute11 AP_DISTRIBUTION_SET_LINES.attribute11%TYPE
25: ,attribute12 AP_DISTRIBUTION_SET_LINES.attribute12%TYPE
26: ,attribute13 AP_DISTRIBUTION_SET_LINES.attribute13%TYPE
27: ,attribute14 AP_DISTRIBUTION_SET_LINES.attribute14%TYPE
20: ,attribute7 AP_DISTRIBUTION_SET_LINES.attribute7%TYPE
21: ,attribute8 AP_DISTRIBUTION_SET_LINES.attribute8%TYPE
22: ,attribute9 AP_DISTRIBUTION_SET_LINES.attribute9%TYPE
23: ,attribute10 AP_DISTRIBUTION_SET_LINES.attribute10%TYPE
24: ,attribute11 AP_DISTRIBUTION_SET_LINES.attribute11%TYPE
25: ,attribute12 AP_DISTRIBUTION_SET_LINES.attribute12%TYPE
26: ,attribute13 AP_DISTRIBUTION_SET_LINES.attribute13%TYPE
27: ,attribute14 AP_DISTRIBUTION_SET_LINES.attribute14%TYPE
28: ,attribute15 AP_DISTRIBUTION_SET_LINES.attribute15%TYPE
21: ,attribute8 AP_DISTRIBUTION_SET_LINES.attribute8%TYPE
22: ,attribute9 AP_DISTRIBUTION_SET_LINES.attribute9%TYPE
23: ,attribute10 AP_DISTRIBUTION_SET_LINES.attribute10%TYPE
24: ,attribute11 AP_DISTRIBUTION_SET_LINES.attribute11%TYPE
25: ,attribute12 AP_DISTRIBUTION_SET_LINES.attribute12%TYPE
26: ,attribute13 AP_DISTRIBUTION_SET_LINES.attribute13%TYPE
27: ,attribute14 AP_DISTRIBUTION_SET_LINES.attribute14%TYPE
28: ,attribute15 AP_DISTRIBUTION_SET_LINES.attribute15%TYPE
29: ,project_source VARCHAR2(30)
22: ,attribute9 AP_DISTRIBUTION_SET_LINES.attribute9%TYPE
23: ,attribute10 AP_DISTRIBUTION_SET_LINES.attribute10%TYPE
24: ,attribute11 AP_DISTRIBUTION_SET_LINES.attribute11%TYPE
25: ,attribute12 AP_DISTRIBUTION_SET_LINES.attribute12%TYPE
26: ,attribute13 AP_DISTRIBUTION_SET_LINES.attribute13%TYPE
27: ,attribute14 AP_DISTRIBUTION_SET_LINES.attribute14%TYPE
28: ,attribute15 AP_DISTRIBUTION_SET_LINES.attribute15%TYPE
29: ,project_source VARCHAR2(30)
30: ,project_accounting_context
23: ,attribute10 AP_DISTRIBUTION_SET_LINES.attribute10%TYPE
24: ,attribute11 AP_DISTRIBUTION_SET_LINES.attribute11%TYPE
25: ,attribute12 AP_DISTRIBUTION_SET_LINES.attribute12%TYPE
26: ,attribute13 AP_DISTRIBUTION_SET_LINES.attribute13%TYPE
27: ,attribute14 AP_DISTRIBUTION_SET_LINES.attribute14%TYPE
28: ,attribute15 AP_DISTRIBUTION_SET_LINES.attribute15%TYPE
29: ,project_source VARCHAR2(30)
30: ,project_accounting_context
31: AP_DISTRIBUTION_SET_LINES.project_accounting_context%TYPE
24: ,attribute11 AP_DISTRIBUTION_SET_LINES.attribute11%TYPE
25: ,attribute12 AP_DISTRIBUTION_SET_LINES.attribute12%TYPE
26: ,attribute13 AP_DISTRIBUTION_SET_LINES.attribute13%TYPE
27: ,attribute14 AP_DISTRIBUTION_SET_LINES.attribute14%TYPE
28: ,attribute15 AP_DISTRIBUTION_SET_LINES.attribute15%TYPE
29: ,project_source VARCHAR2(30)
30: ,project_accounting_context
31: AP_DISTRIBUTION_SET_LINES.project_accounting_context%TYPE
32: ,project_id AP_DISTRIBUTION_SET_LINES.project_id%TYPE
27: ,attribute14 AP_DISTRIBUTION_SET_LINES.attribute14%TYPE
28: ,attribute15 AP_DISTRIBUTION_SET_LINES.attribute15%TYPE
29: ,project_source VARCHAR2(30)
30: ,project_accounting_context
31: AP_DISTRIBUTION_SET_LINES.project_accounting_context%TYPE
32: ,project_id AP_DISTRIBUTION_SET_LINES.project_id%TYPE
33: ,task_id AP_DISTRIBUTION_SET_LINES.task_id%TYPE
34: ,expenditure_organization_id
35: AP_DISTRIBUTION_SET_LINES.expenditure_organization_id%TYPE
28: ,attribute15 AP_DISTRIBUTION_SET_LINES.attribute15%TYPE
29: ,project_source VARCHAR2(30)
30: ,project_accounting_context
31: AP_DISTRIBUTION_SET_LINES.project_accounting_context%TYPE
32: ,project_id AP_DISTRIBUTION_SET_LINES.project_id%TYPE
33: ,task_id AP_DISTRIBUTION_SET_LINES.task_id%TYPE
34: ,expenditure_organization_id
35: AP_DISTRIBUTION_SET_LINES.expenditure_organization_id%TYPE
36: ,expenditure_type AP_DISTRIBUTION_SET_LINES.expenditure_type%TYPE
29: ,project_source VARCHAR2(30)
30: ,project_accounting_context
31: AP_DISTRIBUTION_SET_LINES.project_accounting_context%TYPE
32: ,project_id AP_DISTRIBUTION_SET_LINES.project_id%TYPE
33: ,task_id AP_DISTRIBUTION_SET_LINES.task_id%TYPE
34: ,expenditure_organization_id
35: AP_DISTRIBUTION_SET_LINES.expenditure_organization_id%TYPE
36: ,expenditure_type AP_DISTRIBUTION_SET_LINES.expenditure_type%TYPE
37: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
31: AP_DISTRIBUTION_SET_LINES.project_accounting_context%TYPE
32: ,project_id AP_DISTRIBUTION_SET_LINES.project_id%TYPE
33: ,task_id AP_DISTRIBUTION_SET_LINES.task_id%TYPE
34: ,expenditure_organization_id
35: AP_DISTRIBUTION_SET_LINES.expenditure_organization_id%TYPE
36: ,expenditure_type AP_DISTRIBUTION_SET_LINES.expenditure_type%TYPE
37: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
38: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
39: ,org_id AP_DISTRIBUTION_SET_LINES.org_id%TYPE
32: ,project_id AP_DISTRIBUTION_SET_LINES.project_id%TYPE
33: ,task_id AP_DISTRIBUTION_SET_LINES.task_id%TYPE
34: ,expenditure_organization_id
35: AP_DISTRIBUTION_SET_LINES.expenditure_organization_id%TYPE
36: ,expenditure_type AP_DISTRIBUTION_SET_LINES.expenditure_type%TYPE
37: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
38: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
39: ,org_id AP_DISTRIBUTION_SET_LINES.org_id%TYPE
40: ,award_id AP_DISTRIBUTION_SET_LINES.award_id%TYPE
35: AP_DISTRIBUTION_SET_LINES.expenditure_organization_id%TYPE
36: ,expenditure_type AP_DISTRIBUTION_SET_LINES.expenditure_type%TYPE
37: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
38: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
39: ,org_id AP_DISTRIBUTION_SET_LINES.org_id%TYPE
40: ,award_id AP_DISTRIBUTION_SET_LINES.award_id%TYPE
41: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
42: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE);
43:
36: ,expenditure_type AP_DISTRIBUTION_SET_LINES.expenditure_type%TYPE
37: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
38: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
39: ,org_id AP_DISTRIBUTION_SET_LINES.org_id%TYPE
40: ,award_id AP_DISTRIBUTION_SET_LINES.award_id%TYPE
41: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
42: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE);
43:
44: TYPE dset_line_tab_type IS TABLE OF r_dset_line_info