DBA Data[Home] [Help]

APPS.AP_MATCHING_PKG dependencies on PO_DISTRIBUTIONS

Line 5: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column

1: PACKAGE AP_MATCHING_PKG AUTHID CURRENT_USER AS
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,

Line 13: po_ccid PO_DISTRIBUTIONS.code_combination_id%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,
17: award_id PO_DISTRIBUTIONS.award_id%TYPE DEFAULT NULL,

Line 14: accrue_on_receipt_flag PO_DISTRIBUTIONS.accrue_on_receipt_flag%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,
17: award_id PO_DISTRIBUTIONS.award_id%TYPE DEFAULT NULL,
18: expenditure_type PO_DISTRIBUTIONS.expenditure_type%TYPE,

Line 15: project_id PO_DISTRIBUTIONS.project_id%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,
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,

Line 16: task_id PO_DISTRIBUTIONS.task_id%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,
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,

Line 17: award_id PO_DISTRIBUTIONS.award_id%TYPE DEFAULT NULL,

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,
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,

Line 18: expenditure_type PO_DISTRIBUTIONS.expenditure_type%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,
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,

Line 19: expenditure_item_date PO_DISTRIBUTIONS.expenditure_item_date%TYPE,

15: project_id PO_DISTRIBUTIONS.project_id%TYPE,
16: task_id PO_DISTRIBUTIONS.task_id%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

Line 20: expenditure_organization_id PO_DISTRIBUTIONS.expenditure_organization_id%TYPE,

16: task_id PO_DISTRIBUTIONS.task_id%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:

Line 29: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column

25: TYPE dist_tab_type IS TABLE OF r_dist_info INDEX BY BINARY_INTEGER;
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,