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_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;

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

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

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

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

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

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

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

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

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

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

Line 199: G_Line_Project_id ap_invoice_lines.project_id%TYPE;

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

Line 200: G_Line_Task_Id ap_invoice_lines.task_id%TYPE ;

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

Line 201: G_Line_Award_id ap_invoice_lines.award_id%TYPE;

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

Line 202: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;

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

Line 203: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;

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

Line 204: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;

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

Line 206: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;

202: G_Line_Expenditure_Type ap_invoice_lines.expenditure_type%TYPE ;
203: G_Line_Expenditure_Item_Date ap_invoice_lines.expenditure_item_date%TYPE ;
204: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
205: G_Award_Id ap_invoices.award_id%TYPE;
206: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
207: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
208: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
209: G_Org_Id ap_invoices.org_id%TYPE;
210: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;

Line 207: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;

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

Line 208: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;

204: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
205: G_Award_Id ap_invoices.award_id%TYPE;
206: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
207: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
208: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
209: G_Org_Id ap_invoices.org_id%TYPE;
210: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
211:
212: --Contract Payments

Line 254: l_item_line_number ap_invoice_lines.line_number%TYPE;

250: l_single_dist_flag VARCHAR2(1) := 'N';
251: l_first NUMBER;
252: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
253: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
254: l_item_line_number ap_invoice_lines.line_number%TYPE;
255: l_amount_to_recoup ap_invoice_lines.amount%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_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 255: l_amount_to_recoup ap_invoice_lines.amount%TYPE;

251: l_first NUMBER;
252: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
253: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
254: l_item_line_number ap_invoice_lines.line_number%TYPE;
255: l_amount_to_recoup ap_invoice_lines.amount%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_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
259: l_debug_info VARCHAR2(2000);

Line 256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

252: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
253: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
254: l_item_line_number ap_invoice_lines.line_number%TYPE;
255: l_amount_to_recoup ap_invoice_lines.amount%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_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
259: l_debug_info VARCHAR2(2000);
260: current_calling_sequence VARCHAR2(2000);

Line 257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

253: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
254: l_item_line_number ap_invoice_lines.line_number%TYPE;
255: l_amount_to_recoup ap_invoice_lines.amount%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_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
259: l_debug_info VARCHAR2(2000);
260: current_calling_sequence VARCHAR2(2000);
261: l_Sqlerrm VARCHAR2(2000);

Line 258: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

254: l_item_line_number ap_invoice_lines.line_number%TYPE;
255: l_amount_to_recoup ap_invoice_lines.amount%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_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
259: l_debug_info VARCHAR2(2000);
260: current_calling_sequence VARCHAR2(2000);
261: l_Sqlerrm VARCHAR2(2000);
262: l_success BOOLEAN;

Line 304: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

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

Line 371: UPDATE ap_invoice_lines_all

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

Line 454: UPDATE ap_invoice_lines ail

450: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
452: END IF;
453:
454: UPDATE ap_invoice_lines ail
455: SET (generate_dists ,
456: requester_id ,
457: po_distribution_id ,
458: rcv_shipment_line_id,

Line 539: UPDATE ap_invoice_lines ail

535: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
536: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
537: END IF;
538:
539: UPDATE ap_invoice_lines ail
540: SET (generate_dists ,
541: rcv_shipment_line_id,
542: attribute_category,
543: attribute1,

Line 587: FROM ap_invoice_lines ail1,

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

Line 873: FROM ap_invoice_lines ail

869: g_line_expenditure_item_date,
870: g_line_expenditure_org_id,
871: g_line_awt_group_id,
872: g_line_accounting_date
873: FROM ap_invoice_lines ail
874: WHERE ail.invoice_id = x_invoice_id
875: AND ail.line_number = x_invoice_line_number;
876:
877: END IF;

Line 881: FROM ap_invoice_lines ail

877: END IF;
878:
879: SELECT nvl(max(ail.line_number),0)
880: INTO g_max_invoice_line_number
881: FROM ap_invoice_lines ail
882: WHERE ail.invoice_id = x_invoice_id;
883:
884:
885: IF (x_po_line_location_id is not null) THEN

Line 1780: INSERT INTO AP_INVOICE_LINES

1776: --values from receipt. If those are not existed on receipt then takes
1777: --from PO.
1778:
1779:
1780: INSERT INTO AP_INVOICE_LINES
1781: (INVOICE_ID,
1782: LINE_NUMBER,
1783: LINE_TYPE_LOOKUP_CODE,
1784: REQUESTER_ID,

Line 2172: INSERT INTO AP_INVOICE_LINES

2168: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2169: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2170: END IF;
2171:
2172: INSERT INTO AP_INVOICE_LINES
2173: (INVOICE_ID,
2174: LINE_NUMBER,
2175: LINE_TYPE_LOOKUP_CODE,
2176: REQUESTER_ID,

Line 2484: FROM AP_INVOICE_LINES AIL

2480: G_USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
2481: G_ASSESSABLE_VALUE,
2482: G_dflt_tax_class_code,
2483: X_COST_FACTOR_ID --cost_factor_id
2484: FROM AP_INVOICE_LINES AIL
2485: WHERE AIL.INVOICE_ID = X_INVOICE_ID
2486: AND AIL.LINE_NUMBER = X_ITEM_LINE_NUMBER;
2487:
2488: END IF;

Line 2863: ap_invoice_lines ail,

2859: 'N', --accrual_posted_flag
2860: 'N', --cash_posted_flag
2861: 'N' --rcv_charge_addition_flag
2862: FROM po_distributions pd,--bug6683010
2863: ap_invoice_lines ail,
2864: po_ap_receipt_match_v rcv,
2865: gl_code_combinations gcc
2866: WHERE ail.invoice_id = x_invoice_id
2867: AND ail.line_number = x_invoice_line_number

Line 3282: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

3278: X_Retained_Amount IN NUMBER DEFAULT NULL,
3279: X_Calling_Sequence IN VARCHAR2) IS
3280:
3281: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3282: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3283: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3284: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3285: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3286: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

Line 3283: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;

3279: X_Calling_Sequence IN VARCHAR2) IS
3280:
3281: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3282: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3283: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3284: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3285: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3286: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3287: l_success BOOLEAN;

Line 3284: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

3280:
3281: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3282: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3283: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3284: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3285: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3286: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3287: l_success BOOLEAN;
3288: l_error_message VARCHAR2(4000);

Line 3285: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

3281: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3282: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3283: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3284: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3285: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3286: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3287: l_success BOOLEAN;
3288: l_error_message VARCHAR2(4000);
3289: l_debug_info VARCHAR2(2000);

Line 3286: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;

3282: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3283: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3284: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3285: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
3286: l_retained_amount ap_invoice_lines_all.retained_amount%TYPE;
3287: l_success BOOLEAN;
3288: l_error_message VARCHAR2(4000);
3289: l_debug_info VARCHAR2(2000);
3290: current_calling_sequence VARCHAR2(2000);

Line 3306: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

3302: x_po_line_location_id => x_po_line_location_id,
3303: x_calling_sequence => current_calling_sequence);
3304:
3305: IF g_invoice_type_lookup_code <> 'PREPAYMENT' THEN
3306: l_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
3307: (p_line_location_id => x_po_line_location_id,
3308: p_match_amount => x_correction_amount);
3309: END IF;
3310:

Line 3359: UPDATE ap_invoice_lines ail

3355:
3356:
3357: IF(x_invoice_line_number IS NOT NULL) THEN
3358:
3359: UPDATE ap_invoice_lines ail
3360: SET (generate_dists ,
3361: attribute_category,
3362: attribute1,
3363: attribute2,

Line 3405: FROM ap_invoice_lines ail1,

3401: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
3402: --end Bug 7483260
3403: l_retained_amount,
3404: -1 * l_retained_amount
3405: FROM ap_invoice_lines ail1,
3406: po_line_locations pll
3407: WHERE ail1.invoice_id = x_invoice_id
3408: AND ail1.line_number =x_invoice_line_number
3409: AND pll.line_location_id = ail1.po_line_location_id)

Line 3561: FROM ap_invoice_lines ail,

3557: 'Y', pd.code_combination_id,
3558: aid.dist_code_combination_id),
3559: pd.variance_account_id),
3560: ap_invoice_distributions_s.nextval
3561: FROM ap_invoice_lines ail,
3562: ap_invoice_distributions aid,
3563: po_distributions pd
3564: WHERE ail.invoice_id = x_corrected_invoice_id
3565: AND ail.line_number = x_corrected_line_number

Line 3603: ap_invoice_lines ail,

3599: p_total_quantity_billed , 15) corrected_quantity,
3600: aid.dist_code_combination_id,
3601: ap_invoice_distributions_s.nextval
3602: FROM ap_invoice_distributions aid,
3603: ap_invoice_lines ail,
3604: po_distributions pd
3605: WHERE ail.invoice_id = x_corrected_invoice_id
3606: AND ail.line_number = x_corrected_line_number
3607: AND aid.invoice_id = ail.invoice_id

Line 4007: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,

4003: BEGIN
4004:
4005: current_calling_sequence := 'Insert_Corr_Invoice_Line<-'||x_calling_sequence;
4006:
4007: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,
4008: LINE_NUMBER,
4009: LINE_TYPE_LOOKUP_CODE,
4010: REQUESTER_ID,
4011: DESCRIPTION,

Line 4321: ap_invoice_lines ail,

4317: AIL.PRODUCT_TYPE, --product_type
4318: AIL.PRODUCT_CATEGORY, --product_category
4319: AIL.USER_DEFINED_FISC_CLASS --user_defined_fisc_class
4320: FROM ap_invoices ai,
4321: ap_invoice_lines ail,
4322: po_line_locations_ap_v pll
4323: WHERE ai.invoice_id = x_corrected_invoice_id
4324: AND ail.invoice_id = ai.invoice_id
4325: AND ail.line_number = x_corrected_line_number

Line 4700: FROM ap_invoice_lines ail,

4696: aid.intended_use, --intended_use
4697: 'N', --accrual_posted_flag
4698: 'N', --cash_posted_flag
4699: 'N' --rcv_charge_addition_flag
4700: FROM ap_invoice_lines ail,
4701: ap_invoice_distributions aid,
4702: po_distributions pd
4703: WHERE ail.invoice_id = x_invoice_id
4704: AND ail.line_number = x_invoice_line_number