2: /* $Header: apinlins.pls 120.17 2011/01/19 11:42:31 sbonala ship $ */
3:
4: TYPE r_dist_info IS RECORD
5: (
6: dist_line_num AP_INVOICE_DISTRIBUTIONS.distribution_line_number%TYPE
7: ,accounting_date AP_INVOICE_DISTRIBUTIONS.accounting_date%TYPE
8: ,period_name AP_INVOICE_DISTRIBUTIONS.period_name%TYPE
9: ,description AP_INVOICE_DISTRIBUTIONS.description%TYPE
10: ,dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE
3:
4: TYPE r_dist_info IS RECORD
5: (
6: dist_line_num AP_INVOICE_DISTRIBUTIONS.distribution_line_number%TYPE
7: ,accounting_date AP_INVOICE_DISTRIBUTIONS.accounting_date%TYPE
8: ,period_name AP_INVOICE_DISTRIBUTIONS.period_name%TYPE
9: ,description AP_INVOICE_DISTRIBUTIONS.description%TYPE
10: ,dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE
11: ,charge_applicable_to_dist
4: TYPE r_dist_info IS RECORD
5: (
6: dist_line_num AP_INVOICE_DISTRIBUTIONS.distribution_line_number%TYPE
7: ,accounting_date AP_INVOICE_DISTRIBUTIONS.accounting_date%TYPE
8: ,period_name AP_INVOICE_DISTRIBUTIONS.period_name%TYPE
9: ,description AP_INVOICE_DISTRIBUTIONS.description%TYPE
10: ,dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE
11: ,charge_applicable_to_dist
12: AP_INVOICE_DISTRIBUTIONS.charge_applicable_to_dist_id%TYPE
5: (
6: dist_line_num AP_INVOICE_DISTRIBUTIONS.distribution_line_number%TYPE
7: ,accounting_date AP_INVOICE_DISTRIBUTIONS.accounting_date%TYPE
8: ,period_name AP_INVOICE_DISTRIBUTIONS.period_name%TYPE
9: ,description AP_INVOICE_DISTRIBUTIONS.description%TYPE
10: ,dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE
11: ,charge_applicable_to_dist
12: AP_INVOICE_DISTRIBUTIONS.charge_applicable_to_dist_id%TYPE
13: ,project_id AP_INVOICE_DISTRIBUTIONS.project_id%TYPE
6: dist_line_num AP_INVOICE_DISTRIBUTIONS.distribution_line_number%TYPE
7: ,accounting_date AP_INVOICE_DISTRIBUTIONS.accounting_date%TYPE
8: ,period_name AP_INVOICE_DISTRIBUTIONS.period_name%TYPE
9: ,description AP_INVOICE_DISTRIBUTIONS.description%TYPE
10: ,dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE
11: ,charge_applicable_to_dist
12: AP_INVOICE_DISTRIBUTIONS.charge_applicable_to_dist_id%TYPE
13: ,project_id AP_INVOICE_DISTRIBUTIONS.project_id%TYPE
14: ,task_id AP_INVOICE_DISTRIBUTIONS.task_id%TYPE
8: ,period_name AP_INVOICE_DISTRIBUTIONS.period_name%TYPE
9: ,description AP_INVOICE_DISTRIBUTIONS.description%TYPE
10: ,dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE
11: ,charge_applicable_to_dist
12: AP_INVOICE_DISTRIBUTIONS.charge_applicable_to_dist_id%TYPE
13: ,project_id AP_INVOICE_DISTRIBUTIONS.project_id%TYPE
14: ,task_id AP_INVOICE_DISTRIBUTIONS.task_id%TYPE
15: ,expenditure_type AP_INVOICE_DISTRIBUTIONS.expenditure_type%TYPE
16: ,expenditure_organization_id
9: ,description AP_INVOICE_DISTRIBUTIONS.description%TYPE
10: ,dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE
11: ,charge_applicable_to_dist
12: AP_INVOICE_DISTRIBUTIONS.charge_applicable_to_dist_id%TYPE
13: ,project_id AP_INVOICE_DISTRIBUTIONS.project_id%TYPE
14: ,task_id AP_INVOICE_DISTRIBUTIONS.task_id%TYPE
15: ,expenditure_type AP_INVOICE_DISTRIBUTIONS.expenditure_type%TYPE
16: ,expenditure_organization_id
17: AP_INVOICE_DISTRIBUTIONS.expenditure_organization_id%TYPE
10: ,dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE
11: ,charge_applicable_to_dist
12: AP_INVOICE_DISTRIBUTIONS.charge_applicable_to_dist_id%TYPE
13: ,project_id AP_INVOICE_DISTRIBUTIONS.project_id%TYPE
14: ,task_id AP_INVOICE_DISTRIBUTIONS.task_id%TYPE
15: ,expenditure_type AP_INVOICE_DISTRIBUTIONS.expenditure_type%TYPE
16: ,expenditure_organization_id
17: AP_INVOICE_DISTRIBUTIONS.expenditure_organization_id%TYPE
18: ,expenditure_item_date AP_INVOICE_DISTRIBUTIONS.expenditure_item_date%TYPE
11: ,charge_applicable_to_dist
12: AP_INVOICE_DISTRIBUTIONS.charge_applicable_to_dist_id%TYPE
13: ,project_id AP_INVOICE_DISTRIBUTIONS.project_id%TYPE
14: ,task_id AP_INVOICE_DISTRIBUTIONS.task_id%TYPE
15: ,expenditure_type AP_INVOICE_DISTRIBUTIONS.expenditure_type%TYPE
16: ,expenditure_organization_id
17: AP_INVOICE_DISTRIBUTIONS.expenditure_organization_id%TYPE
18: ,expenditure_item_date AP_INVOICE_DISTRIBUTIONS.expenditure_item_date%TYPE
19: ,project_accounting_context AP_INVOICE_DISTRIBUTIONS.project_accounting_context%TYPE
13: ,project_id AP_INVOICE_DISTRIBUTIONS.project_id%TYPE
14: ,task_id AP_INVOICE_DISTRIBUTIONS.task_id%TYPE
15: ,expenditure_type AP_INVOICE_DISTRIBUTIONS.expenditure_type%TYPE
16: ,expenditure_organization_id
17: AP_INVOICE_DISTRIBUTIONS.expenditure_organization_id%TYPE
18: ,expenditure_item_date AP_INVOICE_DISTRIBUTIONS.expenditure_item_date%TYPE
19: ,project_accounting_context AP_INVOICE_DISTRIBUTIONS.project_accounting_context%TYPE
20: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
21: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
14: ,task_id AP_INVOICE_DISTRIBUTIONS.task_id%TYPE
15: ,expenditure_type AP_INVOICE_DISTRIBUTIONS.expenditure_type%TYPE
16: ,expenditure_organization_id
17: AP_INVOICE_DISTRIBUTIONS.expenditure_organization_id%TYPE
18: ,expenditure_item_date AP_INVOICE_DISTRIBUTIONS.expenditure_item_date%TYPE
19: ,project_accounting_context AP_INVOICE_DISTRIBUTIONS.project_accounting_context%TYPE
20: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
21: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
22: ,award_id AP_INVOICE_DISTRIBUTIONS.award_id%TYPE
15: ,expenditure_type AP_INVOICE_DISTRIBUTIONS.expenditure_type%TYPE
16: ,expenditure_organization_id
17: AP_INVOICE_DISTRIBUTIONS.expenditure_organization_id%TYPE
18: ,expenditure_item_date AP_INVOICE_DISTRIBUTIONS.expenditure_item_date%TYPE
19: ,project_accounting_context AP_INVOICE_DISTRIBUTIONS.project_accounting_context%TYPE
20: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
21: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
22: ,award_id AP_INVOICE_DISTRIBUTIONS.award_id%TYPE
23: ,attribute_category AP_INVOICE_DISTRIBUTIONS.attribute_category%TYPE
16: ,expenditure_organization_id
17: AP_INVOICE_DISTRIBUTIONS.expenditure_organization_id%TYPE
18: ,expenditure_item_date AP_INVOICE_DISTRIBUTIONS.expenditure_item_date%TYPE
19: ,project_accounting_context AP_INVOICE_DISTRIBUTIONS.project_accounting_context%TYPE
20: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
21: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
22: ,award_id AP_INVOICE_DISTRIBUTIONS.award_id%TYPE
23: ,attribute_category AP_INVOICE_DISTRIBUTIONS.attribute_category%TYPE
24: ,attribute1 AP_INVOICE_DISTRIBUTIONS.attribute1%TYPE
17: AP_INVOICE_DISTRIBUTIONS.expenditure_organization_id%TYPE
18: ,expenditure_item_date AP_INVOICE_DISTRIBUTIONS.expenditure_item_date%TYPE
19: ,project_accounting_context AP_INVOICE_DISTRIBUTIONS.project_accounting_context%TYPE
20: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
21: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
22: ,award_id AP_INVOICE_DISTRIBUTIONS.award_id%TYPE
23: ,attribute_category AP_INVOICE_DISTRIBUTIONS.attribute_category%TYPE
24: ,attribute1 AP_INVOICE_DISTRIBUTIONS.attribute1%TYPE
25: ,attribute2 AP_INVOICE_DISTRIBUTIONS.attribute2%TYPE
18: ,expenditure_item_date AP_INVOICE_DISTRIBUTIONS.expenditure_item_date%TYPE
19: ,project_accounting_context AP_INVOICE_DISTRIBUTIONS.project_accounting_context%TYPE
20: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
21: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
22: ,award_id AP_INVOICE_DISTRIBUTIONS.award_id%TYPE
23: ,attribute_category AP_INVOICE_DISTRIBUTIONS.attribute_category%TYPE
24: ,attribute1 AP_INVOICE_DISTRIBUTIONS.attribute1%TYPE
25: ,attribute2 AP_INVOICE_DISTRIBUTIONS.attribute2%TYPE
26: ,attribute3 AP_INVOICE_DISTRIBUTIONS.attribute3%TYPE
19: ,project_accounting_context AP_INVOICE_DISTRIBUTIONS.project_accounting_context%TYPE
20: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
21: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
22: ,award_id AP_INVOICE_DISTRIBUTIONS.award_id%TYPE
23: ,attribute_category AP_INVOICE_DISTRIBUTIONS.attribute_category%TYPE
24: ,attribute1 AP_INVOICE_DISTRIBUTIONS.attribute1%TYPE
25: ,attribute2 AP_INVOICE_DISTRIBUTIONS.attribute2%TYPE
26: ,attribute3 AP_INVOICE_DISTRIBUTIONS.attribute3%TYPE
27: ,attribute4 AP_INVOICE_DISTRIBUTIONS.attribute4%TYPE
20: ,pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
21: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
22: ,award_id AP_INVOICE_DISTRIBUTIONS.award_id%TYPE
23: ,attribute_category AP_INVOICE_DISTRIBUTIONS.attribute_category%TYPE
24: ,attribute1 AP_INVOICE_DISTRIBUTIONS.attribute1%TYPE
25: ,attribute2 AP_INVOICE_DISTRIBUTIONS.attribute2%TYPE
26: ,attribute3 AP_INVOICE_DISTRIBUTIONS.attribute3%TYPE
27: ,attribute4 AP_INVOICE_DISTRIBUTIONS.attribute4%TYPE
28: ,attribute5 AP_INVOICE_DISTRIBUTIONS.attribute5%TYPE
21: ,pa_addition_flag AP_INVOICE_DISTRIBUTIONS.pa_addition_flag%TYPE
22: ,award_id AP_INVOICE_DISTRIBUTIONS.award_id%TYPE
23: ,attribute_category AP_INVOICE_DISTRIBUTIONS.attribute_category%TYPE
24: ,attribute1 AP_INVOICE_DISTRIBUTIONS.attribute1%TYPE
25: ,attribute2 AP_INVOICE_DISTRIBUTIONS.attribute2%TYPE
26: ,attribute3 AP_INVOICE_DISTRIBUTIONS.attribute3%TYPE
27: ,attribute4 AP_INVOICE_DISTRIBUTIONS.attribute4%TYPE
28: ,attribute5 AP_INVOICE_DISTRIBUTIONS.attribute5%TYPE
29: ,attribute6 AP_INVOICE_DISTRIBUTIONS.attribute6%TYPE
22: ,award_id AP_INVOICE_DISTRIBUTIONS.award_id%TYPE
23: ,attribute_category AP_INVOICE_DISTRIBUTIONS.attribute_category%TYPE
24: ,attribute1 AP_INVOICE_DISTRIBUTIONS.attribute1%TYPE
25: ,attribute2 AP_INVOICE_DISTRIBUTIONS.attribute2%TYPE
26: ,attribute3 AP_INVOICE_DISTRIBUTIONS.attribute3%TYPE
27: ,attribute4 AP_INVOICE_DISTRIBUTIONS.attribute4%TYPE
28: ,attribute5 AP_INVOICE_DISTRIBUTIONS.attribute5%TYPE
29: ,attribute6 AP_INVOICE_DISTRIBUTIONS.attribute6%TYPE
30: ,attribute7 AP_INVOICE_DISTRIBUTIONS.attribute7%TYPE
23: ,attribute_category AP_INVOICE_DISTRIBUTIONS.attribute_category%TYPE
24: ,attribute1 AP_INVOICE_DISTRIBUTIONS.attribute1%TYPE
25: ,attribute2 AP_INVOICE_DISTRIBUTIONS.attribute2%TYPE
26: ,attribute3 AP_INVOICE_DISTRIBUTIONS.attribute3%TYPE
27: ,attribute4 AP_INVOICE_DISTRIBUTIONS.attribute4%TYPE
28: ,attribute5 AP_INVOICE_DISTRIBUTIONS.attribute5%TYPE
29: ,attribute6 AP_INVOICE_DISTRIBUTIONS.attribute6%TYPE
30: ,attribute7 AP_INVOICE_DISTRIBUTIONS.attribute7%TYPE
31: ,attribute8 AP_INVOICE_DISTRIBUTIONS.attribute8%TYPE
24: ,attribute1 AP_INVOICE_DISTRIBUTIONS.attribute1%TYPE
25: ,attribute2 AP_INVOICE_DISTRIBUTIONS.attribute2%TYPE
26: ,attribute3 AP_INVOICE_DISTRIBUTIONS.attribute3%TYPE
27: ,attribute4 AP_INVOICE_DISTRIBUTIONS.attribute4%TYPE
28: ,attribute5 AP_INVOICE_DISTRIBUTIONS.attribute5%TYPE
29: ,attribute6 AP_INVOICE_DISTRIBUTIONS.attribute6%TYPE
30: ,attribute7 AP_INVOICE_DISTRIBUTIONS.attribute7%TYPE
31: ,attribute8 AP_INVOICE_DISTRIBUTIONS.attribute8%TYPE
32: ,attribute9 AP_INVOICE_DISTRIBUTIONS.attribute9%TYPE
25: ,attribute2 AP_INVOICE_DISTRIBUTIONS.attribute2%TYPE
26: ,attribute3 AP_INVOICE_DISTRIBUTIONS.attribute3%TYPE
27: ,attribute4 AP_INVOICE_DISTRIBUTIONS.attribute4%TYPE
28: ,attribute5 AP_INVOICE_DISTRIBUTIONS.attribute5%TYPE
29: ,attribute6 AP_INVOICE_DISTRIBUTIONS.attribute6%TYPE
30: ,attribute7 AP_INVOICE_DISTRIBUTIONS.attribute7%TYPE
31: ,attribute8 AP_INVOICE_DISTRIBUTIONS.attribute8%TYPE
32: ,attribute9 AP_INVOICE_DISTRIBUTIONS.attribute9%TYPE
33: ,attribute10 AP_INVOICE_DISTRIBUTIONS.attribute10%TYPE
26: ,attribute3 AP_INVOICE_DISTRIBUTIONS.attribute3%TYPE
27: ,attribute4 AP_INVOICE_DISTRIBUTIONS.attribute4%TYPE
28: ,attribute5 AP_INVOICE_DISTRIBUTIONS.attribute5%TYPE
29: ,attribute6 AP_INVOICE_DISTRIBUTIONS.attribute6%TYPE
30: ,attribute7 AP_INVOICE_DISTRIBUTIONS.attribute7%TYPE
31: ,attribute8 AP_INVOICE_DISTRIBUTIONS.attribute8%TYPE
32: ,attribute9 AP_INVOICE_DISTRIBUTIONS.attribute9%TYPE
33: ,attribute10 AP_INVOICE_DISTRIBUTIONS.attribute10%TYPE
34: ,attribute11 AP_INVOICE_DISTRIBUTIONS.attribute11%TYPE
27: ,attribute4 AP_INVOICE_DISTRIBUTIONS.attribute4%TYPE
28: ,attribute5 AP_INVOICE_DISTRIBUTIONS.attribute5%TYPE
29: ,attribute6 AP_INVOICE_DISTRIBUTIONS.attribute6%TYPE
30: ,attribute7 AP_INVOICE_DISTRIBUTIONS.attribute7%TYPE
31: ,attribute8 AP_INVOICE_DISTRIBUTIONS.attribute8%TYPE
32: ,attribute9 AP_INVOICE_DISTRIBUTIONS.attribute9%TYPE
33: ,attribute10 AP_INVOICE_DISTRIBUTIONS.attribute10%TYPE
34: ,attribute11 AP_INVOICE_DISTRIBUTIONS.attribute11%TYPE
35: ,attribute12 AP_INVOICE_DISTRIBUTIONS.attribute12%TYPE
28: ,attribute5 AP_INVOICE_DISTRIBUTIONS.attribute5%TYPE
29: ,attribute6 AP_INVOICE_DISTRIBUTIONS.attribute6%TYPE
30: ,attribute7 AP_INVOICE_DISTRIBUTIONS.attribute7%TYPE
31: ,attribute8 AP_INVOICE_DISTRIBUTIONS.attribute8%TYPE
32: ,attribute9 AP_INVOICE_DISTRIBUTIONS.attribute9%TYPE
33: ,attribute10 AP_INVOICE_DISTRIBUTIONS.attribute10%TYPE
34: ,attribute11 AP_INVOICE_DISTRIBUTIONS.attribute11%TYPE
35: ,attribute12 AP_INVOICE_DISTRIBUTIONS.attribute12%TYPE
36: ,attribute13 AP_INVOICE_DISTRIBUTIONS.attribute13%TYPE
29: ,attribute6 AP_INVOICE_DISTRIBUTIONS.attribute6%TYPE
30: ,attribute7 AP_INVOICE_DISTRIBUTIONS.attribute7%TYPE
31: ,attribute8 AP_INVOICE_DISTRIBUTIONS.attribute8%TYPE
32: ,attribute9 AP_INVOICE_DISTRIBUTIONS.attribute9%TYPE
33: ,attribute10 AP_INVOICE_DISTRIBUTIONS.attribute10%TYPE
34: ,attribute11 AP_INVOICE_DISTRIBUTIONS.attribute11%TYPE
35: ,attribute12 AP_INVOICE_DISTRIBUTIONS.attribute12%TYPE
36: ,attribute13 AP_INVOICE_DISTRIBUTIONS.attribute13%TYPE
37: ,attribute14 AP_INVOICE_DISTRIBUTIONS.attribute14%TYPE
30: ,attribute7 AP_INVOICE_DISTRIBUTIONS.attribute7%TYPE
31: ,attribute8 AP_INVOICE_DISTRIBUTIONS.attribute8%TYPE
32: ,attribute9 AP_INVOICE_DISTRIBUTIONS.attribute9%TYPE
33: ,attribute10 AP_INVOICE_DISTRIBUTIONS.attribute10%TYPE
34: ,attribute11 AP_INVOICE_DISTRIBUTIONS.attribute11%TYPE
35: ,attribute12 AP_INVOICE_DISTRIBUTIONS.attribute12%TYPE
36: ,attribute13 AP_INVOICE_DISTRIBUTIONS.attribute13%TYPE
37: ,attribute14 AP_INVOICE_DISTRIBUTIONS.attribute14%TYPE
38: ,attribute15 AP_INVOICE_DISTRIBUTIONS.attribute15%TYPE
31: ,attribute8 AP_INVOICE_DISTRIBUTIONS.attribute8%TYPE
32: ,attribute9 AP_INVOICE_DISTRIBUTIONS.attribute9%TYPE
33: ,attribute10 AP_INVOICE_DISTRIBUTIONS.attribute10%TYPE
34: ,attribute11 AP_INVOICE_DISTRIBUTIONS.attribute11%TYPE
35: ,attribute12 AP_INVOICE_DISTRIBUTIONS.attribute12%TYPE
36: ,attribute13 AP_INVOICE_DISTRIBUTIONS.attribute13%TYPE
37: ,attribute14 AP_INVOICE_DISTRIBUTIONS.attribute14%TYPE
38: ,attribute15 AP_INVOICE_DISTRIBUTIONS.attribute15%TYPE
39: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
32: ,attribute9 AP_INVOICE_DISTRIBUTIONS.attribute9%TYPE
33: ,attribute10 AP_INVOICE_DISTRIBUTIONS.attribute10%TYPE
34: ,attribute11 AP_INVOICE_DISTRIBUTIONS.attribute11%TYPE
35: ,attribute12 AP_INVOICE_DISTRIBUTIONS.attribute12%TYPE
36: ,attribute13 AP_INVOICE_DISTRIBUTIONS.attribute13%TYPE
37: ,attribute14 AP_INVOICE_DISTRIBUTIONS.attribute14%TYPE
38: ,attribute15 AP_INVOICE_DISTRIBUTIONS.attribute15%TYPE
39: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
40: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE
33: ,attribute10 AP_INVOICE_DISTRIBUTIONS.attribute10%TYPE
34: ,attribute11 AP_INVOICE_DISTRIBUTIONS.attribute11%TYPE
35: ,attribute12 AP_INVOICE_DISTRIBUTIONS.attribute12%TYPE
36: ,attribute13 AP_INVOICE_DISTRIBUTIONS.attribute13%TYPE
37: ,attribute14 AP_INVOICE_DISTRIBUTIONS.attribute14%TYPE
38: ,attribute15 AP_INVOICE_DISTRIBUTIONS.attribute15%TYPE
39: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
40: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE
41: ,rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE
34: ,attribute11 AP_INVOICE_DISTRIBUTIONS.attribute11%TYPE
35: ,attribute12 AP_INVOICE_DISTRIBUTIONS.attribute12%TYPE
36: ,attribute13 AP_INVOICE_DISTRIBUTIONS.attribute13%TYPE
37: ,attribute14 AP_INVOICE_DISTRIBUTIONS.attribute14%TYPE
38: ,attribute15 AP_INVOICE_DISTRIBUTIONS.attribute15%TYPE
39: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
40: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE
41: ,rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE
42: ,type_1099 AP_INVOICE_DISTRIBUTIONS.type_1099%TYPE
35: ,attribute12 AP_INVOICE_DISTRIBUTIONS.attribute12%TYPE
36: ,attribute13 AP_INVOICE_DISTRIBUTIONS.attribute13%TYPE
37: ,attribute14 AP_INVOICE_DISTRIBUTIONS.attribute14%TYPE
38: ,attribute15 AP_INVOICE_DISTRIBUTIONS.attribute15%TYPE
39: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
40: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE
41: ,rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE
42: ,type_1099 AP_INVOICE_DISTRIBUTIONS.type_1099%TYPE
43: ,income_tax_region AP_INVOICE_DISTRIBUTIONS.income_tax_region%TYPE
36: ,attribute13 AP_INVOICE_DISTRIBUTIONS.attribute13%TYPE
37: ,attribute14 AP_INVOICE_DISTRIBUTIONS.attribute14%TYPE
38: ,attribute15 AP_INVOICE_DISTRIBUTIONS.attribute15%TYPE
39: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
40: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE
41: ,rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE
42: ,type_1099 AP_INVOICE_DISTRIBUTIONS.type_1099%TYPE
43: ,income_tax_region AP_INVOICE_DISTRIBUTIONS.income_tax_region%TYPE
44: ,assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.assets_tracking_flag%TYPE
37: ,attribute14 AP_INVOICE_DISTRIBUTIONS.attribute14%TYPE
38: ,attribute15 AP_INVOICE_DISTRIBUTIONS.attribute15%TYPE
39: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
40: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE
41: ,rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE
42: ,type_1099 AP_INVOICE_DISTRIBUTIONS.type_1099%TYPE
43: ,income_tax_region AP_INVOICE_DISTRIBUTIONS.income_tax_region%TYPE
44: ,assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.assets_tracking_flag%TYPE
45: ,asset_book_type_code AP_INVOICE_DISTRIBUTIONS.asset_book_type_code%TYPE
38: ,attribute15 AP_INVOICE_DISTRIBUTIONS.attribute15%TYPE
39: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
40: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE
41: ,rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE
42: ,type_1099 AP_INVOICE_DISTRIBUTIONS.type_1099%TYPE
43: ,income_tax_region AP_INVOICE_DISTRIBUTIONS.income_tax_region%TYPE
44: ,assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.assets_tracking_flag%TYPE
45: ,asset_book_type_code AP_INVOICE_DISTRIBUTIONS.asset_book_type_code%TYPE
46: ,asset_category_id AP_INVOICE_DISTRIBUTIONS.asset_category_id%TYPE
39: ,amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE
40: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE
41: ,rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE
42: ,type_1099 AP_INVOICE_DISTRIBUTIONS.type_1099%TYPE
43: ,income_tax_region AP_INVOICE_DISTRIBUTIONS.income_tax_region%TYPE
44: ,assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.assets_tracking_flag%TYPE
45: ,asset_book_type_code AP_INVOICE_DISTRIBUTIONS.asset_book_type_code%TYPE
46: ,asset_category_id AP_INVOICE_DISTRIBUTIONS.asset_category_id%TYPE
47: ,awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE
40: ,base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE
41: ,rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE
42: ,type_1099 AP_INVOICE_DISTRIBUTIONS.type_1099%TYPE
43: ,income_tax_region AP_INVOICE_DISTRIBUTIONS.income_tax_region%TYPE
44: ,assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.assets_tracking_flag%TYPE
45: ,asset_book_type_code AP_INVOICE_DISTRIBUTIONS.asset_book_type_code%TYPE
46: ,asset_category_id AP_INVOICE_DISTRIBUTIONS.asset_category_id%TYPE
47: ,awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE
48: ,org_id AP_INVOICE_DISTRIBUTIONS.org_id%TYPE
41: ,rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE
42: ,type_1099 AP_INVOICE_DISTRIBUTIONS.type_1099%TYPE
43: ,income_tax_region AP_INVOICE_DISTRIBUTIONS.income_tax_region%TYPE
44: ,assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.assets_tracking_flag%TYPE
45: ,asset_book_type_code AP_INVOICE_DISTRIBUTIONS.asset_book_type_code%TYPE
46: ,asset_category_id AP_INVOICE_DISTRIBUTIONS.asset_category_id%TYPE
47: ,awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE
48: ,org_id AP_INVOICE_DISTRIBUTIONS.org_id%TYPE
49: ,set_of_books_id AP_INVOICE_DISTRIBUTIONS.set_of_books_id%TYPE
42: ,type_1099 AP_INVOICE_DISTRIBUTIONS.type_1099%TYPE
43: ,income_tax_region AP_INVOICE_DISTRIBUTIONS.income_tax_region%TYPE
44: ,assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.assets_tracking_flag%TYPE
45: ,asset_book_type_code AP_INVOICE_DISTRIBUTIONS.asset_book_type_code%TYPE
46: ,asset_category_id AP_INVOICE_DISTRIBUTIONS.asset_category_id%TYPE
47: ,awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE
48: ,org_id AP_INVOICE_DISTRIBUTIONS.org_id%TYPE
49: ,set_of_books_id AP_INVOICE_DISTRIBUTIONS.set_of_books_id%TYPE
50: --ETAX: Invwkb
43: ,income_tax_region AP_INVOICE_DISTRIBUTIONS.income_tax_region%TYPE
44: ,assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.assets_tracking_flag%TYPE
45: ,asset_book_type_code AP_INVOICE_DISTRIBUTIONS.asset_book_type_code%TYPE
46: ,asset_category_id AP_INVOICE_DISTRIBUTIONS.asset_category_id%TYPE
47: ,awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE
48: ,org_id AP_INVOICE_DISTRIBUTIONS.org_id%TYPE
49: ,set_of_books_id AP_INVOICE_DISTRIBUTIONS.set_of_books_id%TYPE
50: --ETAX: Invwkb
51: ,intended_use AP_INVOICE_DISTRIBUTIONS.intended_use%TYPE
44: ,assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.assets_tracking_flag%TYPE
45: ,asset_book_type_code AP_INVOICE_DISTRIBUTIONS.asset_book_type_code%TYPE
46: ,asset_category_id AP_INVOICE_DISTRIBUTIONS.asset_category_id%TYPE
47: ,awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE
48: ,org_id AP_INVOICE_DISTRIBUTIONS.org_id%TYPE
49: ,set_of_books_id AP_INVOICE_DISTRIBUTIONS.set_of_books_id%TYPE
50: --ETAX: Invwkb
51: ,intended_use AP_INVOICE_DISTRIBUTIONS.intended_use%TYPE
52: --bugfix:4674194
45: ,asset_book_type_code AP_INVOICE_DISTRIBUTIONS.asset_book_type_code%TYPE
46: ,asset_category_id AP_INVOICE_DISTRIBUTIONS.asset_category_id%TYPE
47: ,awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE
48: ,org_id AP_INVOICE_DISTRIBUTIONS.org_id%TYPE
49: ,set_of_books_id AP_INVOICE_DISTRIBUTIONS.set_of_books_id%TYPE
50: --ETAX: Invwkb
51: ,intended_use AP_INVOICE_DISTRIBUTIONS.intended_use%TYPE
52: --bugfix:4674194
53: ,global_attribute3 AP_INVOICE_DISTRIBUTIONS.global_attribute3%TYPE
47: ,awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE
48: ,org_id AP_INVOICE_DISTRIBUTIONS.org_id%TYPE
49: ,set_of_books_id AP_INVOICE_DISTRIBUTIONS.set_of_books_id%TYPE
50: --ETAX: Invwkb
51: ,intended_use AP_INVOICE_DISTRIBUTIONS.intended_use%TYPE
52: --bugfix:4674194
53: ,global_attribute3 AP_INVOICE_DISTRIBUTIONS.global_attribute3%TYPE
54: --7022001
55: ,pay_awt_group_id AP_INVOICE_DISTRIBUTIONS.pay_awt_group_id%TYPE
49: ,set_of_books_id AP_INVOICE_DISTRIBUTIONS.set_of_books_id%TYPE
50: --ETAX: Invwkb
51: ,intended_use AP_INVOICE_DISTRIBUTIONS.intended_use%TYPE
52: --bugfix:4674194
53: ,global_attribute3 AP_INVOICE_DISTRIBUTIONS.global_attribute3%TYPE
54: --7022001
55: ,pay_awt_group_id AP_INVOICE_DISTRIBUTIONS.pay_awt_group_id%TYPE
56: --Bug9296445
57: ,reference_1 AP_INVOICE_DISTRIBUTIONS.reference_1%TYPE
51: ,intended_use AP_INVOICE_DISTRIBUTIONS.intended_use%TYPE
52: --bugfix:4674194
53: ,global_attribute3 AP_INVOICE_DISTRIBUTIONS.global_attribute3%TYPE
54: --7022001
55: ,pay_awt_group_id AP_INVOICE_DISTRIBUTIONS.pay_awt_group_id%TYPE
56: --Bug9296445
57: ,reference_1 AP_INVOICE_DISTRIBUTIONS.reference_1%TYPE
58: ,reference_2 AP_INVOICE_DISTRIBUTIONS.reference_2%TYPE
59: --Bug10241241
53: ,global_attribute3 AP_INVOICE_DISTRIBUTIONS.global_attribute3%TYPE
54: --7022001
55: ,pay_awt_group_id AP_INVOICE_DISTRIBUTIONS.pay_awt_group_id%TYPE
56: --Bug9296445
57: ,reference_1 AP_INVOICE_DISTRIBUTIONS.reference_1%TYPE
58: ,reference_2 AP_INVOICE_DISTRIBUTIONS.reference_2%TYPE
59: --Bug10241241
60: ,stat_amount AP_INVOICE_DISTRIBUTIONS.stat_amount%TYPE
61: );
54: --7022001
55: ,pay_awt_group_id AP_INVOICE_DISTRIBUTIONS.pay_awt_group_id%TYPE
56: --Bug9296445
57: ,reference_1 AP_INVOICE_DISTRIBUTIONS.reference_1%TYPE
58: ,reference_2 AP_INVOICE_DISTRIBUTIONS.reference_2%TYPE
59: --Bug10241241
60: ,stat_amount AP_INVOICE_DISTRIBUTIONS.stat_amount%TYPE
61: );
62:
56: --Bug9296445
57: ,reference_1 AP_INVOICE_DISTRIBUTIONS.reference_1%TYPE
58: ,reference_2 AP_INVOICE_DISTRIBUTIONS.reference_2%TYPE
59: --Bug10241241
60: ,stat_amount AP_INVOICE_DISTRIBUTIONS.stat_amount%TYPE
61: );
62:
63:
64: TYPE r_alloc_line IS RECORD
204: X_line_number IN NUMBER) RETURN NUMBER;
205:
206: -- table to hols the dist ids that can be adjusted - bug 6892789
207: TYPE distribution_id_tab_type IS
208: TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE
209: INDEX BY BINARY_INTEGER;
210:
211: -- function modified to get the dists that can be adjusted - bug 6892789
212: FUNCTION round_base_amts(
263: P_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
264:
265: -- Bug 5114543
266: -- Allow discard of an item line with allocated charges. This utility is placed in the spec
267: -- so that it can be invoked from ap_invoice_lines_pkg and ap_invoice_distributions_pkg.
268:
269: /*=============================================================================
270: | Public Function Reverse_Charge_distributions
271: |