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_MATCHING_PKG dependencies on AP_INVOICE_LINES_ALL

Line 255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;

251:
252: l_single_dist_flag varchar2(1) := 'N';
253: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
254: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

252: l_single_dist_flag varchar2(1) := 'N';
253: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
254: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
260: l_error_message varchar2(4000);

Line 257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

253: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
254: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
260: l_error_message varchar2(4000);
261: l_debug_info varchar2(2000);

Line 258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

254: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
260: l_error_message varchar2(4000);
261: l_debug_info varchar2(2000);
262: l_success boolean;

Line 259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
260: l_error_message varchar2(4000);
261: l_debug_info varchar2(2000);
262: l_success boolean;
263: current_calling_sequence varchar2(2000);

Line 442: FROM ap_invoice_lines_all

438:
439:
440: SELECT AMOUNT
441: INTO l_line_amt
442: FROM ap_invoice_lines_all
443: WHERE invoice_id = x_invoice_id
444: AND line_number = x_invoice_line_number;
445:
446: l_debug_info := 'l_line_amt '||l_line_amt;

Line 454: UPDATE ap_invoice_lines_all

450: END IF;
451:
452: --End Bug#13505998
453:
454: UPDATE ap_invoice_lines_all
455: SET primary_intended_use = nvl(primary_intended_use, g_intended_use)
456: ,product_type = nvl(product_type, g_product_type)
457: ,product_category = nvl(product_category, g_product_category)
458: ,product_fisc_classification = nvl(product_fisc_classification, g_product_fisc_class)

Line 3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

3330: X_Retained_Amount IN NUMBER DEFAULT NULL,
3331: X_Calling_Sequence IN VARCHAR2) IS
3332:
3333: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

3331: X_Calling_Sequence IN VARCHAR2) IS
3332:
3333: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3339: l_success BOOLEAN;

Line 3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

3332:
3333: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3339: l_success BOOLEAN;
3340: l_error_message VARCHAR2(4000);

Line 3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

3333: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3339: l_success BOOLEAN;
3340: l_error_message VARCHAR2(4000);
3341: l_debug_info VARCHAR2(2000);

Line 3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3339: l_success BOOLEAN;
3340: l_error_message VARCHAR2(4000);
3341: l_debug_info VARCHAR2(2000);
3342: current_calling_sequence VARCHAR2(2000);

Line 6028: INSERT INTO AP_INVOICE_LINES_ALL

6024: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6025: END IF;
6026: --End Bug#13505998
6027:
6028: INSERT INTO AP_INVOICE_LINES_ALL
6029: (INVOICE_ID,
6030: LINE_NUMBER,
6031: LINE_TYPE_LOOKUP_CODE,
6032: REQUESTER_ID,