DBA Data[Home] [Help]

APPS.AP_RCT_AMT_MATCH_PKG dependencies on AP_INVOICE_LINES_ALL

Line 241: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

237: l_single_dist_flag varchar2(1) := 'N';
238: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
239: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
240: l_item_line_number ap_invoice_lines.line_number%TYPE;
241: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
242: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
243: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
244: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
245: l_debug_info varchar2(2000);

Line 242: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

238: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
239: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
240: l_item_line_number ap_invoice_lines.line_number%TYPE;
241: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
242: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
243: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
244: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
245: l_debug_info varchar2(2000);
246: l_success boolean;

Line 243: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

239: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
240: l_item_line_number ap_invoice_lines.line_number%TYPE;
241: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
242: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
243: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
244: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
245: l_debug_info varchar2(2000);
246: l_success boolean;
247: l_error_message varchar2(4000);

Line 244: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

240: l_item_line_number ap_invoice_lines.line_number%TYPE;
241: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
242: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
243: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
244: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
245: l_debug_info varchar2(2000);
246: l_success boolean;
247: l_error_message varchar2(4000);
248: current_calling_sequence varchar2(2000);

Line 336: UPDATE ap_invoice_lines_all

332:
333: IF g_source = 'ISP'
334: and x_invoice_line_number IS NOT NULL THEN
335:
336: UPDATE ap_invoice_lines_all
337: SET primary_intended_use = nvl(primary_intended_use, g_intended_use)
338: ,product_type = nvl(product_type, g_product_type)
339: ,product_category = nvl(product_category, g_product_category)
340: ,product_fisc_classification = nvl(product_fisc_classification, g_product_fisc_class)

Line 2987: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

2983: X_Retained_Amount IN NUMBER DEFAULT NULL,
2984: X_Calling_Sequence IN VARCHAR2) IS
2985:
2986: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
2987: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
2988: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
2989: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
2990: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
2991: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 2988: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;

2984: X_Calling_Sequence IN VARCHAR2) IS
2985:
2986: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
2987: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
2988: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
2989: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
2990: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
2991: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
2992: l_success BOOLEAN;

Line 2989: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

2985:
2986: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
2987: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
2988: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
2989: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
2990: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
2991: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
2992: l_success BOOLEAN;
2993: l_error_message VARCHAR2(4000);

Line 2990: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

2986: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
2987: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
2988: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
2989: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
2990: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
2991: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
2992: l_success BOOLEAN;
2993: l_error_message VARCHAR2(4000);
2994: l_debug_info VARCHAR2(2000);

Line 2991: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

2987: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
2988: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
2989: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
2990: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
2991: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
2992: l_success BOOLEAN;
2993: l_error_message VARCHAR2(4000);
2994: l_debug_info VARCHAR2(2000);
2995: current_calling_sequence VARCHAR2(2000);