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

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

128: X_Calling_Sequence IN VARCHAR2);
129:
130:
131: --Global Variable Declaration
132: G_Max_Invoice_Line_Number ap_invoice_lines.line_number%TYPE := 0;
133: G_Batch_id ap_batches.batch_id%TYPE;
134: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
135: G_Period_Name gl_period_statuses.period_name%TYPE;
136: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;

Line 134: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;

130:
131: --Global Variable Declaration
132: G_Max_Invoice_Line_Number ap_invoice_lines.line_number%TYPE := 0;
133: G_Batch_id ap_batches.batch_id%TYPE;
134: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
135: G_Period_Name gl_period_statuses.period_name%TYPE;
136: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
137: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
138: G_Pay_Awt_Group_ID ap_awt_groups.group_id%TYPE; --bug 9689194

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

166: G_Org_id ap_invoices.org_id%TYPE;
167: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
168: G_User_Id number;
169: G_Login_Id number;
170: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
171: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
172: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
173: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
174: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;

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

167: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
168: G_User_Id number;
169: G_Login_Id number;
170: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
171: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
172: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
173: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
174: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
175: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;

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

168: G_User_Id number;
169: G_Login_Id number;
170: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
171: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
172: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
173: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
174: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
175: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
176: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;

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

169: G_Login_Id number;
170: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
171: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
172: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
173: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
174: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
175: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
176: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
177: G_Line_Award_Id ap_invoice_lines.award_id%TYPE ;

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

170: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
171: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
172: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
173: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
174: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
175: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
176: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
177: G_Line_Award_Id ap_invoice_lines.award_id%TYPE ;
178: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;

Line 175: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;

171: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
172: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
173: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
174: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
175: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
176: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
177: G_Line_Award_Id ap_invoice_lines.award_id%TYPE ;
178: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
179: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;

Line 176: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;

172: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
173: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
174: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
175: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
176: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
177: G_Line_Award_Id ap_invoice_lines.award_id%TYPE ;
178: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
179: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
180: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;

Line 177: G_Line_Award_Id ap_invoice_lines.award_id%TYPE ;

173: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
174: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
175: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
176: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
177: G_Line_Award_Id ap_invoice_lines.award_id%TYPE ;
178: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
179: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
180: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
181: G_Award_Id ap_invoices.award_id%TYPE;

Line 178: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;

174: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
175: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
176: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
177: G_Line_Award_Id ap_invoice_lines.award_id%TYPE ;
178: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
179: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
180: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
181: G_Award_Id ap_invoices.award_id%TYPE;
182: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;

Line 179: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;

175: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
176: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
177: G_Line_Award_Id ap_invoice_lines.award_id%TYPE ;
178: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
179: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
180: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
181: G_Award_Id ap_invoices.award_id%TYPE;
182: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
183: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;

Line 180: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;

176: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
177: G_Line_Award_Id ap_invoice_lines.award_id%TYPE ;
178: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
179: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
180: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
181: G_Award_Id ap_invoices.award_id%TYPE;
182: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
183: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
184: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194

Line 182: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;

178: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
179: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
180: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
181: G_Award_Id ap_invoices.award_id%TYPE;
182: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
183: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
184: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
185: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
186: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;

Line 183: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;

179: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
180: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
181: G_Award_Id ap_invoices.award_id%TYPE;
182: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
183: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
184: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
185: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
186: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
187:

Line 184: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194

180: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
181: G_Award_Id ap_invoices.award_id%TYPE;
182: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
183: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
184: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
185: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
186: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
187:
188: --Contract Payments

Line 185: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;

181: G_Award_Id ap_invoices.award_id%TYPE;
182: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
183: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
184: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
185: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
186: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
187:
188: --Contract Payments
189: G_Vendor_Id ap_invoices.vendor_id%TYPE;

Line 230: l_item_line_number ap_invoice_lines.line_number%TYPE;

226: IS
227: l_single_dist_flag varchar2(1) := 'N';
228: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
229: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
230: l_item_line_number ap_invoice_lines.line_number%TYPE;
231: l_amount_to_recoup ap_invoice_lines.amount%TYPE;
232: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
233: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 231: l_amount_to_recoup ap_invoice_lines.amount%TYPE;

227: l_single_dist_flag varchar2(1) := 'N';
228: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
229: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
230: l_item_line_number ap_invoice_lines.line_number%TYPE;
231: l_amount_to_recoup ap_invoice_lines.amount%TYPE;
232: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
233: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
235: l_debug_info varchar2(2000);

Line 232: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

228: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
229: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
230: l_item_line_number ap_invoice_lines.line_number%TYPE;
231: l_amount_to_recoup ap_invoice_lines.amount%TYPE;
232: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
233: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
235: l_debug_info varchar2(2000);
236: l_success boolean;

Line 233: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

229: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
230: l_item_line_number ap_invoice_lines.line_number%TYPE;
231: l_amount_to_recoup ap_invoice_lines.amount%TYPE;
232: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
233: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
235: l_debug_info varchar2(2000);
236: l_success boolean;
237: l_error_message varchar2(4000);

Line 234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

230: l_item_line_number ap_invoice_lines.line_number%TYPE;
231: l_amount_to_recoup ap_invoice_lines.amount%TYPE;
232: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
233: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
234: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
235: l_debug_info varchar2(2000);
236: l_success boolean;
237: l_error_message varchar2(4000);
238: current_calling_sequence varchar2(2000);

Line 281: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

277: X_Po_Line_Location_id => x_po_line_location_id,
278: X_Calling_Sequence => current_calling_sequence);
279:
280: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
281: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
282: (p_line_location_id => x_po_line_location_id,
283: p_match_amount => x_amount);
284: END IF;
285:

Line 413: FROM ap_invoice_lines_all

409: END IF;
410:
411: SELECT AMOUNT
412: INTO l_line_amt
413: FROM ap_invoice_lines_all
414: WHERE invoice_id = x_invoice_id
415: AND line_number = x_invoice_line_number;
416:
417: l_debug_info := 'l_line_amt '||l_line_amt;

Line 424: UPDATE ap_invoice_lines_all

420: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
421: END IF;
422: --End Bug#13505998
423:
424: UPDATE ap_invoice_lines_all
425: SET primary_intended_use = nvl(primary_intended_use, g_intended_use)
426: ,product_type = nvl(product_type, g_product_type)
427: ,product_category = nvl(product_category, g_product_category)
428: ,product_fisc_classification = nvl(product_fisc_classification, g_product_fisc_class)

Line 506: UPDATE ap_invoice_lines ail

502: l_debug_info := 'If the line is matched down to 1 po distribution then need to
503: update the line with po_distribution_id, award_id,requester_id,
504: ,projects related information and generate_dists';
505:
506: UPDATE ap_invoice_lines ail
507: SET (generate_dists ,
508: requester_id ,
509: po_distribution_id ,
510: project_id ,

Line 583: UPDATE ap_invoice_lines ail

579: ELSE
580:
581: l_debug_info := 'Update the generate_dists to D after the distributions are created';
582:
583: UPDATE ap_invoice_lines ail
584: SET (generate_dists ,
585: attribute_category,
586: attribute1,
587: attribute2,

Line 629: FROM ap_invoice_lines ail1,

625: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
626: --end Bug 7483260
627: l_retained_amount,
628: -1 * l_retained_amount
629: FROM ap_invoice_lines ail1,
630: po_line_locations pll
631: WHERE ail1.invoice_id = x_invoice_id
632: AND ail1.line_number =x_invoice_line_number
633: AND pll.line_location_id = ail1.po_line_location_id)

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

726: X_Calling_Sequence IN VARCHAR2 )
727: IS
728: current_calling_sequence VARCHAR2(2000);
729: l_debug_info VARCHAR2(2000);
730: l_accounting_date ap_invoice_lines.accounting_date%TYPE; --Bug16216470
731:
732: BEGIN
733:
734: current_calling_sequence := 'Get_Info<-'||X_Calling_Sequence;

Line 865: FROM ap_invoice_lines ail

861: g_line_expenditure_org_id,
862: g_line_awt_group_id,
863: g_line_accounting_date,
864: g_line_pay_awt_group_id --Bug 9689194
865: FROM ap_invoice_lines ail
866: WHERE ail.invoice_id = x_invoice_id
867: AND ail.line_number = x_invoice_line_number;
868:
869:

Line 874: FROM ap_invoice_lines ail

870: END IF;
871:
872: SELECT nvl(max(ail.line_number),0)
873: INTO g_max_invoice_line_number
874: FROM ap_invoice_lines ail
875: WHERE ail.invoice_id = x_invoice_id;
876:
877: /* Bug 5572876 */
878: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book

Line 1786: INSERT INTO AP_INVOICE_LINES (

1782: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1783: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1784:
1785:
1786: INSERT INTO AP_INVOICE_LINES (
1787: INVOICE_ID,
1788: LINE_NUMBER,
1789: LINE_TYPE_LOOKUP_CODE,
1790: REQUESTER_ID,

Line 2187: INSERT INTO AP_INVOICE_LINES (

2183: ELSIF (x_line_type_lookup_code IN ('FREIGHT','MISCELLANEOUS')) THEN
2184:
2185: l_debug_info := 'Inserting Charge Line';
2186:
2187: INSERT INTO AP_INVOICE_LINES (
2188: INVOICE_ID,
2189: LINE_NUMBER,
2190: LINE_TYPE_LOOKUP_CODE,
2191: REQUESTER_ID,

Line 2503: FROM AP_INVOICE_LINES AIL

2499: DECODE(X_Amount,l_full_mtch_amt,X_Amount, NULL),
2500: G_dflt_tax_class_code,
2501: X_COST_FACTOR_ID, --cost_factor_id
2502: AIL.PAY_AWT_GROUP_ID --Bug 9689194
2503: FROM AP_INVOICE_LINES AIL
2504: WHERE AIL.INVOICE_ID = X_INVOICE_ID
2505: AND AIL.LINE_NUMBER = X_ITEM_LINE_NUMBER;
2506:
2507: END IF;

Line 2904: ap_invoice_lines ail,

2900: 'N', --cash_posted_flag
2901: 'N', --rcv_charge_addition_flag
2902: x_dist_tab(i).pay_awt_group_id --pay_awt_group_id --Bug 9689194
2903: FROM po_distributions pd,
2904: ap_invoice_lines ail,
2905: gl_code_combinations gcc
2906: WHERE ail.invoice_id = x_invoice_id
2907: AND ail.line_number = x_invoice_line_number
2908: AND ail.po_line_location_id = pd.line_location_id

Line 3081: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

3077: X_Retained_Amount IN NUMBER DEFAULT NULL,
3078: X_Calling_Sequence IN VARCHAR2) IS
3079:
3080: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3081: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3082: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3083: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3084: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3085: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 3082: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;

3078: X_Calling_Sequence IN VARCHAR2) IS
3079:
3080: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3081: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3082: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3083: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3084: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3085: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3086: l_success BOOLEAN;

Line 3083: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

3079:
3080: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3081: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3082: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3083: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3084: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3085: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3086: l_success BOOLEAN;
3087: l_error_message VARCHAR2(4000);

Line 3084: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

3080: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3081: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3082: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3083: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3084: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3085: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3086: l_success BOOLEAN;
3087: l_error_message VARCHAR2(4000);
3088: l_debug_info VARCHAR2(2000);

Line 3085: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

3081: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3082: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3083: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3084: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3085: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3086: l_success BOOLEAN;
3087: l_error_message VARCHAR2(4000);
3088: l_debug_info VARCHAR2(2000);
3089: current_calling_sequence VARCHAR2(2000);

Line 3105: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

3101: x_po_line_location_id => x_po_line_location_id,
3102: x_calling_sequence => current_calling_sequence);
3103:
3104: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
3105: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
3106: (p_line_location_id => x_po_line_location_id,
3107: p_match_amount => x_correction_amount);
3108: END IF;
3109:

Line 3152: UPDATE ap_invoice_lines ail

3148:
3149:
3150: IF(x_invoice_line_number IS NOT NULL) THEN
3151:
3152: UPDATE ap_invoice_lines ail
3153: SET (generate_dists ,
3154: attribute_category,
3155: attribute1,
3156: attribute2,

Line 3198: FROM ap_invoice_lines ail1,

3194: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
3195: --end Bug 7483260
3196: l_retained_amount,
3197: -1 * l_retained_amount
3198: FROM ap_invoice_lines ail1,
3199: po_line_locations pll
3200: WHERE ail1.invoice_id = x_invoice_id
3201: AND ail1.line_number =x_invoice_line_number
3202: AND pll.line_location_id = ail1.po_line_location_id)

Line 3309: FROM ap_invoice_lines ail,

3305: /g_min_acct_unit) * g_min_acct_unit
3306: ) amount,
3307: aid.dist_code_combination_id,
3308: ap_invoice_distributions_s.nextval
3309: FROM ap_invoice_lines ail,
3310: ap_invoice_distributions aid
3311: WHERE ail.invoice_id = x_corrected_invoice_id
3312: AND ail.line_number = x_corrected_line_number
3313: AND aid.invoice_id = ail.invoice_id

Line 3630: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,

3626: BEGIN
3627:
3628: current_calling_sequence := 'Insert_Corr_Invoice_Line<-'||x_calling_sequence;
3629:
3630: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,
3631: LINE_NUMBER,
3632: LINE_TYPE_LOOKUP_CODE,
3633: REQUESTER_ID,
3634: DESCRIPTION,

Line 3945: ap_invoice_lines ail,

3941: AIL.PRODUCT_CATEGORY, --product_category
3942: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
3943: g_pay_awt_group_id --Bug 9689194
3944: FROM ap_invoices ai,
3945: ap_invoice_lines ail,
3946: po_line_locations_ap_v pll
3947: WHERE ai.invoice_id = x_corrected_invoice_id
3948: AND ail.invoice_id = ai.invoice_id
3949: AND ail.line_number = x_corrected_line_number

Line 4326: FROM ap_invoice_lines ail,

4322: decode(g_site_allow_awt_flag,'Y',
4323: ail.pay_awt_group_id,NULL),
4324: NULL) --pay_awt_group_id Bug 9689194
4325:
4326: FROM ap_invoice_lines ail,
4327: ap_invoice_distributions aid,
4328: po_distributions pd
4329: WHERE ail.invoice_id = x_invoice_id
4330: AND ail.line_number = x_invoice_line_number