[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
ra.code_combination_id
INTO l_activity_ccid
from ar_receivable_applications ra
where ra.status='ACTIVITY'
and ra.display = 'Y'
AND ra.receivable_application_id = p_receivable_application_id;
debug('Calling AP_INVOICES_INTERFACE_PKG.INSERT_ROW..');
SELECT ap_invoices_interface_s.NEXTVAL
INTO l_invoice_interface_id
FROM DUAL;
SELECT ap_invoice_lines_interface_s.NEXTVAL
INTO l_invoice_line_interface_id
FROM DUAL;
SELECT terms_date_basis
INTO l_terms_date_basis
FROM ap_product_setup;
AP_INVOICES_INTERFACE_PKG.INSERT_ROW (
X_ROWID => l_rowid ,
X_INVOICE_ID => l_invoice_interface_id,
X_INVOICE_NUM => l_invoice_interface_id,
X_INVOICE_TYPE_LOOKUP_CODE => 'PAYMENT REQUEST',
X_INVOICE_DATE => p_invoice_date,
X_PO_NUMBER => NULL,
X_VENDOR_ID => NULL,
X_VENDOR_SITE_ID => NULL,
X_INVOICE_AMOUNT => p_amount,
X_INVOICE_CURRENCY_CODE => p_currency_code,
X_PAYMENT_CURRENCY_CODE => p_currency_code,
X_PAYMENT_CROSS_RATE => NULL,
X_PAYMENT_CROSS_RATE_TYPE => NULL,
X_PAYMENT_CROSS_RATE_DATE => NULL,
X_EXCHANGE_RATE => p_exchange_rate,
X_EXCHANGE_RATE_TYPE => p_exchange_rate_type,
X_EXCHANGE_DATE => p_exchange_date,
X_TERMS_ID => p_terms_id, --Bug7525965
X_DESCRIPTION => p_description, --rct comments
X_AWT_GROUP_ID => NULL,
X_AMT_APPLICABLE_TO_DISCOUNT => NULL,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL,
X_GLOBAL_ATTRIBUTE_CATEGORY => NULL,
X_GLOBAL_ATTRIBUTE1 => NULL,
X_GLOBAL_ATTRIBUTE2 => NULL,
X_GLOBAL_ATTRIBUTE3 => NULL,
X_GLOBAL_ATTRIBUTE4 => NULL,
X_GLOBAL_ATTRIBUTE5 => NULL,
X_GLOBAL_ATTRIBUTE6 => NULL,
X_GLOBAL_ATTRIBUTE7 => NULL,
X_GLOBAL_ATTRIBUTE8 => NULL,
X_GLOBAL_ATTRIBUTE9 => NULL,
X_GLOBAL_ATTRIBUTE10 => NULL,
X_GLOBAL_ATTRIBUTE11 => NULL,
X_GLOBAL_ATTRIBUTE12 => NULL,
X_GLOBAL_ATTRIBUTE13 => NULL,
X_GLOBAL_ATTRIBUTE14 => NULL,
X_GLOBAL_ATTRIBUTE15 => NULL,
X_GLOBAL_ATTRIBUTE16 => NULL,
X_GLOBAL_ATTRIBUTE17 => NULL,
X_GLOBAL_ATTRIBUTE18 => NULL,
X_GLOBAL_ATTRIBUTE19 => NULL,
X_GLOBAL_ATTRIBUTE20 => NULL,
X_STATUS => NULL,
X_SOURCE => 'Receivables',
X_GROUP_ID => NULL,
X_WORKFLOW_FLAG => NULL,
X_DOC_CATEGORY_CODE => NULL,
X_VOUCHER_NUM => NULL,
X_PAY_GROUP_LOOKUP_CODE => p_pay_group_lookup_code,
X_GOODS_RECEIVED_DATE => l_goods_received_date, -- bug 8764872
X_INVOICE_RECEIVED_DATE => l_invoice_received_date,
X_GL_DATE => p_gl_date, --Bug8283120
X_ACCTS_PAY_CCID => NULL,
X_EXCLUSIVE_PAYMENT_FLAG => p_pay_alone_flag,
X_INVOICE_INCLUDES_PREPAY_FLAG => NULL,
X_PREPAY_NUM => NULL,
X_PREPAY_APPLY_AMOUNT => NULL,
X_PREPAY_GL_DATE => NULL,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => fnd_global.user_id,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.login_id,
X_ORG_ID => p_org_id,
X_TERMS_DATE => NULL,
X_REQUESTER_ID => NULL,
X_CONTROL_AMOUNT => NULL,
X_LEGAL_ENTITY_ID => p_legal_entity_id,
x_PAYMENT_METHOD_CODE => p_payment_method_code ,
x_PAYMENT_REASON_CODE => p_payment_reason_code ,
X_PAYMENT_REASON_COMMENTS => p_payment_reason_comments,
x_DELIVERY_CHANNEL_CODE => p_delivery_channel_code ,
x_remittance_message1 => p_remittance_message1 ,
x_remittance_message2 => p_remittance_message2,
x_remittance_message3 => p_remittance_message3,
X_APPLICATION_ID => 222,
X_PRODUCT_TABLE => 'AR_RECEIVABLE_APPLICATIONS_ALL',
X_REFERENCE_KEY1 => p_receivable_application_id,
X_REFERENCE_KEY2 => 'AR_RECEIVABLE_APPLICATIONS_ALL',
X_REFERENCE_KEY3 => NULL,
X_REFERENCE_KEY4 => NULL,
X_REFERENCE_KEY5 => NULL,
X_PARTY_ID => p_party_id,
X_PARTY_SITE_ID => p_party_site_id,
X_PAY_PROC_TRXN_TYPE_CODE => NULL,
X_PAYMENT_FUNCTION => 'AR_CUSTOMER_REFUNDS',
X_PAYMENT_PRIORITY => p_payment_priority, -- Bug7525965
x_external_bank_account_id => p_bank_account_id
);
debug('Calling AP_INVOICES_LINES_INTERFACE_PKG.INSERT_ROW..');
AP_INVOICE_LINES_INTERFACE_PKG.INSERT_ROW(
X_ROWID => l_line_rowid,
X_INVOICE_ID => l_invoice_interface_id,
X_INVOICE_LINE_ID => l_invoice_line_interface_id,
X_LINE_NUMBER => 1,
X_LINE_TYPE_LOOKUP_CODE => 'ITEM',
X_LINE_GROUP_NUMBER => NULL,
X_AMOUNT => p_amount,
X_ACCOUNTING_DATE => NULL,
X_DESCRIPTION => p_description,
X_PRORATE_ACROSS_FLAG => NULL,
X_TAX_CODE => NULL,
X_TAX_CODE_ID => NULL,
X_FINAL_MATCH_FLAG => NULL,
X_PO_HEADER_ID => NULL,
X_PO_LINE_ID => NULL,
X_PO_LINE_LOCATION_ID => NULL,
X_PO_DISTRIBUTION_ID => NULL,
X_UNIT_OF_MEAS_LOOKUP_CODE => NULL,
X_INVENTORY_ITEM_ID => NULL,
X_QUANTITY_INVOICED => NULL,
X_UNIT_PRICE => NULL,
X_DISTRIBUTION_SET_ID => NULL,
X_DIST_CODE_CONCATENATED => NULL,
X_DIST_CODE_COMBINATION_ID => l_activity_ccid,
X_AWT_GROUP_ID => NULL,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL,
X_GLOBAL_ATTRIBUTE_CATEGORY => NULL,
X_GLOBAL_ATTRIBUTE1 => NULL,
X_GLOBAL_ATTRIBUTE2 => NULL,
X_GLOBAL_ATTRIBUTE3 => NULL,
X_GLOBAL_ATTRIBUTE4 => NULL,
X_GLOBAL_ATTRIBUTE5 => NULL,
X_GLOBAL_ATTRIBUTE6 => NULL,
X_GLOBAL_ATTRIBUTE7 => NULL,
X_GLOBAL_ATTRIBUTE8 => NULL,
X_GLOBAL_ATTRIBUTE9 => NULL,
X_GLOBAL_ATTRIBUTE10 => NULL,
X_GLOBAL_ATTRIBUTE11 => NULL,
X_GLOBAL_ATTRIBUTE12 => NULL,
X_GLOBAL_ATTRIBUTE13 => NULL,
X_GLOBAL_ATTRIBUTE14 => NULL,
X_GLOBAL_ATTRIBUTE15 => NULL,
X_GLOBAL_ATTRIBUTE16 => NULL,
X_GLOBAL_ATTRIBUTE17 => NULL,
X_GLOBAL_ATTRIBUTE18 => NULL,
X_GLOBAL_ATTRIBUTE19 => NULL,
X_GLOBAL_ATTRIBUTE20 => NULL,
X_PO_RELEASE_ID => NULL,
X_BALANCING_SEGMENT => NULL,
X_COST_CENTER_SEGMENT => NULL,
X_ACCOUNT_SEGMENT => NULL,
X_PROJECT_ID => NULL,
X_TASK_ID => NULL,
X_EXPENDITURE_TYPE => NULL,
X_EXPENDITURE_ITEM_DATE => NULL,
X_EXPENDITURE_ORGANIZATION_ID => NULL,
X_PROJECT_ACCOUNTING_CONTEXT => NULL,
X_PA_ADDITION_FLAG => NULL,
X_PA_QUANTITY => NULL,
X_STAT_AMOUNT => NULL,
X_TYPE_1099 => NULL,
X_INCOME_TAX_REGION => NULL,
X_ASSETS_TRACKING_FLAG => NULL,
X_PRICE_CORRECTION_FLAG => NULL,
X_RECEIPT_NUMBER => NULL,
X_MATCH_OPTION => NULL,
X_RCV_TRANSACTION_ID => NULL,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => FND_GLOBAL.USER_ID,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
X_ORG_ID => p_org_id,
X_Calling_Sequence => g_pkg_name||'.create_refund'
);
/* Need to update the newly created application with the
refund invoice id.. */
IF NVL(p_called_from,'ARXRWAPP') <> 'TEST' THEN
arp_app_pkg.fetch_p(p_receivable_application_id,l_app_rec);
arp_app_pkg.update_p(l_app_rec);
l_last_update_date DATE;
, P_last_updated_by => fnd_global.user_id
, P_last_update_login => fnd_global.login_id
, P_accounting_date => NULL
, P_message_name => l_message_name
, P_invoice_amount => l_refund_amount
, P_base_amount => l_acctd_refund_amount
, P_temp_cancelled_amount => l_temp_cancelled_amount
, P_cancelled_by => l_cancelled_by
, P_cancelled_amount => l_cancelled_amount
, P_cancelled_date => l_cancelled_date
, P_last_update_date => l_last_update_date
, P_original_prepayment_amount => l_orig_ppay_amount
, P_pay_curr_invoice_amount => l_pay_curr_amount
, P_Token => l_token
, P_calling_sequence => 'ar_refund_pvt.cancel_refund'
) THEN
x_return_status := FND_API.G_RET_STS_ERROR;