APPS.AR_BILLS_MAINTAIN_PUB SQL Statements

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

Line: 39

C_MATURITY_DATE_UPDATED	CONSTANT VARCHAR2(30)	:=	'MATURITY_DATE_UPDATED';

Line: 43

C_SELECTED_REMITTANCE	CONSTANT VARCHAR2(30)	:=	'SELECTED_REMITTANCE';

Line: 44

C_DESELECTED_REMITTANCE	CONSTANT VARCHAR2(30)	:=	'DESELECTED_REMITTANCE';

Line: 64

C_SELECT_REMIT		CONSTANT VARCHAR2(30)	:=	'SELECT_REMIT';

Line: 65

C_DESELECT_REMIT	CONSTANT VARCHAR2(30)	:=	'DESELECT_REMIT';

Line: 81

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

Line: 112

	select_remit_flag	VARCHAR2(1),
	deselect_remit_flag	VARCHAR2(1),
	approve_remit_flag	VARCHAR2(1),
	hold_flag		VARCHAR2(1),
	unhold_flag		VARCHAR2(1),
	recall_flag		VARCHAR2(1),
	eliminate_flag		VARCHAR2(1),
	uneliminate_flag	VARCHAR2(1),
	unpaid_flag		VARCHAR2(1),
	protest_flag		VARCHAR2(1),
	endorse_flag		VARCHAR2(1),
	restate_flag		VARCHAR2(1),
	exchange_flag		VARCHAR2(1),
	delete_flag		VARCHAR2(1));

Line: 253

        select trx_number,drawee_id,drawee_site_use_id,org_id,payment_trxn_extension_id,
	       substr(created_from ,1,8)
	into l_trx_number,l_drawee_id,l_drawee_site_use_id,l_org_id,l_payment_trxn_extension_id,
	     l_created_from
	from ra_customer_trx
	where customer_trx_id = p_customer_trx_id;

Line: 270

          Select instr_assignment_id
	  Into l_instr_id
          from ra_customer_Trx_lines brlines,
               ra_customer_trx   ct,
               iby_trxn_extensions_v iby
          where ct.customer_trx_id = brlines.br_ref_customer_trx_id
          and ct.payment_trxn_extension_id = iby.trxn_extension_id
          and brlines.customer_trx_id = p_customer_trx_id
          and rownum = 1;

Line: 324

  	update ra_customer_trx
	set payment_trxn_extension_id = l_payment_trxn_extension_id
	where customer_trx_id = p_customer_trx_id;

Line: 349

		p_select_remit_flag	=>  C_ACTION_REC.select_remit_flag,
		p_deselect_remit_flag	=>  C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>  C_ACTION_REC.approve_remit_flag,
		p_hold_flag		=>  C_ACTION_REC.hold_flag,
		p_unhold_flag		=>  C_ACTION_REC.unhold_flag,
		p_recall_flag		=>  C_ACTION_REC.recall_flag,
		p_eliminate_flag	=>  C_ACTION_REC.eliminate_flag,
		p_uneliminate_flag	=>  C_ACTION_REC.uneliminate_flag,
		p_unpaid_flag		=>  C_ACTION_REC.unpaid_flag,
		p_protest_flag		=>  C_ACTION_REC.protest_flag,
		p_endorse_flag		=>  C_ACTION_REC.endorse_flag,
		p_restate_flag		=>  C_ACTION_REC.restate_flag,
		p_exchange_flag		=>  C_ACTION_REC.exchange_flag,
		p_delete_flag		=>  C_ACTION_REC.delete_flag);

Line: 423

        |   Update the Complete Flag in the BR Header	 |
        +------------------------------------------------*/

	l_trx_rec.complete_flag		:=	'Y';

Line: 428

	ARP_PROCESS_BR_HEADER.update_header  (l_trx_rec, l_trx_rec.customer_trx_id);

Line: 432

        |   Insertion in Transaction History Table	 |
        +------------------------------------------------*/


	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 455

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 651

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 708

        |   Update the Complete Flag in the BR Header	 |
        +------------------------------------------------*/

	l_trx_rec.complete_flag		:=	'N';

Line: 713

	ARP_PROCESS_BR_HEADER.update_header  (  l_trx_rec	,
						l_trx_rec.customer_trx_id);

Line: 717

        |   Insertion in Transaction History Table	 |
        +------------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 740

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 745

        |   Delete the BR Payment Schedule		 |
        +------------------------------------------------*/

	IF  (l_acceptance_flag = 'N')
	THEN
        --  Bug 2057740:
        --  Commenting out NOCOPY and calling delete_f_Ct_id instead because
        --  there is already a routine to delete ps by cust_trx_id.
        --  no need to call another routine to find the ps id first.
	--  AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (
        --                               p_customer_trx_id, l_ps_id);

Line: 758

            arp_ps_pkg.delete_f_ct_id(p_customer_trx_id);

Line: 956

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 1026

        |   Insertion in Transaction History Table	 |
        +------------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 1049

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 1232

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 1273

        |    Update the Payment Schedule of the BR 	|
        +-----------------------------------------------*/

	AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);

Line: 1278

	AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'USER' , p_customer_trx_id);

Line: 1283

        |    Update the Hold Flag in the BR Header	|
        +-----------------------------------------------*/

	l_trx_rec.br_on_hold_flag	:=	'Y';

Line: 1288

	ARP_PROCESS_BR_HEADER.update_header (l_trx_rec, l_trx_rec.customer_trx_id);

Line: 1293

        |    Insert a Transaction History Record 	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 1323

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 1503

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 1543

        |    Updates the Payment Schedule of the BR 	|
        +-----------------------------------------------*/

	AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);

Line: 1548

	AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL, NULL);

Line: 1552

        |    Update the Hold Flag in the BR Header	|
        +-----------------------------------------------*/

	l_trx_rec.br_on_hold_flag	:=	'N';

Line: 1557

	ARP_PROCESS_BR_HEADER.update_header (l_trx_rec,	l_trx_rec.customer_trx_id);

Line: 1561

        |    Insert a Transaction History Record 	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 1589

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 1671

 |    Select_BR_remit			                                     	|
 |                                                                           	|
 | DESCRIPTION                                                               	|
 |    Selects a BR for remittance					     	|
 |									  	|
 +==============================================================================*/


PROCEDURE Select_BR_Remit (

           --   *****  Input  parameters  *****

		p_batch_id			IN  	NUMBER	,
		p_ps_id				IN  	NUMBER	,

           --   *****  Output parameters  *****

		p_status			OUT NOCOPY 	VARCHAR2				)

IS

		l_batch_rec			ar_batches%ROWTYPE;

Line: 1701

	   arp_util.debug('AR_BILLS_MAINTAIN_PUB.Select_BR_Remit ()+');

Line: 1708

      	SAVEPOINT Select_BR_Remit_PVT;

Line: 1736

	l_action			:=	C_SELECT_REMIT;

Line: 1744

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 1764

	IF	(C_ACTION_REC.select_remit_flag	<>	'Y')
	THEN
		IF PG_DEBUG in ('Y', 'C') THEN
		   arp_util.debug( '>>>>>>>>>> The action ' || l_action || ' is not allowed on the BR ' || l_ps_rec.customer_trx_id);

Line: 1769

		FND_MESSAGE.set_name	( 'AR', 'AR_BR_CANNOT_SELECT_REMIT' );

Line: 1787

        |    Updates the Payment Schedule of the BR 	|
        +-----------------------------------------------*/

	AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, 'REMITTANCE' , p_batch_id);

Line: 1794

        |    Insert a Transaction History Record 	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 1818

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 1828

	   arp_util.debug('AR_BILLS_MAINTAIN_PUB.Select_BR_Remit ()-');

Line: 1834

   		   arp_util.debug('EXCEPTION OTHERS: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit');

Line: 1838

		ROLLBACK TO Select_BR_Remit_PVT;

Line: 1841

END Select_BR_Remit;

Line: 1846

 |    DeSelect_BR_remit			                                     	|
 |                                                                           	|
 | DESCRIPTION                                                               	|
 |    DeSelects a BR out NOCOPY of a remittance batch				     	|
 |									  	|
 +==============================================================================*/


PROCEDURE DeSelect_BR_Remit (

           --   *****  Input  parameters  *****
		p_ps_id				IN  	NUMBER	,

           --   *****  Output parameters  *****
		p_status			OUT NOCOPY 	VARCHAR2				)
IS

		l_trh_rec			ar_transaction_history%ROWTYPE;

Line: 1871

	   arp_util.debug('AR_BILLS_MAINTAIN_PUB.DeSelect_BR_Remit ()+');

Line: 1878

      	SAVEPOINT DeSelect_BR_Remit_PVT;

Line: 1901

	l_action			:=	C_DESELECT_REMIT;

Line: 1909

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 1929

	IF	(C_ACTION_REC.deselect_remit_flag	<>	'Y')
	THEN
		IF PG_DEBUG in ('Y', 'C') THEN
		   arp_util.debug( '>>>>>>>>>> The action ' || l_action || ' is not allowed on the BR ' || l_ps_rec.customer_trx_id);

Line: 1934

		FND_MESSAGE.set_name	( 'AR', 'AR_BR_CANNOT_DESELECT_REMIT' );

Line: 1949

        |    Updates the Payment Schedule of the BR 	|
        +-----------------------------------------------*/

	AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL, NULL);

Line: 1956

        |    Insert a Transaction History Record 	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 1978

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 1988

	   arp_util.debug('AR_BILLS_MAINTAIN_PUB.DeSelect_BR_Remit ()-');

Line: 1994

   		   arp_util.debug('EXCEPTION OTHERS: AR_BILLS_MAINTAIN_PUB.DeSelect_BR_Remit');

Line: 1998

		ROLLBACK TO DeSelect_BR_Remit_PVT;

Line: 2001

END DeSelect_BR_Remit;

Line: 2010

 |    Cancels the selection of a BR in a remittance batch 		     	|
 |    Removes the history record related to the selection			|
 |									  	|
 +==============================================================================*/


PROCEDURE Cancel_BR_Remit (

           --   *****  Input  parameters  *****
		p_ps_id				IN  	NUMBER	)
IS

		l_trh_rec			ar_transaction_history%ROWTYPE;

Line: 2061

	l_action			:=	C_DESELECT_REMIT;

Line: 2069

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 2089

	IF	(C_ACTION_REC.deselect_remit_flag	<>	'Y')
	THEN
		IF PG_DEBUG in ('Y', 'C') THEN
		   arp_util.debug('Cancel_BR_Remit: ' || '>>>>>>>>>> The action ' || l_action || ' is not allowed on the BR ' || l_ps_rec.customer_trx_id);

Line: 2094

		FND_MESSAGE.set_name	( 'AR', 'AR_BR_CANNOT_DESELECT_REMIT' );

Line: 2109

        |    Updates the Payment Schedule of the BR 	|
        +-----------------------------------------------*/

	AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL, NULL);

Line: 2117

        |    Deletes the current Transaction History Record 	|
	|    (Status Selected Remittance)			|
        +-------------------------------------------------------*/

	l_trh_id	:=	l_trh_rec.prv_trx_history_id;

Line: 2123

	ARP_PROC_TRANSACTION_HISTORY.delete_transaction_history (l_trh_rec.transaction_history_id);

Line: 2127

        |    Updates the previous Transaction History Record 	|
        +-------------------------------------------------------*/

 	ARP_TRANSACTION_HISTORY_PKG.set_to_dummy(l_trh_rec);

Line: 2133

        | Set the flag to be updated |
        +----------------------------*/

	l_trh_rec.current_record_flag	:=	'Y';

Line: 2138

	ARP_PROC_TRANSACTION_HISTORY.update_transaction_history	(l_trh_rec, l_trh_id);

Line: 2142

	   arp_util.debug('Cancel_BR_Remit: ' || 'AR_BILLS_MAINTAIN_PUB.DeSelect_BR_Remit ()-');

Line: 2225

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 2301

		AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL , NULL);

Line: 2304

        	|  Insert the First Transaction History Record	|
        	+-----------------------------------------------*/

		-- Fetch the new status and new event of the BR

		AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 2327

		arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 	l_trh_rec.transaction_history_id);

Line: 2353

	ARP_PROCESS_BR_HEADER.update_header  (  l_trx_rec		,
						l_trx_rec.customer_trx_id);

Line: 2358

        |  Insert the Transaction History Record	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 2381

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 2539

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 2622

        |  Insert the Transaction History Record	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 2642

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 2675

		arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);

Line: 2866

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 2952

	ARP_PROCESS_BR_HEADER.update_header  (l_trx_rec, l_trx_rec.customer_trx_id);

Line: 2956

        |  Insert the Transaction History Record	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 2976

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 3170

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 3271

	        |    Updates the Payment Schedule of the BR 	|
		|    with the Adjustment Information		|
        	+-----------------------------------------------*/

		AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'ADJUSTMENT', new_adj_id);

Line: 3308

	        |  Insert the first Transaction History Record	|
	        +-----------------------------------------------*/

		-- Fetch the new status and new event of the BR

		AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 3329

		arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 3335

        |  Insert the Transaction History Record	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 3356

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 3541

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 3594

        |  Insert the Transaction History Record	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 3615

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 3804

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 3865

	ARP_PROCESS_BR_HEADER.update_header  (  l_trx_rec	,
						l_trx_rec.customer_trx_id);

Line: 3869

        |  Insert the Transaction History Record	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 3890

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 4083

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 4180

	AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL , NULL);

Line: 4184

        |  Insert the Transaction History Record	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 4204

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 4215

	ARP_PROCESS_BR_HEADER.update_header  (  l_trx_rec, l_trx_rec.customer_trx_id);

Line: 4410

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 4524

	AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL , NULL);

Line: 4528

        |  Insert the Transaction History Record	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 4550

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 4750

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 4852

		AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'REMITTANCE' , l_trx_rec.remittance_batch_id);

Line: 4866

		SELECT 	receivables_trx_id
		INTO	l_receivables_trx_id
		FROM	ar_adjustments
		WHERE	adjustment_id	=	l_adj_id;

Line: 4884

	        |    Updates the Payment Schedule of the BR 	|
		|    with the Adjustment Information		|
        	+-----------------------------------------------*/

		AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'ADJUSTMENT', l_new_adj_id);

Line: 4895

        |  Insert the Transaction History Record	|
        +-----------------------------------------------*/

	-- Fetch the new status and new event of the BR

	AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event (
			p_trx_rec	=>	l_trx_rec	,
			p_action        =>	l_action	,
			p_new_status	=>	l_trh_rec.status,
			p_new_event	=>	l_trh_rec.event	);

Line: 4917

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 5113

		p_select_remit_flag	=>	C_ACTION_REC.select_remit_flag	,
		p_deselect_remit_flag	=>	C_ACTION_REC.deselect_remit_flag,
		p_approve_remit_flag	=>	C_ACTION_REC.approve_remit_flag	,
		p_hold_flag		=>	C_ACTION_REC.hold_flag		,
		p_unhold_flag		=>	C_ACTION_REC.unhold_flag	,
		p_recall_flag		=>	C_ACTION_REC.recall_flag	,
		p_eliminate_flag	=>	C_ACTION_REC.eliminate_flag	,
		p_uneliminate_flag	=>	C_ACTION_REC.uneliminate_flag	,
		p_unpaid_flag		=>	C_ACTION_REC.unpaid_flag	,
		p_protest_flag		=>	C_ACTION_REC.protest_flag	,
		p_endorse_flag		=>	C_ACTION_REC.endorse_flag	,
		p_restate_flag		=>	C_ACTION_REC.restate_flag	,
		p_exchange_flag		=>	C_ACTION_REC.exchange_flag	,
		p_delete_flag		=>	C_ACTION_REC.delete_flag	);

Line: 5276

        |   Update the event of the new BR created	 |
        +------------------------------------------------*/

	l_trh_rec.customer_trx_id	:=	p_new_customer_trx_id;

Line: 5284

	ARP_PROC_TRANSACTION_HISTORY.update_transaction_history (l_trh_rec,
								 l_trh_rec.transaction_history_id);