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

  	update ra_customer_trx
	set payment_trxn_extension_id = l_payment_trxn_extension_id
	where customer_trx_id = p_customer_trx_id;

Line: 338

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

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

	l_trx_rec.complete_flag		:=	'Y';

Line: 417

	ARP_PROCESS_BR_HEADER.update_header  (l_trx_rec, l_trx_rec.customer_trx_id);

Line: 421

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 640

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

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

	l_trx_rec.complete_flag		:=	'N';

Line: 702

	ARP_PROCESS_BR_HEADER.update_header  (  l_trx_rec	,
						l_trx_rec.customer_trx_id);

Line: 706

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 734

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

            arp_ps_pkg.delete_f_ct_id(p_customer_trx_id);

Line: 945

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

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 1221

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

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

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

Line: 1272

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

	l_trx_rec.br_on_hold_flag	:=	'Y';

Line: 1277

	ARP_PROCESS_BR_HEADER.update_header (l_trx_rec, l_trx_rec.customer_trx_id);

Line: 1282

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 1492

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

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

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

Line: 1541

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

	l_trx_rec.br_on_hold_flag	:=	'N';

Line: 1546

	ARP_PROCESS_BR_HEADER.update_header (l_trx_rec,	l_trx_rec.customer_trx_id);

Line: 1550

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 1660

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

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

Line: 1697

      	SAVEPOINT Select_BR_Remit_PVT;

Line: 1725

	l_action			:=	C_SELECT_REMIT;

Line: 1733

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

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

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

Line: 1776

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

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

Line: 1783

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 1817

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

Line: 1823

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

Line: 1827

		ROLLBACK TO Select_BR_Remit_PVT;

Line: 1830

END Select_BR_Remit;

Line: 1835

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

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

Line: 1867

      	SAVEPOINT DeSelect_BR_Remit_PVT;

Line: 1890

	l_action			:=	C_DESELECT_REMIT;

Line: 1898

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

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

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

Line: 1938

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

	AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL, NULL);

Line: 1945

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 1977

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

Line: 1983

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

Line: 1987

		ROLLBACK TO DeSelect_BR_Remit_PVT;

Line: 1990

END DeSelect_BR_Remit;

Line: 1999

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

	l_action			:=	C_DESELECT_REMIT;

Line: 2058

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

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

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

Line: 2098

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

	AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL, NULL);

Line: 2106

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

	l_trh_id	:=	l_trh_rec.prv_trx_history_id;

Line: 2112

	ARP_PROC_TRANSACTION_HISTORY.delete_transaction_history (l_trh_rec.transaction_history_id);

Line: 2116

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

 	ARP_TRANSACTION_HISTORY_PKG.set_to_dummy(l_trh_rec);

Line: 2122

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

	l_trh_rec.current_record_flag	:=	'Y';

Line: 2127

	ARP_PROC_TRANSACTION_HISTORY.update_transaction_history	(l_trh_rec, l_trh_id);

Line: 2131

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

Line: 2214

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

		AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL , NULL);

Line: 2293

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

		arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 	l_trh_rec.transaction_history_id);

Line: 2342

	ARP_PROCESS_BR_HEADER.update_header  (  l_trx_rec		,
						l_trx_rec.customer_trx_id);

Line: 2347

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 2528

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

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 2664

		arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);

Line: 2855

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

	ARP_PROCESS_BR_HEADER.update_header  (l_trx_rec, l_trx_rec.customer_trx_id);

Line: 2945

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 3159

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

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

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

		arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 3324

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 3530

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

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec, l_trh_rec.transaction_history_id);

Line: 3793

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

	ARP_PROCESS_BR_HEADER.update_header  (  l_trx_rec	,
						l_trx_rec.customer_trx_id);

Line: 3858

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 4072

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

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

Line: 4173

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 4204

	ARP_PROCESS_BR_HEADER.update_header  (  l_trx_rec, l_trx_rec.customer_trx_id);

Line: 4399

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

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

Line: 4517

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 4739

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

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

Line: 4855

		SELECT 	receivables_trx_id
		INTO	l_receivables_trx_id
		FROM	ar_adjustments
		WHERE	adjustment_id	=	l_adj_id;

Line: 4873

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

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

	arp_proc_transaction_history.insert_transaction_history (l_trh_rec	,
								 l_trh_rec.transaction_history_id);

Line: 5102

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

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

	l_trh_rec.customer_trx_id	:=	p_new_customer_trx_id;

Line: 5273

	ARP_PROC_TRANSACTION_HISTORY.update_transaction_history (l_trh_rec,
								 l_trh_rec.transaction_history_id);