DBA Data[Home] [Help]

APPS.AP_MATCHING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 6: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,

2: /*$Header: apmatchs.pls 120.13.12010000.2 2009/02/12 11:56:56 mayyalas ship $*/
3:
4: TYPE r_dist_info IS RECORD
5: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
6: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
7: quantity_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
8: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
9: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
10: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,

Line 7: quantity_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,

3:
4: TYPE r_dist_info IS RECORD
5: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
6: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
7: quantity_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
8: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
9: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
10: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
11: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,

Line 8: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,

4: TYPE r_dist_info IS RECORD
5: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
6: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
7: quantity_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
8: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
9: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
10: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
11: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
12: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE,

Line 9: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,

5: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
6: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
7: quantity_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
8: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
9: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
10: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
11: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
12: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE,
13: po_ccid PO_DISTRIBUTIONS.code_combination_id%TYPE,

Line 10: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,

6: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
7: quantity_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
8: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
9: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
10: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
11: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
12: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE,
13: po_ccid PO_DISTRIBUTIONS.code_combination_id%TYPE,
14: accrue_on_receipt_flag PO_DISTRIBUTIONS.accrue_on_receipt_flag%TYPE,

Line 11: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,

7: quantity_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
8: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
9: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
10: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
11: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
12: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE,
13: po_ccid PO_DISTRIBUTIONS.code_combination_id%TYPE,
14: accrue_on_receipt_flag PO_DISTRIBUTIONS.accrue_on_receipt_flag%TYPE,
15: project_id PO_DISTRIBUTIONS.project_id%TYPE,

Line 12: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE,

8: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
9: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
10: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
11: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
12: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE,
13: po_ccid PO_DISTRIBUTIONS.code_combination_id%TYPE,
14: accrue_on_receipt_flag PO_DISTRIBUTIONS.accrue_on_receipt_flag%TYPE,
15: project_id PO_DISTRIBUTIONS.project_id%TYPE,
16: task_id PO_DISTRIBUTIONS.task_id%TYPE,

Line 21: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,

17: award_id PO_DISTRIBUTIONS.award_id%TYPE DEFAULT NULL,
18: expenditure_type PO_DISTRIBUTIONS.expenditure_type%TYPE,
19: expenditure_item_date PO_DISTRIBUTIONS.expenditure_item_date%TYPE,
20: expenditure_organization_id PO_DISTRIBUTIONS.expenditure_organization_id%TYPE,
21: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
22: awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE,
23: pay_awt_group_id AP_INVOICE_DISTRIBUTIONS.pay_awt_group_id%TYPE); --bug8222382
24:
25: TYPE dist_tab_type IS TABLE OF r_dist_info INDEX BY BINARY_INTEGER;

Line 22: awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE,

18: expenditure_type PO_DISTRIBUTIONS.expenditure_type%TYPE,
19: expenditure_item_date PO_DISTRIBUTIONS.expenditure_item_date%TYPE,
20: expenditure_organization_id PO_DISTRIBUTIONS.expenditure_organization_id%TYPE,
21: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
22: awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE,
23: pay_awt_group_id AP_INVOICE_DISTRIBUTIONS.pay_awt_group_id%TYPE); --bug8222382
24:
25: TYPE dist_tab_type IS TABLE OF r_dist_info INDEX BY BINARY_INTEGER;
26:

Line 23: pay_awt_group_id AP_INVOICE_DISTRIBUTIONS.pay_awt_group_id%TYPE); --bug8222382

19: expenditure_item_date PO_DISTRIBUTIONS.expenditure_item_date%TYPE,
20: expenditure_organization_id PO_DISTRIBUTIONS.expenditure_organization_id%TYPE,
21: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
22: awt_group_id AP_INVOICE_DISTRIBUTIONS.awt_group_id%TYPE,
23: pay_awt_group_id AP_INVOICE_DISTRIBUTIONS.pay_awt_group_id%TYPE); --bug8222382
24:
25: TYPE dist_tab_type IS TABLE OF r_dist_info INDEX BY BINARY_INTEGER;
26:
27:

Line 30: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,

26:
27:
28: TYPE r_corr_dist_info IS RECORD
29: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
30: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
31: corrected_inv_dist_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
32: corrected_quantity AP_INVOICE_DISTRIBUTIONS.corrected_quantity%TYPE,
33: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
34: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,

Line 31: corrected_inv_dist_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,

27:
28: TYPE r_corr_dist_info IS RECORD
29: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
30: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
31: corrected_inv_dist_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
32: corrected_quantity AP_INVOICE_DISTRIBUTIONS.corrected_quantity%TYPE,
33: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
34: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
35: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,

Line 32: corrected_quantity AP_INVOICE_DISTRIBUTIONS.corrected_quantity%TYPE,

28: TYPE r_corr_dist_info IS RECORD
29: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
30: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
31: corrected_inv_dist_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
32: corrected_quantity AP_INVOICE_DISTRIBUTIONS.corrected_quantity%TYPE,
33: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
34: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
35: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
36: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,

Line 33: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,

29: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
30: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
31: corrected_inv_dist_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
32: corrected_quantity AP_INVOICE_DISTRIBUTIONS.corrected_quantity%TYPE,
33: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
34: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
35: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
36: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
37: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,

Line 34: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,

30: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
31: corrected_inv_dist_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
32: corrected_quantity AP_INVOICE_DISTRIBUTIONS.corrected_quantity%TYPE,
33: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
34: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
35: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
36: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
37: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
38: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE);

Line 35: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,

31: corrected_inv_dist_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
32: corrected_quantity AP_INVOICE_DISTRIBUTIONS.corrected_quantity%TYPE,
33: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
34: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
35: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
36: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
37: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
38: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE);
39:

Line 36: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,

32: corrected_quantity AP_INVOICE_DISTRIBUTIONS.corrected_quantity%TYPE,
33: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
34: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
35: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
36: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
37: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
38: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE);
39:
40:

Line 37: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,

33: amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
34: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
35: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
36: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
37: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
38: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE);
39:
40:
41: TYPE corr_dist_tab_type IS TABLE OF r_corr_dist_info INDEX BY BINARY_INTEGER;

Line 38: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE);

34: base_amount AP_INVOICE_DISTRIBUTIONS.base_amount%TYPE,
35: rounding_amt AP_INVOICE_DISTRIBUTIONS.rounding_amt%TYPE,
36: unit_price AP_INVOICE_DISTRIBUTIONS.unit_price%TYPE,
37: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
38: dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE);
39:
40:
41: TYPE corr_dist_tab_type IS TABLE OF r_corr_dist_info INDEX BY BINARY_INTEGER;
42: