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 309: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

305: X_Po_Line_Location_id => x_po_line_location_id,
306: X_Calling_Sequence => current_calling_sequence);
307:
308: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
309: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
310: (p_line_location_id => x_po_line_location_id,
311: p_match_amount => x_amount);
312: END IF;
313:

Line 442: FROM ap_invoice_lines_all

438:
439:
440: SELECT AMOUNT
441: INTO l_line_amt
442: FROM ap_invoice_lines_all
443: WHERE invoice_id = x_invoice_id
444: AND line_number = x_invoice_line_number;
445:
446: l_debug_info := 'l_line_amt '||l_line_amt;

Line 454: UPDATE ap_invoice_lines_all

450: END IF;
451:
452: --End Bug#13505998
453:
454: UPDATE ap_invoice_lines_all
455: SET primary_intended_use = nvl(primary_intended_use, g_intended_use)
456: ,product_type = nvl(product_type, g_product_type)
457: ,product_category = nvl(product_category, g_product_category)
458: ,product_fisc_classification = nvl(product_fisc_classification, g_product_fisc_class)

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: requester_id ,
546: po_distribution_id ,
547: project_id ,

Line 624: UPDATE ap_invoice_lines ail

620: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
621: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
622: END IF;
623:
624: UPDATE ap_invoice_lines ail
625: SET (generate_dists ,
626: attribute_category,
627: attribute1,
628: attribute2,

Line 670: FROM ap_invoice_lines ail1,

666: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
667: --end Bug 7483260
668: l_retained_amount,
669: -1 * l_retained_amount
670: FROM ap_invoice_lines ail1,
671: po_line_locations pll
672: WHERE ail1.invoice_id = x_invoice_id
673: AND ail1.line_number =x_invoice_line_number
674: AND pll.line_location_id = ail1.po_line_location_id)

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

810:
811: current_calling_sequence VARCHAR2(2000);
812: l_debug_info VARCHAR2(2000);
813: l_api_name VARCHAR2(30);
814: l_accounting_date ap_invoice_lines.accounting_date%TYPE; --7463095
815:
816: BEGIN
817:
818: l_api_name := 'Get_Info';

Line 957: FROM ap_invoice_lines ail

953: g_line_expenditure_org_id,
954: g_line_awt_group_id,
955: g_line_accounting_date,
956: g_line_pay_awt_group_id
957: FROM ap_invoice_lines ail
958: WHERE ail.invoice_id = x_invoice_id
959: AND ail.line_number = x_invoice_line_number;
960:
961: END IF;

Line 965: FROM ap_invoice_lines ail

961: END IF;
962:
963: SELECT nvl(max(ail.line_number),0)
964: INTO g_max_invoice_line_number
965: FROM ap_invoice_lines ail
966: WHERE ail.invoice_id = x_invoice_id;
967:
968: /* Bug 5572876 */
969: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book

Line 1833: INSERT INTO AP_INVOICE_LINES (

1829: -- bug 5061826
1830: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1831: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1832:
1833: INSERT INTO AP_INVOICE_LINES (
1834: INVOICE_ID,
1835: LINE_NUMBER,
1836: LINE_TYPE_LOOKUP_CODE,
1837: REQUESTER_ID,

Line 2236: INSERT INTO AP_INVOICE_LINES (

2232: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2233: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2234: END IF;
2235:
2236: INSERT INTO AP_INVOICE_LINES (
2237: INVOICE_ID,
2238: LINE_NUMBER,
2239: LINE_TYPE_LOOKUP_CODE,
2240: REQUESTER_ID,

Line 2557: FROM AP_INVOICE_LINES AIL

2553: DECODE(X_Amount,l_full_mtch_amt,X_AMOUNT, NULL),
2554: G_dflt_tax_class_code,
2555: X_COST_FACTOR_ID, --cost_factor_id
2556: AIL.PAY_AWT_GROUP_ID --pay_awt_group_id bug8222382
2557: FROM AP_INVOICE_LINES AIL
2558: WHERE AIL.INVOICE_ID = X_INVOICE_ID
2559: AND AIL.LINE_NUMBER = X_ITEM_LINE_NUMBER;
2560:
2561: END IF;

Line 2973: ap_invoice_lines ail,

2969: 'N', --cash_posted_flag
2970: 'N', --rcv_charge_addition_flag
2971: x_dist_tab(i).pay_awt_group_id --pay_awt_group_id bug8222382
2972: FROM po_distributions pd,
2973: ap_invoice_lines ail,
2974: gl_code_combinations gcc
2975: WHERE ail.invoice_id = x_invoice_id
2976: AND ail.line_number = x_invoice_line_number
2977: AND ail.po_line_location_id = pd.line_location_id

Line 3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

3330: X_Retained_Amount IN NUMBER DEFAULT NULL,
3331: X_Calling_Sequence IN VARCHAR2) IS
3332:
3333: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

3331: X_Calling_Sequence IN VARCHAR2) IS
3332:
3333: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3339: l_success BOOLEAN;

Line 3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

3332:
3333: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3339: l_success BOOLEAN;
3340: l_error_message VARCHAR2(4000);

Line 3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

3333: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3339: l_success BOOLEAN;
3340: l_error_message VARCHAR2(4000);
3341: l_debug_info VARCHAR2(2000);

Line 3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

3334: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3335: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3336: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3337: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3338: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3339: l_success BOOLEAN;
3340: l_error_message VARCHAR2(4000);
3341: l_debug_info VARCHAR2(2000);
3342: current_calling_sequence VARCHAR2(2000);

Line 3367: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

3363: x_po_line_location_id => x_po_line_location_id,
3364: x_calling_sequence => current_calling_sequence);
3365:
3366: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
3367: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
3368: (p_line_location_id => x_po_line_location_id,
3369: p_match_amount => x_correction_amount);
3370: END IF;
3371:

Line 3441: UPDATE ap_invoice_lines ail

3437: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3438: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3439: END IF;
3440:
3441: UPDATE ap_invoice_lines ail
3442: SET (generate_dists ,
3443: attribute_category,
3444: attribute1,
3445: attribute2,

Line 3487: FROM ap_invoice_lines ail1,

3483: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
3484: --end Bug 7483260
3485: l_retained_amount,
3486: -1 * l_retained_amount
3487: FROM ap_invoice_lines ail1,
3488: po_line_locations pll
3489: WHERE ail1.invoice_id = x_invoice_id
3490: AND ail1.line_number =x_invoice_line_number
3491: AND pll.line_location_id = ail1.po_line_location_id)

Line 3627: FROM ap_invoice_lines ail,

3623: 'Y', pd.code_combination_id,
3624: aid1.dist_code_combination_id),
3625: pd.variance_account_id),
3626: ap_invoice_distributions_s.nextval
3627: FROM ap_invoice_lines ail,
3628: ap_invoice_distributions aid1,
3629: po_distributions pd,
3630: ap_invoice_distributions aid2
3631: WHERE ail.invoice_id = x_corrected_invoice_id

Line 3670: ap_invoice_lines ail,

3666: p_total_quantity_billed , 15) corrected_quantity,
3667: aid.dist_code_combination_id,
3668: ap_invoice_distributions_s.nextval
3669: FROM ap_invoice_distributions aid,
3670: ap_invoice_lines ail,
3671: po_distributions pd
3672: WHERE ail.invoice_id = x_corrected_invoice_id
3673: AND ail.line_number = x_corrected_line_number
3674: AND aid.invoice_id = ail.invoice_id

Line 4172: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,

4168: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4169: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Corr_Invoice_Line(+)');
4170: END IF;
4171:
4172: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,
4173: LINE_NUMBER,
4174: LINE_TYPE_LOOKUP_CODE,
4175: REQUESTER_ID,
4176: DESCRIPTION,

Line 4489: ap_invoice_lines ail,

4485: AIL.PRODUCT_CATEGORY, --product_category
4486: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
4487: g_pay_awt_group_id --pay_awt_group_id bug8222382
4488: FROM ap_invoices ai,
4489: ap_invoice_lines ail,
4490: po_line_locations_ap_v pll
4491: WHERE ai.invoice_id = x_corrected_invoice_id
4492: AND ail.invoice_id = ai.invoice_id
4493: AND ail.line_number = x_corrected_line_number

Line 4886: FROM ap_invoice_lines ail,

4882: decode(g_system_allow_awt_flag,'Y',
4883: decode(g_site_allow_awt_flag,'Y',
4884: ail.pay_awt_group_id,NULL),
4885: NULL) --pay_awt_group_id bug8222382
4886: FROM ap_invoice_lines ail,
4887: ap_invoice_distributions aid,
4888: po_distributions pd
4889: WHERE ail.invoice_id = x_invoice_id
4890: AND ail.line_number = x_invoice_line_number

Line 5221: l_amount ap_invoice_lines.amount%TYPE;

5217: AND rcv.po_match_option = 'R'
5218: ORDER BY rcv.rcv_transaction_id;
5219:
5220: l_available_match_amount NUMBER := x_match_amount;
5221: l_amount ap_invoice_lines.amount%TYPE;
5222: l_base_amount ap_invoice_lines.base_amount%TYPE;
5223: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;
5224: l_po_line_location_id po_line_locations.line_location_id%TYPE;
5225: l_po_line_id po_lines.po_line_id%TYPE;

Line 5222: l_base_amount ap_invoice_lines.base_amount%TYPE;

5218: ORDER BY rcv.rcv_transaction_id;
5219:
5220: l_available_match_amount NUMBER := x_match_amount;
5221: l_amount ap_invoice_lines.amount%TYPE;
5222: l_base_amount ap_invoice_lines.base_amount%TYPE;
5223: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;
5224: l_po_line_location_id po_line_locations.line_location_id%TYPE;
5225: l_po_line_id po_lines.po_line_id%TYPE;
5226: l_po_release_id po_releases.po_release_id%TYPE;

Line 5223: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;

5219:
5220: l_available_match_amount NUMBER := x_match_amount;
5221: l_amount ap_invoice_lines.amount%TYPE;
5222: l_base_amount ap_invoice_lines.base_amount%TYPE;
5223: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;
5224: l_po_line_location_id po_line_locations.line_location_id%TYPE;
5225: l_po_line_id po_lines.po_line_id%TYPE;
5226: l_po_release_id po_releases.po_release_id%TYPE;
5227: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;

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

5252: l_attribute12 po_line_locations.attribute12%TYPE;
5253: l_attribute13 po_line_locations.attribute13%TYPE;
5254: l_attribute14 po_line_locations.attribute14%TYPE;
5255: l_attribute15 po_line_locations.attribute15%TYPE;
5256: l_invoice_line_number ap_invoice_lines.line_number%TYPE := 1;
5257: l_index po_line_locations.line_location_id%TYPE;
5258: l_conversion_factor NUMBER;
5259: l_ordered_qty NUMBER;
5260: l_cancelled_qty NUMBER;

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

5265: l_billed_qty NUMBER;
5266: l_accepted_qty NUMBER;
5267: l_rejected_qty NUMBER;
5268: l_rect_unit_price po_lines.unit_price%TYPE;
5269: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5270: l_rounded_index po_line_locations.line_location_id%TYPE;
5271: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5272: l_available_amount po_line_locations.amount%TYPE;
5273: l_available_qty po_line_locations.quantity%TYPE;

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

5267: l_rejected_qty NUMBER;
5268: l_rect_unit_price po_lines.unit_price%TYPE;
5269: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5270: l_rounded_index po_line_locations.line_location_id%TYPE;
5271: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5272: l_available_amount po_line_locations.amount%TYPE;
5273: l_available_qty po_line_locations.quantity%TYPE;
5274: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5275: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;

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

5270: l_rounded_index po_line_locations.line_location_id%TYPE;
5271: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5272: l_available_amount po_line_locations.amount%TYPE;
5273: l_available_qty po_line_locations.quantity%TYPE;
5274: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5275: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5276: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5277: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5278: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;

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

5271: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5272: l_available_amount po_line_locations.amount%TYPE;
5273: l_available_qty po_line_locations.quantity%TYPE;
5274: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5275: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5276: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5277: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5278: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5279: l_product_type ap_invoice_lines.product_type%TYPE;

Line 5276: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;

5272: l_available_amount po_line_locations.amount%TYPE;
5273: l_available_qty po_line_locations.quantity%TYPE;
5274: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5275: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5276: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5277: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5278: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5279: l_product_type ap_invoice_lines.product_type%TYPE;
5280: l_product_category ap_invoice_lines.product_category%TYPE;

Line 5277: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;

5273: l_available_qty po_line_locations.quantity%TYPE;
5274: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5275: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5276: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5277: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5278: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5279: l_product_type ap_invoice_lines.product_type%TYPE;
5280: l_product_category ap_invoice_lines.product_category%TYPE;
5281: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;

Line 5278: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;

5274: l_invoice_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5275: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5276: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5277: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5278: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5279: l_product_type ap_invoice_lines.product_type%TYPE;
5280: l_product_category ap_invoice_lines.product_category%TYPE;
5281: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;
5282: l_amount_ordered NUMBER;

Line 5279: l_product_type ap_invoice_lines.product_type%TYPE;

5275: l_sum_line_base_amount ap_invoice_lines.base_amount%TYPE := 0;
5276: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5277: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5278: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5279: l_product_type ap_invoice_lines.product_type%TYPE;
5280: l_product_category ap_invoice_lines.product_category%TYPE;
5281: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;
5282: l_amount_ordered NUMBER;
5283: l_amount_cancelled NUMBER;

Line 5280: l_product_category ap_invoice_lines.product_category%TYPE;

5276: l_ship_to_location_id ap_invoice_lines.ship_to_location_id%TYPE;
5277: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5278: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5279: l_product_type ap_invoice_lines.product_type%TYPE;
5280: l_product_category ap_invoice_lines.product_category%TYPE;
5281: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;
5282: l_amount_ordered NUMBER;
5283: l_amount_cancelled NUMBER;
5284: l_amount_delivered NUMBER;

Line 5281: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;

5277: l_primary_intended_use ap_invoice_lines.primary_intended_use%TYPE;
5278: l_product_fisc_classification ap_invoice_lines.product_fisc_classification%TYPE;
5279: l_product_type ap_invoice_lines.product_type%TYPE;
5280: l_product_category ap_invoice_lines.product_category%TYPE;
5281: l_user_defined_fisc_class ap_invoice_lines.user_defined_fisc_class%TYPE;
5282: l_amount_ordered NUMBER;
5283: l_amount_cancelled NUMBER;
5284: l_amount_delivered NUMBER;
5285: l_amount_billed NUMBER;

Line 5289: l_retained_amount ap_invoice_lines.retained_amount%TYPE;

5285: l_amount_billed NUMBER;
5286: l_amount_received NUMBER;
5287: l_amount_corrected NUMBER;
5288: l_matching_basis po_line_locations.matching_basis%TYPE;
5289: l_retained_amount ap_invoice_lines.retained_amount%TYPE;
5290: l_ret_status VARCHAR2(100);
5291: l_msg_count NUMBER;
5292: l_msg_data VARCHAR2(250);
5293: l_debug_info VARCHAR2(2000);

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

5524: X_shipment_Table(l_index).assessable_value := g_assessable_value;
5525: X_shipment_Table(l_index).tax_classification_code := g_dflt_tax_class_code;
5526:
5527: X_Shipment_Table(l_index).matching_basis := l_matching_basis;
5528: X_Shipment_Table(l_index).retained_amount := ap_invoice_lines_utility_pkg.get_retained_amount
5529: (l_po_line_location_id, l_amount);
5530:
5531: --Get the max of the largest invoice line, to be used for assignment of
5532: --rounding due to proration.

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

5863: X_shipment_Table(l_index).tax_classification_code := g_dflt_tax_class_code;
5864: --End Bug#12414407
5865:
5866: X_Shipment_Table(l_index).matching_basis := l_matching_basis;
5867: X_Shipment_Table(l_index).retained_amount := ap_invoice_lines_utility_pkg.get_retained_amount
5868: (l_po_line_location_id, l_amount);
5869:
5870: --Get the max of the largest invoice line, to be used for assignment of
5871: --rounding due to proration.

Line 6028: INSERT INTO AP_INVOICE_LINES_ALL

6024: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6025: END IF;
6026: --End Bug#13505998
6027:
6028: INSERT INTO AP_INVOICE_LINES_ALL
6029: (INVOICE_ID,
6030: LINE_NUMBER,
6031: LINE_TYPE_LOOKUP_CODE,
6032: REQUESTER_ID,