[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT instrid
FROM iby_creditcard_v
WHERE ownerid = payer_id
AND instrid = nvl(l_instr_id, instrid);
SELECT instrid
FROM iby_purchasecard_v
WHERE ownerid = payer_id
AND instrid = nvl(l_instr_id, instrid);
SELECT b.ext_bank_account_id
FROM iby_ext_bank_accounts_v b,
iby_account_owners ao
WHERE ao.account_owner_party_id = payer_id
AND ao.ext_bank_account_id = b.ext_bank_account_id
AND b.ext_bank_account_id = nvl(l_instr_id, b.ext_bank_account_id);
IBY_CREDITCARD_PKG.Update_Card
(FND_API.G_FALSE,
p_pmtInstrRec.PurchaseCardInstr.Instr_Id,
p_pmtInstrRec.PurchaseCardInstr.Owner_Id,
p_pmtInstrRec.PurchaseCardInstr.PC_HolderName,
p_pmtInstrRec.PurchaseCardInstr.Billing_Address_Id,
'S',
p_pmtInstrRec.PurchaseCardInstr.Billing_PostalCode,
p_pmtInstrRec.PurchaseCardInstr.Billing_Country,
p_pmtInstrRec.PurchaseCardInstr.PC_ExpDate,
'CREDITCARD',
'Y',
p_pmtInstrRec.PurchaseCardInstr.PC_Subtype,
p_pmtInstrRec.PurchaseCardInstr.FIName,
p_pmtInstrRec.PurchaseCardInstr.Single_Use_Flag,
p_pmtInstrRec.PurchaseCardInstr.Info_Only_Flag,
p_pmtInstrRec.PurchaseCardInstr.Card_Purpose,
p_pmtInstrRec.PurchaseCardInstr.PC_Desc,
p_pmtInstrRec.PurchaseCardInstr.Active_Flag,
p_pmtInstrRec.PurchaseCardInstr.Inactive_Date,
p_pmtInstrRec.PurchaseCardInstr.attribute_category,
p_pmtInstrRec.PurchaseCardInstr.attribute1,
p_pmtInstrRec.PurchaseCardInstr.attribute2,
p_pmtInstrRec.PurchaseCardInstr.attribute3,
p_pmtInstrRec.PurchaseCardInstr.attribute4,
p_pmtInstrRec.PurchaseCardInstr.attribute5,
p_pmtInstrRec.PurchaseCardInstr.attribute6,
p_pmtInstrRec.PurchaseCardInstr.attribute7,
p_pmtInstrRec.PurchaseCardInstr.attribute8,
p_pmtInstrRec.PurchaseCardInstr.attribute9,
p_pmtInstrRec.PurchaseCardInstr.attribute10,
p_pmtInstrRec.PurchaseCardInstr.attribute11,
p_pmtInstrRec.PurchaseCardInstr.attribute12,
p_pmtInstrRec.PurchaseCardInstr.attribute13,
p_pmtInstrRec.PurchaseCardInstr.attribute14,
p_pmtInstrRec.PurchaseCardInstr.attribute15,
p_pmtInstrRec.PurchaseCardInstr.attribute16,
p_pmtInstrRec.PurchaseCardInstr.attribute17,
p_pmtInstrRec.PurchaseCardInstr.attribute18,
p_pmtInstrRec.PurchaseCardInstr.attribute19,
p_pmtInstrRec.PurchaseCardInstr.attribute20,
p_pmtInstrRec.PurchaseCardInstr.attribute21,
p_pmtInstrRec.PurchaseCardInstr.attribute22,
p_pmtInstrRec.PurchaseCardInstr.attribute23,
p_pmtInstrRec.PurchaseCardInstr.attribute24,
p_pmtInstrRec.PurchaseCardInstr.attribute25,
p_pmtInstrRec.PurchaseCardInstr.attribute26,
p_pmtInstrRec.PurchaseCardInstr.attribute27,
p_pmtInstrRec.PurchaseCardInstr.attribute28,
p_pmtInstrRec.PurchaseCardInstr.attribute29,
p_pmtInstrRec.PurchaseCardInstr.attribute30,
x_result.Result_Code
);
IBY_CREDITCARD_PKG.Update_Card
(FND_API.G_FALSE,
p_pmtInstrRec.CreditCardInstr.Instr_Id,
p_pmtInstrRec.CreditCardInstr.Owner_Id,
p_pmtInstrRec.CreditCardInstr.CC_HolderName,
p_pmtInstrRec.CreditCardInstr.Billing_Address_Id,
'S',
p_pmtInstrRec.CreditCardInstr.Billing_PostalCode,
p_pmtInstrRec.CreditCardInstr.Billing_Country,
p_pmtInstrRec.CreditCardInstr.CC_ExpDate,
'CREDITCARD',
'N',
NULL,
p_pmtInstrRec.CreditCardInstr.FIName,
p_pmtInstrRec.CreditCardInstr.Single_Use_Flag,
p_pmtInstrRec.CreditCardInstr.Info_Only_Flag,
p_pmtInstrRec.CreditCardInstr.Card_Purpose,
p_pmtInstrRec.CreditCardInstr.CC_Desc,
p_pmtInstrRec.CreditCardInstr.Active_Flag,
p_pmtInstrRec.CreditCardInstr.Inactive_Date,
p_pmtInstrRec.CreditCardInstr.attribute_category,
p_pmtInstrRec.CreditCardInstr.attribute1,
p_pmtInstrRec.CreditCardInstr.attribute2,
p_pmtInstrRec.CreditCardInstr.attribute3,
p_pmtInstrRec.CreditCardInstr.attribute4,
p_pmtInstrRec.CreditCardInstr.attribute5,
p_pmtInstrRec.CreditCardInstr.attribute6,
p_pmtInstrRec.CreditCardInstr.attribute7,
p_pmtInstrRec.CreditCardInstr.attribute8,
p_pmtInstrRec.CreditCardInstr.attribute9,
p_pmtInstrRec.CreditCardInstr.attribute10,
p_pmtInstrRec.CreditCardInstr.attribute11,
p_pmtInstrRec.CreditCardInstr.attribute12,
p_pmtInstrRec.CreditCardInstr.attribute13,
p_pmtInstrRec.CreditCardInstr.attribute14,
p_pmtInstrRec.CreditCardInstr.attribute15,
p_pmtInstrRec.CreditCardInstr.attribute16,
p_pmtInstrRec.CreditCardInstr.attribute17,
p_pmtInstrRec.CreditCardInstr.attribute18,
p_pmtInstrRec.CreditCardInstr.attribute19,
p_pmtInstrRec.CreditCardInstr.attribute20,
p_pmtInstrRec.CreditCardInstr.attribute21,
p_pmtInstrRec.CreditCardInstr.attribute22,
p_pmtInstrRec.CreditCardInstr.attribute23,
p_pmtInstrRec.CreditCardInstr.attribute24,
p_pmtInstrRec.CreditCardInstr.attribute25,
p_pmtInstrRec.CreditCardInstr.attribute26,
p_pmtInstrRec.CreditCardInstr.attribute27,
p_pmtInstrRec.CreditCardInstr.attribute28,
p_pmtInstrRec.CreditCardInstr.attribute29,
p_pmtInstrRec.CreditCardInstr.attribute30,
x_result.Result_Code
);
IBY_INSTRHOLDER_PKG.deleteHolderInstr( NULL,
g_owner_type,
p_payer_id,
NULL,
p_instr_id
);
SELECT count(*) INTO l_count
FROM IBY_INSTRHOLDER
WHERE ownerid = p_payer_id
AND activestatus = 1;
SELECT count(*) INTO l_count
FROM IBY_INSTRHOLDER
WHERE ownerid = p_payer_id
AND activestatus = 1;
SELECT count(*) INTO l_count
FROM IBY_INSTRHOLDER
WHERE instrid = p_instr_id
AND activestatus = 1;
SELECT count(*) INTO l_count
FROM IBY_INSTRHOLDER
WHERE instrid = p_instr_id
AND ownerid = p_payer_id
AND activestatus = 1;