The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_select_detail varchar2(25000) := NULL;
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);
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;
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);
arp_util.debug('create_remit_batch: ' || 'Commit -- Insertion du Batch '||l_batch_id||' status '||l_batch_applied_status);
arp_util.debug('create_remit_batch: ' || 'NB selected BR :'|| TOTAL_COUNT);
| 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';
l_select_detail varchar2(25000);
arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');
SAVEPOINT select_and_assign_PVT;
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);
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);
arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');
arp_util.debug('create_remit_batch: ' || 'EXCEPTION : ARP_PROGRAM_BR_REMIT.select_and_assign_br_to_remit - ROLLBACK');
ROLLBACK TO select_and_assign_PVT;
END select_and_assign_br_to_remit;
| 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;
arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (+)-------------');
/* 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 ' ||
l_where_clause ||
l_order_clause;
arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (-)-------------');
arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit ');
END construct_select_br_for_remit;
| 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;
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;
AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,l_ps_rec.payment_schedule_id,l_new_status);
AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,l_ps_rec.payment_schedule_id,l_new_status);
FND_MESSAGE.set_name('AR','AR_BR_CANNOT_UPDATE_REMIT');
arp_util.debug('create_remit_batch: ' || 'Action Deselect - Remove the BR '||p_ps_id||' from its remittance');
AR_BILLS_MAINTAIN_PUB.DeSelect_BR_Remit(p_ps_id,l_new_status);
arp_util.debug('create_remit_batch: ' || 'Action Select - BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);
AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,p_ps_id,l_new_status);
arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
select org_id into l_org_id
from ar_system_parameters;
arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
select org_id into l_org_id
from ar_system_parameters;
arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
| 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';
arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (+)');
SAVEPOINT update_batch_status_PVT;
arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (-)');
arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
ROLLBACK TO update_batch_status_PVT;
arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
ROLLBACK TO update_batch_status_PVT;
arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
arp_util.debug('update_batch_status: ' || SQLERRM);
ROLLBACK TO update_batch_status_PVT;
END update_batch_status;