[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE INSERT_ROWS (
p_trx_header_tbl IN AR_INVOICE_API_PUB.trx_header_tbl_type,
p_trx_lines_tbl IN AR_INVOICE_API_PUB.trx_line_tbl_type,
p_trx_dist_tbl IN AR_INVOICE_API_PUB.trx_dist_tbl_type,
p_trx_salescredits_tbl IN AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
x_errmsg OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2
) IS
RecExist Number;
ar_invoice_utils.debug ('AR_TRX_GLOBAL_PROCESS_TMP.INSERT_ROWS(+)');
INSERT INTO ar_trx_header_tmp_gt (
TRX_HEADER_ID,
TRX_NUMBER,
TRX_DATE,
TRX_CURRENCY,
REFERENCE_NUMBER,
TRX_CLASS,
CUST_TRX_TYPE_ID,
GL_DATE,
BILL_TO_CUSTOMER_ID,
BILL_TO_ACCOUNT_NUMBER,
BILL_TO_CUSTOMER_NAME,
BILL_TO_CONTACT_ID,
BILL_TO_ADDRESS_ID,
BILL_TO_SITE_USE_ID,
SHIP_TO_CUSTOMER_ID,
SHIP_TO_ACCOUNT_NUMBER,
SHIP_TO_CUSTOMER_NAME,
SHIP_TO_CONTACT_ID,
SHIP_TO_ADDRESS_ID,
SHIP_TO_SITE_USE_ID,
SOLD_TO_CUSTOMER_ID,
TERM_ID,
PRIMARY_SALESREP_ID,
PRIMARY_SALESREP_NAME,
EXCHANGE_RATE_TYPE,
EXCHANGE_DATE,
EXCHANGE_RATE,
TERRITORY_ID,
REMIT_TO_ADDRESS_ID,
INVOICING_RULE_ID,
PRINTING_OPTION,
PURCHASE_ORDER,
PURCHASE_ORDER_REVISION,
PURCHASE_ORDER_DATE,
COMMENTS,
INTERNAL_NOTES,
FINANCE_CHARGES,
RECEIPT_METHOD_ID,
RELATED_CUSTOMER_TRX_ID,
AGREEMENT_ID,
SHIP_VIA,
SHIP_DATE_ACTUAL,
WAYBILL_NUMBER,
FOB_POINT,
CUSTOMER_BANK_ACCOUNT_ID,
DEFAULT_USSGL_TRANSACTION_CODE,
STATUS_TRX,
PAYING_CUSTOMER_ID,
PAYING_SITE_USE_ID,
DEFAULT_TAX_EXEMPT_FLAG,
DOC_SEQUENCE_VALUE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
GLOBAL_ATTRIBUTE21,
GLOBAL_ATTRIBUTE22,
GLOBAL_ATTRIBUTE23,
GLOBAL_ATTRIBUTE24,
GLOBAL_ATTRIBUTE25,
GLOBAL_ATTRIBUTE26,
GLOBAL_ATTRIBUTE27,
GLOBAL_ATTRIBUTE28,
GLOBAL_ATTRIBUTE29,
GLOBAL_ATTRIBUTE30,
INTERFACE_HEADER_CONTEXT,
INTERFACE_HEADER_ATTRIBUTE1,
INTERFACE_HEADER_ATTRIBUTE2,
INTERFACE_HEADER_ATTRIBUTE3,
INTERFACE_HEADER_ATTRIBUTE4,
INTERFACE_HEADER_ATTRIBUTE5,
INTERFACE_HEADER_ATTRIBUTE6,
INTERFACE_HEADER_ATTRIBUTE7,
INTERFACE_HEADER_ATTRIBUTE8,
INTERFACE_HEADER_ATTRIBUTE9,
INTERFACE_HEADER_ATTRIBUTE10,
INTERFACE_HEADER_ATTRIBUTE11,
INTERFACE_HEADER_ATTRIBUTE12,
INTERFACE_HEADER_ATTRIBUTE13,
INTERFACE_HEADER_ATTRIBUTE14,
INTERFACE_HEADER_ATTRIBUTE15,
ORG_ID,
LEGAL_ENTITY_ID,
payment_trxn_extension_id,
BILLING_DATE,
interest_header_id,
late_charges_assessed,
DOCUMENT_SUB_TYPE,
DEFAULT_TAXATION_COUNTRY
)
VALUES
( p_trx_header_tbl(i).TRX_HEADER_ID,
p_trx_header_tbl(i).TRX_NUMBER,
p_trx_header_tbl(i).TRX_DATE,
p_trx_header_tbl(i).TRX_CURRENCY,
p_trx_header_tbl(i).REFERENCE_NUMBER,
p_trx_header_tbl(i).TRX_CLASS,
p_trx_header_tbl(i).CUST_TRX_TYPE_ID,
p_trx_header_tbl(i).GL_DATE,
p_trx_header_tbl(i).BILL_TO_CUSTOMER_ID,
p_trx_header_tbl(i).BILL_TO_ACCOUNT_NUMBER,
p_trx_header_tbl(i).BILL_TO_CUSTOMER_NAME,
p_trx_header_tbl(i).BILL_TO_CONTACT_ID,
p_trx_header_tbl(i).BILL_TO_ADDRESS_ID,
p_trx_header_tbl(i).BILL_TO_SITE_USE_ID,
p_trx_header_tbl(i).SHIP_TO_CUSTOMER_ID,
p_trx_header_tbl(i).SHIP_TO_ACCOUNT_NUMBER,
p_trx_header_tbl(i).SHIP_TO_CUSTOMER_NAME,
p_trx_header_tbl(i).SHIP_TO_CONTACT_ID,
p_trx_header_tbl(i).SHIP_TO_ADDRESS_ID,
p_trx_header_tbl(i).SHIP_TO_SITE_USE_ID,
p_trx_header_tbl(i).SOLD_TO_CUSTOMER_ID,
p_trx_header_tbl(i).TERM_ID,
p_trx_header_tbl(i).PRIMARY_SALESREP_ID,
p_trx_header_tbl(i).PRIMARY_SALESREP_NAME,
p_trx_header_tbl(i).EXCHANGE_RATE_TYPE,
p_trx_header_tbl(i).EXCHANGE_DATE,
p_trx_header_tbl(i).EXCHANGE_RATE,
p_trx_header_tbl(i).TERRITORY_ID,
p_trx_header_tbl(i).REMIT_TO_ADDRESS_ID,
p_trx_header_tbl(i).INVOICING_RULE_ID,
p_trx_header_tbl(i).PRINTING_OPTION,
p_trx_header_tbl(i).PURCHASE_ORDER,
p_trx_header_tbl(i).PURCHASE_ORDER_REVISION,
p_trx_header_tbl(i).PURCHASE_ORDER_DATE,
p_trx_header_tbl(i).COMMENTS,
p_trx_header_tbl(i).INTERNAL_NOTES,
p_trx_header_tbl(i).FINANCE_CHARGES,
p_trx_header_tbl(i).RECEIPT_METHOD_ID,
p_trx_header_tbl(i).RELATED_CUSTOMER_TRX_ID,
p_trx_header_tbl(i).AGREEMENT_ID,
p_trx_header_tbl(i).SHIP_VIA,
p_trx_header_tbl(i).SHIP_DATE_ACTUAL,
p_trx_header_tbl(i).WAYBILL_NUMBER,
p_trx_header_tbl(i).FOB_POINT,
p_trx_header_tbl(i).CUSTOMER_BANK_ACCOUNT_ID,
p_trx_header_tbl(i).DEFAULT_USSGL_TRANSACTION_CODE,
p_trx_header_tbl(i).STATUS_TRX,
p_trx_header_tbl(i).PAYING_CUSTOMER_ID,
p_trx_header_tbl(i).PAYING_SITE_USE_ID,
p_trx_header_tbl(i).DEFAULT_TAX_EXEMPT_FLAG,
p_trx_header_tbl(i).DOC_SEQUENCE_VALUE,
p_trx_header_tbl(i).ATTRIBUTE_CATEGORY,
p_trx_header_tbl(i).ATTRIBUTE1,
p_trx_header_tbl(i).ATTRIBUTE2,
p_trx_header_tbl(i).ATTRIBUTE3,
p_trx_header_tbl(i).ATTRIBUTE4,
p_trx_header_tbl(i).ATTRIBUTE5,
p_trx_header_tbl(i).ATTRIBUTE6,
p_trx_header_tbl(i).ATTRIBUTE7,
p_trx_header_tbl(i).ATTRIBUTE8,
p_trx_header_tbl(i).ATTRIBUTE9,
p_trx_header_tbl(i).ATTRIBUTE10,
p_trx_header_tbl(i).ATTRIBUTE11,
p_trx_header_tbl(i).ATTRIBUTE12,
p_trx_header_tbl(i).ATTRIBUTE13,
p_trx_header_tbl(i).ATTRIBUTE14,
p_trx_header_tbl(i).ATTRIBUTE15,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE_CATEGORY,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE1,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE2,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE3,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE4,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE5,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE6,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE7,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE8,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE9,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE10,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE11,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE12,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE13,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE14,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE15,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE16,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE17,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE18,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE19,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE20,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE21,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE22,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE23,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE24,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE25,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE26,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE27,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE28,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE29,
p_trx_header_tbl(i).GLOBAL_ATTRIBUTE30,
p_trx_header_tbl(i).INTERFACE_HEADER_CONTEXT,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE1,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE2,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE3,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE4,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE5,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE6,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE7,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE8,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE9,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE10,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE11,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE12,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE13,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE14,
p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE15,
p_trx_header_tbl(i).org_id,
p_trx_header_tbl(i).legal_entity_id,
p_trx_header_tbl(i).payment_trxn_extension_id,
p_trx_header_tbl(i).BILLING_DATE,
p_trx_header_tbl(i).interest_header_id,
p_trx_header_tbl(i).late_charges_assessed,
p_trx_header_tbl(i).document_sub_type,
p_trx_header_tbl(i).default_taxation_country
);
INSERT INTO ar_trx_lines_tmp_gt
( TRX_HEADER_ID,
TRX_LINE_ID,
LINK_TO_TRX_LINE_ID,
LINE_NUMBER,
REASON_CODE,
INVENTORY_ITEM_ID,
DESCRIPTION,
QUANTITY_ORDERED,
QUANTITY_INVOICED,
UNIT_STANDARD_PRICE,
UNIT_SELLING_PRICE,
SALES_ORDER,
SALES_ORDER_LINE,
SALES_ORDER_DATE,
ACCOUNTING_RULE_ID,
LINE_TYPE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
RULE_START_DATE,
INTERFACE_LINE_CONTEXT,
INTERFACE_LINE_ATTRIBUTE1,
INTERFACE_LINE_ATTRIBUTE2,
INTERFACE_LINE_ATTRIBUTE3,
INTERFACE_LINE_ATTRIBUTE4,
INTERFACE_LINE_ATTRIBUTE5,
INTERFACE_LINE_ATTRIBUTE6,
INTERFACE_LINE_ATTRIBUTE7,
INTERFACE_LINE_ATTRIBUTE8,
INTERFACE_LINE_ATTRIBUTE9,
INTERFACE_LINE_ATTRIBUTE10,
INTERFACE_LINE_ATTRIBUTE11,
INTERFACE_LINE_ATTRIBUTE12,
INTERFACE_LINE_ATTRIBUTE13,
INTERFACE_LINE_ATTRIBUTE14,
INTERFACE_LINE_ATTRIBUTE15,
SALES_ORDER_SOURCE,
AMOUNT,
TAX_PRECEDENCE,
TAX_RATE,
TAX_EXEMPTION_ID,
MEMO_LINE_ID,
UOM_CODE,
DEFAULT_USSGL_TRANSACTION_CODE,
DEFAULT_USSGL_TRX_CODE_CONTEXT,
VAT_TAX_ID,
TAX_EXEMPT_FLAG,
TAX_EXEMPT_NUMBER,
TAX_EXEMPT_REASON_CODE,
TAX_VENDOR_RETURN_CODE,
MOVEMENT_ID,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
GLOBAL_ATTRIBUTE_CATEGORY,
AMOUNT_INCLUDES_TAX_FLAG,
WAREHOUSE_ID,
CONTRACT_LINE_ID,
SOURCE_DATA_KEY1,
SOURCE_DATA_KEY2,
SOURCE_DATA_KEY3,
SOURCE_DATA_KEY4,
SOURCE_DATA_KEY5,
INVOICED_LINE_ACCTG_LEVEL,
SHIP_DATE_ACTUAL,
RULE_END_DATE,
SOURCE_APPLICATION_ID,
SOURCE_EVENT_CLASS_CODE,
SOURCE_ENTITY_CODE,
SOURCE_TRX_ID,
SOURCE_TRX_LINE_ID,
SOURCE_TRX_LINE_TYPE,
SOURCE_TRX_DETAIL_TAX_LINE_ID,
HISTORICAL_FLAG,
TAXABLE_FLAG,
TAX_REGIME_CODE,
TAX,
TAX_STATUS_CODE,
TAX_RATE_CODE,
TAX_JURISDICTION_CODE,
TAX_CLASSIFICATION_CODE,
INTEREST_LINE_ID,
TRX_BUSINESS_CATEGORY,
PRODUCT_FISC_CLASSIFICATION,
PRODUCT_CATEGORY,
PRODUCT_TYPE,
LINE_INTENDED_USE,
ASSESSABLE_VALUE
)
VALUES
( p_trx_lines_tbl(i).TRX_HEADER_ID,
p_trx_lines_tbl(i).TRX_LINE_ID,
p_trx_lines_tbl(i).LINK_TO_TRX_LINE_ID,
p_trx_lines_tbl(i).LINE_NUMBER,
p_trx_lines_tbl(i).REASON_CODE,
p_trx_lines_tbl(i).INVENTORY_ITEM_ID,
p_trx_lines_tbl(i).DESCRIPTION,
p_trx_lines_tbl(i).QUANTITY_ORDERED,
p_trx_lines_tbl(i).QUANTITY_INVOICED,
p_trx_lines_tbl(i).UNIT_STANDARD_PRICE,
p_trx_lines_tbl(i).UNIT_SELLING_PRICE,
p_trx_lines_tbl(i).SALES_ORDER,
p_trx_lines_tbl(i).SALES_ORDER_LINE,
p_trx_lines_tbl(i).SALES_ORDER_DATE,
p_trx_lines_tbl(i).ACCOUNTING_RULE_ID,
p_trx_lines_tbl(i).LINE_TYPE,
p_trx_lines_tbl(i).ATTRIBUTE_CATEGORY,
p_trx_lines_tbl(i).ATTRIBUTE1,
p_trx_lines_tbl(i).ATTRIBUTE2,
p_trx_lines_tbl(i).ATTRIBUTE3,
p_trx_lines_tbl(i).ATTRIBUTE4,
p_trx_lines_tbl(i).ATTRIBUTE5,
p_trx_lines_tbl(i).ATTRIBUTE6,
p_trx_lines_tbl(i).ATTRIBUTE7,
p_trx_lines_tbl(i).ATTRIBUTE8,
p_trx_lines_tbl(i).ATTRIBUTE9,
p_trx_lines_tbl(i).ATTRIBUTE10,
p_trx_lines_tbl(i).ATTRIBUTE11,
p_trx_lines_tbl(i).ATTRIBUTE12,
p_trx_lines_tbl(i).ATTRIBUTE13,
p_trx_lines_tbl(i).ATTRIBUTE14,
p_trx_lines_tbl(i).ATTRIBUTE15,
p_trx_lines_tbl(i).RULE_START_DATE,
p_trx_lines_tbl(i).INTERFACE_LINE_CONTEXT,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE1,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE2,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE3,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE4,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE5,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE6,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE7,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE8,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE9,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE10,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE11,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE12,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE13,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE14,
p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE15,
p_trx_lines_tbl(i).SALES_ORDER_SOURCE,
p_trx_lines_tbl(i).AMOUNT,
p_trx_lines_tbl(i).TAX_PRECEDENCE,
p_trx_lines_tbl(i).TAX_RATE,
p_trx_lines_tbl(i).TAX_EXEMPTION_ID,
p_trx_lines_tbl(i).MEMO_LINE_ID,
p_trx_lines_tbl(i).UOM_CODE,
p_trx_lines_tbl(i).DEFAULT_USSGL_TRANSACTION_CODE,
p_trx_lines_tbl(i).DEFAULT_USSGL_TRX_CODE_CONTEXT,
p_trx_lines_tbl(i).VAT_TAX_ID,
p_trx_lines_tbl(i).TAX_EXEMPT_FLAG,
p_trx_lines_tbl(i).TAX_EXEMPT_NUMBER,
p_trx_lines_tbl(i).TAX_EXEMPT_REASON_CODE,
p_trx_lines_tbl(i).TAX_VENDOR_RETURN_CODE,
p_trx_lines_tbl(i).MOVEMENT_ID,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE1,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE2,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE3,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE4,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE5,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE6,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE7,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE8,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE9,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE10,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE11,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE12,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE13,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE14,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE15,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE16,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE17,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE18,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE19,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE20,
p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE_CATEGORY,
p_trx_lines_tbl(i).AMOUNT_INCLUDES_TAX_FLAG,
p_trx_lines_tbl(i).WAREHOUSE_ID,
p_trx_lines_tbl(i).CONTRACT_LINE_ID,
p_trx_lines_tbl(i).SOURCE_DATA_KEY1,
p_trx_lines_tbl(i).SOURCE_DATA_KEY2,
p_trx_lines_tbl(i).SOURCE_DATA_KEY3,
p_trx_lines_tbl(i).SOURCE_DATA_KEY4,
p_trx_lines_tbl(i).SOURCE_DATA_KEY5,
p_trx_lines_tbl(i).INVOICED_LINE_ACCTG_LEVEL,
p_trx_lines_tbl(i).SHIP_DATE_ACTUAL,
p_trx_lines_tbl(i).rule_end_date,
p_trx_lines_tbl(i).source_application_id,
p_trx_lines_tbl(i).source_event_class_code,
p_trx_lines_tbl(i).source_entity_code,
p_trx_lines_tbl(i).source_trx_id,
p_trx_lines_tbl(i).source_trx_line_id,
p_trx_lines_tbl(i).source_trx_line_type,
p_trx_lines_tbl(i).source_trx_detail_tax_line_id,
p_trx_lines_tbl(i).historical_flag,
p_trx_lines_tbl(i).taxable_flag,
p_trx_lines_tbl(i).tax_regime_code,
p_trx_lines_tbl(i).tax,
p_trx_lines_tbl(i).tax_status_code,
p_trx_lines_tbl(i).tax_rate_code,
p_trx_lines_tbl(i).tax_jurisdiction_code,
p_trx_lines_tbl(i).tax_classification_code,
p_trx_lines_tbl(i).interest_line_id,
p_trx_lines_tbl(i).trx_business_category,
p_trx_lines_tbl(i).product_fisc_classification,
p_trx_lines_tbl(i).product_category,
p_trx_lines_tbl(i).product_type,
p_trx_lines_tbl(i).line_intended_use,
p_trx_lines_tbl(i).assessable_value
);
INSERT INTO ar_trx_dist_tmp_gt
( TRX_DIST_ID,
TRX_HEADER_ID,
TRX_LINE_ID,
ACCOUNT_CLASS,
AMOUNT,
ACCTD_AMOUNT,
PERCENT,
CODE_COMBINATION_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
COMMENTS)
VALUES
( p_trx_dist_tbl(i).TRX_DIST_ID,
p_trx_dist_tbl(i).TRX_HEADER_ID,
p_trx_dist_tbl(i).TRX_LINE_ID,
p_trx_dist_tbl(i).ACCOUNT_CLASS,
p_trx_dist_tbl(i).AMOUNT,
p_trx_dist_tbl(i).ACCTD_AMOUNT,
p_trx_dist_tbl(i).PERCENT,
p_trx_dist_tbl(i).CODE_COMBINATION_ID,
p_trx_dist_tbl(i).ATTRIBUTE_CATEGORY,
p_trx_dist_tbl(i).ATTRIBUTE1,
p_trx_dist_tbl(i).ATTRIBUTE2,
p_trx_dist_tbl(i).ATTRIBUTE3,
p_trx_dist_tbl(i).ATTRIBUTE4,
p_trx_dist_tbl(i).ATTRIBUTE5,
p_trx_dist_tbl(i).ATTRIBUTE6,
p_trx_dist_tbl(i).ATTRIBUTE7,
p_trx_dist_tbl(i).ATTRIBUTE8,
p_trx_dist_tbl(i).ATTRIBUTE9,
p_trx_dist_tbl(i).ATTRIBUTE10,
p_trx_dist_tbl(i).ATTRIBUTE11,
p_trx_dist_tbl(i).ATTRIBUTE12,
p_trx_dist_tbl(i).ATTRIBUTE13,
p_trx_dist_tbl(i).ATTRIBUTE14,
p_trx_dist_tbl(i).ATTRIBUTE15,
p_trx_dist_tbl(i).COMMENTS
);
INSERT INTO ar_trx_salescredits_tmp_gt
( TRX_SALESCREDIT_ID,
TRX_LINE_ID,
SALESREP_ID,
SALESREP_NUMBER,
SALES_CREDIT_TYPE_NAME,
SALES_CREDIT_TYPE_ID,
SALESCREDIT_AMOUNT_SPLIT,
SALESCREDIT_PERCENT_SPLIT,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
)
VALUES
( p_trx_salescredits_tbl(i).TRX_SALESCREDIT_ID,
p_trx_salescredits_tbl(i).TRX_LINE_ID,
p_trx_salescredits_tbl(i).SALESREP_ID,
p_trx_salescredits_tbl(i).SALESREP_NUMBER,
p_trx_salescredits_tbl(i).SALES_CREDIT_TYPE_NAME,
p_trx_salescredits_tbl(i).SALES_CREDIT_TYPE_ID,
p_trx_salescredits_tbl(i).SALESCREDIT_AMOUNT_SPLIT,
p_trx_salescredits_tbl(i).SALESCREDIT_PERCENT_SPLIT,
p_trx_salescredits_tbl(i).ATTRIBUTE_CATEGORY,
p_trx_salescredits_tbl(i).ATTRIBUTE1,
p_trx_salescredits_tbl(i).ATTRIBUTE2,
p_trx_salescredits_tbl(i).ATTRIBUTE3,
p_trx_salescredits_tbl(i).ATTRIBUTE4,
p_trx_salescredits_tbl(i).ATTRIBUTE5,
p_trx_salescredits_tbl(i).ATTRIBUTE6,
p_trx_salescredits_tbl(i).ATTRIBUTE7,
p_trx_salescredits_tbl(i).ATTRIBUTE8,
p_trx_salescredits_tbl(i).ATTRIBUTE9,
p_trx_salescredits_tbl(i).ATTRIBUTE10,
p_trx_salescredits_tbl(i).ATTRIBUTE11,
p_trx_salescredits_tbl(i).ATTRIBUTE12,
p_trx_salescredits_tbl(i).ATTRIBUTE13,
p_trx_salescredits_tbl(i).ATTRIBUTE14,
p_trx_salescredits_tbl(i).ATTRIBUTE15
);
ar_invoice_utils.debug ('AR_TRX_GLOBAL_PROCESS_TMP.INSERT_ROWS(-)');
x_errmsg := 'Error in AR_TRX_GLOBAL_PROCESS_TMP.INSERT_ROWS '||sqlerrm;
END INSERT_ROWS;
select *
from ar_trx_header_tmp_gt
where nvl(org_id,-99) = nvl(p_org_id,-99);
select *
from ar_trx_lines_tmp_gt
where TRX_HEADER_ID = P_TRX_HEADER_ID;
/* 4652982 - Modified to only insert line-level dists */
cursor dist_cur (P_TRX_LINE_ID number ) is
select *
from ar_trx_dist_tmp_gt
where TRX_LINE_ID = P_TRX_LINE_ID;
/* 4652982 - Added to insert header-level dists */
cursor dist_rec_cur (P_TRX_HEADER_ID number) is
select *
from ar_trx_dist_tmp_gt
where TRX_HEADER_ID = P_TRX_HEADER_ID
and TRX_LINE_ID is NULL;
select *
from ar_trx_salescredits_tmp_gt
where --(TRX_HEADER_ID = P_TRX_HEADER_ID) or
(TRX_LINE_ID = P_TRX_LINE_ID);
/* 4652982 - Insert header dist rows
NOTE: We use same index as prev dist insert so
our records are consecutive in the table for
future bulk reads. */
FOR dist_rec in dist_rec_cur(hdr_rec.trx_header_id) LOOP
k := k + 1;
END LOOP; -- end of hdr rec/round dist insert