eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: 258


 select party_id
 from iby_fndcpt_payer_assgn_instr_v
 where instr_assignment_id = p_assignment_id;

Line: 263


 SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;

Line: 266


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

Line: 272


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

Line: 554


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

Line: 558


     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: 657


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: 684


 select party_id
 from iby_fndcpt_payer_assgn_instr_v
 where instr_assignment_id = p_assignment_id;

Line: 689


 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: 696


     SAVEPOINT UPDATE_PAYMENT_ROW_INT;

Line: 701


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

Line: 931


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

Line: 937


            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: 952


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

Line: 953


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

Line: 954


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

Line: 955


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

Line: 956


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

Line: 962


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

Line: 1059


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

Line: 1062


             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: 1073


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

Line: 1083


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

Line: 1182


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

Line: 1186


			  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: 1203


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

Line: 1232


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

Line: 1237


                    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: 1252


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

Line: 1253


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

Line: 1254


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

Line: 1255


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

Line: 1256


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

Line: 1262


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

Line: 1283


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

Line: 1376


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

Line: 1379


	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: 1450


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

Line: 1483


end  update_payment_row;

Line: 1486


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: 1502


 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: 1509


     SAVEPOINT DELETE_PAYMENT_ROW_INT;

Line: 1513


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

Line: 1548


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

Line: 1553


            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: 1568


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

Line: 1569


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

Line: 1570


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

Line: 1571


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

Line: 1572


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

Line: 1578


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

Line: 1589


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

Line: 1604


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

Line: 1637


End delete_payment_row;