[Home] [Help]
321: C_overbilled VARCHAR2(1);
322: C_Quantity NUMBER;
323: C_Transfer_desc_flex_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
324: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
325: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;
326: C_Price NUMBER;
327: C_Description ap_lookup_codes.description%TYPE;
328: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
329: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
326: C_Price NUMBER;
327: C_Description ap_lookup_codes.description%TYPE;
328: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
329: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
330: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
331: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
332: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
333: C_retained_amount Number; /*bug 5228301 */
334: C_match_type AP_INVOICE_LINES_ALL.Match_Type%TYPE;
330: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
331: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
332: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
333: C_retained_amount Number; /*bug 5228301 */
334: C_match_type AP_INVOICE_LINES_ALL.Match_Type%TYPE;
335: C_sched_holds_count NUMBER; --bug 5452979
336:
337: -- eTax Uptake
338: l_inv_hdr_amount NUMBER;
1996: current_calling_sequence VARCHAR2(2000);
1997: debug_info VARCHAR2(100);
1998: l_User_Id number;
1999: l_Login_Id number;
2000: l_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
2001:
2002: BEGIN
2003:
2004: current_calling_sequence := 'Insert_Invoice_Line<-'||P_calling_sequence;