eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ISP_UTILITIES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 2264: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,

2260: l_po_ap_line_loc_rec PO_AP_LINE_LOC_REC_TYPE;
2261:
2262: TYPE r_dist_info IS RECORD
2263: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
2264: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
2265: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
2266: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2267: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2268: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,

Line 2266: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,

2262: TYPE r_dist_info IS RECORD
2263: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
2264: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
2265: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
2266: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2267: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2268: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
2269: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2270: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,

Line 2267: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,

2263: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
2264: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
2265: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
2266: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2267: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2268: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
2269: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2270: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2271: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE

Line 2268: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,

2264: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
2265: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
2266: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2267: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2268: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
2269: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2270: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2271: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
2272: );

Line 2269: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,

2265: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
2266: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2267: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2268: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
2269: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2270: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2271: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
2272: );
2273: TYPE Dist_Tab_Type IS TABLE OF r_dist_info INDEX BY BINARY_INTEGER;

Line 2270: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,

2266: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2267: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2268: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
2269: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2270: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2271: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
2272: );
2273: TYPE Dist_Tab_Type IS TABLE OF r_dist_info INDEX BY BINARY_INTEGER;
2274: x_dist_tab DIST_TAB_TYPE;

Line 2271: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE

2267: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2268: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
2269: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2270: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2271: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
2272: );
2273: TYPE Dist_Tab_Type IS TABLE OF r_dist_info INDEX BY BINARY_INTEGER;
2274: x_dist_tab DIST_TAB_TYPE;
2275:

Line 2283: FROM ap_invoice_distributions_all

2279: rcv_transaction_id,
2280: amount,
2281: quantity_invoiced,
2282: pa_quantity
2283: FROM ap_invoice_distributions_all
2284: WHERE invoice_id = p_invoice_id
2285: AND invoice_line_number = p_line_number;
2286:
2287: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;

Line 2288: l_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;

2284: WHERE invoice_id = p_invoice_id
2285: AND invoice_line_number = p_line_number;
2286:
2287: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
2288: l_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
2289: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
2290: l_match_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
2291: l_match_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
2292: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;

Line 2290: l_match_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;

2286:
2287: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
2288: l_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
2289: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
2290: l_match_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
2291: l_match_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
2292: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
2293: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;
2294: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;

Line 2297: l_max_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;

2293: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;
2294: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
2295: l_sum_prorated_amount AP_INVOICE_LINES.AMOUNT%TYPE;
2296: l_sum_prorated_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
2297: l_max_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
2298: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
2299: l_api_name VARCHAR2(32);
2300: l_msg_data VARCHAR2(4000);
2301: l_return_status VARCHAR2(100);

Line 2304: l_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE;

2300: l_msg_data VARCHAR2(4000);
2301: l_return_status VARCHAR2(100);
2302: l_debug_info VARCHAR2(1000);
2303: l_matching_basis VARCHAR2(30);
2304: l_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE;
2305: current_calling_sequence VARCHAR2(1000);
2306: api_call_failed EXCEPTION;
2307:
2308: begin

Line 2325: FROM ap_invoice_distributions_all

2321:
2322:
2323: SELECT sum(quantity_invoiced),sum(amount)
2324: INTO l_total_quantity_billed,l_total_amount_billed
2325: FROM ap_invoice_distributions_all
2326: WHERE invoice_id = p_invoice_id
2327: AND invoice_line_number = p_line_number;
2328:
2329: SELECT matching_basis

Line 2439: UPDATE ap_invoice_distributions_all

2435: p_amount_recouped => NULL,
2436: p_retainage_withheld_amt => NULL,
2437: p_retainage_released_amt => NULL);
2438:
2439: UPDATE ap_invoice_distributions_all
2440: SET amount = amount - nvl(x_dist_tab(i).update_amount,0),
2441: quantity_invoiced = quantity_invoiced - nvl(x_dist_tab(i).update_quantity,0),
2442: pa_quantity = pa_quantity - nvl(x_dist_tab(i).update_pa_quantity,0)
2443: WHERE invoice_distribution_id = x_dist_tab(i).invoice_distribution_id;

Line 3227: p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,

3223: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
3224: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
3225: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
3226: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
3227: p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,
3228: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,
3229: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,
3230: p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,
3231: p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,

Line 3228: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,

3224: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
3225: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
3226: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
3227: p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,
3228: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,
3229: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,
3230: p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,
3231: p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,
3232: p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,

Line 3229: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,

3225: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
3226: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
3227: p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,
3228: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,
3229: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,
3230: p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,
3231: p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,
3232: p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,
3233: p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,

Line 3230: p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,

3226: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
3227: p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,
3228: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,
3229: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,
3230: p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,
3231: p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,
3232: p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,
3233: p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,
3234: p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,

Line 3231: p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,

3227: p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,
3228: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,
3229: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,
3230: p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,
3231: p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,
3232: p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,
3233: p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,
3234: p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,
3235: p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,

Line 3232: p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,

3228: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,
3229: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,
3230: p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,
3231: p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,
3232: p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,
3233: p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,
3234: p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,
3235: p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,
3236: p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,

Line 3233: p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,

3229: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,
3230: p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,
3231: p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,
3232: p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,
3233: p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,
3234: p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,
3235: p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,
3236: p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,
3237: p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,

Line 3234: p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,

3230: p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,
3231: p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,
3232: p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,
3233: p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,
3234: p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,
3235: p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,
3236: p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,
3237: p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,
3238: p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,

Line 3235: p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,

3231: p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,
3232: p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,
3233: p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,
3234: p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,
3235: p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,
3236: p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,
3237: p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,
3238: p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,
3239: p_dist_attribute12 IN ap_invoice_distributions_all.attribute12%TYPE,

Line 3236: p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,

3232: p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,
3233: p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,
3234: p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,
3235: p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,
3236: p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,
3237: p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,
3238: p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,
3239: p_dist_attribute12 IN ap_invoice_distributions_all.attribute12%TYPE,
3240: p_dist_attribute13 IN ap_invoice_distributions_all.attribute13%TYPE,

Line 3237: p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,

3233: p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,
3234: p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,
3235: p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,
3236: p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,
3237: p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,
3238: p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,
3239: p_dist_attribute12 IN ap_invoice_distributions_all.attribute12%TYPE,
3240: p_dist_attribute13 IN ap_invoice_distributions_all.attribute13%TYPE,
3241: p_dist_attribute14 IN ap_invoice_distributions_all.attribute14%TYPE,

Line 3238: p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,

3234: p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,
3235: p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,
3236: p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,
3237: p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,
3238: p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,
3239: p_dist_attribute12 IN ap_invoice_distributions_all.attribute12%TYPE,
3240: p_dist_attribute13 IN ap_invoice_distributions_all.attribute13%TYPE,
3241: p_dist_attribute14 IN ap_invoice_distributions_all.attribute14%TYPE,
3242: p_dist_attribute15 IN ap_invoice_distributions_all.attribute15%TYPE,

Line 3239: p_dist_attribute12 IN ap_invoice_distributions_all.attribute12%TYPE,

3235: p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,
3236: p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,
3237: p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,
3238: p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,
3239: p_dist_attribute12 IN ap_invoice_distributions_all.attribute12%TYPE,
3240: p_dist_attribute13 IN ap_invoice_distributions_all.attribute13%TYPE,
3241: p_dist_attribute14 IN ap_invoice_distributions_all.attribute14%TYPE,
3242: p_dist_attribute15 IN ap_invoice_distributions_all.attribute15%TYPE,
3243: p_input_ccid IN gl_code_combinations.code_combination_id%TYPE default null,

Line 3240: p_dist_attribute13 IN ap_invoice_distributions_all.attribute13%TYPE,

3236: p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,
3237: p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,
3238: p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,
3239: p_dist_attribute12 IN ap_invoice_distributions_all.attribute12%TYPE,
3240: p_dist_attribute13 IN ap_invoice_distributions_all.attribute13%TYPE,
3241: p_dist_attribute14 IN ap_invoice_distributions_all.attribute14%TYPE,
3242: p_dist_attribute15 IN ap_invoice_distributions_all.attribute15%TYPE,
3243: p_input_ccid IN gl_code_combinations.code_combination_id%TYPE default null,
3244: x_return_ccid OUT NOCOPY gl_code_combinations.code_combination_id%TYPE,

Line 3241: p_dist_attribute14 IN ap_invoice_distributions_all.attribute14%TYPE,

3237: p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,
3238: p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,
3239: p_dist_attribute12 IN ap_invoice_distributions_all.attribute12%TYPE,
3240: p_dist_attribute13 IN ap_invoice_distributions_all.attribute13%TYPE,
3241: p_dist_attribute14 IN ap_invoice_distributions_all.attribute14%TYPE,
3242: p_dist_attribute15 IN ap_invoice_distributions_all.attribute15%TYPE,
3243: p_input_ccid IN gl_code_combinations.code_combination_id%TYPE default null,
3244: x_return_ccid OUT NOCOPY gl_code_combinations.code_combination_id%TYPE,
3245: x_concat_segs IN OUT NOCOPY VARCHAR2, -- Bug 5935019

Line 3242: p_dist_attribute15 IN ap_invoice_distributions_all.attribute15%TYPE,

3238: p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,
3239: p_dist_attribute12 IN ap_invoice_distributions_all.attribute12%TYPE,
3240: p_dist_attribute13 IN ap_invoice_distributions_all.attribute13%TYPE,
3241: p_dist_attribute14 IN ap_invoice_distributions_all.attribute14%TYPE,
3242: p_dist_attribute15 IN ap_invoice_distributions_all.attribute15%TYPE,
3243: p_input_ccid IN gl_code_combinations.code_combination_id%TYPE default null,
3244: x_return_ccid OUT NOCOPY gl_code_combinations.code_combination_id%TYPE,
3245: x_concat_segs IN OUT NOCOPY VARCHAR2, -- Bug 5935019
3246: x_concat_ids IN OUT NOCOPY VARCHAR2, -- Bug 5935019

Line 3250: p_accounting_date IN ap_invoice_distributions_all.accounting_date%TYPE default NULL,

3246: x_concat_ids IN OUT NOCOPY VARCHAR2, -- Bug 5935019
3247: x_concat_descrs IN OUT NOCOPY VARCHAR2, -- Bug 5935019
3248: x_error_message OUT NOCOPY VARCHAR2,
3249: X_award_set_id IN NUMBER DEFAULT NULL,
3250: p_accounting_date IN ap_invoice_distributions_all.accounting_date%TYPE default NULL,
3251: p_award_id IN NUMBER DEFAULT NULL,
3252: p_expenditure_item_id IN NUMBER DEFAULT NULL ) RETURN NUMBER IS
3253:
3254: l_result BOOLEAN;