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

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

Line: 119


l_select_detail			varchar2(25000) := NULL;

Line: 171


ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (
	p_transaction_type1_id,
	p_transaction_type2_id,
	p_drawee_class1_code,
	p_drawee_class2_code,
	p_drawee_class3_code,
	p_drawee_bank_name,
	p_drawee_bank_branch_id,
	p_drawee_branch_city,
	p_unsigned_flag,
	p_signed_flag,
	p_drawee_issued_flag,
	p_br_sort_criteria,
	p_br_order,
	p_drawee_sort_criteria,
	p_drawee_order,
	l_select_detail);

Line: 191


OPEN CUR_BR FOR l_select_detail
	USING  p_include_unpaid_flag,
	       p_batch_date,
	       p_gl_date,
               p_currency_code,
               p_remittance_bank_account_id,
	       p_maturity_date_low,
	       p_maturity_date_high,
	       p_br_number_low,
	       p_br_number_high,
	       p_br_amount_low,
	       p_br_amount_high,
	       p_drawee_id,
	       p_drawee_number_low,
	       p_drawee_number_high;

Line: 233


  ARP_BR_REMIT_BATCHES.insert_remit(
	p_batch_date,
	p_gl_date,
	p_currency_code,
	p_comments,
	p_attribute_category,
	p_attribute1,
	p_attribute2,
	p_attribute3,
	p_attribute4,
	p_attribute5,
	p_attribute6,
	p_attribute7,
	p_attribute8,
	p_attribute9,
	p_attribute10,
	p_media_reference,
	p_receipt_method_id,
	p_remittance_bank_account_id,
	p_receipt_class_id,
	p_remittance_bank_branch_id,
	p_remit_method_code,
	p_with_recourse_flag,
	p_bank_deposit_number,
	p_auto_print_program_id,
	p_auto_trans_program_id,
	l_batch_id,
	l_batch_name,
	l_batch_applied_status);

Line: 263


     arp_util.debug('create_remit_batch: ' || 'Commit -- Insertion du Batch '||l_batch_id||' status '||l_batch_applied_status);

Line: 264


     arp_util.debug('create_remit_batch: ' || 'NB selected BR          :'|| TOTAL_COUNT);

Line: 338


 |    select_and_assign_br_to_remit                                          |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Procedure called during the process create bills receivable            |
 |    remittance process, to select the bills and assign them                |
 |    to the remittance                                                      |
 |                                                                           |
 | SCOPE - PRIVATE                                                           |
 |                                                                           |
 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE                             |
 |                                                                           |
 |                                                                           |
 |                                                                           |
 | ARGUMENTS : IN :                                                          |
 |           : OUT NOCOPY : NONE                                                    |
 |                                                                           |
 | RETURNS   : NONE                                                          |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY - Created by Mireille Flahaut - 15/06/2000           |
 |                                                                           |
 +===========================================================================*/
PROCEDURE select_and_assign_br_to_remit(
	p_api_version      		IN  NUMBER			,
        p_init_msg_list    		IN  VARCHAR2 := FND_API.G_FALSE	,
        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			,
	p_batch_id			IN	AR_BATCHES.batch_id%TYPE,
	p_remit_total_low		IN	AR_BATCHES.control_amount%TYPE,
	p_remit_total_high		IN	AR_BATCHES.control_amount%TYPE,
	p_maturity_date_low		IN	AR_PAYMENT_SCHEDULES.due_date%TYPE,
	p_maturity_date_high		IN	AR_PAYMENT_SCHEDULES.due_date%TYPE,
	p_br_number_low			IN	AR_PAYMENT_SCHEDULES.trx_number%TYPE,
	p_br_number_high		IN	AR_PAYMENT_SCHEDULES.trx_number%TYPE,
	p_br_amount_low			IN	AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
	p_br_amount_high		IN	AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
	p_transaction_type1_id		IN	AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
	p_transaction_type2_id		IN	AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
	p_unsigned_flag			IN	varchar2,
	p_signed_flag			IN	RA_CUST_TRX_TYPES.signed_flag%TYPE,
	p_drawee_issued_flag		IN	RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
	p_include_unpaid_flag    	IN 	varchar2,
	p_drawee_id			IN	AR_PAYMENT_SCHEDULES.customer_id%TYPE,
	p_drawee_number_low		IN	HZ_CUST_ACCOUNTS.account_number%TYPE,
	p_drawee_number_high		IN	HZ_CUST_ACCOUNTS.account_number%TYPE,
	p_drawee_class1_code		IN	HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
	p_drawee_class2_code		IN	HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
	p_drawee_class3_code		IN	HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
	p_drawee_bank_name		IN	ce_bank_branches_v.bank_name%TYPE,
	p_drawee_bank_branch_id		IN	ce_bank_branches_v.branch_party_id%TYPE,
	p_drawee_branch_city		IN	ce_bank_branches_v.city%TYPE,
	p_br_sort_criteria	    	IN 	varchar2,
	p_br_order		    	IN 	varchar2,
	p_drawee_sort_criteria	    	IN 	varchar2,
	p_drawee_order		    	IN 	varchar2,
	p_control_count			OUT NOCOPY	AR_BATCHES.control_count%TYPE,
	p_control_amount		OUT NOCOPY	AR_BATCHES.control_amount%TYPE,
	p_batch_applied_status		OUT NOCOPY	AR_BATCHES.batch_applied_status%TYPE) IS

l_api_name			CONSTANT varchar2(30) := 'select_and_assign_br_to_remit';

Line: 406


l_select_detail		varchar2(25000);

Line: 414


   arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');

Line: 417


SAVEPOINT select_and_assign_PVT;

Line: 467


ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (
	p_transaction_type1_id,
	p_transaction_type2_id,
	p_drawee_class1_code,
	p_drawee_class2_code,
	p_drawee_class3_code,
	p_drawee_bank_name,
	p_drawee_bank_branch_id,
	p_drawee_branch_city,
	p_unsigned_flag,
	p_signed_flag,
	p_drawee_issued_flag,
	p_br_sort_criteria,
	p_br_order,
	p_drawee_sort_criteria,
	p_drawee_order,
	l_select_detail);

Line: 488


	l_select_detail,
        l_batch_rec.batch_id,
        p_remit_total_high,
	p_include_unpaid_flag,
        l_batch_rec.batch_date,
        l_batch_rec.gl_date,
	l_batch_rec.currency_code,
	l_batch_rec.remit_bank_acct_use_id,
	p_maturity_date_low,
	p_maturity_date_high,
	p_br_number_low,
	p_br_number_high,
	p_br_amount_low,
	p_br_amount_high,
	p_unsigned_flag,
	p_signed_flag,
	p_drawee_issued_flag,
	p_drawee_id,
	p_drawee_number_low,
	p_drawee_number_high,
        l_control_count,
        l_control_amount);

Line: 515


arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);

Line: 525


   arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');

Line: 531


      arp_util.debug('create_remit_batch: ' || 'EXCEPTION : ARP_PROGRAM_BR_REMIT.select_and_assign_br_to_remit - ROLLBACK');

Line: 534


   ROLLBACK TO select_and_assign_PVT;

Line: 537


END select_and_assign_br_to_remit;

Line: 543


 |    construct_select_br_for_remit                                          |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Procedure called during the process create bills receivable            |
 |    remittance to build the BR select statement according the entered      |
 |    criteria                                                               |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE                             |
 |                                                                           |
 | ARGUMENTS : IN :                                                          |
 |                                                                           |
 | RETURNS   : NONE                                                          |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY - Created by Mireille Flahaut - 20/04/2000           |
 |                                                                           |
 +===========================================================================*/
PROCEDURE construct_select_br_for_remit (
	p_transaction_type1_id		IN	AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
	p_transaction_type2_id		IN	AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
	p_drawee_class1_code	IN	HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
	p_drawee_class2_code		IN	HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
	p_drawee_class3_code		IN	HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
	p_drawee_bank_name		IN	ce_bank_branches_v.bank_name%TYPE,
	p_drawee_bank_branch_id		IN	ce_bank_branches_v.branch_party_id%TYPE,
	p_drawee_branch_city		IN	ce_bank_branches_v.city%TYPE,
	p_unsigned_flag			IN	varchar2,
	p_signed_flag			IN	RA_CUST_TRX_TYPES.signed_flag%TYPE,
	p_drawee_issued_flag		IN	RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
	p_br_sort_criteria		IN	varchar2,
	p_br_order			IN	varchar2,
	p_drawee_sort_criteria		IN	varchar2,
	p_drawee_order			IN	varchar2,
	p_select_detail			OUT NOCOPY	varchar2) IS

l_field		                varchar2(30) := NULL;

Line: 598


   arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (+)-------------');

Line: 620


                                    '(SELECT MAX(transaction_history_id) FROM AR_TRANSACTION_HISTORY WHERE customer_trx_id = PS.customer_trx_id ' ||
				    ' AND event NOT IN (''SELECTED_REMITTANCE'', ''DESELECTED_REMITTANCE''))';

Line: 737


/* Select                                                                              */
/*-------------------------------------------------------------------------------------*/
/* Bug 3424656 Modified the following SELECT to pick all
   the columns from PS rather than all the columns using
   the wildcard character. This was giving ORA-00932
   Inconsitent Datatypes errors in 10g. */

p_select_detail := 'SELECT PS.* ' ||
                   'FROM AR_PAYMENT_SCHEDULES PS, ' ||
                        'AR_TRANSACTION_HISTORY HS, ' ||
                        'HZ_CUST_ACCOUNTS CUST, ' ||
                        'HZ_PARTIES PARTY, ' ||
                        'RA_CUST_TRX_TYPES TRX_TYPE, ' ||
                        'RA_CUSTOMER_TRX TRX, ' ||
                        'AP_BANK_ACCOUNTS ACC, ' ||
                        'CE_BANK_BRANCHES_V BRANCH, ' ||
			'AR_TRANSACTION_HISTORY HS1 ' ||
		         l_where_clause ||
                         l_order_clause;

Line: 758


   arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (-)-------------');

Line: 765


      arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit ');

Line: 769


END construct_select_br_for_remit;

Line: 1006


 |    remittance to select the BR and assign them to the remittance          |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE                             |
 |                                                                           |
 | ARGUMENTS : IN :                                                          |
 |                                                                           |
 | RETURNS   : NONE                                                          |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY - Created by Mireille Flahaut - 30/05/2000           |
 |                                                                           |
 +===========================================================================*/
PROCEDURE assign_br_to_remit(
	p_select_detail			IN	varchar2,
        p_batch_id			IN	AR_BATCHES.batch_id%TYPE,
        p_remit_total_high		IN	AR_BATCHES.control_amount%TYPE,
	p_include_unpaid_flag		IN	varchar2,
        p_batch_date			IN	AR_BATCHES.batch_date%TYPE,
        p_gl_date			IN	AR_BATCHES.gl_date%TYPE,
	p_currency_code			IN	AR_BATCHES.currency_code%TYPE,
	p_remittance_bank_account_id	IN	AR_BATCHES.remit_bank_acct_use_id%TYPE,
	p_maturity_date_low		IN	AR_PAYMENT_SCHEDULES.due_date%TYPE,
	p_maturity_date_high		IN	AR_PAYMENT_SCHEDULES.due_date%TYPE,
	p_br_number_low			IN	AR_PAYMENT_SCHEDULES.trx_number%TYPE,
	p_br_number_high		IN	AR_PAYMENT_SCHEDULES.trx_number%TYPE,
	p_br_amount_low			IN	AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
	p_br_amount_high		IN	AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
	p_unsigned_flag			IN	varchar2,
	p_signed_flag			IN	RA_CUST_TRX_TYPES.signed_flag%TYPE,
	p_drawee_issued_flag		IN	RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
	p_drawee_id			IN	AR_PAYMENT_SCHEDULES.customer_id%TYPE,
	p_drawee_number_low		IN	HZ_CUST_ACCOUNTS.account_number%TYPE,
	p_drawee_number_high		IN	HZ_CUST_ACCOUNTS.account_number%TYPE,
        p_control_count			OUT NOCOPY	AR_BATCHES.control_count%TYPE,
        p_control_amount		OUT NOCOPY	AR_BATCHES.control_amount%TYPE) IS

CUR_BR			CUR_TYP;

Line: 1061


OPEN CUR_BR FOR p_select_detail
	USING  p_include_unpaid_flag,
               p_batch_date,
               p_gl_date,
               p_currency_code,
               p_remittance_bank_account_id,
	       p_maturity_date_low,
	       p_maturity_date_high,
	       p_br_number_low,
	       p_br_number_high,
	       p_br_amount_low,
	       p_br_amount_high,
	       p_drawee_id,
	       p_drawee_number_low,
	       p_drawee_number_high;

Line: 1090


     AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,l_ps_rec.payment_schedule_id,l_new_status);

Line: 1105


         AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,l_ps_rec.payment_schedule_id,l_new_status);

Line: 1231


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

Line: 1250


       arp_util.debug('create_remit_batch: ' || 'Action Deselect - Remove the BR '||p_ps_id||' from its remittance');

Line: 1252


    AR_BILLS_MAINTAIN_PUB.DeSelect_BR_Remit(p_ps_id,l_new_status);

Line: 1264


       arp_util.debug('create_remit_batch: ' || 'Action Select - BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);

Line: 1266


    AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,p_ps_id,l_new_status);

Line: 1274


arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);

Line: 1471


select org_id into l_org_id
from ar_system_parameters;

Line: 1539


arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);

Line: 1693


select org_id into l_org_id
from ar_system_parameters;

Line: 1777


arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);

Line: 1822


 |    update_batch_status_after_create                                       |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Procedure called during the process create bills receivable            |
 |    remittance to update the batch status to Completed_creation            |
 |    if the batch is created manually                                       |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE                             |
 |                                                                           |
 | ARGUMENTS : IN :                                                          |
 |                                                                           |
 | RETURNS   : NONE                                                          |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY - Created by Mireille Flahaut - 21/09/2000           |
 |  bug 1407469 : Actions Window Create doesn't update batch applied_status  |
 |                                                                           |
 +===========================================================================*/
PROCEDURE update_batch_status (
	p_api_version			IN	number,
	p_init_msg_list			IN	varchar2 := FND_API.G_FALSE,
	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,
	p_batch_id			IN	AR_BATCHES.batch_id%TYPE,
	p_batch_applied_status		OUT NOCOPY	AR_BATCHES.batch_applied_status%TYPE) IS

l_api_name			CONSTANT varchar2(30) := 'update_batch_status';

Line: 1862


   arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (+)');

Line: 1865


SAVEPOINT update_batch_status_PVT;

Line: 1887


arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);

Line: 1894


   arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (-)');

Line: 1900


      arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');

Line: 1903


   ROLLBACK TO update_batch_status_PVT;

Line: 1907


      arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');

Line: 1910


   ROLLBACK TO update_batch_status_PVT;

Line: 1914


      arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');

Line: 1915


      arp_util.debug('update_batch_status: ' || SQLERRM);

Line: 1917


   ROLLBACK TO update_batch_status_PVT;

Line: 1926


END update_batch_status;