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: AND ail.line_type_lookup_code = 'ITEM'; -- Bug 5597409
413:
414: RETURN(l_line_total);

Line 442: FROM ap_invoice_lines ail,

438: g_precision),
439: round (((x_correction_amount * ail.amount/p_line_proration_total)/
440: g_min_acct_unit) * g_min_acct_unit)
441: )
442: FROM ap_invoice_lines ail,
443: ap_invoices ai
444: WHERE ai.invoice_id = x_corrected_invoice_id
445: AND ail.invoice_id = ai.invoice_id
446: AND ail.line_type_lookup_code = 'ITEM'; -- Bug 5597409, restricting for Item line only

Line 448: l_corrected_line_number ap_invoice_lines.line_number%TYPE;

444: WHERE ai.invoice_id = x_corrected_invoice_id
445: AND ail.invoice_id = ai.invoice_id
446: AND ail.line_type_lookup_code = 'ITEM'; -- Bug 5597409, restricting for Item line only
447:
448: l_corrected_line_number ap_invoice_lines.line_number%TYPE;
449: l_amount ap_invoice_lines.amount%TYPE;
450: i NUMBER;
451: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
452: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;

Line 449: l_amount ap_invoice_lines.amount%TYPE;

445: AND ail.invoice_id = ai.invoice_id
446: AND ail.line_type_lookup_code = 'ITEM'; -- Bug 5597409, restricting for Item line only
447:
448: l_corrected_line_number ap_invoice_lines.line_number%TYPE;
449: l_amount ap_invoice_lines.amount%TYPE;
450: i NUMBER;
451: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
452: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
453: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;

Line 451: l_line_rounded_index ap_invoice_lines.line_number%TYPE;

447:
448: l_corrected_line_number ap_invoice_lines.line_number%TYPE;
449: l_amount ap_invoice_lines.amount%TYPE;
450: i NUMBER;
451: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
452: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
453: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
454: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
455: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;

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

448: l_corrected_line_number ap_invoice_lines.line_number%TYPE;
449: l_amount ap_invoice_lines.amount%TYPE;
450: i NUMBER;
451: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
452: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
453: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
454: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
455: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
456: l_base_amount ap_invoice_lines.base_amount%TYPE;

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

449: l_amount ap_invoice_lines.amount%TYPE;
450: i NUMBER;
451: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
452: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
453: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
454: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
455: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
456: l_base_amount ap_invoice_lines.base_amount%TYPE;
457: l_debug_info VARCHAR2(100);

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

450: i NUMBER;
451: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
452: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
453: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
454: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
455: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
456: l_base_amount ap_invoice_lines.base_amount%TYPE;
457: l_debug_info VARCHAR2(100);
458: l_line_proration_total NUMBER;

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

451: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
452: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
453: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
454: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
455: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
456: l_base_amount ap_invoice_lines.base_amount%TYPE;
457: l_debug_info VARCHAR2(100);
458: l_line_proration_total NUMBER;
459: current_calling_sequence VARCHAR2(2000);

Line 456: l_base_amount ap_invoice_lines.base_amount%TYPE;

452: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
453: l_sum_line_prorated_amount ap_invoice_lines.amount%TYPE := 0;
454: l_total_base_amount ap_invoice_lines.base_amount%TYPE := 0;
455: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
456: l_base_amount ap_invoice_lines.base_amount%TYPE;
457: l_debug_info VARCHAR2(100);
458: l_line_proration_total NUMBER;
459: current_calling_sequence VARCHAR2(2000);
460: l_api_name VARCHAR2(30);

Line 611: FROM ap_invoice_lines ail,

607: g_min_acct_unit) * g_min_acct_unit)
608: ) ,
609:
610: ap_invoice_distributions_s.nextval
611: FROM ap_invoice_lines ail,
612: ap_invoice_distributions aid
613: WHERE ail.invoice_id = x_corrected_invoice_id
614: AND ail.line_number = x_corrected_line_number
615: AND aid.invoice_id = ail.invoice_id

Line 799: l_invoice_line_number ap_invoice_lines.line_number%TYPE;

795: X_Correction_Price IN NUMBER,
796: X_Total_Correction_Amount IN NUMBER,
797: X_Calling_Sequence IN VARCHAR2) IS
798:
799: l_invoice_line_number ap_invoice_lines.line_number%TYPE;
800: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;
801: l_max_line_amount ap_invoice_lines.amount%TYPE;
802: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
803: l_line_rounding_amount ap_invoice_lines.amount%TYPE;

Line 800: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;

796: X_Total_Correction_Amount IN NUMBER,
797: X_Calling_Sequence IN VARCHAR2) IS
798:
799: l_invoice_line_number ap_invoice_lines.line_number%TYPE;
800: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;
801: l_max_line_amount ap_invoice_lines.amount%TYPE;
802: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
803: l_line_rounding_amount ap_invoice_lines.amount%TYPE;
804: l_debug_info VARCHAR2(100);

Line 801: l_max_line_amount ap_invoice_lines.amount%TYPE;

797: X_Calling_Sequence IN VARCHAR2) IS
798:
799: l_invoice_line_number ap_invoice_lines.line_number%TYPE;
800: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;
801: l_max_line_amount ap_invoice_lines.amount%TYPE;
802: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
803: l_line_rounding_amount ap_invoice_lines.amount%TYPE;
804: l_debug_info VARCHAR2(100);
805: current_calling_sequence VARCHAR2(2000);

Line 802: l_line_rounded_index ap_invoice_lines.line_number%TYPE;

798:
799: l_invoice_line_number ap_invoice_lines.line_number%TYPE;
800: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;
801: l_max_line_amount ap_invoice_lines.amount%TYPE;
802: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
803: l_line_rounding_amount ap_invoice_lines.amount%TYPE;
804: l_debug_info VARCHAR2(100);
805: current_calling_sequence VARCHAR2(2000);
806: l_api_name VARCHAR2(30);

Line 803: l_line_rounding_amount ap_invoice_lines.amount%TYPE;

799: l_invoice_line_number ap_invoice_lines.line_number%TYPE;
800: l_sum_prorated_amount ap_invoice_lines.amount%TYPE;
801: l_max_line_amount ap_invoice_lines.amount%TYPE;
802: l_line_rounded_index ap_invoice_lines.line_number%TYPE;
803: l_line_rounding_amount ap_invoice_lines.amount%TYPE;
804: l_debug_info VARCHAR2(100);
805: current_calling_sequence VARCHAR2(2000);
806: l_api_name VARCHAR2(30);
807: l_line_base_amount NUMBER;

Line 874: From ap_invoice_lines_all

870:
871: Begin
872: Select nvl(included_tax_amount, 0)
873: Into x_line_tab(i).included_tax_amount
874: From ap_invoice_lines_all
875: Where invoice_id = x_invoice_id
876: And line_number = x_line_tab(i).line_number;
877:
878: Exception

Line 972: INSERT INTO AP_INVOICE_LINES_ALL (

968:
969:
970: l_debug_info := 'Inserting non-matched Item Line';
971:
972: INSERT INTO AP_INVOICE_LINES_ALL (
973: INVOICE_ID,
974: LINE_NUMBER,
975: LINE_TYPE_LOOKUP_CODE,
976: REQUESTER_ID,

Line 1280: ap_invoice_lines ail

1276: AIL.PRODUCT_CATEGORY, --product_category
1277: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
1278: AIL.PURCHASING_CATEGORY_ID --purchasing_category_id
1279: FROM ap_invoices ai,
1280: ap_invoice_lines ail
1281: WHERE ai.invoice_id = ail.invoice_id
1282: AND ai.invoice_id = x_corrected_invoice_id
1283: AND ail.line_number = x_corrected_line_number;
1284:

Line 1672: ap_invoice_lines ail,

1668: --ETAX: Invwkb
1669: aid.intended_use, --intended_use
1670: 'N'
1671: FROM ap_invoice_distributions aid,
1672: ap_invoice_lines ail,
1673: gl_code_combinations gcc
1674: WHERE ail.invoice_id = x_invoice_id
1675: AND ail.line_number = x_invoice_line_number
1676: AND aid.invoice_id = ail.corrected_inv_id