[Home] [Help]
156: Select ap_invoices_interface_s.nextval
157: Into inv_interface_id
158: From dual;
159:
160: SELECT ap_invoice_lines_interface_s.NEXTVAL
161: INTO inv_line_interface_id
162: FROM DUAL;
163:
164: Select currency_code
467: SELECT ap_invoices_interface_s.NEXTVAL
468: INTO inv_interface_id
469: FROM dual;
470:
471: SELECT ap_invoice_lines_interface_s.NEXTVAL
472: INTO inv_line_interface_id
473: FROM DUAL;
474:
475: SELECT currency_code
717: FETCH counter_cur
718: INTO counter_cur_rec;
719: CLOSE counter_cur;
720:
721: SELECT ap_invoice_lines_interface_s.NEXTVAL
722: INTO inv_line_interface_id
723: FROM dual;
724:
725: lv_tax_account_code := jai_boe_general_pkg.get_boe_accounting(get_tax_amount_rec.tax_type,
770: open counter_cur(inv_interface_id);
771: fetch counter_cur into counter_cur_rec;
772: close counter_cur;
773:
774: SELECT ap_invoice_lines_interface_s.NEXTVAL
775: INTO inv_line_interface_id
776: FROM DUAL;
777:
778: insert into ap_invoice_lines_interface
1181: p_po_unit_of_measure IN ap_invoice_lines_interface.PO_UNIT_OF_MEASURE%TYPE DEFAULT NULL,
1182: p_inventory_item_id IN ap_invoice_lines_interface.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
1183: p_item_description IN ap_invoice_lines_interface.ITEM_DESCRIPTION%TYPE DEFAULT NULL,
1184: p_quantity_invoiced IN ap_invoice_lines_interface.QUANTITY_INVOICED%TYPE DEFAULT NULL,
1185: p_ship_to_location_code IN ap_invoice_lines_interface.SHIP_TO_LOCATION_CODE%TYPE DEFAULT NULL,
1186: p_unit_price IN ap_invoice_lines_interface.UNIT_PRICE%TYPE DEFAULT NULL,
1187: p_distribution_set_id IN ap_invoice_lines_interface.DISTRIBUTION_SET_ID%TYPE DEFAULT NULL,
1188: p_distribution_set_name IN ap_invoice_lines_interface.DISTRIBUTION_SET_NAME%TYPE DEFAULT NULL,
1189: p_dist_code_concatenated IN ap_invoice_lines_interface.DIST_CODE_CONCATENATED%TYPE DEFAULT NULL,
1225: p_project_accounting_context IN ap_invoice_lines_interface.PROJECT_ACCOUNTING_CONTEXT%TYPE DEFAULT NULL,
1226: p_pa_addition_flag IN ap_invoice_lines_interface.PA_ADDITION_FLAG%TYPE DEFAULT NULL,
1227: p_pa_quantity IN ap_invoice_lines_interface.PA_QUANTITY%TYPE DEFAULT NULL,
1228: p_ussgl_transaction_code IN ap_invoice_lines_interface.USSGL_TRANSACTION_CODE%TYPE DEFAULT NULL,
1229: p_stat_amount IN ap_invoice_lines_interface.STAT_AMOUNT%TYPE DEFAULT NULL,
1230: p_type_1099 IN ap_invoice_lines_interface.TYPE_1099%TYPE DEFAULT NULL,
1231: p_income_tax_region IN ap_invoice_lines_interface.INCOME_TAX_REGION%TYPE DEFAULT NULL,
1232: p_assets_tracking_flag IN ap_invoice_lines_interface.ASSETS_TRACKING_FLAG%TYPE DEFAULT NULL,
1233: p_price_correction_flag IN ap_invoice_lines_interface.PRICE_CORRECTION_FLAG%TYPE DEFAULT NULL,
1360: PRICE_CORRECT_INV_NUM,
1361: EXTERNAL_DOC_LINE_REF*/)--commented by Sanjikum for Bug#4183001
1362: VALUES(
1363: p_invoice_id,
1364: ap_invoice_lines_interface_s.NEXTVAL,
1365: p_line_number,
1366: p_line_type_lookup_code,
1367: p_line_group_number,
1368: p_amount,