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 90: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;

86: g_vendor_id ap_invoices.vendor_id%TYPE;
87: g_vendor_site_id ap_invoices.vendor_site_id%TYPE;
88: g_invoice_date ap_invoices.invoice_date%TYPE;
89: g_batch_id ap_batches.batch_id%TYPE;
90: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;
91: g_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
92: g_exchange_rate ap_invoices.exchange_rate%TYPE;
93: g_base_currency_code ap_system_parameters.base_currency_code%TYPE;
94: g_accounting_date ap_invoices.gl_date%TYPE;

Line 346: UPDATE ap_invoice_lines

342: x_invoice_line_number => x_invoice_line_number,
343: x_description => x_description,
344: x_calling_sequence => current_calling_sequence);
345:
346: UPDATE ap_invoice_lines
347: SET generate_dists ='D'
348: WHERE invoice_id = x_invoice_id
349: AND line_number = x_invoice_line_number;
350:

Line 403: l_accounting_date ap_invoice_lines.accounting_date%TYPE; --Bug16216470

399: X_Calling_Sequence IN VARCHAR2) IS
400:
401: current_calling_sequence VARCHAR2(2000);
402: l_debug_info VARCHAR2(100);
403: l_accounting_date ap_invoice_lines.accounting_date%TYPE; --Bug16216470
404:
405: BEGIN
406:
407:

Line 454: FROM ap_invoice_lines ail

450: AND ai.org_id = asp.org_id;
451:
452: SELECT nvl(max(ail.line_number),0)
453: INTO g_max_invoice_line_number
454: FROM ap_invoice_lines ail
455: WHERE ail.invoice_id = x_invoice_id;
456:
457: BEGIN
458:

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

513:
514: l_charge_amount number := 0;
515: l_total_rcv_qty number := 0;
516: I number;
517: l_sum_amount_prorated ap_invoice_lines.amount%TYPE := 0;
518: l_rounding_index number;
519: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
520: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;
521: l_base_amount ap_invoice_lines.base_amount%TYPE ;

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

515: l_total_rcv_qty number := 0;
516: I number;
517: l_sum_amount_prorated ap_invoice_lines.amount%TYPE := 0;
518: l_rounding_index number;
519: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
520: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;
521: l_base_amount ap_invoice_lines.base_amount%TYPE ;
522: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
523: l_debug_info varchar2(1000); --bug11075838: increased the size

Line 520: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;

516: I number;
517: l_sum_amount_prorated ap_invoice_lines.amount%TYPE := 0;
518: l_rounding_index number;
519: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
520: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;
521: l_base_amount ap_invoice_lines.base_amount%TYPE ;
522: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
523: l_debug_info varchar2(1000); --bug11075838: increased the size
524: current_calling_sequence varchar2(2000);

Line 521: l_base_amount ap_invoice_lines.base_amount%TYPE ;

517: l_sum_amount_prorated ap_invoice_lines.amount%TYPE := 0;
518: l_rounding_index number;
519: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
520: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;
521: l_base_amount ap_invoice_lines.base_amount%TYPE ;
522: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
523: l_debug_info varchar2(1000); --bug11075838: increased the size
524: current_calling_sequence varchar2(2000);
525: l_api_name CONSTANT VARCHAR2(200) := 'Get_Proration_Info'; --bug11075838

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

518: l_rounding_index number;
519: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
520: l_total_base_amount ap_invoice_lines.base_amount%TYPE ;
521: l_base_amount ap_invoice_lines.base_amount%TYPE ;
522: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
523: l_debug_info varchar2(1000); --bug11075838: increased the size
524: current_calling_sequence varchar2(2000);
525: l_api_name CONSTANT VARCHAR2(200) := 'Get_Proration_Info'; --bug11075838
526:

Line 663: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

659: x_calling_sequence IN VARCHAR2) IS
660:
661: l_debug_info VARCHAR2(100);
662: current_calling_sequence VARCHAR2(2000);
663: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
664: l_sum_amount_prorated NUMBER;
665: l_max_line_amount NUMBER := 0;
666: l_proration_round_amount NUMBER := 0;
667: l_rounded_line_number NUMBER;

Line 741: INSERT INTO AP_INVOICE_LINES

737: BEGIN
738:
739: current_calling_sequence := 'Insert_Invoice_Line<-'||x_calling_sequence;
740:
741: INSERT INTO AP_INVOICE_LINES
742: (INVOICE_ID,
743: LINE_NUMBER,
744: LINE_TYPE_LOOKUP_CODE,
745: /*OPEN ISSUE 2*/

Line 1434: FROM ap_invoice_lines AIL,

1430: --OPEN ISSUE 1
1431: /*,rcv.intended_use */
1432: 'N', --rcv_charge_addition_flag
1433: NULL --pay_awt_group_id bug9689194
1434: FROM ap_invoice_lines AIL,
1435: gl_code_combinations GCC,
1436: rcv_transactions rcv
1437: WHERE ail.invoice_id = x_invoice_id
1438: AND ail.line_number = x_invoice_line_number