DBA Data[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on PO_DISTRIBUTIONS

Line 609: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';

605: p_retainage_withheld_amt => NULL,
606: p_retainage_released_amt => NULL
607: );
608:
609: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
610: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
612: END IF;
613:

Line 1208: po_distributions.line_location_id%TYPE;

1204: ap_invoice_distributions.tax_recoverable_flag%TYPE;
1205: l_po_distribution_id
1206: ap_invoice_distributions.po_distribution_id%TYPE;
1207: l_line_location_id
1208: po_distributions.line_location_id%TYPE;
1209: l_accrue_on_receipt
1210: po_distributions.accrue_on_receipt_flag%TYPE;
1211: l_dist_count NUMBER;
1212: l_user_id NUMBER;

Line 1210: po_distributions.accrue_on_receipt_flag%TYPE;

1206: ap_invoice_distributions.po_distribution_id%TYPE;
1207: l_line_location_id
1208: po_distributions.line_location_id%TYPE;
1209: l_accrue_on_receipt
1210: po_distributions.accrue_on_receipt_flag%TYPE;
1211: l_dist_count NUMBER;
1212: l_user_id NUMBER;
1213: l_dist_attribute_category
1214: ap_invoice_distributions.attribute_category%TYPE;

Line 1362: po_distributions PD,

1358: gsob.chart_of_accounts_id
1359: FROM ap_invoice_distributions AID,
1360: ap_invoices AI,
1361: ap_suppliers PV,
1362: po_distributions PD,
1363: ap_system_parameters ap,
1364: gl_sets_of_books gsob
1365: WHERE AI.invoice_id = X_invoice_id
1366: AND AID.invoice_id = AI.invoice_id

Line 4798: l_po_accrue_on_receipt_flag PO_DISTRIBUTIONS.ACCRUE_ON_RECEIPT_FLAG%TYPE;

4794: X_default_dist_ccid IN AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE) --bug 5386396
4795: RETURN BOOLEAN
4796: IS
4797:
4798: l_po_accrue_on_receipt_flag PO_DISTRIBUTIONS.ACCRUE_ON_RECEIPT_FLAG%TYPE;
4799: l_po_ccid PO_DISTRIBUTIONS.CODE_COMBINATION_ID%TYPE;
4800: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
4801: l_dist_code_concat VARCHAR2(2000);
4802: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

Line 4799: l_po_ccid PO_DISTRIBUTIONS.CODE_COMBINATION_ID%TYPE;

4795: RETURN BOOLEAN
4796: IS
4797:
4798: l_po_accrue_on_receipt_flag PO_DISTRIBUTIONS.ACCRUE_ON_RECEIPT_FLAG%TYPE;
4799: l_po_ccid PO_DISTRIBUTIONS.CODE_COMBINATION_ID%TYPE;
4800: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
4801: l_dist_code_concat VARCHAR2(2000);
4802: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
4803: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

Line 5089: FROM po_distributions

5085: SELECT code_combination_id,
5086: accrue_on_receipt_flag
5087: INTO l_po_ccid,
5088: l_po_accrue_on_receipt_flag
5089: FROM po_distributions
5090: WHERE po_distribution_id = X_item_po_dist_id;
5091:
5092: EXCEPTION
5093: When no_data_found then

Line 6846: po_distributions PD,

6842: PLL.matching_basis -- l_match_basis /* Amount Based Matching */
6843: FROM ap_invoices_all AI,
6844: ap_system_parameters_all ASP,
6845: ap_invoice_distributions D,
6846: po_distributions PD,
6847: po_lines PL,
6848: po_line_types PLT, -- Amount Based Matching
6849: po_line_locations PLL,
6850: rcv_transactions RTXN,