APPS.ASO_PAYMENT_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

  select payment_term_id from aso_payments
  where   quote_line_id   = p_qte_line_id
  and     quote_header_id = p_qte_header_id;

Line: 29

  select payment_term_id from aso_payments
  where  quote_header_id = p_qte_header_id;

Line: 266

 select party_id
 from iby_fndcpt_payer_assgn_instr_v
 where instr_assignment_id = p_assignment_id;

Line: 271

 SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;

Line: 274

 select payment_id
 from aso_payments
 where quote_header_id = p_qte_hdr_id
 and quote_line_id is null;

Line: 280

 select payment_id
 from aso_payments
 where quote_header_id = p_qte_hdr_id
 and quote_line_id = p_qte_line_id;

Line: 562

              aso_debug_pub.add('Before calling the table handler to insert the data ', 1, 'Y');

Line: 566

     ASO_PAYMENTS_PKG.Insert_Row(
            px_PAYMENT_ID                 => l_payment_rec.PAYMENT_ID,
            p_CREATION_DATE               => SYSDATE,
            p_CREATED_BY                  => fnd_global.USER_ID,
            p_LAST_UPDATE_DATE            => SYSDATE,
            p_LAST_UPDATED_BY             => fnd_global.USER_ID,
            p_LAST_UPDATE_LOGIN           => FND_GLOBAL.CONC_LOGIN_ID,
            p_REQUEST_ID                  => l_payment_rec.REQUEST_ID,
            p_PROGRAM_APPLICATION_ID      => l_payment_rec.PROGRAM_APPLICATION_ID,
            p_PROGRAM_ID                  => l_payment_rec.PROGRAM_ID,
            p_PROGRAM_UPDATE_DATE         => l_payment_rec.PROGRAM_UPDATE_DATE,
            p_QUOTE_HEADER_ID             => l_payment_rec.QUOTE_HEADER_ID,
            p_QUOTE_LINE_ID               => l_payment_rec.QUOTE_LINE_ID,
            p_QUOTE_SHIPMENT_ID           => l_payment_rec.QUOTE_SHIPMENT_ID ,
            p_PAYMENT_TYPE_CODE           => l_payment_rec.PAYMENT_TYPE_CODE,
            p_PAYMENT_REF_NUMBER          => l_payment_ref_number,
            p_PAYMENT_OPTION              => l_payment_rec.PAYMENT_OPTION,
            p_PAYMENT_TERM_ID             => l_payment_rec.PAYMENT_TERM_ID,
            p_CREDIT_CARD_CODE            => null,
            p_CREDIT_CARD_HOLDER_NAME     => null,
            p_CREDIT_CARD_EXPIRATION_DATE => null,
            p_CREDIT_CARD_APPROVAL_CODE   => null,
            p_CREDIT_CARD_APPROVAL_DATE   => null,
            p_PAYMENT_AMOUNT              => l_payment_rec.PAYMENT_AMOUNT,
            p_ATTRIBUTE_CATEGORY          => l_payment_rec.ATTRIBUTE_CATEGORY,
            p_ATTRIBUTE1                  => l_payment_rec.ATTRIBUTE1,
            p_ATTRIBUTE2                  => l_payment_rec.ATTRIBUTE2,
            p_ATTRIBUTE3                  => l_payment_rec.ATTRIBUTE3,
            p_ATTRIBUTE4                  => l_payment_rec.ATTRIBUTE4,
            p_ATTRIBUTE5                  => l_payment_rec.ATTRIBUTE5,
            p_ATTRIBUTE6                  => l_payment_rec.ATTRIBUTE6,
            p_ATTRIBUTE7                  => l_payment_rec.ATTRIBUTE7,
            p_ATTRIBUTE8                  => l_payment_rec.ATTRIBUTE8,
            p_ATTRIBUTE9                  => l_payment_rec.ATTRIBUTE9,
            p_ATTRIBUTE10                 => l_payment_rec.ATTRIBUTE10,
            p_ATTRIBUTE11                 => l_payment_rec.ATTRIBUTE11,
            p_ATTRIBUTE12                 => l_payment_rec.ATTRIBUTE12,
            p_ATTRIBUTE13                 => l_payment_rec.ATTRIBUTE13,
            p_ATTRIBUTE14                 => l_payment_rec.ATTRIBUTE14,
            p_ATTRIBUTE15                 => l_payment_rec.ATTRIBUTE15,
           p_ATTRIBUTE16                 => l_payment_rec.ATTRIBUTE16,
            p_ATTRIBUTE17                 => l_payment_rec.ATTRIBUTE17,
            p_ATTRIBUTE18                 => l_payment_rec.ATTRIBUTE18,
            p_ATTRIBUTE19                 => l_payment_rec.ATTRIBUTE19,
            p_ATTRIBUTE20                 => l_payment_rec.ATTRIBUTE20,
          p_CUST_PO_NUMBER              => l_payment_rec.CUST_PO_NUMBER,
           p_PAYMENT_TERM_ID_FROM        => l_payment_rec.PAYMENT_TERM_ID_FROM,
          p_OBJECT_VERSION_NUMBER       => l_payment_rec.OBJECT_VERSION_NUMBER,
            p_CUST_PO_LINE_NUMBER         => l_payment_rec.CUST_PO_LINE_NUMBER,
            p_trxn_extension_id           => lx_entity_id
          );

Line: 665

PROCEDURE update_payment_row(p_payment_rec   IN         aso_quote_pub.payment_rec_type,
                             x_payment_rec   OUT NOCOPY aso_quote_pub.payment_rec_type,
                             x_return_status OUT NOCOPY varchar2,
                             x_msg_count     OUT NOCOPY number,
                             x_msg_data      OUT NOCOPY varchar2) is

l_api_name            varchar2(1000) := 'update_payment_row';

Line: 690

/*** Start : Code Added for Bug 8712439 for HTML Quoting PA-DSS update issue ***/
lc_payment_rec        aso_quote_pub.payment_rec_type := p_payment_rec;

Line: 692

/*** End : Code Added for Bug 8712439 for HTML Quoting PA-DSS update issue ***/


 Cursor c_get_payer_id ( p_assignment_id NUMBER) is
 select party_id
 from iby_fndcpt_payer_assgn_instr_v
 where instr_assignment_id = p_assignment_id;

Line: 703

 select a.party_id
 from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b
 where a.instr_assignment_id = b.instr_assignment_id
 and b.trxn_extension_id = p_trxn_extension_id;

Line: 713

SELECT p.party_id
FROM fnd_lookup_values_vl ccunk,
  iby_creditcard c,
  iby_creditcard_issuers_vl i,
  iby_external_payers_all p,
  iby_ext_bank_accounts_v b,
  iby_pmt_instr_uses_all u,
  hz_parties hzcc,
  IBY_TRXN_EXTENSIONS_V t
WHERE(u.ext_pmt_party_id = p.ext_payer_id)
 AND(decode(u.instrument_type,   'CREDITCARD',   u.instrument_id,   'DEBITCARD',   u.instrument_id,   NULL) = c.instrid(+))
 AND(decode(u.instrument_type,   'BANKACCOUNT',   u.instrument_id,   NULL) = b.bank_account_id(+))
 AND(c.card_issuer_code = i.card_issuer_code(+))
 AND(c.card_owner_id = hzcc.party_id(+))
 AND(u.payment_flow = 'FUNDS_CAPTURE')
 --AND(nvl(c.inactive_date,   sysdate + 10) > sysdate) /***  Commented to get all the creditcard records for bug 9751000 ***/
 AND(ccunk.lookup_type = 'IBY_CARD_TYPES')
 AND(ccunk.lookup_code = 'UNKNOWN')
 AND u.instrument_payment_use_id = t.instr_assignment_id
 AND t.trxn_extension_id = p_trxn_extension_id;

Line: 736

 select authorized_flag
 from IBY_TRXN_EXTENSIONS_V
 where trxn_extension_id = p_trxn_extension_id;

Line: 745

     SAVEPOINT UPDATE_PAYMENT_ROW_INT;

Line: 750

         aso_debug_pub.add('Begin update_payment_row ', 1, 'Y');

Line: 771

     /*** Start : Code Added for Bug 8712439 for HTML Quoting PA-DSS update issue ***/

     If (nvl(l_db_payment_rec.payment_type_code,'NULL') = 'CREDIT_CARD') And
        (l_payment_rec.payment_type_code Is Null Or l_payment_rec.payment_type_code = fnd_api.g_miss_char) Then

         IF aso_debug_pub.g_debug_flag = 'Y' THEN
            aso_debug_pub.add('Database payment_type_code is CREDIT_CARD ', 1, 'Y');

Line: 799

     /*** End : Code Added for Bug 8712439 for HTML Quoting PA-DSS update issue ***/

     IF aso_debug_pub.g_debug_flag = 'Y' THEN
              aso_debug_pub.add('Database payment_type_code is : '||l_db_payment_rec.payment_type_code, 1, 'Y');

Line: 1013

              aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');

Line: 1019

            IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
            (
            p_api_version       => 1.0,
            p_init_msg_list     => FND_API.G_FALSE,
            p_commit            => FND_API.G_FALSE,
            x_return_status     => x_return_status,
            x_msg_count         => x_msg_count,
            x_msg_data          => x_msg_data,
            p_payer             => l_payer,
            p_entity_id         => l_db_payment_rec.trxn_extension_id,
            p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
            x_response          => lx_response
            );

Line: 1034

              aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');

Line: 1035

              aso_debug_pub.add('Return Status from IBY Delete API:                       '||x_return_status, 1, 'Y');

Line: 1036

              aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code:     '|| to_char(lx_response.result_code), 1, 'Y');

Line: 1037

              aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');

Line: 1038

              aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message:  '|| to_char(lx_response.result_message), 1, 'Y');

Line: 1044

                 FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);

Line: 1077

	    /***Bug 8712439: Passing lc_payment_rec with 'CREDIT_CARD' as payment type code for HTML Quoting PA-DSS update issue ***/

             aso_payment_int.create_iby_payment(p_payment_rec   => lc_payment_rec, --p_payment_rec,
                                                db_payment_rec  => l_db_payment_rec,
						p_payer         => l_payer,
						x_payment_rec   => l_payment_rec,
                                                x_return_status => x_return_status ,
                                                x_msg_count     => x_msg_count,
                                                x_msg_data      => x_msg_data);

Line: 1143

              aso_debug_pub.add('Before calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');

Line: 1146

             IBY_FNDCPT_SETUP_PUB.Update_Card
                 (
                 p_api_version       => 1.0,
                 p_init_msg_list     => FND_API.G_FALSE,
                 p_commit            => FND_API.G_FALSE,
                 x_return_status     => x_return_status,
                 x_msg_count         => x_msg_count,
                 x_msg_data          => x_msg_data,
                 p_card_instrument  =>  l_card_instrument,
                 x_response         =>  lx_response);

Line: 1157

            aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');

Line: 1167

                 FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Update_Card', FALSE);

Line: 1271

                   aso_debug_pub.add('update_payment_row , l_authorized_flag : '||l_authorized_flag, 1, 'Y');

Line: 1278

                   aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');

Line: 1282

			  IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension
                    (
                    p_api_version       => 1.0,
                    p_init_msg_list     => FND_API.G_FALSE,
                    p_commit            => FND_API.G_FALSE,
                    x_return_status     => x_return_status,
                    x_msg_count         => x_msg_count,
                    x_msg_data          => x_msg_data,
                    p_payer             => l_payer,
                    p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
                    p_entity_id        =>   l_db_payment_rec.trxn_extension_id,
		          p_pmt_channel       => l_db_payment_rec.payment_type_code,
                    p_instr_assignment  => l_payment_rec.instr_assignment_id,
                    p_trxn_attribs      => l_trxn_attribs,
                    x_response          => lx_response);

Line: 1299

                       aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');

Line: 1330

                     aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');

Line: 1335

                    IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
                     (
                     p_api_version       => 1.0,
                     p_init_msg_list     => FND_API.G_FALSE,
                     p_commit            => FND_API.G_FALSE,
                     x_return_status     => x_return_status,
                     x_msg_count         => x_msg_count,
                     x_msg_data          => x_msg_data,
                     p_payer             => l_payer,
                     p_entity_id         => l_db_payment_rec.trxn_extension_id,
                     p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
                     x_response          => lx_response
                     );

Line: 1350

                        aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');

Line: 1351

                        aso_debug_pub.add('Return Status from IBY Delete API:                       '||x_return_status, 1, 'Y');

Line: 1352

                        aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code:     '|| to_char(lx_response.result_code), 1, 'Y');

Line: 1353

                        aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');

Line: 1354

                        aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message:  '|| to_char(lx_response.result_message), 1, 'Y');

Line: 1360

                           FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);

Line: 1381

                 aso_debug_pub.add('No trx ext id exists for cc iStore Fax CC being updated ', 1, 'Y');

Line: 1474

              aso_debug_pub.add('before calling the table handler to update  the data ', 1, 'Y');

Line: 1477

	ASO_PAYMENTS_PKG.Update_Row(
	    p_PAYMENT_ID                           => l_payment_rec.PAYMENT_ID,
	    p_CREATION_DATE                        => l_payment_rec.creation_date,
	    p_CREATED_BY                           => fnd_global.USER_ID,
	    p_LAST_UPDATE_DATE	                  => sysdate,
	    p_LAST_UPDATED_BY                      => fnd_global.USER_ID,
	    p_LAST_UPDATE_LOGIN                    => FND_GLOBAL.CONC_LOGIN_ID,
	    p_REQUEST_ID                           => l_payment_rec.REQUEST_ID,
	    p_PROGRAM_APPLICATION_ID               => l_payment_rec.PROGRAM_APPLICATION_ID,
	    p_PROGRAM_ID                           => l_payment_rec.PROGRAM_ID,
	    p_PROGRAM_UPDATE_DATE                  => l_payment_rec.PROGRAM_UPDATE_DATE,
	    p_QUOTE_HEADER_ID                      => l_payment_rec.quote_header_id,
	    p_QUOTE_LINE_ID                        => l_payment_rec.QUOTE_LINE_ID,
	    p_PAYMENT_TYPE_CODE                    => l_payment_rec.PAYMENT_TYPE_CODE,
	    p_PAYMENT_REF_NUMBER                   => l_payment_ref_number,
	    p_PAYMENT_OPTION                       => l_payment_rec.PAYMENT_OPTION,
	    p_PAYMENT_TERM_ID                      => l_payment_rec.PAYMENT_TERM_ID,
	    p_CREDIT_CARD_CODE	                  => null,
	    p_CREDIT_CARD_HOLDER_NAME              => null,
	    p_CREDIT_CARD_EXPIRATION_DATE          => null,
	    p_CREDIT_CARD_APPROVAL_CODE            => null,
	    p_CREDIT_CARD_APPROVAL_DATE            => null,
	    p_PAYMENT_AMOUNT                       => l_payment_rec.PAYMENT_AMOUNT,
	    p_ATTRIBUTE_CATEGORY                   => l_payment_rec.ATTRIBUTE_CATEGORY,
	    p_ATTRIBUTE1                           => l_payment_rec.ATTRIBUTE1,
	    p_ATTRIBUTE2                           => l_payment_rec.ATTRIBUTE2,
	    p_ATTRIBUTE3                           => l_payment_rec.ATTRIBUTE3,
	    p_ATTRIBUTE4                           => l_payment_rec.ATTRIBUTE4,
	    p_ATTRIBUTE5                           => l_payment_rec.ATTRIBUTE5,
	    p_ATTRIBUTE6                           => l_payment_rec.ATTRIBUTE6,
	    p_ATTRIBUTE7                           => l_payment_rec.ATTRIBUTE7,
	    p_ATTRIBUTE8                           => l_payment_rec.ATTRIBUTE8,
	    p_ATTRIBUTE9                           => l_payment_rec.ATTRIBUTE9,
	    p_ATTRIBUTE10                          => l_payment_rec.ATTRIBUTE10,
	    p_ATTRIBUTE11                          => l_payment_rec.ATTRIBUTE11,
	    p_ATTRIBUTE12                          => l_payment_rec.ATTRIBUTE12,
	    p_ATTRIBUTE13                          => l_payment_rec.ATTRIBUTE13,
	    p_ATTRIBUTE14                          => l_payment_rec.ATTRIBUTE14,
	    p_ATTRIBUTE15                          => l_payment_rec.ATTRIBUTE15,
         p_ATTRIBUTE16                          => l_payment_rec.ATTRIBUTE16,
         p_ATTRIBUTE17                          => l_payment_rec.ATTRIBUTE17,
         p_ATTRIBUTE18                          => l_payment_rec.ATTRIBUTE18,
         p_ATTRIBUTE19                          => l_payment_rec.ATTRIBUTE19,
         p_ATTRIBUTE20                          => l_payment_rec.ATTRIBUTE20,
		p_QUOTE_SHIPMENT_ID                   => l_payment_rec.QUOTE_SHIPMENT_ID,
	    p_CUST_PO_NUMBER                       => l_payment_rec.CUST_PO_NUMBER,
           p_PAYMENT_TERM_ID_FROM               => l_payment_rec.PAYMENT_TERM_ID_FROM,
		 p_OBJECT_VERSION_NUMBER              => l_payment_rec.OBJECT_VERSION_NUMBER,
          p_CUST_PO_LINE_NUMBER                 => l_payment_rec.CUST_PO_LINE_NUMBER,
		p_TRXN_EXTENSION_ID                   => l_payment_rec.trxn_extension_id
	    );

Line: 1548

      aso_debug_pub.ADD ('END update_payment_row',1,'N');

Line: 1581

end  update_payment_row;

Line: 1584

PROCEDURE delete_payment_row(p_payment_rec   IN         aso_quote_pub.payment_rec_type,
                             x_return_status OUT NOCOPY varchar2,
                             x_msg_count     OUT NOCOPY number,
                             x_msg_data      OUT NOCOPY varchar2)
IS

  L_API_NAME            varchar2(1000) := 'delete_payment_row';

Line: 1600

 select a.party_id
 from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b
 where a.instr_assignment_id = b.instr_assignment_id
 and b.trxn_extension_id = p_trxn_extension_id;

Line: 1607

     SAVEPOINT DELETE_PAYMENT_ROW_INT;

Line: 1611

         aso_debug_pub.add('Begin delete_payment_row ', 1, 'Y');

Line: 1646

              aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');

Line: 1651

            IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
            (
            p_api_version       => 1.0,
            p_init_msg_list     => FND_API.G_FALSE,
            p_commit            => FND_API.G_FALSE,
            x_return_status     => x_return_status,
            x_msg_count         => x_msg_count,
            x_msg_data          => x_msg_data,
            p_payer             => l_payer,
            p_entity_id         => l_payment_rec.trxn_extension_id,
            p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
		  x_response          => lx_response
            );

Line: 1666

              aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');

Line: 1667

              aso_debug_pub.add('Return Status from IBY Delete API:                       '||x_return_status, 1, 'Y');

Line: 1668

              aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code:     '|| to_char(lx_response.result_code), 1, 'Y');

Line: 1669

              aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');

Line: 1670

              aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message:  '|| to_char(lx_response.result_message), 1, 'Y');

Line: 1676

                 FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);

Line: 1687

     ASO_PAYMENTS_PKG.Delete_Row(p_PAYMENT_ID => p_payment_rec.PAYMENT_ID);

Line: 1702

      aso_debug_pub.ADD ('END delete_payment_row',1,'N');

Line: 1735

End delete_payment_row;

Line: 1742

     UPDATE ASO_PAYMENTS
     SET    CREDIT_CARD_EXPIRATION_DATE = NULL,
            CREDIT_CARD_HOLDER_NAME = NULL,
            PAYMENT_REF_NUMBER = NULL
     WHERE  PAYMENT_TYPE_CODE = 'CREDIT_CARD';