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

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

156: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
157: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECT_MATCH_PKG.';
158:
159:
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:
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_pay_awt_group_id ap_awt_groups.group_id%TYPE; --bug 9689194

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

191: G_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
192: --G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE; - Bug 4277744
193: G_login_id number;
194: G_User_id number;
195: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
196: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
197: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
198: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
199: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;

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

192: --G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE; - Bug 4277744
193: G_login_id number;
194: G_User_id number;
195: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
196: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
197: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
198: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
199: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
200: G_Line_Project_id ap_invoice_lines.project_id%TYPE;

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

193: G_login_id number;
194: G_User_id number;
195: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
196: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
197: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
198: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
199: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
200: G_Line_Project_id ap_invoice_lines.project_id%TYPE;
201: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;

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

194: G_User_id number;
195: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
196: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
197: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
198: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
199: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
200: G_Line_Project_id ap_invoice_lines.project_id%TYPE;
201: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
202: G_Line_Award_id ap_invoice_lines.award_id%TYPE;

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

195: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
196: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
197: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
198: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
199: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
200: G_Line_Project_id ap_invoice_lines.project_id%TYPE;
201: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
202: G_Line_Award_id ap_invoice_lines.award_id%TYPE;
203: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;

Line 200: G_Line_Project_id ap_invoice_lines.project_id%TYPE;

196: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
197: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
198: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
199: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
200: G_Line_Project_id ap_invoice_lines.project_id%TYPE;
201: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
202: G_Line_Award_id ap_invoice_lines.award_id%TYPE;
203: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
204: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;

Line 201: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;

197: G_Cost_Center_Segment ap_invoice_lines.cost_center_segment%TYPE := NULL;
198: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
199: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
200: G_Line_Project_id ap_invoice_lines.project_id%TYPE;
201: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
202: G_Line_Award_id ap_invoice_lines.award_id%TYPE;
203: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
204: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
205: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;

Line 202: G_Line_Award_id ap_invoice_lines.award_id%TYPE;

198: G_Overlay_Dist_Code_Concat ap_invoice_lines.overlay_dist_code_concat%TYPE := NULL;
199: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
200: G_Line_Project_id ap_invoice_lines.project_id%TYPE;
201: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
202: G_Line_Award_id ap_invoice_lines.award_id%TYPE;
203: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
204: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
205: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
206: G_Award_Id ap_invoices.award_id%TYPE;

Line 203: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;

199: G_Default_Dist_CCid ap_invoice_lines.default_dist_ccid%TYPE := NULL;
200: G_Line_Project_id ap_invoice_lines.project_id%TYPE;
201: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
202: G_Line_Award_id ap_invoice_lines.award_id%TYPE;
203: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
204: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
205: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
206: G_Award_Id ap_invoices.award_id%TYPE;
207: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;

Line 204: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;

200: G_Line_Project_id ap_invoice_lines.project_id%TYPE;
201: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
202: G_Line_Award_id ap_invoice_lines.award_id%TYPE;
203: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
204: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
205: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
206: G_Award_Id ap_invoices.award_id%TYPE;
207: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
208: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;

Line 205: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;

201: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;
202: G_Line_Award_id ap_invoice_lines.award_id%TYPE;
203: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
204: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
205: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
206: G_Award_Id ap_invoices.award_id%TYPE;
207: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
208: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
209: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194

Line 207: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;

203: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
204: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
205: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
206: G_Award_Id ap_invoices.award_id%TYPE;
207: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
208: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
209: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
210: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
211: G_Org_Id ap_invoices.org_id%TYPE;

Line 208: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;

204: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
205: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
206: G_Award_Id ap_invoices.award_id%TYPE;
207: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
208: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
209: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
210: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
211: G_Org_Id ap_invoices.org_id%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;

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

205: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
206: G_Award_Id ap_invoices.award_id%TYPE;
207: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
208: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
209: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
210: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
211: G_Org_Id ap_invoices.org_id%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213:

Line 210: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;

206: G_Award_Id ap_invoices.award_id%TYPE;
207: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
208: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
209: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; --bug 9689194
210: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
211: G_Org_Id ap_invoices.org_id%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213:
214: --Contract Payments

Line 256: l_item_line_number ap_invoice_lines.line_number%TYPE;

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

Line 257: l_amount_to_recoup ap_invoice_lines.amount%TYPE;

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

Line 258: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

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

Line 259: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

255: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
256: l_item_line_number ap_invoice_lines.line_number%TYPE;
257: l_amount_to_recoup ap_invoice_lines.amount%TYPE;
258: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
259: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
260: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
261: l_debug_info VARCHAR2(2000);
262: current_calling_sequence VARCHAR2(2000);
263: l_Sqlerrm VARCHAR2(2000);

Line 260: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

256: l_item_line_number ap_invoice_lines.line_number%TYPE;
257: l_amount_to_recoup ap_invoice_lines.amount%TYPE;
258: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
259: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
260: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
261: l_debug_info VARCHAR2(2000);
262: current_calling_sequence VARCHAR2(2000);
263: l_Sqlerrm VARCHAR2(2000);
264: l_success BOOLEAN;

Line 316: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

312: X_Calling_Sequence => current_calling_sequence);
313:
314:
315: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
316: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
317: (p_line_location_id => x_po_line_location_id,
318: p_match_amount => x_amount);
319: END IF;
320:

Line 446: FROM ap_invoice_lines_all

442: END IF;
443:
444: SELECT AMOUNT
445: INTO l_line_amt
446: FROM ap_invoice_lines_all
447: WHERE invoice_id = x_invoice_id
448: AND line_number = x_invoice_line_number;
449:
450: l_debug_info := 'l_line_amt '||l_line_amt;

Line 458: UPDATE ap_invoice_lines_all

454: END IF;
455:
456: --End Bug#13505998
457:
458: UPDATE ap_invoice_lines_all
459: SET primary_intended_use = nvl(primary_intended_use, g_intended_use)
460: ,product_type = nvl(product_type, g_product_type)
461: ,product_category = nvl(product_category, g_product_category)
462: ,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: rcv_shipment_line_id,

Line 628: UPDATE ap_invoice_lines ail

624: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
625: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
626: END IF;
627:
628: UPDATE ap_invoice_lines ail
629: SET (generate_dists ,
630: rcv_shipment_line_id,
631: attribute_category,
632: attribute1,

Line 676: FROM ap_invoice_lines ail1,

672: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
673: --end Bug 7483260
674: l_retained_amount,
675: -1 * l_retained_amount
676: FROM ap_invoice_lines ail1,
677: po_line_locations pll,
678: rcv_transactions rcv
679: WHERE ail1.invoice_id = x_invoice_id
680: AND ail1.line_number =x_invoice_line_number

Line 966: FROM ap_invoice_lines ail

962: g_line_expenditure_org_id,
963: g_line_awt_group_id,
964: g_line_accounting_date,
965: g_line_pay_awt_group_id --bug 9689194
966: FROM ap_invoice_lines ail
967: WHERE ail.invoice_id = x_invoice_id
968: AND ail.line_number = x_invoice_line_number;
969:
970: END IF;

Line 974: FROM ap_invoice_lines ail

970: END IF;
971:
972: SELECT nvl(max(ail.line_number),0)
973: INTO g_max_invoice_line_number
974: FROM ap_invoice_lines ail
975: WHERE ail.invoice_id = x_invoice_id;
976:
977:
978: IF (x_po_line_location_id is not null) THEN

Line 1941: INSERT INTO AP_INVOICE_LINES

1937: from ap_invoices_all ai
1938: where ai.invoice_id = X_Invoice_Id;
1939: -- Bug 9160534. End
1940:
1941: INSERT INTO AP_INVOICE_LINES
1942: (INVOICE_ID,
1943: LINE_NUMBER,
1944: LINE_TYPE_LOOKUP_CODE,
1945: REQUESTER_ID,

Line 2346: INSERT INTO AP_INVOICE_LINES

2342: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2343: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2344: END IF;
2345:
2346: INSERT INTO AP_INVOICE_LINES
2347: (INVOICE_ID,
2348: LINE_NUMBER,
2349: LINE_TYPE_LOOKUP_CODE,
2350: REQUESTER_ID,

Line 2662: FROM AP_INVOICE_LINES AIL

2658: DECODE(X_Amount,l_full_mtch_amt,X_Amount, NULL),
2659: G_dflt_tax_class_code,
2660: X_COST_FACTOR_ID, --cost_factor_id
2661: AIL.PAY_AWT_GROUP_ID --bug 9689194
2662: FROM AP_INVOICE_LINES AIL
2663: WHERE AIL.INVOICE_ID = X_INVOICE_ID
2664: AND AIL.LINE_NUMBER = X_ITEM_LINE_NUMBER;
2665:
2666: END IF;

Line 3071: ap_invoice_lines ail,

3067: 'N', --cash_posted_flag
3068: 'N', --rcv_charge_addition_flag
3069: x_dist_tab(i).pay_awt_group_id --pay_awt_group_id bug9689194
3070: FROM po_distributions pd,--bug6683010
3071: ap_invoice_lines ail,
3072: po_ap_receipt_match_v rcv,
3073: gl_code_combinations gcc
3074: WHERE ail.invoice_id = x_invoice_id
3075: AND ail.line_number = x_invoice_line_number

Line 3491: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

3487: X_Retained_Amount IN NUMBER DEFAULT NULL,
3488: X_Calling_Sequence IN VARCHAR2) IS
3489:
3490: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3491: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3492: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3493: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3494: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3495: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 3492: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;

3488: X_Calling_Sequence IN VARCHAR2) IS
3489:
3490: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3491: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3492: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3493: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3494: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3495: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3496: l_success BOOLEAN;

Line 3493: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

3489:
3490: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3491: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3492: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3493: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3494: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3495: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3496: l_success BOOLEAN;
3497: l_error_message VARCHAR2(4000);

Line 3494: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

3490: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3491: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3492: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3493: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3494: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3495: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3496: l_success BOOLEAN;
3497: l_error_message VARCHAR2(4000);
3498: l_debug_info VARCHAR2(2000);

Line 3495: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

3491: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3492: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3493: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3494: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3495: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3496: l_success BOOLEAN;
3497: l_error_message VARCHAR2(4000);
3498: l_debug_info VARCHAR2(2000);
3499: current_calling_sequence VARCHAR2(2000);

Line 3515: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

3511: x_po_line_location_id => x_po_line_location_id,
3512: x_calling_sequence => current_calling_sequence);
3513:
3514: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
3515: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
3516: (p_line_location_id => x_po_line_location_id,
3517: p_match_amount => x_correction_amount);
3518: END IF;
3519:

Line 3568: UPDATE ap_invoice_lines ail

3564:
3565:
3566: IF(x_invoice_line_number IS NOT NULL) THEN
3567:
3568: UPDATE ap_invoice_lines ail
3569: SET (generate_dists ,
3570: attribute_category,
3571: attribute1,
3572: attribute2,

Line 3614: FROM ap_invoice_lines ail1,

3610: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
3611: --end Bug 7483260
3612: l_retained_amount,
3613: -1 * l_retained_amount
3614: FROM ap_invoice_lines ail1,
3615: po_line_locations pll
3616: WHERE ail1.invoice_id = x_invoice_id
3617: AND ail1.line_number =x_invoice_line_number
3618: AND pll.line_location_id = ail1.po_line_location_id)

Line 3771: FROM ap_invoice_lines ail,

3767: 'Y', pd.code_combination_id,
3768: aid1.dist_code_combination_id),
3769: pd.variance_account_id),
3770: ap_invoice_distributions_s.nextval
3771: FROM ap_invoice_lines ail,
3772: ap_invoice_distributions aid1,
3773: po_distributions pd,
3774: ap_invoice_distributions aid2
3775: WHERE ail.invoice_id = x_corrected_invoice_id

Line 3816: ap_invoice_lines ail,

3812: p_total_quantity_billed , 15) corrected_quantity,
3813: aid.dist_code_combination_id,
3814: ap_invoice_distributions_s.nextval
3815: FROM ap_invoice_distributions aid,
3816: ap_invoice_lines ail,
3817: po_distributions pd
3818: WHERE ail.invoice_id = x_corrected_invoice_id
3819: AND ail.line_number = x_corrected_line_number
3820: AND aid.invoice_id = ail.invoice_id

Line 4226: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,

4222: BEGIN
4223:
4224: current_calling_sequence := 'Insert_Corr_Invoice_Line<-'||x_calling_sequence;
4225:
4226: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,
4227: LINE_NUMBER,
4228: LINE_TYPE_LOOKUP_CODE,
4229: REQUESTER_ID,
4230: DESCRIPTION,

Line 4544: ap_invoice_lines ail,

4540: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
4541: G_PAY_AWT_GROUP_ID, --bug 9689194
4542: AIL.RCV_SHIPMENT_LINE_ID /*BUG :15946088*/
4543: FROM ap_invoices ai,
4544: ap_invoice_lines ail,
4545: po_line_locations_ap_v pll
4546: WHERE ai.invoice_id = x_corrected_invoice_id
4547: AND ail.invoice_id = ai.invoice_id
4548: AND ail.line_number = x_corrected_line_number

Line 4927: FROM ap_invoice_lines ail,

4923: 'N', --rcv_charge_addition_flag
4924: decode(g_system_allow_awt_flag,'Y',
4925: decode(g_site_allow_awt_flag,'Y',ail.pay_awt_group_id,NULL),
4926: NULL) --pay_awt_group_id Bug9689194
4927: FROM ap_invoice_lines ail,
4928: ap_invoice_distributions aid,
4929: po_distributions pd
4930: WHERE ail.invoice_id = x_invoice_id
4931: AND ail.line_number = x_invoice_line_number