[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(*)
INTO l_count
FROM ra_batches
--WHERE batch_source_id = p_batch_source_id
WHERE name = p_name;
| Validates that a batch to be deleted contains no transactions. |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_batch_id |
| OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 05-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE ar_empty_batch ( p_batch_id IN number ) IS
l_count number := 0;
SELECT count(*)
INTO l_count
FROM ra_customer_trx
WHERE batch_id = p_batch_id;
| val_insert_batch |
| |
| DESCRIPTION |
| Does validation that is required when a new batch is inserted. |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_batch_rec |
| OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 05-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE val_insert_batch ( p_batch_rec IN ra_batches%rowtype ) IS
BEGIN
arp_util.debug('arp_process_batch.val_insert_batch()+');
arp_util.debug('arp_process_batch.val_insert_batch()-');
arp_util.debug('EXCEPTION: arp_process_batch.val_insert_batch()');
arp_util.debug('------ parameters for val_insert_batch() -------');
| val_update_batch |
| |
| DESCRIPTION |
| Does validation that is required when a batch is updated. |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_batch_rec |
| OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 05-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE val_update_batch ( p_batch_rec IN ra_batches%rowtype ) IS
BEGIN
arp_util.debug('arp_process_batchval_update_batch()+');
arp_util.debug('arp_process_batch.val_update_batch()-');
arp_util.debug('EXCEPTION: arp_process_batch.val_update_batch()');
arp_util.debug('------ parameters for val_update_batch() -------');
| val_delete__batch |
| |
| DESCRIPTION |
| Does validation that is required when a batch is deleted. |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_batch_rec |
| OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 05-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE val_delete_batch ( p_batch_rec IN ra_batches%rowtype ) IS
BEGIN
arp_util.debug('arp_process_batch.val_delete_batch()+');
arp_util.debug('arp_process_batch.val_delete_batch()-');
arp_util.debug('EXCEPTION: arp_process_batch.val_delete_batch()');
arp_util.debug('------ parameters for val_delete_batch() -------');
| insert_batch |
| |
| DESCRIPTION |
| Inserts a record into ra_batches. |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_batch_rec |
| OUT: |
| P_batch_id |
| IN/ OUT: |
| p_name |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 13-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE insert_batch(
p_form_name IN varchar2,
p_form_version IN number,
p_batch_rec ra_batches%rowtype,
p_batch_id OUT NOCOPY ra_batches.batch_id%type,
p_name IN OUT NOCOPY ra_batches.name%type)
IS
BEGIN
arp_util.debug('arp_process_batch.insert_batch()+');
arp_process_batch.val_insert_batch(p_batch_rec);
| Call the table handler to insert the batch |
+---------------------------------------------*/
arp_tbat_pkg.insert_p( p_batch_rec,
p_batch_id,
p_name);
arp_util.debug('arp_process_batch.insert_batch()-');
arp_util.debug('EXCEPTION: arp_process_batch.insert_batch()');
arp_util.debug('---------- parameters for insert_batch() ---------');
| update_batch |
| |
| DESCRIPTION |
| Updates a ra_batches record |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_batch_rec |
| OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 13-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE update_batch(
p_form_name IN varchar2,
p_form_version IN number,
p_batch_id IN ra_batches.batch_id%type,
p_batch_rec IN ra_batches%rowtype ) IS
BEGIN
arp_util.debug('arp_process_batch.update_batch()+');
arp_process_batch.val_update_batch(p_batch_rec);
| call the table-handler to update the batch record |
+-----------------------------------------------------*/
arp_tbat_pkg.update_p( p_batch_rec,
p_batch_id);
arp_util.debug('arp_process_batch.update_batch()-');
arp_util.debug('EXCEPTION: arp_process_batch.update_batch()');
arp_util.debug('---------- parameters for update_batch() ---------');
| delete_batch |
| |
| DESCRIPTION |
| Deletes records from ra_batches |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_batch_id |
| OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 13-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE delete_batch(p_form_name IN varchar2,
p_form_version IN number,
p_batch_id IN ra_batches.batch_id%type,
p_batch_rec IN ra_batches%rowtype) IS
BEGIN
arp_util.debug('arp_process_batch.delete_batch()+');
arp_process_batch.val_delete_batch(p_batch_rec);
| call the table-handler to delete the batch record |
+-----------------------------------------------------*/
arp_tbat_pkg.delete_p( p_batch_id );
arp_util.debug('arp_process_batch.delete_batch()-');
arp_util.debug('EXCEPTION: arp_process_batch.delete_batch()');
arp_util.debug('---------- parameters for delete_batch() ---------');
| insert_batch_cover |
| |
| DESCRIPTION |
| Cover for calling the batch entity handler insert_batch |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_batch_source_id |
| p_batch_date |
| p_gl_date |
| p_status |
| p_type |
| p_currency_code |
| p_exchange_rate_type |
| p_exchange_date |
| p_exchange_rate |
| p_control_count |
| p_control_amount |
| p_comments |
| p_set_of_books_id |
| p_purged_children_flag |
| p_attribute_category |
| p_attribute1 - 15 |
| OUT: |
| p_batch_id |
| IN OUT: |
| p_name |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 10-NOV-95 Subash C Created |
| |
+===========================================================================*/
PROCEDURE insert_batch_cover(
p_form_name IN varchar2,
p_form_version IN number,
p_batch_source_id IN ra_batches.batch_source_id%type,
p_batch_date IN ra_batches.batch_date%type,
p_gl_date IN ra_batches.gl_date%type,
p_status IN ra_batches.status%type,
p_type IN ra_batches.type%type,
p_currency_code IN ra_batches.currency_code%type,
p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
p_exchange_date IN ra_batches.exchange_date%type,
p_exchange_rate IN ra_batches.exchange_rate%type,
p_control_count IN ra_batches.control_count%type,
p_control_amount IN ra_batches.control_amount%type,
p_comments IN ra_batches.comments%type,
p_set_of_books_id IN ra_batches.set_of_books_id%type,
p_purged_children_flag IN ra_batches.purged_children_flag%type,
p_attribute_category IN ra_batches.attribute_category%type,
p_attribute1 IN ra_batches.attribute1%type,
p_attribute2 IN ra_batches.attribute2%type,
p_attribute3 IN ra_batches.attribute3%type,
p_attribute4 IN ra_batches.attribute4%type,
p_attribute5 IN ra_batches.attribute5%type,
p_attribute6 IN ra_batches.attribute6%type,
p_attribute7 IN ra_batches.attribute7%type,
p_attribute8 IN ra_batches.attribute8%type,
p_attribute9 IN ra_batches.attribute9%type,
p_attribute10 IN ra_batches.attribute10%type,
p_attribute11 IN ra_batches.attribute11%type,
p_attribute12 IN ra_batches.attribute12%type,
p_attribute13 IN ra_batches.attribute13%type,
p_attribute14 IN ra_batches.attribute14%type,
p_attribute15 IN ra_batches.attribute15%type,
p_batch_id OUT NOCOPY ra_batches.batch_id%type,
p_name IN OUT NOCOPY ra_batches.name%type)
IS
l_batch_rec ra_batches%rowtype;
arp_util.debug('arp_process_batch.insert_batch_cover()+');
arp_process_batch.insert_batch(p_form_name,
p_form_version,
l_batch_rec,
l_batch_id,
l_name);
arp_util.debug('arp_process_batch.insert_batch_cover()-');
arp_util.debug('EXCEPTION : arp_process_batch.insert_batch_cover');
| update_batch_cover |
| |
| DESCRIPTION |
| Cover for calling the batch entity handler update_batch |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_batch_id |
| p_name |
| p_batch_source_id |
| p_batch_date |
| p_gl_date |
| p_status |
| p_type |
| p_currency_code |
| p_exchange_rate_type |
| p_exchange_date |
| p_exchange_rate |
| p_control_count |
| p_control_amount |
| p_comments |
| p_set_of_books_id |
| p_purged_children_flag |
| p_attribute_category |
| p_attribute1 - 15 |
| OUT: |
| None |
| IN OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 10-NOV-95 Subash C Created |
| |
+===========================================================================*/
PROCEDURE update_batch_cover(
p_form_name IN varchar2,
p_form_version IN number,
p_batch_id IN ra_batches.batch_id%type,
p_name IN ra_batches.name%type,
p_batch_source_id IN ra_batches.batch_source_id%type,
p_batch_date IN ra_batches.batch_date%type,
p_gl_date IN ra_batches.gl_date%type,
p_status IN ra_batches.status%type,
p_type IN ra_batches.type%type,
p_currency_code IN ra_batches.currency_code%type,
p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
p_exchange_date IN ra_batches.exchange_date%type,
p_exchange_rate IN ra_batches.exchange_rate%type,
p_control_count IN ra_batches.control_count%type,
p_control_amount IN ra_batches.control_amount%type,
p_comments IN ra_batches.comments%type,
p_set_of_books_id IN ra_batches.set_of_books_id%type,
p_purged_children_flag IN ra_batches.purged_children_flag%type,
p_attribute_category IN ra_batches.attribute_category%type,
p_attribute1 IN ra_batches.attribute1%type,
p_attribute2 IN ra_batches.attribute2%type,
p_attribute3 IN ra_batches.attribute3%type,
p_attribute4 IN ra_batches.attribute4%type,
p_attribute5 IN ra_batches.attribute5%type,
p_attribute6 IN ra_batches.attribute6%type,
p_attribute7 IN ra_batches.attribute7%type,
p_attribute8 IN ra_batches.attribute8%type,
p_attribute9 IN ra_batches.attribute9%type,
p_attribute10 IN ra_batches.attribute10%type,
p_attribute11 IN ra_batches.attribute11%type,
p_attribute12 IN ra_batches.attribute12%type,
p_attribute13 IN ra_batches.attribute13%type,
p_attribute14 IN ra_batches.attribute14%type,
p_attribute15 IN ra_batches.attribute15%type)
IS
l_batch_rec ra_batches%rowtype;
arp_util.debug('arp_process_batch.update_batch_cover()+');
arp_process_batch.update_batch(p_form_name,
p_form_version,
p_batch_id,
l_batch_rec);
arp_util.debug('arp_process_batch.update_batch_cover()-');
arp_util.debug('EXCEPTION : arp_process_batch.update_batch_cover');
| delete_batch_cover |
| |
| DESCRIPTION |
| Cover for calling the batch entity handler delete_batch |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_batch_id |
| OUT: |
| None |
| IN OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 10-NOV-95 Subash C Created |
| |
+===========================================================================*/
PROCEDURE delete_batch_cover(
p_form_name IN varchar2,
p_form_version IN number,
p_batch_id IN ra_batches.batch_id%type)
IS
l_batch_rec ra_batches%rowtype;
arp_util.debug('arp_process_batch.delete_batch_cover()+');
arp_process_batch.delete_batch(p_form_name,
p_form_version,
p_batch_id,
l_batch_rec);
arp_util.debug('arp_process_batch.delete_batch_cover()-');
arp_util.debug('EXCEPTION : arp_process_batch.delete_batch_cover');