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_OTHR_CHRG_MATCH_PKG dependencies on AP_INVOICE_LINES

Line 8: actual Charge Lines in AP_INVOICE_LINES and 1 invoice distribution

4:
5: /*
6: Procedure OTHR_CHRG_MATCH does the actual matching (linking) of a
7: standard Invoice/ CM/DM to a particular rcv transaction. It creates the
8: actual Charge Lines in AP_INVOICE_LINES and 1 invoice distribution
9: per charge line in AP_INVOICE_DISTRIBUTIONS and stores the associated
10: rcv_transaction_id for that line. One Charge Invoice line will be created
11: in AP_INVOICE_LINES for Receipt/Receipt Line the user selects to match to
12: in the Other Charge Matching Window. Invoice Distributions will be generated

Line 11: in AP_INVOICE_LINES for Receipt/Receipt Line the user selects to match to

7: standard Invoice/ CM/DM to a particular rcv transaction. It creates the
8: actual Charge Lines in AP_INVOICE_LINES and 1 invoice distribution
9: per charge line in AP_INVOICE_DISTRIBUTIONS and stores the associated
10: rcv_transaction_id for that line. One Charge Invoice line will be created
11: in AP_INVOICE_LINES for Receipt/Receipt Line the user selects to match to
12: in the Other Charge Matching Window. Invoice Distributions will be generated
13: immediately during the matching, 1 per invoice line.
14:
15: Either the total amount is prorated (if

Line 85: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;

81: g_vendor_id ap_invoices.vendor_id%TYPE;
82: g_vendor_site_id ap_invoices.vendor_site_id%TYPE;
83: g_invoice_date ap_invoices.invoice_date%TYPE;
84: g_batch_id ap_batches.batch_id%TYPE;
85: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;
86: g_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
87: g_exchange_rate ap_invoices.exchange_rate%TYPE;
88: g_base_currency_code ap_system_parameters.base_currency_code%TYPE;
89: g_accounting_date ap_invoices.gl_date%TYPE;

Line 319: UPDATE ap_invoice_lines

315: x_invoice_line_number => x_invoice_line_number,
316: x_description => x_description,
317: x_calling_sequence => current_calling_sequence);
318:
319: UPDATE ap_invoice_lines
320: SET generate_dists ='D'
321: WHERE invoice_id = x_invoice_id
322: AND line_number = x_invoice_line_number;
323:

Line 426: FROM ap_invoice_lines ail

422: AND ai.org_id = asp.org_id;
423:
424: SELECT nvl(max(ail.line_number),0)
425: INTO g_max_invoice_line_number
426: FROM ap_invoice_lines ail
427: WHERE ail.invoice_id = x_invoice_id;
428:
429: BEGIN
430:

Line 483: l_sum_amount_prorated ap_invoice_lines.amount%TYPE := 0;

479:
480: l_charge_amount number := 0;
481: l_total_rcv_qty number := 0;
482: I number;
483: l_sum_amount_prorated ap_invoice_lines.amount%TYPE := 0;
484: l_rounding_index number;
485: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
486: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;
487: l_base_amount ap_invoice_lines.base_amount%TYPE ;

Line 485: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;

481: l_total_rcv_qty number := 0;
482: I number;
483: l_sum_amount_prorated ap_invoice_lines.amount%TYPE := 0;
484: l_rounding_index number;
485: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
486: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;
487: l_base_amount ap_invoice_lines.base_amount%TYPE ;
488: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
489: l_debug_info varchar2(100);

Line 486: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;

482: I number;
483: l_sum_amount_prorated ap_invoice_lines.amount%TYPE := 0;
484: l_rounding_index number;
485: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
486: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;
487: l_base_amount ap_invoice_lines.base_amount%TYPE ;
488: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
489: l_debug_info varchar2(100);
490: current_calling_sequence varchar2(2000);

Line 487: l_base_amount ap_invoice_lines.base_amount%TYPE ;

483: l_sum_amount_prorated ap_invoice_lines.amount%TYPE := 0;
484: l_rounding_index number;
485: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
486: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;
487: l_base_amount ap_invoice_lines.base_amount%TYPE ;
488: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
489: l_debug_info varchar2(100);
490: current_calling_sequence varchar2(2000);
491:

Line 488: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;

484: l_rounding_index number;
485: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
486: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;
487: l_base_amount ap_invoice_lines.base_amount%TYPE ;
488: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
489: l_debug_info varchar2(100);
490: current_calling_sequence varchar2(2000);
491:
492:

Line 599: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

595: x_calling_sequence IN VARCHAR2) IS
596:
597: l_debug_info VARCHAR2(100);
598: current_calling_sequence VARCHAR2(2000);
599: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
600: l_sum_amount_prorated NUMBER;
601: l_max_line_amount NUMBER := 0;
602: l_proration_round_amount NUMBER := 0;
603: l_rounded_line_number NUMBER;

Line 677: INSERT INTO AP_INVOICE_LINES

673: BEGIN
674:
675: current_calling_sequence := 'Insert_Invoice_Line<-'||x_calling_sequence;
676:
677: INSERT INTO AP_INVOICE_LINES
678: (INVOICE_ID,
679: LINE_NUMBER,
680: LINE_TYPE_LOOKUP_CODE,
681: /*OPEN ISSUE 2*/

Line 1345: FROM ap_invoice_lines AIL,

1341: --ETAX: Invwkb
1342: --OPEN ISSUE 1
1343: /*,rcv.intended_use */
1344: 'N' --rcv_charge_addition_flag
1345: FROM ap_invoice_lines AIL,
1346: gl_code_combinations GCC,
1347: rcv_transactions rcv
1348: WHERE ail.invoice_id = x_invoice_id
1349: AND ail.line_number = x_invoice_line_number