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

Line 160: G_Max_Invoice_Line_Number ap_invoice_lines.line_number%TYPE := 0;

156: p_release_amount IN NUMBER,
157: x_calling_sequence IN VARCHAR2);
158:
159: --Global Variable Declaration
160: G_Max_Invoice_Line_Number ap_invoice_lines.line_number%TYPE := 0;
161: G_Batch_id ap_batches.batch_id%TYPE;
162: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
163: G_Period_Name gl_period_statuses.period_name%TYPE;
164: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;

Line 162: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;

158:
159: --Global Variable Declaration
160: G_Max_Invoice_Line_Number ap_invoice_lines.line_number%TYPE := 0;
161: G_Batch_id ap_batches.batch_id%TYPE;
162: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
163: G_Period_Name gl_period_statuses.period_name%TYPE;
164: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
165: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
166: G_Invoice_Type_Lookup_Code ap_invoices.invoice_type_lookup_code%TYPE;

Line 198: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;

194: G_Org_id ap_invoices.org_id%TYPE;
195: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
196: G_User_Id number;
197: G_Login_Id number;
198: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
199: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
200: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
201: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
202: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;

Line 199: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;

195: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
196: G_User_Id number;
197: G_Login_Id number;
198: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
199: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
200: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
201: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
202: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
203: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;

Line 200: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;

196: G_User_Id number;
197: G_Login_Id number;
198: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
199: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
200: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
201: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
202: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
203: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
204: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;

Line 201: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;

197: G_Login_Id number;
198: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
199: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
200: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
201: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
202: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
203: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
204: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
205: G_Line_Award_ID ap_invoice_lines.award_id%TYPE ;

Line 202: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;

198: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
199: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
200: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
201: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
202: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
203: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
204: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
205: G_Line_Award_ID ap_invoice_lines.award_id%TYPE ;
206: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;

Line 203: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;

199: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
200: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
201: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
202: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
203: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
204: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
205: G_Line_Award_ID ap_invoice_lines.award_id%TYPE ;
206: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
207: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;

Line 204: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;

200: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
201: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
202: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
203: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
204: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
205: G_Line_Award_ID ap_invoice_lines.award_id%TYPE ;
206: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
207: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
208: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;

Line 205: G_Line_Award_ID ap_invoice_lines.award_id%TYPE ;

201: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
202: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
203: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
204: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
205: G_Line_Award_ID ap_invoice_lines.award_id%TYPE ;
206: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
207: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
208: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
209: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;

Line 206: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;

202: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
203: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
204: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
205: G_Line_Award_ID ap_invoice_lines.award_id%TYPE ;
206: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
207: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
208: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
209: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
210: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;

Line 207: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;

203: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
204: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
205: G_Line_Award_ID ap_invoice_lines.award_id%TYPE ;
206: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
207: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
208: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
209: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
210: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
211: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;

Line 208: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;

204: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
205: G_Line_Award_ID ap_invoice_lines.award_id%TYPE ;
206: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
207: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
208: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
209: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
210: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
211: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;

Line 209: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;

205: G_Line_Award_ID ap_invoice_lines.award_id%TYPE ;
206: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
207: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
208: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
209: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
210: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
211: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213: --Contract Payments

Line 210: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;

206: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
207: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
208: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
209: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
210: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
211: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213: --Contract Payments
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;

Line 211: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;

207: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
208: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
209: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
210: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
211: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213: --Contract Payments
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;

Line 230: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; -- bug8222382

226: G_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
227: G_source ap_invoices_all.source%type;
228: G_recurring_payment_id ap_invoices.recurring_payment_id%TYPE; -- Bug 7305223
229: G_PAY_AWT_GROUP_ID ap_invoices_all.pay_awt_group_id%TYPE; -- bug8222382
230: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; -- bug8222382
231:
232: PROCEDURE Base_Credit_PO_Match(X_match_mode IN VARCHAR2,
233: X_invoice_id IN NUMBER,
234: X_invoice_line_number IN NUMBER,

Line 255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;

251:
252: l_single_dist_flag varchar2(1) := 'N';
253: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
254: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

252: l_single_dist_flag varchar2(1) := 'N';
253: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
254: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
260: l_error_message varchar2(4000);

Line 257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

253: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
254: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
260: l_error_message varchar2(4000);
261: l_debug_info varchar2(2000);

Line 258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

254: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
260: l_error_message varchar2(4000);
261: l_debug_info varchar2(2000);
262: l_success boolean;

Line 259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
259: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
260: l_error_message varchar2(4000);
261: l_debug_info varchar2(2000);
262: l_success boolean;
263: current_calling_sequence varchar2(2000);

Line 302: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

298: X_Po_Line_Location_id => x_po_line_location_id,
299: X_Calling_Sequence => current_calling_sequence);
300:
301: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
302: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
303: (p_line_location_id => x_po_line_location_id,
304: p_match_amount => x_amount);
305: END IF;
306:

Line 375: UPDATE ap_invoice_lines_all

371:
372: IF g_source = 'ISP'
373: and x_invoice_line_number IS NOT NULL THEN
374:
375: UPDATE ap_invoice_lines_all
376: SET primary_intended_use = nvl(primary_intended_use, g_intended_use)
377: ,product_type = nvl(product_type, g_product_type)
378: ,product_category = nvl(product_category, g_product_category)
379: ,product_fisc_classification = nvl(product_fisc_classification, g_product_fisc_class)

Line 462: UPDATE ap_invoice_lines ail

458: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
460: END IF;
461:
462: UPDATE ap_invoice_lines ail
463: SET (generate_dists ,
464: requester_id ,
465: po_distribution_id ,
466: project_id ,

Line 543: UPDATE ap_invoice_lines ail

539: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
540: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
541: END IF;
542:
543: UPDATE ap_invoice_lines ail
544: SET (generate_dists ,
545: attribute_category,
546: attribute1,
547: attribute2,

Line 589: FROM ap_invoice_lines ail1,

585: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
586: --end Bug 7483260
587: l_retained_amount,
588: -1 * l_retained_amount
589: FROM ap_invoice_lines ail1,
590: po_line_locations pll
591: WHERE ail1.invoice_id = x_invoice_id
592: AND ail1.line_number =x_invoice_line_number
593: AND pll.line_location_id = ail1.po_line_location_id)

Line 733: l_accounting_date ap_invoice_lines.accounting_date%TYPE; --7463095

729:
730: current_calling_sequence VARCHAR2(2000);
731: l_debug_info VARCHAR2(2000);
732: l_api_name VARCHAR2(30);
733: l_accounting_date ap_invoice_lines.accounting_date%TYPE; --7463095
734:
735: BEGIN
736:
737: l_api_name := 'Get_Info';

Line 876: FROM ap_invoice_lines ail

872: g_line_expenditure_org_id,
873: g_line_awt_group_id,
874: g_line_accounting_date,
875: g_line_pay_awt_group_id
876: FROM ap_invoice_lines ail
877: WHERE ail.invoice_id = x_invoice_id
878: AND ail.line_number = x_invoice_line_number;
879:
880: END IF;

Line 884: FROM ap_invoice_lines ail

880: END IF;
881:
882: SELECT nvl(max(ail.line_number),0)
883: INTO g_max_invoice_line_number
884: FROM ap_invoice_lines ail
885: WHERE ail.invoice_id = x_invoice_id;
886:
887: /* Bug 5572876 */
888: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book

Line 1734: INSERT INTO AP_INVOICE_LINES (

1730: -- bug 5061826
1731: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1732: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1733:
1734: INSERT INTO AP_INVOICE_LINES (
1735: INVOICE_ID,
1736: LINE_NUMBER,
1737: LINE_TYPE_LOOKUP_CODE,
1738: REQUESTER_ID,

Line 2136: INSERT INTO AP_INVOICE_LINES (

2132: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2133: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2134: END IF;
2135:
2136: INSERT INTO AP_INVOICE_LINES (
2137: INVOICE_ID,
2138: LINE_NUMBER,
2139: LINE_TYPE_LOOKUP_CODE,
2140: REQUESTER_ID,

Line 2455: FROM AP_INVOICE_LINES AIL

2451: G_ASSESSABLE_VALUE,
2452: G_dflt_tax_class_code,
2453: X_COST_FACTOR_ID, --cost_factor_id
2454: AIL.PAY_AWT_GROUP_ID --pay_awt_group_id bug8222382
2455: FROM AP_INVOICE_LINES AIL
2456: WHERE AIL.INVOICE_ID = X_INVOICE_ID
2457: AND AIL.LINE_NUMBER = X_ITEM_LINE_NUMBER;
2458:
2459: END IF;

Line 2869: ap_invoice_lines ail,

2865: 'N', --cash_posted_flag
2866: 'N', --rcv_charge_addition_flag
2867: x_dist_tab(i).pay_awt_group_id --pay_awt_group_id bug8222382
2868: FROM po_distributions pd,
2869: ap_invoice_lines ail,
2870: gl_code_combinations gcc
2871: WHERE ail.invoice_id = x_invoice_id
2872: AND ail.line_number = x_invoice_line_number
2873: AND ail.po_line_location_id = pd.line_location_id

Line 3230: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

3226: X_Retained_Amount IN NUMBER DEFAULT NULL,
3227: X_Calling_Sequence IN VARCHAR2) IS
3228:
3229: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3230: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3231: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3232: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3233: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 3231: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

3227: X_Calling_Sequence IN VARCHAR2) IS
3228:
3229: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3230: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3231: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3232: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3233: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3235: l_success BOOLEAN;

Line 3232: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

3228:
3229: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3230: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3231: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3232: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3233: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3235: l_success BOOLEAN;
3236: l_error_message VARCHAR2(4000);

Line 3233: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

3229: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3230: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3231: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3232: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3233: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3235: l_success BOOLEAN;
3236: l_error_message VARCHAR2(4000);
3237: l_debug_info VARCHAR2(2000);

Line 3234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

3230: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3231: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3232: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3233: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3235: l_success BOOLEAN;
3236: l_error_message VARCHAR2(4000);
3237: l_debug_info VARCHAR2(2000);
3238: current_calling_sequence VARCHAR2(2000);

Line 3263: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

3259: x_po_line_location_id => x_po_line_location_id,
3260: x_calling_sequence => current_calling_sequence);
3261:
3262: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
3263: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
3264: (p_line_location_id => x_po_line_location_id,
3265: p_match_amount => x_correction_amount);
3266: END IF;
3267:

Line 3337: UPDATE ap_invoice_lines ail

3333: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3335: END IF;
3336:
3337: UPDATE ap_invoice_lines ail
3338: SET (generate_dists ,
3339: attribute_category,
3340: attribute1,
3341: attribute2,

Line 3383: FROM ap_invoice_lines ail1,

3379: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
3380: --end Bug 7483260
3381: l_retained_amount,
3382: -1 * l_retained_amount
3383: FROM ap_invoice_lines ail1,
3384: po_line_locations pll
3385: WHERE ail1.invoice_id = x_invoice_id
3386: AND ail1.line_number =x_invoice_line_number
3387: AND pll.line_location_id = ail1.po_line_location_id)

Line 3522: FROM ap_invoice_lines ail,

3518: 'Y', pd.code_combination_id,
3519: aid.dist_code_combination_id),
3520: pd.variance_account_id),
3521: ap_invoice_distributions_s.nextval
3522: FROM ap_invoice_lines ail,
3523: ap_invoice_distributions aid,
3524: po_distributions pd
3525: WHERE ail.invoice_id = x_corrected_invoice_id
3526: AND ail.line_number = x_corrected_line_number

Line 3562: ap_invoice_lines ail,

3558: p_total_quantity_billed , 15) corrected_quantity,
3559: aid.dist_code_combination_id,
3560: ap_invoice_distributions_s.nextval
3561: FROM ap_invoice_distributions aid,
3562: ap_invoice_lines ail,
3563: po_distributions pd
3564: WHERE ail.invoice_id = x_corrected_invoice_id
3565: AND ail.line_number = x_corrected_line_number
3566: AND aid.invoice_id = ail.invoice_id

Line 4058: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,

4054: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4055: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Corr_Invoice_Line(+)');
4056: END IF;
4057:
4058: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,
4059: LINE_NUMBER,
4060: LINE_TYPE_LOOKUP_CODE,
4061: REQUESTER_ID,
4062: DESCRIPTION,

Line 4375: ap_invoice_lines ail,

4371: AIL.PRODUCT_CATEGORY, --product_category
4372: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
4373: g_pay_awt_group_id --pay_awt_group_id bug8222382
4374: FROM ap_invoices ai,
4375: ap_invoice_lines ail,
4376: po_line_locations_ap_v pll
4377: WHERE ai.invoice_id = x_corrected_invoice_id
4378: AND ail.invoice_id = ai.invoice_id
4379: AND ail.line_number = x_corrected_line_number

Line 4772: FROM ap_invoice_lines ail,

4768: decode(g_system_allow_awt_flag,'Y',
4769: decode(g_site_allow_awt_flag,'Y',
4770: ail.pay_awt_group_id,NULL),
4771: NULL) --pay_awt_group_id bug8222382
4772: FROM ap_invoice_lines ail,
4773: ap_invoice_distributions aid,
4774: po_distributions pd
4775: WHERE ail.invoice_id = x_invoice_id
4776: AND ail.line_number = x_invoice_line_number

Line 5096: l_amount ap_invoice_lines.amount%TYPE;

5092: AND rcv.po_match_option = 'R'
5093: ORDER BY rcv.rcv_transaction_id;
5094:
5095: l_available_match_amount NUMBER := x_match_amount;
5096: l_amount ap_invoice_lines.amount%TYPE;
5097: l_base_amount ap_invoice_lines.base_amount%TYPE;
5098: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;
5099: l_po_line_location_id po_line_locations.line_location_id%TYPE;
5100: l_po_line_id po_lines.po_line_id%TYPE;

Line 5097: l_base_amount ap_invoice_lines.base_amount%TYPE;

5093: ORDER BY rcv.rcv_transaction_id;
5094:
5095: l_available_match_amount NUMBER := x_match_amount;
5096: l_amount ap_invoice_lines.amount%TYPE;
5097: l_base_amount ap_invoice_lines.base_amount%TYPE;
5098: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;
5099: l_po_line_location_id po_line_locations.line_location_id%TYPE;
5100: l_po_line_id po_lines.po_line_id%TYPE;
5101: l_po_release_id po_releases.po_release_id%TYPE;

Line 5098: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;

5094:
5095: l_available_match_amount NUMBER := x_match_amount;
5096: l_amount ap_invoice_lines.amount%TYPE;
5097: l_base_amount ap_invoice_lines.base_amount%TYPE;
5098: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;
5099: l_po_line_location_id po_line_locations.line_location_id%TYPE;
5100: l_po_line_id po_lines.po_line_id%TYPE;
5101: l_po_release_id po_releases.po_release_id%TYPE;
5102: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;

Line 5131: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;

5127: l_attribute12 po_line_locations.attribute12%TYPE;
5128: l_attribute13 po_line_locations.attribute13%TYPE;
5129: l_attribute14 po_line_locations.attribute14%TYPE;
5130: l_attribute15 po_line_locations.attribute15%TYPE;
5131: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;
5132: l_index po_line_locations.line_location_id%TYPE;
5133: l_conversion_factor NUMBER;
5134: l_ordered_qty NUMBER;
5135: l_cancelled_qty NUMBER;

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

5140: l_billed_qty NUMBER;
5141: l_accepted_qty NUMBER;
5142: l_rejected_qty NUMBER;
5143: l_rect_unit_price po_lines.unit_price%TYPE;
5144: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5145: l_rounded_index po_line_locations.line_location_id%TYPE;
5146: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5147: l_available_amount po_line_locations.amount%TYPE;
5148: l_available_qty po_line_locations.quantity%TYPE;

Line 5146: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;

5142: l_rejected_qty NUMBER;
5143: l_rect_unit_price po_lines.unit_price%TYPE;
5144: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5145: l_rounded_index po_line_locations.line_location_id%TYPE;
5146: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5147: l_available_amount po_line_locations.amount%TYPE;
5148: l_available_qty po_line_locations.quantity%TYPE;
5149: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5150: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;

Line 5149: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;

5145: l_rounded_index po_line_locations.line_location_id%TYPE;
5146: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5147: l_available_amount po_line_locations.amount%TYPE;
5148: l_available_qty po_line_locations.quantity%TYPE;
5149: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5150: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5151: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5152: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5153: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;

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

5146: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5147: l_available_amount po_line_locations.amount%TYPE;
5148: l_available_qty po_line_locations.quantity%TYPE;
5149: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5150: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5151: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5152: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5153: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5154: l_product_type ap_invoice_lines.product_type%TYPE;

Line 5151: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;

5147: l_available_amount po_line_locations.amount%TYPE;
5148: l_available_qty po_line_locations.quantity%TYPE;
5149: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5150: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5151: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5152: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5153: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5154: l_product_type ap_invoice_lines.product_type%TYPE;
5155: l_product_category ap_invoice_lines.product_category%TYPE;

Line 5152: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;

5148: l_available_qty po_line_locations.quantity%TYPE;
5149: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5150: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5151: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5152: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5153: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5154: l_product_type ap_invoice_lines.product_type%TYPE;
5155: l_product_category ap_invoice_lines.product_category%TYPE;
5156: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;

Line 5153: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;

5149: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5150: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5151: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5152: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5153: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5154: l_product_type ap_invoice_lines.product_type%TYPE;
5155: l_product_category ap_invoice_lines.product_category%TYPE;
5156: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;
5157: l_amount_ordered NUMBER;

Line 5154: l_product_type ap_invoice_lines.product_type%TYPE;

5150: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5151: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5152: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5153: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5154: l_product_type ap_invoice_lines.product_type%TYPE;
5155: l_product_category ap_invoice_lines.product_category%TYPE;
5156: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;
5157: l_amount_ordered NUMBER;
5158: l_amount_cancelled NUMBER;

Line 5155: l_product_category ap_invoice_lines.product_category%TYPE;

5151: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5152: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5153: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5154: l_product_type ap_invoice_lines.product_type%TYPE;
5155: l_product_category ap_invoice_lines.product_category%TYPE;
5156: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;
5157: l_amount_ordered NUMBER;
5158: l_amount_cancelled NUMBER;
5159: l_amount_delivered NUMBER;

Line 5156: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;

5152: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5153: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5154: l_product_type ap_invoice_lines.product_type%TYPE;
5155: l_product_category ap_invoice_lines.product_category%TYPE;
5156: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;
5157: l_amount_ordered NUMBER;
5158: l_amount_cancelled NUMBER;
5159: l_amount_delivered NUMBER;
5160: l_amount_billed NUMBER;

Line 5164: l_retained_amount ap_invoice_lines.retained_amount%TYPE;

5160: l_amount_billed NUMBER;
5161: l_amount_received NUMBER;
5162: l_amount_corrected NUMBER;
5163: l_matching_basis po_line_locations.matching_basis%TYPE;
5164: l_retained_amount ap_invoice_lines.retained_amount%TYPE;
5165: l_ret_status VARCHAR2(100);
5166: l_msg_count NUMBER;
5167: l_msg_data VARCHAR2(250);
5168: l_debug_info VARCHAR2(2000);

Line 5341: X_Shipment_Table(l_index).retained_amount := ap_invoice_lines_utility_pkg.get_retained_amount

5337: X_shipment_Table(l_index).assessable_value := g_assessable_value;
5338: X_shipment_Table(l_index).tax_classification_code := g_dflt_tax_class_code;
5339:
5340: X_Shipment_Table(l_index).matching_basis := l_matching_basis;
5341: X_Shipment_Table(l_index).retained_amount := ap_invoice_lines_utility_pkg.get_retained_amount
5342: (l_po_line_location_id, l_amount);
5343:
5344: --Get the max of the largest invoice line, to be used for assignment of
5345: --rounding due to proration.

Line 5559: X_Shipment_Table(l_index).retained_amount := ap_invoice_lines_utility_pkg.get_retained_amount

5555: X_Shipment_Table(l_index).product_category := l_product_category;
5556: X_Shipment_Table(l_index).user_defined_fisc_class := l_user_defined_fisc_class;
5557:
5558: X_Shipment_Table(l_index).matching_basis := l_matching_basis;
5559: X_Shipment_Table(l_index).retained_amount := ap_invoice_lines_utility_pkg.get_retained_amount
5560: (l_po_line_location_id, l_amount);
5561:
5562: --Get the max of the largest invoice line, to be used for assignment of
5563: --rounding due to proration.

Line 5680: INSERT INTO AP_INVOICE_LINES_ALL

5676: FOR i IN NVL(x_shipment_table.first,0) .. NVL(x_shipment_table.last,0) LOOP
5677:
5678: IF (x_shipment_table.exists(i)) THEN
5679: /* bug 6150813 */
5680: INSERT INTO AP_INVOICE_LINES_ALL
5681: (INVOICE_ID,
5682: LINE_NUMBER,
5683: LINE_TYPE_LOOKUP_CODE,
5684: REQUESTER_ID,