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

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

142: X_Calling_Sequence IN VARCHAR2);
143:
144:
145: --Global Variable Declaration
146: G_Max_Invoice_Line_Number ap_invoice_lines.line_number%TYPE := 0;
147: G_Batch_id ap_batches.batch_id%TYPE;
148: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
149: G_Period_Name gl_period_statuses.period_name%TYPE;
150: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;

Line 148: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;

144:
145: --Global Variable Declaration
146: G_Max_Invoice_Line_Number ap_invoice_lines.line_number%TYPE := 0;
147: G_Batch_id ap_batches.batch_id%TYPE;
148: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
149: G_Period_Name gl_period_statuses.period_name%TYPE;
150: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
151: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
152: G_Pay_Awt_Group_ID ap_awt_groups.group_id%TYPE; --bug 9689194

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

181: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
182: G_match_option po_line_locations.match_option%TYPE;
183: G_User_Id number;
184: G_Login_Id number;
185: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
186: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
187: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
188: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
189: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;

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

182: G_match_option po_line_locations.match_option%TYPE;
183: G_User_Id number;
184: G_Login_Id number;
185: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
186: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
187: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
188: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
189: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
190: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;

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

183: G_User_Id number;
184: G_Login_Id number;
185: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
186: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
187: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
188: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
189: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
190: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
191: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;

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

184: G_Login_Id number;
185: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
186: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
187: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
188: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
189: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
190: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
191: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
192: G_Line_Award_Id ap_invoice_lines.award_id%TYPE;

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

185: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
186: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
187: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
188: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
189: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
190: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
191: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
192: G_Line_Award_Id ap_invoice_lines.award_id%TYPE;
193: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;

Line 190: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;

186: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
187: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
188: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
189: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
190: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
191: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
192: G_Line_Award_Id ap_invoice_lines.award_id%TYPE;
193: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
194: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;

Line 191: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;

187: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
188: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
189: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
190: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
191: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
192: G_Line_Award_Id ap_invoice_lines.award_id%TYPE;
193: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
194: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
195: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;

Line 192: G_Line_Award_Id ap_invoice_lines.award_id%TYPE;

188: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
189: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
190: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
191: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
192: G_Line_Award_Id ap_invoice_lines.award_id%TYPE;
193: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
194: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
195: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
196: G_Award_Id ap_invoices.award_id%TYPE;

Line 193: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;

189: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
190: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
191: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
192: G_Line_Award_Id ap_invoice_lines.award_id%TYPE;
193: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
194: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
195: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
196: G_Award_Id ap_invoices.award_id%TYPE;
197: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;

Line 194: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;

190: G_Line_Project_Id ap_invoice_lines.project_id%TYPE ;
191: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
192: G_Line_Award_Id ap_invoice_lines.award_id%TYPE;
193: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
194: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
195: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
196: G_Award_Id ap_invoices.award_id%TYPE;
197: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
198: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;

Line 195: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;

191: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
192: G_Line_Award_Id ap_invoice_lines.award_id%TYPE;
193: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
194: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
195: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
196: G_Award_Id ap_invoices.award_id%TYPE;
197: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
198: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
199: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194

Line 197: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;

193: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
194: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
195: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
196: G_Award_Id ap_invoices.award_id%TYPE;
197: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
198: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
199: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
200: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
201: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;

Line 198: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;

194: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
195: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
196: G_Award_Id ap_invoices.award_id%TYPE;
197: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
198: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
199: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
200: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
201: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
202: --Contract Payments

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

195: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
196: G_Award_Id ap_invoices.award_id%TYPE;
197: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
198: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
199: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
200: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
201: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
202: --Contract Payments
203: G_Vendor_Id ap_invoices.vendor_id%TYPE;

Line 200: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;

196: G_Award_Id ap_invoices.award_id%TYPE;
197: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
198: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
199: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
200: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
201: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
202: --Contract Payments
203: G_Vendor_Id ap_invoices.vendor_id%TYPE;
204: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;

Line 242: l_item_line_number ap_invoice_lines.line_number%TYPE;

238: IS
239: l_single_dist_flag varchar2(1) := 'N';
240: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
241: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
242: l_item_line_number ap_invoice_lines.line_number%TYPE;
243: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
244: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
245: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
246: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 243: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

239: l_single_dist_flag varchar2(1) := 'N';
240: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
241: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
242: l_item_line_number ap_invoice_lines.line_number%TYPE;
243: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
244: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
245: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
246: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
247: l_debug_info varchar2(2000);

Line 244: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

240: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
241: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
242: l_item_line_number ap_invoice_lines.line_number%TYPE;
243: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
244: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
245: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
246: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
247: l_debug_info varchar2(2000);
248: l_success boolean;

Line 245: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

241: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
242: l_item_line_number ap_invoice_lines.line_number%TYPE;
243: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
244: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
245: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
246: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
247: l_debug_info varchar2(2000);
248: l_success boolean;
249: l_error_message varchar2(4000);

Line 246: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

242: l_item_line_number ap_invoice_lines.line_number%TYPE;
243: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
244: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
245: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
246: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
247: l_debug_info varchar2(2000);
248: l_success boolean;
249: l_error_message varchar2(4000);
250: current_calling_sequence varchar2(2000);

Line 293: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

289: X_Po_Line_Location_id => x_po_line_location_id,
290: X_Calling_Sequence => current_calling_sequence);
291:
292: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
293: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
294: (p_line_location_id => x_po_line_location_id,
295: p_match_amount => x_amount);
296: END IF;
297:

Line 410: FROM ap_invoice_lines_all

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

Line 421: UPDATE ap_invoice_lines_all

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

Line 501: UPDATE ap_invoice_lines ail

497: l_debug_info := 'If the line is matched down to 1 po distribution then need to
498: update the line with po_distribution_id, award_id,requester_id,
499: ,projects related information and generate_dists';
500:
501: UPDATE ap_invoice_lines ail
502: SET (generate_dists ,
503: requester_id ,
504: po_distribution_id ,
505: rcv_shipment_line_id, -- bug 5443250

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: rcv_shipment_line_id, -- bug 5443250
586: attribute_category,
587: attribute1,

Line 631: FROM ap_invoice_lines ail1,

627: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
628: --end Bug 7483260
629: l_retained_amount,
630: -1 * l_retained_amount
631: FROM ap_invoice_lines ail1,
632: po_line_locations pll,
633: rcv_transactions rtxn -- bug 5443250
634: WHERE ail1.invoice_id = x_invoice_id
635: AND ail1.line_number =x_invoice_line_number

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

763: X_Calling_Sequence IN VARCHAR2 )
764: IS
765: current_calling_sequence VARCHAR2(2000);
766: l_debug_info VARCHAR2(2000);
767: l_accounting_date ap_invoice_lines.accounting_date%TYPE; --Bug16216470
768:
769: BEGIN
770:
771: current_calling_sequence := 'Get_Info<-'||X_Calling_Sequence;

Line 897: FROM ap_invoice_lines ail

893: g_line_expenditure_org_id,
894: g_line_awt_group_id,
895: g_line_accounting_date,
896: g_line_pay_awt_group_id --bug 9689194
897: FROM ap_invoice_lines ail
898: WHERE ail.invoice_id = x_invoice_id
899: AND ail.line_number = x_invoice_line_number;
900:
901: END IF;

Line 905: FROM ap_invoice_lines ail

901: END IF;
902:
903: SELECT nvl(max(ail.line_number),0)
904: INTO g_max_invoice_line_number
905: FROM ap_invoice_lines ail
906: WHERE ail.invoice_id = x_invoice_id;
907:
908:
909:

Line 1944: INSERT INTO AP_INVOICE_LINES (

1940: --Modified below insert for bug #7015553 to insert project and task
1941: --values from receipt. If those are not existed on receipt then takes
1942: --from PO.
1943:
1944: INSERT INTO AP_INVOICE_LINES (
1945: INVOICE_ID,
1946: LINE_NUMBER,
1947: LINE_TYPE_LOOKUP_CODE,
1948: REQUESTER_ID,

Line 2297: INSERT INTO AP_INVOICE_LINES (

2293: ELSIF (x_line_type_lookup_code IN ('FREIGHT','MISCELLANEOUS')) THEN
2294:
2295: l_debug_info := 'Inserting Charge Line';
2296:
2297: INSERT INTO AP_INVOICE_LINES (
2298: INVOICE_ID,
2299: LINE_NUMBER,
2300: LINE_TYPE_LOOKUP_CODE,
2301: REQUESTER_ID,

Line 2571: FROM AP_INVOICE_LINES AIL

2567: DECODE(X_Amount,l_full_mtch_amt,X_Amount, NULL),
2568: G_dflt_tax_class_code,
2569: X_COST_FACTOR_ID, --cost_factor_id
2570: AIL.pay_awt_group_id --bug 9689194
2571: FROM AP_INVOICE_LINES AIL
2572: WHERE AIL.INVOICE_ID = X_INVOICE_ID
2573: AND AIL.LINE_NUMBER = X_ITEM_LINE_NUMBER;
2574:
2575: END IF;

Line 2972: ap_invoice_lines ail,

2968: ,'N' --cash_posted_flag
2969: ,'N' --rcv_charge_addition_flag
2970: ,x_dist_tab(i).pay_awt_group_id --pay_awt_group_id --bug 9689194
2971: FROM po_distributions_ap_v pd,
2972: ap_invoice_lines ail,
2973: po_ap_receipt_match_v rcv,
2974: gl_code_combinations gcc
2975: WHERE ail.invoice_id = x_invoice_id
2976: AND ail.line_number = x_invoice_line_number

Line 3152: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

3148: X_Retained_Amount IN NUMBER DEFAULT NULL,
3149: X_Calling_Sequence IN VARCHAR2) IS
3150:
3151: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3152: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3153: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3154: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3155: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3156: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 3153: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;

3149: X_Calling_Sequence IN VARCHAR2) IS
3150:
3151: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3152: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3153: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3154: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3155: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3156: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3157: l_success BOOLEAN;

Line 3154: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

3150:
3151: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3152: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3153: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3154: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3155: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3156: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3157: l_success BOOLEAN;
3158: l_error_message VARCHAR2(4000);

Line 3155: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

3151: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3152: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3153: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3154: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3155: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3156: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3157: l_success BOOLEAN;
3158: l_error_message VARCHAR2(4000);
3159: l_debug_info VARCHAR2(2000);

Line 3156: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

3152: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3153: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3154: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3155: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3156: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3157: l_success BOOLEAN;
3158: l_error_message VARCHAR2(4000);
3159: l_debug_info VARCHAR2(2000);
3160: current_calling_sequence VARCHAR2(2000);

Line 3176: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

3172: x_po_line_location_id => x_po_line_location_id,
3173: x_calling_sequence => current_calling_sequence);
3174:
3175: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
3176: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
3177: (p_line_location_id => x_po_line_location_id,
3178: p_match_amount => x_correction_amount);
3179: END IF;
3180:

Line 3221: UPDATE ap_invoice_lines ail

3217:
3218:
3219: IF(x_invoice_line_number IS NOT NULL) THEN
3220:
3221: UPDATE ap_invoice_lines ail
3222: SET (generate_dists ,
3223: attribute_category,
3224: attribute1,
3225: attribute2,

Line 3267: FROM ap_invoice_lines ail1,

3263: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
3264: --end Bug 7483260
3265: l_retained_amount,
3266: -1 * l_retained_amount
3267: FROM ap_invoice_lines ail1,
3268: po_line_locations pll
3269: WHERE ail1.invoice_id = x_invoice_id
3270: AND ail1.line_number =x_invoice_line_number
3271: AND pll.line_location_id = ail1.po_line_location_id)

Line 3386: FROM ap_invoice_lines ail,

3382: /g_min_acct_unit) * g_min_acct_unit
3383: ) amount,
3384: aid.dist_code_combination_id,
3385: ap_invoice_distributions_s.nextval
3386: FROM ap_invoice_lines ail,
3387: ap_invoice_distributions aid
3388: WHERE ail.invoice_id = x_corrected_invoice_id
3389: AND ail.line_number = x_corrected_line_number
3390: AND aid.invoice_id = ail.invoice_id

Line 3663: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,

3659: BEGIN
3660:
3661: current_calling_sequence := 'Insert_Corr_Invoice_Line<-'||x_calling_sequence;
3662:
3663: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,
3664: LINE_NUMBER,
3665: LINE_TYPE_LOOKUP_CODE,
3666: REQUESTER_ID,
3667: DESCRIPTION,

Line 3979: ap_invoice_lines ail,

3975: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
3976: g_pay_awt_group_id, --pay_awt_group_id bug 9689194
3977: AIL.RCV_SHIPMENT_LINE_ID --rcv_shipment_line_id /*Bug :15946088*/
3978: FROM ap_invoices ai,
3979: ap_invoice_lines ail,
3980: po_line_locations_ap_v pll
3981: WHERE ai.invoice_id = x_corrected_invoice_id
3982: AND ail.invoice_id = ai.invoice_id
3983: AND ail.line_number = x_corrected_line_number

Line 4357: FROM ap_invoice_lines ail,

4353: decode(g_system_allow_awt_flag,'Y',
4354: decode(g_site_allow_awt_flag,'Y',
4355: ail.pay_awt_group_id,NULL),
4356: NULL) --pay_awt_group_id bug 9689194
4357: FROM ap_invoice_lines ail,
4358: ap_invoice_distributions aid,
4359: po_distributions pd
4360: WHERE ail.invoice_id = x_invoice_id
4361: AND ail.line_number = x_invoice_line_number