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.AR_BILLS_CREATION_PUB SQL Statements

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

Line: 32


C_DELETE		CONSTANT VARCHAR2(30)	:=	'DELETE'				;

Line: 238


	ARP_PROCESS_BR_HEADER.insert_header  (  l_trx_rec		,
						l_gl_date		,
						l_new_trx_number	,
						l_customer_trx_id	);

Line: 332


 |    Update_BR_Header			                                     	|
 |                                                                           	|
 | DESCRIPTION                                                               	|
 |    Updates BR Header information					     	|
 |									  	|
 +==============================================================================*/


PROCEDURE Update_BR_Header (

           --   *****  Standard API parameters *****
                p_api_version      		IN  NUMBER			,
                p_init_msg_list    		IN  VARCHAR2 := FND_API.G_TRUE	,
                p_commit           		IN  VARCHAR2 := FND_API.G_FALSE	,
                p_validation_level 		IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
                x_return_status    		OUT NOCOPY VARCHAR2			,
                x_msg_count        		OUT NOCOPY NUMBER			,
                x_msg_data         		OUT NOCOPY VARCHAR2			,

           --   *****  BR Header info. parameters *****
		p_customer_trx_id		IN  NUMBER	DEFAULT NULL	,
		p_term_due_date			IN  DATE	DEFAULT NULL	,
		p_cust_trx_type_id		IN  NUMBER	DEFAULT NULL	,
		p_invoice_currency_code 	IN  VARCHAR2	DEFAULT NULL	,
		p_br_amount			IN  NUMBER	DEFAULT NULL	,
		p_trx_date			IN  DATE	DEFAULT NULL	,
		p_gl_date			IN  DATE	DEFAULT NULL	,
		p_drawee_id			IN  NUMBER	DEFAULT NULL	,
		p_drawee_site_use_id		IN  NUMBER	DEFAULT NULL	,
		p_drawee_contact_id		IN  NUMBER	DEFAULT NULL	,
		p_printing_option		IN  VARCHAR2	DEFAULT NULL	,
		p_comments			IN  VARCHAR2	DEFAULT NULL	,
		p_special_instructions		IN  VARCHAR2	DEFAULT NULL	,
		p_drawee_bank_account_id     	IN  NUMBER	DEFAULT NULL	,
		p_remittance_bank_account_id 	IN  NUMBER 	DEFAULT NULL	,
		p_override_remit_account_flag	IN  VARCHAR2	DEFAULT NULL	,
		p_doc_sequence_id		IN  NUMBER	DEFAULT NULL	,
		p_doc_sequence_value		IN  NUMBER	DEFAULT NULL	,
		p_created_from			IN  VARCHAR2	DEFAULT NULL	,

           --   ***** Descriptive Flexfield parameters *****
                p_attribute_category		IN  VARCHAR2	DEFAULT NULL	,
		p_attribute1			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute2			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute3			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute4			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute5			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute6			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute7			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute8			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute9			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute10			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute11			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute12			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute13			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute14			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute15			IN  VARCHAR2	DEFAULT NULL	,
                p_customer_reference            IN  VARCHAR2    DEFAULT NULL    ,
                p_le_id                         IN  NUMBER      DEFAULT NULL    ,
                p_payment_trxn_extn_id          IN  NUMBER      DEFAULT NULL)

IS
		l_api_name			CONSTANT VARCHAR2(20)	:=	'Update_BR_Header';

Line: 406


           arp_util.debug('AR_BILLS_CREATION_PUB.Update_BR_Header()+ ');

Line: 416


      	SAVEPOINT Update_BR_Header_PVT;

Line: 497


	AR_BILLS_CREATION_LIB_PVT.Default_Update_BR_Header  (l_trx_rec);

Line: 504


        AR_BILLS_CREATION_VAL_PVT.Validate_Update_BR_Header (l_trx_rec,	l_gl_date);

Line: 511


	ARP_PROCESS_BR_HEADER.update_header  (  l_trx_rec, l_trx_rec.customer_trx_id);

Line: 530


		l_trh_rec.event			:=	'MATURITY_DATE_UPDATED';

Line: 540


		ARP_PROC_TRANSACTION_HISTORY.insert_transaction_history (l_trh_rec,
								 	 l_trh_rec.transaction_history_id);

Line: 549


			arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);

Line: 552


		ARP_PROC_TRANSACTION_HISTORY.update_transaction_history (l_trh_rec,
								 	 l_trh_rec.transaction_history_id);

Line: 558


        |   Update the Payment Schedule Information    	|
        +-----------------------------------------------*/

	IF  (l_trh_rec.status not in (C_INCOMPLETE, C_PENDING_ACCEPTANCE, C_CANCELLED))
	THEN
		AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);

Line: 571


		arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);

Line: 589


           arp_util.debug('AR_BILLS_CREATION_PUB.Update_BR_Header()- ');

Line: 599


                ROLLBACK TO Update_BR_Header_PVT;

Line: 613


                ROLLBACK TO Update_BR_Header_PVT;

Line: 634


                ROLLBACK TO Update_BR_Header_PVT;

Line: 645


END Update_BR_Header;

Line: 650


 |    Delete_BR_Header			                                     	|
 |                                                                           	|
 | DESCRIPTION                                                               	|
 |    Delete BR Header information					     	|
 |									  	|
 +==============================================================================*/

PROCEDURE Delete_BR_Header (

           --   *****  Standard API parameters *****
                p_api_version      		IN  NUMBER			,
                p_init_msg_list    		IN  VARCHAR2 := FND_API.G_TRUE	,
                p_commit           		IN  VARCHAR2 := FND_API.G_FALSE	,
                p_validation_level 		IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
                x_return_status    		OUT NOCOPY VARCHAR2			,
                x_msg_count        		OUT NOCOPY NUMBER			,
                x_msg_data         		OUT NOCOPY VARCHAR2			,

           --   *****  BR Header info. parameters *****
		p_customer_trx_id		IN  NUMBER	DEFAULT NULL	)

IS
		l_api_name			CONSTANT VARCHAR2(20)	:=	'Delete_BR_Header';

Line: 679


		l_select_remit_flag		VARCHAR2(1);

Line: 680


		l_deselect_remit_flag		VARCHAR2(1);

Line: 692


		l_delete_flag			VARCHAR2(1);

Line: 699


       	   arp_util.debug('AR_BILLS_CREATION_PUB.Delete_BR_Header()+ ');

Line: 709


      	SAVEPOINT Delete_BR_Header_PVT;

Line: 750


		p_select_remit_flag	=>	l_select_remit_flag	,
		p_deselect_remit_flag	=>	l_deselect_remit_flag	,
		p_approve_remit_flag	=>	l_approve_remit_flag	,
		p_hold_flag		=>	l_hold_flag		,
		p_unhold_flag		=>	l_unhold_flag		,
		p_recall_flag		=>	l_recall_flag		,
		p_eliminate_flag	=>	l_eliminate_flag	,
		p_uneliminate_flag	=>	l_uneliminate_flag	,
		p_unpaid_flag		=>	l_unpaid_flag		,
		p_protest_flag		=>	l_protest_flag		,
		p_endorse_flag		=>	l_endorse_flag		,
		p_restate_flag		=>	l_restate_flag		,
		p_exchange_flag		=>	l_exchange_flag		,
		p_delete_flag		=>	l_delete_flag		);

Line: 769


	IF	(l_delete_flag	<>	'Y')
	THEN
		ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);

Line: 773


		   arp_util.debug(  '>>>>>>>>>> The Action Delete is not allowed on the BR ' || p_customer_trx_id);

Line: 776


		FND_MESSAGE.set_token	( 'ACTION', C_DELETE);

Line: 793


	ARP_PROCESS_BR_HEADER.delete_header  (p_customer_trx_id);

Line: 809


           arp_util.debug('AR_BILLS_CREATION_PUB.Delete_BR_Header()- ');

Line: 820


                ROLLBACK TO Delete_BR_Header_PVT;

Line: 833


                ROLLBACK TO Delete_BR_Header_PVT;

Line: 853


		ROLLBACK TO Delete_BR_Header_PVT;

Line: 864


END Delete_BR_Header;

Line: 1267


	ARP_PROCESS_BR_LINE.insert_line (l_trl_rec, l_customer_trx_line_id);

Line: 1306


		arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
									 l_trh_rec.transaction_history_id);

Line: 1396


 |    Update_BR_Assignment			                               	|
 |                                                                           	|
 | DESCRIPTION                                                               	|
 |    Update BR Assignment information					     	|
 |									  	|
 +==============================================================================*/


PROCEDURE Update_BR_Assignment (

           --   *****  Standard API parameters *****
                p_api_version      		IN  NUMBER			,
                p_init_msg_list    		IN  VARCHAR2 := FND_API.G_TRUE	,
                p_commit           		IN  VARCHAR2 := FND_API.G_FALSE	,
                p_validation_level 		IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
                x_return_status    		OUT NOCOPY VARCHAR2			,
                x_msg_count        		OUT NOCOPY NUMBER			,
                x_msg_data         		OUT NOCOPY VARCHAR2			,

           --   *****  BR Assignment information parameters *****
		p_customer_trx_id		IN  NUMBER	DEFAULT NULL	,
		p_customer_trx_line_id		IN  NUMBER	DEFAULT NULL	,
		p_br_ref_payment_schedule_id	IN  NUMBER	DEFAULT NULL	,
		p_assigned_amount		IN  NUMBER	DEFAULT NULL	,

           --   ***** Descriptive Flexfield parameters *****
                p_attribute_category		IN  VARCHAR2	DEFAULT NULL	,
		p_attribute1			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute2			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute3			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute4			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute5			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute6			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute7			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute8			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute9			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute10			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute11			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute12			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute13			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute14			IN  VARCHAR2	DEFAULT NULL	,
		p_attribute15			IN  VARCHAR2	DEFAULT NULL	)

IS
		l_api_name			CONSTANT VARCHAR2(20)	:=	'Update_BR_Assignment';

Line: 1452


	   arp_util.debug('AR_BILLS_CREATION_PUB.Update_BR_Assignment()+ ');

Line: 1463


      	SAVEPOINT Update_BR_Assignment_PVT;

Line: 1554


	ARP_PROCESS_BR_LINE.update_line  (l_trl_rec.customer_trx_line_id, l_trl_rec);

Line: 1570


           arp_util.debug('AR_BILLS_CREATION_PUB.Update_BR_Assignment()- ');

Line: 1580


                ROLLBACK TO Update_BR_Assignment_PVT;

Line: 1590


                ROLLBACK TO Update_BR_Assignment_PVT;

Line: 1608


		ROLLBACK TO Update_BR_Assignment_PVT;

Line: 1619


END Update_BR_Assignment;

Line: 1626


 |    Delete_BR_Assignment			                               	|
 |                                                                           	|
 | DESCRIPTION                                                               	|
 |    Delete BR Assignment information					     	|
 |									  	|
 +==============================================================================*/


PROCEDURE Delete_BR_Assignment (

           --   *****  Standard API parameters *****
                p_api_version      		IN  NUMBER			,
                p_init_msg_list    		IN  VARCHAR2 := FND_API.G_TRUE	,
                p_commit           		IN  VARCHAR2 := FND_API.G_FALSE	,
                p_validation_level 		IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
                x_return_status    		OUT NOCOPY VARCHAR2			,
                x_msg_count        		OUT NOCOPY NUMBER			,
                x_msg_data         		OUT NOCOPY VARCHAR2			,

           --   *****  BR Assignment information parameters *****
		p_customer_trx_id		IN  NUMBER	DEFAULT NULL	,
		p_customer_trx_line_id		IN  NUMBER	DEFAULT NULL	)

IS
		l_api_name			CONSTANT VARCHAR2(20)	:=	'Delete_BR_Assignment';

Line: 1659


       	   arp_util.debug('AR_BILLS_CREATION_PUB.Delete_BR_Assignment()+ ');

Line: 1669


      	SAVEPOINT Delete_BR_Assignment_PVT;

Line: 1722


	ARP_PROCESS_BR_LINE.Delete_line  (p_customer_trx_line_id, l_trl_rec.customer_trx_id);

Line: 1737


           arp_util.debug('AR_BILLS_CREATION_PUB.Delete_BR_Assignment()- ');

Line: 1748


                ROLLBACK TO Delete_BR_Assignment_PVT;

Line: 1761


                ROLLBACK TO Delete_BR_Assignment_PVT;

Line: 1781


		ROLLBACK TO Delete_BR_Assignment_PVT;

Line: 1792


END Delete_BR_Assignment;

Line: 2064


 |   Update_BR_Trxn_Extension                                                  |
 |                                                                              |
 | DESCRIPTION                                                                  |
 |    Updates  payment trxn extension details via IBY API                        |
 |                                                                              |
 +==============================================================================*/

PROCEDURE Update_BR_Trxn_Extension(

           --   *****  Standard API parameters *****
                p_api_version                   IN  NUMBER                      ,
                p_init_msg_list                 IN  VARCHAR2 := FND_API.G_TRUE  ,
                p_commit                        IN  VARCHAR2 := FND_API.G_FALSE ,
                x_return_status                 OUT NOCOPY VARCHAR2             ,
                x_msg_count                     OUT NOCOPY NUMBER               ,
                x_msg_data                      OUT NOCOPY VARCHAR2             ,

           --   *****  BR Header information parameters *****
                p_customer_trx_id               IN  NUMBER      DEFAULT NULL    ,
                p_trx_number                    IN  VARCHAR2    DEFAULT NULL    ,
                p_org_id                        IN  NUMBER      DEFAULT NULL    ,
                p_drawee_id                     IN  NUMBER      DEFAULT NULL    ,
                p_drawee_site_use_id            IN  NUMBER      DEFAULT NULL    ,
                p_payment_channel               IN  VARCHAR2    DEFAULT NULL    ,
                p_instrument_assign_id          IN  NUMBER      DEFAULT NULL    ,
                p_payment_trxn_extn_id          IN  IBY_TRXN_EXTENSIONS_V.TRXN_EXTENSION_ID%TYPE    )
IS
    l_payer_rec            IBY_FNDCPT_COMMON_PUB.payercontext_rec_type;

Line: 2096


        arp_standard.debug('AR_BILLS_CREATION_PUB.Update_BR_Trxn_Extension()+ ');

Line: 2117


            IBY_FNDCPT_TRXN_PUB.update_transaction_extension(
               p_api_version           => 1.0,
               p_init_msg_list         => p_init_msg_list,
               p_commit                => p_commit,
               x_return_status         => x_return_status,
               x_msg_count             => x_msg_count,
               x_msg_data              => x_msg_data,
               p_payer                 => l_payer_rec,
               p_payer_equivalency     => 'UPWARD',
               p_pmt_channel           => l_payment_channel,
               p_instr_assignment      => nvl(p_instrument_assign_id,FND_API.G_MISS_NUM),
               p_trxn_attribs          => l_trxn_attribs_rec,
               p_entity_id             => p_payment_trxn_extn_id,
               x_response              => l_response);

Line: 2136


       arp_standard.debug('Errors Reported by IBY API:Update Transaction Extension ');

Line: 2140


       arp_standard.debug('exception in AR_BILLS_CREATION_PUB.Update_BR_Trxn_Extension ');

Line: 2142


END Update_BR_Trxn_Extension;

Line: 2148


 |   Delete_BR_Trxn_Extension      	                                        |
 |                                                                              |
 | DESCRIPTION                                                                  |
 |    Deletes  payment trxn extension details via IBY API                       |
 |                                                                              |
 +==============================================================================*/

PROCEDURE Delete_BR_Trxn_Extension(

           --   *****  Standard API parameters *****
                p_api_version                   IN  NUMBER                      ,
                p_init_msg_list                 IN  VARCHAR2 := FND_API.G_TRUE  ,
                p_commit                        IN  VARCHAR2 := FND_API.G_FALSE ,
                x_return_status                 OUT NOCOPY VARCHAR2             ,
                x_msg_count                     OUT NOCOPY NUMBER               ,
                x_msg_data                      OUT NOCOPY VARCHAR2             ,

           --   *****  BR Header information parameters *****
                p_customer_trx_id               IN  NUMBER      DEFAULT NULL    ,
                p_trx_number                    IN  VARCHAR2    DEFAULT NULL    ,
                p_org_id                        IN  NUMBER      DEFAULT NULL    ,
                p_drawee_id                     IN  NUMBER      DEFAULT NULL    ,
                p_drawee_site_use_id            IN  NUMBER      DEFAULT NULL    ,
                p_payment_channel               IN  VARCHAR2    DEFAULT NULL    ,
                p_instrument_assign_id          IN  NUMBER      DEFAULT NULL    ,
                p_payment_trxn_extn_id          IN  IBY_TRXN_EXTENSIONS_V.TRXN_EXTENSION_ID%TYPE    )
IS
    l_payer_rec            IBY_FNDCPT_COMMON_PUB.payercontext_rec_type;

Line: 2180


        arp_standard.debug('AR_BILLS_CREATION_PUB.Delete_BR_Trxn_Extension()+ ');

Line: 2200


            IBY_FNDCPT_TRXN_PUB.delete_transaction_extension(
               p_api_version           => 1.0,
               p_init_msg_list         => p_init_msg_list,
               p_commit                => p_commit,
               x_return_status         => x_return_status,
               x_msg_count             => x_msg_count,
               x_msg_data              => x_msg_data,
               p_payer                 => l_payer_rec,
               p_payer_equivalency     => 'UPWARD',
               p_entity_id             => p_payment_trxn_extn_id,
               x_response              => l_response);

Line: 2216


       arp_standard.debug('Errors Reported by IBY API:Delete Transaction Extension ');

Line: 2220


       arp_standard.debug('exception in AR_BILLS_CREATION_PUB.Delete_BR_Trxn_Extension ');

Line: 2222


END Delete_BR_Trxn_Extension;