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_ALL

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