[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Amount NUMBER,
X_Ce_Bank_Acct_Use_Id NUMBER,
X_Bank_Account_Name VARCHAR2,
X_Check_Date DATE,
X_Check_Id NUMBER,
X_Check_Number NUMBER,
X_Currency_Code VARCHAR2,
X_Last_Updated_By NUMBER,
X_Last_Update_Date DATE,
--IBY:SP X_Payment_Method_Lookup_Code VARCHAR2,
X_Payment_Type_Flag VARCHAR2,
X_Address_Line1 VARCHAR2 DEFAULT NULL,
X_Address_Line2 VARCHAR2 DEFAULT NULL,
X_Address_Line3 VARCHAR2 DEFAULT NULL,
X_Checkrun_Name VARCHAR2 DEFAULT NULL,
X_Check_Format_Id NUMBER DEFAULT NULL,
X_Check_Stock_Id NUMBER DEFAULT NULL,
X_City VARCHAR2 DEFAULT NULL,
X_Country VARCHAR2 DEFAULT NULL,
X_Created_By NUMBER DEFAULT NULL,
X_Creation_Date DATE DEFAULT NULL,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Status_Lookup_Code VARCHAR2 DEFAULT NULL,
X_Vendor_Name VARCHAR2 DEFAULT NULL,
X_Vendor_Site_Code VARCHAR2 DEFAULT NULL,
X_External_Bank_Account_Id NUMBER,
X_Zip VARCHAR2 DEFAULT NULL,
X_Bank_Account_Num VARCHAR2 DEFAULT NULL,
X_Bank_Account_Type VARCHAR2 DEFAULT NULL,
X_Bank_Num VARCHAR2 DEFAULT NULL,
X_Check_Voucher_Num NUMBER DEFAULT NULL,
X_Cleared_Amount NUMBER DEFAULT NULL,
X_Cleared_Date DATE DEFAULT NULL,
X_Doc_Category_Code VARCHAR2 DEFAULT NULL,
X_Doc_Sequence_Id NUMBER DEFAULT NULL,
X_Doc_Sequence_Value NUMBER DEFAULT NULL,
X_Province VARCHAR2 DEFAULT NULL,
X_Released_Date DATE DEFAULT NULL,
X_Released_By NUMBER DEFAULT NULL,
X_State VARCHAR2 DEFAULT NULL,
X_Stopped_Date DATE DEFAULT NULL,
X_Stopped_By NUMBER DEFAULT NULL,
X_Void_Date DATE DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Future_Pay_Due_Date DATE DEFAULT NULL,
X_Treasury_Pay_Date DATE DEFAULT NULL,
X_Treasury_Pay_Number NUMBER DEFAULT NULL,
-- Removed for bug 4277744
-- X_Ussgl_Transaction_Code VARCHAR2 DEFAULT NULL,
-- X_Ussgl_Trx_Code_Context VARCHAR2 DEFAULT NULL,
X_Withholding_Status_Lkup_Code VARCHAR2 DEFAULT NULL,
X_Reconciliation_Batch_Id NUMBER DEFAULT NULL,
X_Cleared_Base_Amount NUMBER DEFAULT NULL,
X_Cleared_Exchange_Rate NUMBER DEFAULT NULL,
X_Cleared_Exchange_Date DATE DEFAULT NULL,
X_Cleared_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
X_Address_Line4 VARCHAR2 DEFAULT NULL,
X_County VARCHAR2 DEFAULT NULL,
X_Address_Style VARCHAR2 DEFAULT NULL,
X_Org_Id NUMBER DEFAULT NULL,
X_Vendor_Id NUMBER,
X_Vendor_Site_Id NUMBER,
X_Exchange_Rate NUMBER DEFAULT NULL,
X_Exchange_Date DATE DEFAULT NULL,
X_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
X_Base_Amount NUMBER DEFAULT NULL,
X_Checkrun_Id NUMBER DEFAULT NULL,
X_global_attribute_category VARCHAR2 DEFAULT NULL,
X_global_attribute1 VARCHAR2 DEFAULT NULL,
X_global_attribute2 VARCHAR2 DEFAULT NULL,
X_global_attribute3 VARCHAR2 DEFAULT NULL,
X_global_attribute4 VARCHAR2 DEFAULT NULL,
X_global_attribute5 VARCHAR2 DEFAULT NULL,
X_global_attribute6 VARCHAR2 DEFAULT NULL,
X_global_attribute7 VARCHAR2 DEFAULT NULL,
X_global_attribute8 VARCHAR2 DEFAULT NULL,
X_global_attribute9 VARCHAR2 DEFAULT NULL,
X_global_attribute10 VARCHAR2 DEFAULT NULL,
X_global_attribute11 VARCHAR2 DEFAULT NULL,
X_global_attribute12 VARCHAR2 DEFAULT NULL,
X_global_attribute13 VARCHAR2 DEFAULT NULL,
X_global_attribute14 VARCHAR2 DEFAULT NULL,
X_global_attribute15 VARCHAR2 DEFAULT NULL,
X_global_attribute16 VARCHAR2 DEFAULT NULL,
X_global_attribute17 VARCHAR2 DEFAULT NULL,
X_global_attribute18 VARCHAR2 DEFAULT NULL,
X_global_attribute19 VARCHAR2 DEFAULT NULL,
X_global_attribute20 VARCHAR2 DEFAULT NULL,
X_transfer_priority VARCHAR2 DEFAULT NULL,
X_maturity_exchange_rate_type VARCHAR2 DEFAULT NULL,
X_maturity_exchange_date DATE DEFAULT NULL,
X_maturity_exchange_rate NUMBER DEFAULT NULL,
X_description VARCHAR2 DEFAULT NULL,
X_anticipated_value_date DATE DEFAULT NULL,
X_actual_value_date DATE DEFAULT NULL,
x_payment_method_code VARCHAR2 DEFAULT NULL,
x_payment_profile_id NUMBER DEFAULT NULL,
x_bank_charge_bearer VARCHAR2 DEFAULT NULL,
x_settlement_priority VARCHAR2 DEFAULT NULL,
x_payment_document_id NUMBER DEFAULT NULL,
x_party_id NUMBER DEFAULT NULL,
x_party_site_id NUMBER DEFAULT NULL,
x_legal_entity_id NUMBER DEFAULT NULL,
x_payment_id NUMBER DEFAULT NULL,
X_calling_sequence IN VARCHAR2,
X_Remit_To_Supplier_Name VARCHAR2 DEFAULT NULL,
X_Remit_To_Supplier_Id Number DEFAULT NULL,
X_Remit_To_Supplier_Site VARCHAR2 DEFAULT NULL,
X_Remit_To_Supplier_Site_Id NUMBER DEFAULT NULL,
X_Relationship_Id NUMBER DEFAULT NULL,
X_paycard_authorization_number VARCHAR2 DEFAULT NULL,
X_paycard_reference_id NUMBER DEFAULT NULL
) IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'AP_CHECKS_PKG.INSERT_ROW<-' ||
X_calling_sequence;
debug_info := 'Insert into ap_checks';
AP_AC_TABLE_HANDLER_PKG.Insert_Row(
X_Rowid,
X_Amount,
X_Ce_Bank_Acct_Use_Id,
X_Bank_Account_Name,
X_Check_Date,
X_Check_Id,
X_Check_Number,
X_Currency_Code,
X_Last_Updated_By,
X_Last_Update_Date,
--IBY:SP X_Payment_Method_Lookup_Code,
X_Payment_Type_Flag,
X_Address_Line1,
X_Address_Line2,
X_Address_Line3,
X_Checkrun_Name,
X_Check_Format_Id,
X_Check_Stock_Id,
X_City,
X_Country,
X_Created_By,
X_Creation_Date,
X_Last_Update_Login,
X_Status_Lookup_Code,
X_Vendor_Name,
X_Vendor_Site_Code,
X_External_Bank_Account_Id,
X_Zip,
X_Bank_Account_Num,
X_Bank_Account_Type,
X_Bank_Num,
X_Check_Voucher_Num,
X_Cleared_Amount,
X_Cleared_Date,
X_Doc_Category_Code,
X_Doc_Sequence_Id,
X_Doc_Sequence_Value,
X_Province,
X_Released_Date,
X_Released_By,
X_State,
X_Stopped_Date,
X_Stopped_By,
X_Void_Date,
X_Attribute1,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute15,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute_Category,
X_Future_Pay_Due_Date,
X_Treasury_Pay_Date,
X_Treasury_Pay_Number,
-- Removed for bug 4277744
-- X_Ussgl_Transaction_Code,
-- X_Ussgl_Trx_Code_Context,
X_Withholding_Status_Lkup_Code,
X_Reconciliation_Batch_Id,
X_Cleared_Base_Amount,
X_Cleared_Exchange_Rate,
X_Cleared_Exchange_Date,
X_Cleared_Exchange_Rate_Type,
X_Address_Line4,
X_County,
X_Address_Style,
X_Org_Id,
X_Vendor_Id,
X_Vendor_Site_Id,
X_Exchange_Rate,
X_Exchange_Date,
X_Exchange_Rate_Type,
X_Base_Amount,
X_Checkrun_Id,
X_global_attribute_category,
X_global_attribute1,
X_global_attribute2,
X_global_attribute3,
X_global_attribute4,
X_global_attribute5,
X_global_attribute6,
X_global_attribute7,
X_global_attribute8,
X_global_attribute9,
X_global_attribute10,
X_global_attribute11,
X_global_attribute12,
X_global_attribute13,
X_global_attribute14,
X_global_attribute15,
X_global_attribute16,
X_global_attribute17,
X_global_attribute18,
X_global_attribute19,
X_global_attribute20,
X_transfer_priority,
X_maturity_exchange_rate_type,
X_maturity_exchange_date,
X_maturity_exchange_rate,
X_description,
X_anticipated_value_date,
X_actual_value_date,
x_payment_method_code,
x_payment_profile_id,
x_bank_charge_bearer,
x_settlement_priority,
x_payment_document_id,
x_party_id,
x_party_site_id,
x_legal_entity_id,
x_payment_id,
current_calling_sequence,
X_Remit_To_Supplier_Name,
X_Remit_To_Supplier_Id,
X_Remit_To_Supplier_Site,
X_Remit_To_Supplier_Site_Id,
X_Relationship_ID ,
x_paycard_authorization_number,
X_paycard_reference_id
);
END Insert_Row;
SELECT
ACTUAL_VALUE_DATE,
ANTICIPATED_VALUE_DATE,
AMOUNT,
CE_BANK_ACCT_USE_ID,
BANK_ACCOUNT_NAME,
CHECK_DATE,
CHECK_ID,
CHECK_NUMBER,
CURRENCY_CODE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
--IBY:SP
--Bug5949912, bug6312110
PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE,
PAYMENT_TYPE_FLAG,
-- Bug 6620381. trimming trailing space for the address lines
rtrim(ADDRESS_LINE1) ADDRESS_LINE1,
rtrim(ADDRESS_LINE2) ADDRESS_LINE2,
rtrim(ADDRESS_LINE3) ADDRESS_LINE3,
CHECKRUN_NAME,
-- CHECK_FORMAT_ID, Bug 5460922. Removing these fields from cursor
-- CHECK_STOCK_ID, as these fields are no longer used in R12.
rtrim(CITY) CITY,
COUNTRY,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
STATUS_LOOKUP_CODE,
--bug7670430 trimming trailing spaces for vendor_name
rtrim(VENDOR_NAME) VENDOR_NAME ,
VENDOR_SITE_CODE,
ZIP,
BANK_ACCOUNT_NUM,
BANK_ACCOUNT_TYPE,
BANK_NUM,
CHECK_VOUCHER_NUM,
CLEARED_AMOUNT,
CLEARED_DATE,
DOC_CATEGORY_CODE,
DOC_SEQUENCE_ID,
DOC_SEQUENCE_VALUE,
PROVINCE,
RELEASED_AT,
RELEASED_BY,
rtrim(STATE) STATE,
STOPPED_AT,
STOPPED_BY,
VOID_DATE,
ATTRIBUTE1,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE_CATEGORY,
FUTURE_PAY_DUE_DATE,
TREASURY_PAY_DATE,
TREASURY_PAY_NUMBER,
-- Removed for bug 4277744
-- USSGL_TRANSACTION_CODE,
-- USSGL_TRX_CODE_CONTEXT,
WITHHOLDING_STATUS_LOOKUP_CODE,
RECONCILIATION_BATCH_ID,
CLEARED_BASE_AMOUNT,
CLEARED_EXCHANGE_RATE,
CLEARED_EXCHANGE_DATE,
CLEARED_EXCHANGE_RATE_TYPE,
rtrim(ADDRESS_LINE4) ADDRESS_LINE4,
COUNTY,
ADDRESS_STYLE,
ORG_ID,
VENDOR_ID,
VENDOR_SITE_ID,
EXCHANGE_RATE,
EXCHANGE_DATE,
EXCHANGE_RATE_TYPE,
BASE_AMOUNT,
CHECKRUN_ID,
REQUEST_ID,
CLEARED_ERROR_AMOUNT,
CLEARED_CHARGES_AMOUNT,
CLEARED_ERROR_BASE_AMOUNT,
CLEARED_CHARGES_BASE_AMOUNT,
POSITIVE_PAY_STATUS_CODE,
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,
TRANSFER_PRIORITY,
EXTERNAL_BANK_ACCOUNT_ID,
STAMP_DUTY_AMT,
STAMP_DUTY_BASE_AMT,
-- MRC_CLEARED_BASE_AMOUNT, Bug 5460922
-- MRC_CLEARED_EXCHANGE_RATE,
-- MRC_CLEARED_EXCHANGE_DATE,
-- MRC_CLEARED_EXCHANGE_RATE_TYPE,
-- MRC_EXCHANGE_RATE,
-- MRC_EXCHANGE_DATE,
-- MRC_EXCHANGE_RATE_TYPE,
-- MRC_BASE_AMOUNT,
-- MRC_CLEARED_ERROR_BASE_AMOUNT,
-- MRC_CLEARED_CHARGES_BASE_AMT,
-- MRC_STAMP_DUTY_BASE_AMT,
MATURITY_EXCHANGE_DATE,
MATURITY_EXCHANGE_RATE_TYPE,
MATURITY_EXCHANGE_RATE,
DESCRIPTION,
RELEASED_DATE,
STOPPED_DATE,
-- MRC_MATURITY_EXG_DATE, Bug 5460922
-- MRC_MATURITY_EXG_RATE,
-- MRC_MATURITY_EXG_RATE_TYPE,
PAYMENT_METHOD_CODE,
PAYMENT_PROFILE_ID,
BANK_CHARGE_BEARER,
SETTLEMENT_PRIORITY,
PAYMENT_DOCUMENT_ID,
PARTY_ID,
PARTY_SITE_ID,
legal_entity_id,
payment_id,
Remit_To_Supplier_Name,
Remit_To_Supplier_Id,
Remit_To_Supplier_Site,
Remit_To_Supplier_Site_Id,
Relationship_Id,
Paycard_authorization_number,
Paycard_reference_id
FROM ap_checks_all
WHERE rowid = X_Rowid
FOR UPDATE of Check_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Amount NUMBER,
X_Ce_Bank_Acct_Use_Id NUMBER,
X_Bank_Account_Name VARCHAR2,
X_Check_Date DATE,
X_Check_Id NUMBER,
X_Check_Number NUMBER,
X_Currency_Code VARCHAR2,
X_Last_Updated_By NUMBER,
X_Last_Update_Date DATE,
--IBY:SP X_Payment_Method_Lookup_Code VARCHAR2,
X_Payment_Type_Flag VARCHAR2,
X_Address_Line1 VARCHAR2 DEFAULT NULL,
X_Address_Line2 VARCHAR2 DEFAULT NULL,
X_Address_Line3 VARCHAR2 DEFAULT NULL,
X_Checkrun_Name VARCHAR2 DEFAULT NULL,
X_Check_Format_Id NUMBER DEFAULT NULL,
X_Check_Stock_Id NUMBER DEFAULT NULL,
X_City VARCHAR2 DEFAULT NULL,
X_Country VARCHAR2 DEFAULT NULL,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Status_Lookup_Code VARCHAR2 DEFAULT NULL,
X_Vendor_Name VARCHAR2 DEFAULT NULL,
X_Vendor_Site_Code VARCHAR2 DEFAULT NULL,
X_External_Bank_Account_Id NUMBER,
X_Zip VARCHAR2 DEFAULT NULL,
X_Bank_Account_Num VARCHAR2 DEFAULT NULL,
X_Bank_Account_Type VARCHAR2 DEFAULT NULL,
X_Bank_Num VARCHAR2 DEFAULT NULL,
X_Check_Voucher_Num NUMBER DEFAULT NULL,
X_Cleared_Amount NUMBER DEFAULT NULL,
X_Cleared_Date DATE DEFAULT NULL,
X_Doc_Category_Code VARCHAR2 DEFAULT NULL,
X_Doc_Sequence_Id NUMBER DEFAULT NULL,
X_Doc_Sequence_Value NUMBER DEFAULT NULL,
X_Province VARCHAR2 DEFAULT NULL,
X_Released_Date DATE DEFAULT NULL,
X_Released_By NUMBER DEFAULT NULL,
X_State VARCHAR2 DEFAULT NULL,
X_Stopped_Date DATE DEFAULT NULL,
X_Stopped_By NUMBER DEFAULT NULL,
X_Void_Date DATE DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Future_Pay_Due_Date DATE DEFAULT NULL,
X_Treasury_Pay_Date DATE DEFAULT NULL,
X_Treasury_Pay_Number NUMBER DEFAULT NULL,
-- Removed for bug 4277744
-- X_Ussgl_Transaction_Code VARCHAR2 DEFAULT NULL,
-- X_Ussgl_Trx_Code_Context VARCHAR2 DEFAULT NULL,
X_Withholding_Status_Lkup_Code VARCHAR2 DEFAULT NULL,
X_Reconciliation_Batch_Id NUMBER DEFAULT NULL,
X_Cleared_Base_Amount NUMBER DEFAULT NULL,
X_Cleared_Exchange_Rate NUMBER DEFAULT NULL,
X_Cleared_Exchange_Date DATE DEFAULT NULL,
X_Cleared_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
X_Address_Line4 VARCHAR2 DEFAULT NULL,
X_County VARCHAR2 DEFAULT NULL,
X_Address_Style VARCHAR2 DEFAULT NULL,
X_Org_Id NUMBER DEFAULT NULL,
X_Vendor_Id NUMBER,
X_Vendor_Site_Id NUMBER,
X_Exchange_Rate NUMBER DEFAULT NULL,
X_Exchange_Date DATE DEFAULT NULL,
X_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
X_Base_Amount NUMBER DEFAULT NULL,
X_Checkrun_Id NUMBER DEFAULT NULL,
X_global_attribute_category VARCHAR2 DEFAULT NULL,
X_global_attribute1 VARCHAR2 DEFAULT NULL,
X_global_attribute2 VARCHAR2 DEFAULT NULL,
X_global_attribute3 VARCHAR2 DEFAULT NULL,
X_global_attribute4 VARCHAR2 DEFAULT NULL,
X_global_attribute5 VARCHAR2 DEFAULT NULL,
X_global_attribute6 VARCHAR2 DEFAULT NULL,
X_global_attribute7 VARCHAR2 DEFAULT NULL,
X_global_attribute8 VARCHAR2 DEFAULT NULL,
X_global_attribute9 VARCHAR2 DEFAULT NULL,
X_global_attribute10 VARCHAR2 DEFAULT NULL,
X_global_attribute11 VARCHAR2 DEFAULT NULL,
X_global_attribute12 VARCHAR2 DEFAULT NULL,
X_global_attribute13 VARCHAR2 DEFAULT NULL,
X_global_attribute14 VARCHAR2 DEFAULT NULL,
X_global_attribute15 VARCHAR2 DEFAULT NULL,
X_global_attribute16 VARCHAR2 DEFAULT NULL,
X_global_attribute17 VARCHAR2 DEFAULT NULL,
X_global_attribute18 VARCHAR2 DEFAULT NULL,
X_global_attribute19 VARCHAR2 DEFAULT NULL,
X_global_attribute20 VARCHAR2 DEFAULT NULL,
X_transfer_priority VARCHAR2 DEFAULT NULL,
X_maturity_exchange_rate_type VARCHAR2 DEFAULT NULL,
X_maturity_exchange_date DATE DEFAULT NULL,
X_maturity_exchange_rate NUMBER DEFAULT NULL,
X_description VARCHAR2 DEFAULT NULL,
X_anticipated_value_date DATE DEFAULT NULL,
X_actual_value_date DATE DEFAULT NULL,
x_payment_method_code VARCHAR2 DEFAULT NULL,
x_payment_profile_id NUMBER DEFAULT NULL,
x_bank_charge_bearer VARCHAR2 DEFAULT NULL,
x_settlement_priority VARCHAR2 DEFAULT NULL,
x_payment_document_id NUMBER DEFAULT NULL,
x_party_id NUMBER DEFAULT NULL,
x_party_site_id NUMBER DEFAULT NULL,
x_legal_entity_id NUMBER DEFAULT NULL,
x_payment_id NUMBER DEFAULT NULL,
X_calling_sequence IN VARCHAR2,
X_Remit_To_Supplier_Name VARCHAR2 DEFAULT NULL,
X_Remit_To_Supplier_Id Number DEFAULT NULL,
X_Remit_To_Supplier_Site VARCHAR2 DEFAULT NULL,
X_Remit_To_Supplier_Site_Id NUMBER DEFAULT NULL,
X_Relationship_Id NUMBER DEFAULT NULL,
X_paycard_authorization_number VARCHAR2 DEFAULT NULL,
X_paycard_reference_id NUMBER DEFAULT NULL
) IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'AP_CHECKS_PKG.UPDATE_ROW<-' ||
X_calling_sequence;
SELECT status_lookup_code
INTO l_old_status_lookup_code
FROM ap_checks_all
WHERE rowid = X_RowID;
debug_info := 'Insert row in Ap_Payment_History for payment maturity';
X_CREATED_BY => X_last_updated_by,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => X_last_updated_by,
X_LAST_UPDATE_LOGIN => X_last_update_login,
X_PROGRAM_UPDATE_DATE => NULL,
X_PROGRAM_APPLICATION_ID => NULL,
X_PROGRAM_ID => NULL,
X_REQUEST_ID => NULL,
X_CALLING_SEQUENCE => current_calling_sequence);
debug_info := 'Delete maturity row from ap_payment_history';
X_CREATED_BY => X_last_updated_by,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => X_last_updated_by,
X_LAST_UPDATE_LOGIN => X_last_update_login,
X_PROGRAM_UPDATE_DATE => NULL,
X_PROGRAM_APPLICATION_ID => NULL,
X_PROGRAM_ID => NULL,
X_REQUEST_ID => NULL,
X_CALLING_SEQUENCE => current_calling_sequence);
debug_info := 'Update ap_checks';
AP_AC_TABLE_HANDLER_PKG.Update_Row(
X_Rowid,
X_Amount,
X_Ce_Bank_Acct_Use_Id,
X_Bank_Account_Name,
X_Check_Date,
X_Check_Id,
X_Check_Number,
X_Currency_Code,
X_Last_Updated_By,
X_Last_Update_Date,
--IBY:SP X_Payment_Method_Lookup_Code,
X_Payment_Type_Flag,
X_Address_Line1,
X_Address_Line2,
X_Address_Line3,
X_Checkrun_Name,
X_Check_Format_Id,
X_Check_Stock_Id,
X_City,
X_Country,
X_Last_Update_Login,
X_Status_Lookup_Code,
X_Vendor_Name,
X_Vendor_Site_Code,
X_External_Bank_Account_Id,
X_Zip,
X_Bank_Account_Num,
X_Bank_Account_Type,
X_Bank_Num,
X_Check_Voucher_Num,
X_Cleared_Amount,
X_Cleared_Date,
X_Doc_Category_Code,
X_Doc_Sequence_Id,
X_Doc_Sequence_Value,
X_Province,
X_Released_Date,
X_Released_By,
X_State,
X_Stopped_Date,
X_Stopped_By,
X_Void_Date,
X_Attribute1,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute15,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute_Category,
X_Future_Pay_Due_Date,
X_Treasury_Pay_Date,
X_Treasury_Pay_Number,
-- Removed for bug 4277744
-- X_Ussgl_Transaction_Code,
-- X_Ussgl_Trx_Code_Context,
X_Withholding_Status_Lkup_Code,
X_Reconciliation_Batch_Id,
X_Cleared_Base_Amount,
X_Cleared_Exchange_Rate,
X_Cleared_Exchange_Date,
X_Cleared_Exchange_Rate_Type,
X_Address_Line4,
X_County,
X_Address_Style,
X_Org_Id,
X_Vendor_Id,
X_Vendor_Site_Id,
X_Exchange_Rate,
X_Exchange_Date,
X_Exchange_Rate_Type,
X_Base_Amount,
X_Checkrun_Id,
X_global_attribute_category,
X_global_attribute1,
X_global_attribute2,
X_global_attribute3,
X_global_attribute4,
X_global_attribute5,
X_global_attribute6,
X_global_attribute7,
X_global_attribute8,
X_global_attribute9,
X_global_attribute10,
X_global_attribute11,
X_global_attribute12,
X_global_attribute13,
X_global_attribute14,
X_global_attribute15,
X_global_attribute16,
X_global_attribute17,
X_global_attribute18,
X_global_attribute19,
X_global_attribute20,
X_transfer_priority,
X_maturity_exchange_rate_type,
X_maturity_exchange_date,
X_maturity_exchange_rate,
X_description,
X_anticipated_value_date,
X_actual_value_date,
x_payment_method_code,
x_payment_profile_id,
x_bank_charge_bearer,
x_settlement_priority,
x_payment_document_id,
x_party_id,
x_party_site_id,
x_legal_entity_id,
x_payment_id,
current_calling_sequence,
X_Remit_To_Supplier_Name,
X_Remit_To_Supplier_Id,
X_Remit_To_Supplier_Site,
X_Remit_To_Supplier_Site_Id,
X_Relationship_Id,
x_paycard_authorization_number,
x_paycard_reference_id
);
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
X_calling_sequence IN VARCHAR2) IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'AP_CHECKS_PKG.DELETE_ROW<-' ||
X_calling_sequence;
debug_info := 'Delete from ap_checks';
AP_AC_TABLE_HANDLER_PKG.Delete_Row(
X_Rowid,
current_calling_sequence);
END Delete_Row;
SELECT ai.invoice_num
FROM ap_invoices ai,
ap_invoice_payments aip
WHERE aip.check_id = l_check_id
AND aip.invoice_id = ai.invoice_id;
debug_info := 'Selecting from ap_payment_history';
SELECT count(*)
INTO l_num_accounted_pay_hist
FROM ap_payment_history
WHERE check_id = X_check_id
AND transaction_type = 'PAYMENT MATURITY'
AND posted_flag = 'Y';
debug_info := 'Selecting from ap_payment_history';
SELECT count(*)
INTO l_num_pay_hist
FROM ap_payment_history
WHERE check_id = X_check_id
AND transaction_type = 'PAYMENT MATURITY';
SELECT posted_flag
FROM ap_invoice_payments_all
WHERE check_id = l_check_id
UNION ALL
SELECT posted_flag
FROM ap_payment_history aph, ap_system_parameters asp
WHERE check_id = l_check_id
AND nvl(aph.org_id, -99) = nvl(asp.org_id, -99)
AND (nvl(asp.when_to_account_pmt, 'ALWAYS') = 'ALWAYS' or
(nvl(asp.when_to_account_pmt, 'ALWAYS') = 'CLEARING ONLY' and
aph.transaction_type in
('PAYMENT CLEARING', 'PAYMENT UNCLEARING')))
;
SELECT Reg_Application_ID,
Registration_API
FROM AP_Product_Registrations
WHERE Reg_Application_ID = P_Application_ID
AND Registration_Event_Type = P_Event_Type;