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

Line 84: G_max_invoice_line_number ap_invoice_lines.line_number%TYPE := 0;

80: X_Calling_Sequence IN VARCHAR2);
81:
82:
83: --Global Variable Declaration
84: G_max_invoice_line_number ap_invoice_lines.line_number%TYPE := 0;
85: G_batch_id ap_batches.batch_id%TYPE;
86: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
87: G_Period_Name gl_period_statuses.period_name%TYPE;
88: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;

Line 86: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;

82:
83: --Global Variable Declaration
84: G_max_invoice_line_number ap_invoice_lines.line_number%TYPE := 0;
85: G_batch_id ap_batches.batch_id%TYPE;
86: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
87: G_Period_Name gl_period_statuses.period_name%TYPE;
88: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
89: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
90: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;

Line 124: l_line_base_amount ap_invoice_lines.base_amount%TYPE;

120: X_Dist_Tab IN OUT NOCOPY DIST_TAB_TYPE,
121: X_Calling_Sequence IN VARCHAR2) IS
122:
123:
124: l_line_base_amount ap_invoice_lines.base_amount%TYPE;
125: l_debug_info VARCHAR2(100);
126: current_calling_sequence VARCHAR2(2000);
127: l_api_name VARCHAR2(30);
128: l_success BOOLEAN := TRUE;

Line 180: From ap_invoice_lines_all

176: l_debug_info := 'Get Line Included Tax Amount';
177: Begin
178: Select nvl(included_tax_amount, 0)
179: Into l_included_tax_amount
180: From ap_invoice_lines_all
181: Where invoice_id = x_invoice_id
182: And line_number = x_invoice_line_number;
183: Exception
184: When Others Then

Line 210: UPDATE ap_invoice_lines

206: X_Calling_Sequence => current_calling_sequence);
207:
208: l_debug_info := 'Update the generate_dists to D after the distributions are created';
209:
210: UPDATE ap_invoice_lines
211: SET generate_dists = 'D'
212: WHERE invoice_id = x_invoice_id
213: AND line_number = x_invoice_line_number;
214:

Line 350: FROM ap_invoice_lines ail

346: AND ai.invoice_currency_code = fc.currency_code (+);
347:
348: SELECT nvl(max(ail.line_number),0)
349: INTO g_max_invoice_line_number
350: FROM ap_invoice_lines ail
351: WHERE ail.invoice_id = x_invoice_id;
352:
353: l_debug_info := 'select period for accounting date';
354:

Line 410: FROM ap_invoice_lines_all ail

406: current_calling_sequence := 'Get_Line_Proration_Total <- '||x_calling_sequence;
407:
408: SELECT sum(ail.amount)
409: INTO l_line_total
410: FROM ap_invoice_lines_all ail
411: WHERE ail.invoice_id = x_corrected_invoice_id
412: --Modified below condition for bug#10410133
413: --from " = 'ITEM' to in ('ITEM','FREIGHT','MISCELLANEOUS') "
414: -- Bug 5597409, restricting for Item line only

Line 448: FROM ap_invoice_lines ail,

444: g_precision),
445: round (((x_correction_amount * ail.amount/p_line_proration_total)/
446: g_min_acct_unit) * g_min_acct_unit)
447: )
448: FROM ap_invoice_lines ail,
449: ap_invoices ai
450: WHERE ai.invoice_id = x_corrected_invoice_id
451: AND ail.invoice_id = ai.invoice_id
452: --Modified below condition for bug#10410133

Line 462: l_corrected_line_number ap_invoice_lines.line_number%TYPE;

458: --Added condition for bug#10410133
459: AND NVL(match_type,'NOT_MATCHED') = 'NOT_MATCHED';
460:
461:
462: l_corrected_line_number ap_invoice_lines.line_number%TYPE;
463: l_amount ap_invoice_lines.amount%TYPE;
464: i NUMBER;
465: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
466: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;

Line 463: l_amount ap_invoice_lines.amount%TYPE;

459: AND NVL(match_type,'NOT_MATCHED') = 'NOT_MATCHED';
460:
461:
462: l_corrected_line_number ap_invoice_lines.line_number%TYPE;
463: l_amount ap_invoice_lines.amount%TYPE;
464: i NUMBER;
465: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
466: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
467: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;

Line 465: l_line_rounded_index ap_invoice_lines.line_number%TYPE;

461:
462: l_corrected_line_number ap_invoice_lines.line_number%TYPE;
463: l_amount ap_invoice_lines.amount%TYPE;
464: i NUMBER;
465: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
466: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
467: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
468: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
469: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;

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

462: l_corrected_line_number ap_invoice_lines.line_number%TYPE;
463: l_amount ap_invoice_lines.amount%TYPE;
464: i NUMBER;
465: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
466: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
467: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
468: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
469: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
470: l_base_amount ap_invoice_lines.base_amount%TYPE;

Line 467: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;

463: l_amount ap_invoice_lines.amount%TYPE;
464: i NUMBER;
465: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
466: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
467: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
468: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
469: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
470: l_base_amount ap_invoice_lines.base_amount%TYPE;
471: l_debug_info VARCHAR2(100);

Line 468: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;

464: i NUMBER;
465: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
466: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
467: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
468: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
469: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
470: l_base_amount ap_invoice_lines.base_amount%TYPE;
471: l_debug_info VARCHAR2(100);
472: l_line_proration_total NUMBER;

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

465: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
466: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
467: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
468: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
469: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
470: l_base_amount ap_invoice_lines.base_amount%TYPE;
471: l_debug_info VARCHAR2(100);
472: l_line_proration_total NUMBER;
473: current_calling_sequence VARCHAR2(2000);

Line 470: l_base_amount ap_invoice_lines.base_amount%TYPE;

466: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
467: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
468: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
469: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
470: l_base_amount ap_invoice_lines.base_amount%TYPE;
471: l_debug_info VARCHAR2(100);
472: l_line_proration_total NUMBER;
473: current_calling_sequence VARCHAR2(2000);
474: l_api_name VARCHAR2(30);

Line 625: FROM ap_invoice_lines ail,

621: g_min_acct_unit) * g_min_acct_unit)
622: ) ,
623:
624: ap_invoice_distributions_s.nextval
625: FROM ap_invoice_lines ail,
626: ap_invoice_distributions aid
627: WHERE ail.invoice_id = x_corrected_invoice_id
628: AND ail.line_number = x_corrected_line_number
629: AND aid.invoice_id = ail.invoice_id

Line 826: l_invoice_line_number ap_invoice_lines.line_number%TYPE;

822: X_Correction_Price IN NUMBER,
823: X_Total_Correction_Amount IN NUMBER,
824: X_Calling_Sequence IN VARCHAR2) IS
825:
826: l_invoice_line_number ap_invoice_lines.line_number%TYPE;
827: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;
828: l_max_line_amount ap_invoice_lines.amount%TYPE;
829: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
830: l_line_rounding_amount ap_invoice_lines.amount%TYPE;

Line 827: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;

823: X_Total_Correction_Amount IN NUMBER,
824: X_Calling_Sequence IN VARCHAR2) IS
825:
826: l_invoice_line_number ap_invoice_lines.line_number%TYPE;
827: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;
828: l_max_line_amount ap_invoice_lines.amount%TYPE;
829: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
830: l_line_rounding_amount ap_invoice_lines.amount%TYPE;
831: l_debug_info VARCHAR2(100);

Line 828: l_max_line_amount ap_invoice_lines.amount%TYPE;

824: X_Calling_Sequence IN VARCHAR2) IS
825:
826: l_invoice_line_number ap_invoice_lines.line_number%TYPE;
827: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;
828: l_max_line_amount ap_invoice_lines.amount%TYPE;
829: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
830: l_line_rounding_amount ap_invoice_lines.amount%TYPE;
831: l_debug_info VARCHAR2(100);
832: current_calling_sequence VARCHAR2(2000);

Line 829: l_line_rounded_index ap_invoice_lines.line_number%TYPE;

825:
826: l_invoice_line_number ap_invoice_lines.line_number%TYPE;
827: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;
828: l_max_line_amount ap_invoice_lines.amount%TYPE;
829: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
830: l_line_rounding_amount ap_invoice_lines.amount%TYPE;
831: l_debug_info VARCHAR2(100);
832: current_calling_sequence VARCHAR2(2000);
833: l_api_name VARCHAR2(30);

Line 830: l_line_rounding_amount ap_invoice_lines.amount%TYPE;

826: l_invoice_line_number ap_invoice_lines.line_number%TYPE;
827: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;
828: l_max_line_amount ap_invoice_lines.amount%TYPE;
829: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
830: l_line_rounding_amount ap_invoice_lines.amount%TYPE;
831: l_debug_info VARCHAR2(100);
832: current_calling_sequence VARCHAR2(2000);
833: l_api_name VARCHAR2(30);
834: l_line_base_amount NUMBER;

Line 901: From ap_invoice_lines_all

897:
898: Begin
899: Select nvl(included_tax_amount, 0)
900: Into x_line_tab(i).included_tax_amount
901: From ap_invoice_lines_all
902: Where invoice_id = x_invoice_id
903: And line_number = x_line_tab(i).line_number;
904:
905: Exception

Line 999: INSERT INTO AP_INVOICE_LINES_ALL (

995:
996:
997: l_debug_info := 'Inserting non-matched Item Line';
998:
999: INSERT INTO AP_INVOICE_LINES_ALL (
1000: INVOICE_ID,
1001: LINE_NUMBER,
1002: LINE_TYPE_LOOKUP_CODE,
1003: REQUESTER_ID,

Line 1312: ap_invoice_lines ail

1308: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
1309: AIL.PURCHASING_CATEGORY_ID, --purchasing_category_id
1310: AIL.PAY_AWT_GROUP_ID --pay_awt_group_id --bug13793337
1311: FROM ap_invoices ai,
1312: ap_invoice_lines ail
1313: WHERE ai.invoice_id = ail.invoice_id
1314: AND ai.invoice_id = x_corrected_invoice_id
1315: AND ail.line_number = x_corrected_line_number;
1316:

Line 1708: ap_invoice_lines ail,

1704: aid.intended_use, --intended_use
1705: 'N',
1706: aid.pay_awt_group_id --pay_awt_group_id --bug13793337
1707: FROM ap_invoice_distributions aid,
1708: ap_invoice_lines ail,
1709: gl_code_combinations gcc
1710: WHERE ail.invoice_id = x_invoice_id
1711: AND ail.line_number = x_invoice_line_number
1712: AND aid.invoice_id = ail.corrected_inv_id