The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT trxtype.type,
trxtype.name,
trxtype.allow_overapplication_flag ,
trxtype.natural_application_only_flag,
trxtype.creation_sign
INTO p_trx_type_rec.type,
p_trx_type_rec.name,
p_trx_type_rec.allow_overapplication_flag,
p_trx_type_rec.natural_application_only_flag,
p_trx_type_rec.creation_sign
FROM ra_cust_trx_types trxtype, ra_customer_trx header
WHERE header.customer_trx_id = p_customer_trx_id
AND trxtype.cust_trx_type_id = header.cust_trx_type_id;
| 4. If all fine then update ra_customer_trx with complete_flag =Y|
| and call to maintain the payment schedules |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_ct_pkg.lock_fetch_p |
| arp_trx_complete_chk.do_completion_checking |
| FND_SEQNUM.GET_SEQ_VAL |
| arp_ct_pkg.update_p |
| ARP_PROCESS_HEADER_POST_COMMIT.post_commit |
| |
| ARGUMENTS : |
| IN: |
| p_api_version |
| p_init_msg_list |
| p_commit |
| p_validation_level |
| p_customer_trx_id |
| OUT: |
| x_return_status |
| x_msg_count |
| x_mssg_data |
| IN/ OUT: |
| None
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| |
+===========================================================================*/
PROCEDURE COMPLETE_TRANSACTION(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := NULL,
p_commit IN VARCHAR2 := NULL,
p_validation_level IN NUMBER := NULL,
p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_api_name CONSTANT VARCHAR2(30) := 'COMPLETE_TRANSACTION';
SELECT copy_doc_number_flag
INTO l_copy_doc_num_flag
FROM RA_BATCH_SOURCES batch, RA_CUSTOMER_TRX header
WHERE batch.batch_source_id = header.batch_source_id
AND header.customer_trx_id = p_customer_trx_id;
arp_ct_pkg.update_p(l_trx_rec,p_customer_trx_id);
| 4. If none of above then update ra_customer_trx with |
| complete_flag =N and call to maintain the payment schedules |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_ct_pkg.lock_fetch_p |
| arpt_sql_func_util.get_posted_flag |
| arpt_sql_func_util.get_activity_flag
| arp_ct_pkg.update_p |
| ARP_PROCESS_HEADER_POST_COMMIT.post_commit |
| |
| ARGUMENTS : |
| IN: |
| p_api_version |
| p_init_msg_list |
| p_commit |
| p_validation_level |
| p_customer_trx_id |
| OUT: |
| x_return_status |
| x_msg_count |
| x_mssg_data |
| IN/ OUT: |
| None
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| |
+===========================================================================*/
PROCEDURE INCOMPLETE_TRANSACTION(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := NULL,
p_commit IN VARCHAR2 := NULL,
p_validation_level IN NUMBER := NULL,
p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_api_name CONSTANT VARCHAR2(30) := 'INCOMPLETE_TRANSACTION';
FND_MESSAGE.Set_Name('AR', 'AR_TAPI_CANT_UPDATE_POSTED');
FND_MESSAGE.Set_Name('AR', 'AR_TAPI_CANT_UPDATE_POSTED');
FND_MESSAGE.Set_Name('AR', 'AR_TAPI_CANT_UPDATE_DM_REV');
FND_MESSAGE.Set_Name('AR', 'AR_TAPI_CANT_UPDATE_CB');
arp_ct_pkg.update_p(l_trx_rec,p_customer_trx_id);