[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE validate_args_insert_remit(
p_batch_rec IN AR_BATCHES%ROWTYPE);
PROCEDURE validate_args_update_remit(
p_batch_rec IN AR_BATCHES%ROWTYPE);
| insert_remit |
| |
| DESCRIPTION |
| Procedure called during the process create bills receivable |
| remittance to insert the remittance batch row in the table AR_BATCHES |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| |
+===========================================================================*/
PROCEDURE insert_remit(
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_comments IN AR_BATCHES.comments%TYPE,
p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
p_attribute1 IN AR_BATCHES.attribute1%TYPE,
p_attribute2 IN AR_BATCHES.attribute2%TYPE,
p_attribute3 IN AR_BATCHES.attribute3%TYPE,
p_attribute4 IN AR_BATCHES.attribute4%TYPE,
p_attribute5 IN AR_BATCHES.attribute5%TYPE,
p_attribute6 IN AR_BATCHES.attribute6%TYPE,
p_attribute7 IN AR_BATCHES.attribute7%TYPE,
p_attribute8 IN AR_BATCHES.attribute8%TYPE,
p_attribute9 IN AR_BATCHES.attribute9%TYPE,
p_attribute10 IN AR_BATCHES.attribute10%TYPE,
p_media_reference IN AR_BATCHES.media_reference%TYPE,
p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
l_batch_rec AR_BATCHES%ROWTYPE;
arp_util.debug( 'ARP_BR_REMIT_BATCHES.insert_remit (+)');
UPDATE ar_batch_sources
SET last_batch_num = NVL(last_batch_num,0) + 1
WHERE batch_source_id = l_batch_rec.batch_source_id;
SELECT NVL(last_batch_num,0)
INTO l_batch_rec.name
FROM ar_batch_sources
WHERE batch_source_id = l_batch_rec.batch_source_id;
arp_util.debug( 'ARP_BR_REMIT_BATCHES.insert_remit ... last_batch_num:'||l_batch_rec.name);
arp_br_remit_batches.validate_args_insert_remit(l_batch_rec);
arp_cr_batches_pkg.insert_p(l_batch_rec, l_row_id, p_batch_id);
arp_util.debug( 'ARP_BR_REMIT_BATCHES.insert_remit (-)');
arp_util.debug( 'EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.insert_remit');
END insert_remit;
| validate_args_insert_remit |
| |
| DESCRIPTION |
| Procedure called during the process create bills receivable |
| remittance to validate the remittance batch row |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| |
+===========================================================================*/
PROCEDURE validate_args_insert_remit(
p_batch_rec IN AR_BATCHES%ROWTYPE) IS
l_row_id varchar2(20) := NULL;
arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_insert_remit (+)');
FND_MESSAGE.set_token('PROCEDURE','validate_args_insert_remit');
arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_insert_remit (-)');
arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_args_insert_remit');
END validate_args_insert_remit;
| Procedure called during the validation before inserting a batch row |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| |
+===========================================================================*/
PROCEDURE validate_currency_code(
p_currency_code IN AR_BATCHES.currency_code%TYPE,
p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
NB number;
SELECT COUNT(*)
INTO NB
FROM FND_CURRENCIES_VL
WHERE currency_code = p_currency_code
AND p_batch_date BETWEEN NVL(start_date_active,p_batch_date) and NVL(end_date_active,p_batch_date);
| Procedure called during the validation before inserting a batch row |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| 31/07/00 - MFLAHAUT |
| Receipt method on the remittance batch has to have the document sequence |
| defined, or the receipt_inherit_inv_num_flag has to be set to 'Y'. |
| |
+===========================================================================*/
PROCEDURE validate_receipt_method(
p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
CURSOR Receipt_method IS
SELECT NVL(MT.receipt_inherit_inv_num_flag,'N'), MT.name
FROM AR_RECEIPT_METHODS MT,
AR_RECEIPT_CLASSES CL,
AR_LOOKUPS LK
WHERE MT.receipt_method_id = p_receipt_method_id
AND p_batch_date BETWEEN NVL(start_date,p_batch_date) and NVL(end_date,p_batch_date)
AND MT.receipt_class_id = CL.receipt_class_id
AND CL.creation_method_code = LK.lookup_code
AND LK.lookup_type = 'RECEIPT_CREATION_METHOD'
AND LK.lookup_code = 'BR_REMIT';
| Procedure called during the validation before inserting a batch row |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| |
+===========================================================================*/
PROCEDURE validate_remit_bank_branch(
p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
NB number;
SELECT COUNT(*)
INTO NB
FROM ce_bank_branches_v
WHERE branch_party_id = p_remittance_bank_branch_id
AND p_batch_date BETWEEN p_batch_date and NVL(end_date,p_batch_date);
| Procedure called during the validation before inserting a batch row |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| |
+===========================================================================*/
PROCEDURE validate_remit_bank_account(
p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
nb NUMBER;
SELECT COUNT(*)
FROM ce_bank_accounts cba,
ce_bank_acct_uses cbau
WHERE cbau.bank_acct_use_id = p_remittance_bank_account_id
AND cbau.bank_account_id = cba.bank_account_id
AND p_date BETWEEN p_date AND
NVL(cbau.end_date,p_date);
| Procedure called during the validation before inserting a batch row |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| |
+===========================================================================*/
PROCEDURE validate_remit_method_code(
p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE) IS
BEGIN
IF PG_DEBUG in ('Y', 'C') THEN
arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_method_code (+)');
| Procedure called during the validation before inserting a batch row |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| |
+===========================================================================*/
PROCEDURE validate_auto_program(
p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
NB number;
SELECT COUNT(*)
INTO NB
FROM ap_payment_programs
WHERE program_id = p_auto_trans_program_id
AND program_type like 'REMIT_TRANSMIT';
| delete_remit |
| |
| DESCRIPTION |
| Procedure called during the process delete bills receivable |
| remittance to delete the remittance batch row in the table AR_BATCHES |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created as part of bug 9147689 |
| |
+===========================================================================*/
PROCEDURE delete_remit( p_batch_id IN ar_batches.batch_id%TYPE ) IS
l_id NUMBER;
SELECT batch_id
INTO l_id
FROM ar_batches
WHERE batch_id = p_batch_id
FOR UPDATE NOWAIT;
ARP_CR_BATCHES_PKG.delete_p(p_batch_id);
arp_standard.debug('EXCEPTION: ARP_BR_REMIT_BATCHES.delete_remit');
END delete_remit;
| update_remit |
| |
| DESCRIPTION |
| Procedure called during the process create bills receivable |
| remittance to update the remittance batch row in the table AR_BATCHES |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| |
+===========================================================================*/
PROCEDURE update_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_status IN AR_BATCHES.status%TYPE,
p_control_count IN AR_BATCHES.control_count%TYPE,
p_control_amount IN AR_BATCHES.control_amount%TYPE,
p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
p_comments IN AR_BATCHES.comments%TYPE,
p_media_reference IN AR_BATCHES.media_reference%TYPE,
p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE) IS
l_api_name CONSTANT varchar2(30) := 'update_remit';
arp_util.debug('ARP_BR_REMIT_BATCHES.update_remit (+)');
SAVEPOINT update_remit_PVT;
arp_br_remit_batches.validate_args_update_remit(l_batch_rec);
arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
arp_util.debug('ARP_BR_REMIT_BATCHES.update_remit (-)');
arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
ROLLBACK TO update_remit_PVT;
arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
ROLLBACK TO update_remit_PVT;
arp_util.debug('EXCEPTION OTHERS:ARP_BR_REMIT_BATCHES.update_remit');
arp_util.debug('update_remit: ' || SQLERRM);
ROLLBACK TO update_remit_PVT;
END update_remit;
| validate_args_update_remit |
| |
| DESCRIPTION |
| Procedure called during the process create bills receivable |
| remittance to validate the remittance batch row |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| |
+===========================================================================*/
PROCEDURE validate_args_update_remit(
p_batch_rec IN AR_BATCHES%ROWTYPE) IS
l_row_id varchar2(20) := NULL;
arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_update_remit (+)');
FND_MESSAGE.set_token('PROCEDURE','validate_args_insert_remit');
arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_update_remit (-)');
arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_args_update_remit');
END validate_args_update_remit;
| remittance to update the remittance batch row in the table AR_BATCHES |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| |
| ARGUMENTS : IN : |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY - Created by Mireille Flahaut - 22/05/2000 |
| |
+===========================================================================*/
PROCEDURE cancel_remit(
p_batch_id IN AR_BATCHES.batch_id%TYPE,
p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
l_batch_rec AR_BATCHES%ROWTYPE;
SELECT payment_schedule_id
FROM AR_PAYMENT_SCHEDULES
WHERE reserved_type = 'REMITTANCE'
AND reserved_value = p_batch_id;
AR_BILLS_MAINTAIN_PUB.Deselect_BR_Remit(l_ps_id,l_new_status);
arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
| update_br_remit_batch_to_crh |
| |
| DESCRIPTION |
| This function is used to update the BR remittance batch id on the |
| current cash receipt history record of the receipt created by BR |
| remittance batch. |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: p_cr_id Cash receipt id of the receipt to be updated |
| p_batch_id Value to be updated |
| OUT: |
| IN/ OUT: |
| NOTES |
| |
| MODIFICATION HISTORY |
| 5-SEP-2000 Jani Rautiainen Created |
| |
+===========================================================================*/
PROCEDURE update_br_remit_batch_to_crh(p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
p_batch_id IN ar_cash_receipt_history.batch_id%TYPE) IS
/*--------------------------------------------+
| Cursor to fetch the current cash receipt |
| history record |
+--------------------------------------------*/
CURSOR receipt_cur IS
SELECT cash_receipt_history_id
FROM ar_cash_receipt_history
WHERE cash_receipt_id = p_cr_id
AND current_record_flag = 'Y';
arp_standard.debug('arp_br_remit_batches.update_br_remit_batch_to_crh()+');
arp_standard.debug('update_br_remit_batch_to_crh: ' || 'current receipt history record cannot be found cr_id = '||to_char(p_cr_id));
| Update the cash receipt history record |
+-----------------------------------------*/
ARP_CR_HISTORY_PKG.update_p(l_crh_rec,
receipt_rec.cash_receipt_history_id);
arp_standard.debug('arp_br_remit_batches.update_br_remit_batch_to_crh()-');
arp_util.debug('EXCEPTION: arp_br_remit_batches.update_br_remit_batch_to_crh');
END update_br_remit_batch_to_crh;