[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| val_insert_salescredit |
| |
| DESCRIPTION |
| Does validation necessary when a new salescredit is inserted. |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_srep_rec |
| OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 19-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE val_insert_salescredit ( p_srep_rec IN
ra_cust_trx_line_salesreps%rowtype ) IS
BEGIN
arp_util.debug('arp_process_salescredit.val_insert_salescredit()+');
arp_util.debug('arp_process_salescredit.val_val_insert_salescredit()-');
'EXCEPTION: arp_process_salescredit.val_insert_salescredit()');
arp_util.debug('---------- val_insert_salescredit() ---------');
| val_update_salescredit |
| |
| DESCRIPTION |
| Does validation that is required when a salescredit is updated. |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_srep_rec |
| OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 19-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE val_update_salescredit ( p_srep_rec IN
ra_cust_trx_line_salesreps%rowtype ) IS
BEGIN
arp_util.debug('arp_process_salescredit.val_update_salescredit()+');
arp_util.debug('arp_process_salescredit.val_val_update_salescredit()-');
'EXCEPTION: arp_process_salescredit.val_update_salescredit()');
arp_util.debug('---------- val_update_salescredit() ---------');
| val_delete_salescredit |
| |
| DESCRIPTION |
| Does validation that is required when a salescredit is deleted. |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_srep_rec |
| OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 19-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE val_delete_salescredit ( p_srep_rec IN
ra_cust_trx_line_salesreps%rowtype ) IS
BEGIN
arp_util.debug('arp_process_salescredit.val_delete_salescredit()+');
arp_util.debug('arp_process_salescredit.val_delete_salescredit()-');
'EXCEPTION: arp_process_salescredit.val_delete_salescredit()');
arp_util.debug('---------- val_update_salescredit() ---------');
| p_delete_flag |
| OUT: |
| p_posted_flag |
| p_salesrep_changed_flag |
| p_amount_percent_changed_flag |
| p_rev_amt_percent_changed_flag |
| p_default_record_flag |
| p_revised_backout_flag |
| IN/ OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 17-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE set_flags(p_cust_trx_line_salesrep_id IN
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
p_backout_flag IN boolean,
p_delete_flag IN boolean,
p_posted_flag OUT NOCOPY boolean,
p_salesrep_changed_flag OUT NOCOPY boolean,
p_amount_percent_changed_flag OUT NOCOPY boolean,
p_rev_amt_percent_changed_flag OUT NOCOPY boolean,
p_default_record_flag OUT NOCOPY boolean,
p_revised_backout_flag OUT NOCOPY boolean) IS
l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
p_delete_flag = TRUE
)
)
THEN l_revised_backout_flag := TRUE;
arp_util.debug('p_delete_flag = ' ||
arp_trx_util.boolean_to_varchar2(p_delete_flag));
| Inserts two records to backout the existing salescredit record. |
| This procedure is called if backout is required and the salescredit's |
| salesrep name or number has changed. |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_old_srep_rec |
| p_new_srep_rec |
| p_run_auto_accounting_flag |
| OUT: |
| p_status |
| IN/ OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 12-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE backout_salesrep(
p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
p_run_auto_accounting_flag IN boolean,
p_status OUT NOCOPY varchar2 )
IS
l_cust_trx_line_salesrep_id
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
| insert the new row |
+--------------------------*/
/*---------------------------------------------------------------+
| If a new value was specified in the srep rec passed into |
| update_salescredit(). use that value. Otherwise, use the |
| value from the original salescredit line. |
+---------------------------------------------------------------*/
arp_ctls_pkg.merge_srep_recs(l_old_srep_rec,
l_new_srep_rec,
l_new_srep_rec);
| Call the table handler to insert the new salesrep record |
+-------------------------------------------------------------*/
arp_ctls_pkg.insert_p( l_new_srep_rec,
l_cust_trx_line_salesrep_id);
arp_ctls_pkg.insert_p( l_old_srep_rec,
l_cust_trx_line_salesrep_id);
| Inserts one record to backout the existing salescredit record. |
| This procedure is called if backout is required and the amount or |
| percent of a salescredit record has changed. |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_old_srep_rec |
| p_new_srep_rec |
| p_run_auto_accounting_flag |
| OUT: |
| p_status |
| IN/ OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 12-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE backout_amount(
p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
p_run_auto_accounting_flag IN boolean,
p_status OUT NOCOPY varchar2 )
IS
l_cust_trx_line_salesrep_id
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
| update_salescredit(). use that value. Otherwise, use the |
| value from the original salescredit line. |
+---------------------------------------------------------------*/
arp_ctls_pkg.merge_srep_recs(l_old_srep_rec,
l_new_srep_rec,
l_old_srep_rec);
arp_ctls_pkg.insert_p( l_old_srep_rec,
l_cust_trx_line_salesrep_id);
| insert_salescredit |
| |
| DESCRIPTION |
| Inserts a record into ra_cust_trx_line_salesreps |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_run_auto_accounting_flag |
| p_srep_rec |
| p_cust_trx_line_salesrep_id |
| OUT: |
| p_status |
| IN/ OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 12-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE insert_salescredit(
p_form_name IN varchar2,
p_form_version IN number,
p_run_auto_accounting_flag IN boolean,
p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
p_cust_trx_line_salesrep_id OUT NOCOPY
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
p_status OUT NOCOPY varchar2)
IS
l_cust_trx_line_salesrep_id
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
arp_util.debug('arp_process_salescredit.insert_salescredit()+');
arp_process_salescredit.val_insert_salescredit(p_srep_rec);
arp_ctls_pkg.insert_p( p_srep_rec,
l_cust_trx_line_salesrep_id);
arp_util.debug('arp_process_salescredit.insert_salescredit()-');
arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');
arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');
arp_util.debug('---------- insert_salescredit() ---------');
| update_salescredit |
| |
| DESCRIPTION |
| Updates a record in ra_cust_trx_line_salesreps |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_run_auto_accounting_flag |
| p_backout_flag |
| p_posted_flag |
| p_salesrep_changed_flag |
| p_amount_percent_changed_flag |
| p_cust_trx_line_salesrep_id |
| p_customer_trx_id |
| p_srep_rec |
| OUT: |
| p_backout_done_flag |
| p_status |
| IN/ OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 12-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE update_salescredit(
p_form_name IN varchar2,
p_form_version IN number,
p_run_auto_accounting_flag IN boolean,
p_backout_flag IN boolean,
p_cust_trx_line_salesrep_id IN
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
p_customer_trx_id IN
ra_customer_trx.customer_trx_id%type,
p_customer_trx_line_id IN
ra_customer_trx_lines.customer_trx_line_id%type,
p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
p_backout_done_flag OUT NOCOPY boolean,
p_status OUT NOCOPY varchar2)
IS
l_cust_trx_line_salesrep_id
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
arp_util.debug('arp_process_salescredit.update_salescredit()+');
FALSE, -- p_delete_flag
l_posted_flag,
l_salesrep_changed_flag,
l_amount_percent_changed_flag,
l_rev_amt_percent_changed_flag,
l_default_records_flag,
l_backout_flag);
arp_process_salescredit.val_update_salescredit(p_srep_rec);
| THEN do a simple update |
| ELSE IF the salesrep name has changed |
| THEN create two offsetting records |
| ELSE IF the amount or percent has changed |
| THEN create one ofsetting record |
| ELSE do a simple update |
+------------------------------------------------------*/
IF (l_backout_flag = FALSE)
THEN
/*--------------------------------------+
| Do a simple update with no backout. |
+--------------------------------------*/
arp_util.debug('simple update - case 1');
arp_ctls_pkg.update_p( p_srep_rec,
p_cust_trx_line_salesrep_id);
| Insert 2 rows into ra_cust_trx_line_salesreps |
| 1. amount = -, |
| ccid = |
| 2. amount = , |
| ccid = |
+------------------------------------------------*/
backout_salesrep(l_old_srep_rec,
p_srep_rec,
p_run_auto_accounting_flag,
l_status1 );
| Insert one new row to backout the old amount. |
| amount = - |
+------------------------------------------------*/
backout_amount(l_old_srep_rec,
p_srep_rec,
p_run_auto_accounting_flag,
l_status2 );
| Do a simple update with no backout. |
| Nothing of consequence has changed. |
+--------------------------------------*/
arp_util.debug('simple update - case 2');
arp_ctls_pkg.update_p(p_srep_rec,
p_cust_trx_line_salesrep_id);
| revenue pct, or revenue amount were updated. |
+-------------------------------------------------------------------*/
IF (
(
l_salesrep_changed_flag = TRUE OR
l_rev_amt_percent_changed_flag = TRUE
)
AND l_backout_flag = FALSE
)
THEN
arp_ctls_pkg.erase_foreign_key_references(
p_cust_trx_line_salesrep_id,
NULL,
NULL);
arp_util.debug('arp_process_salescredit.update_salescredit()-');
arp_util.debug('EXCEPTION: arp_process_salescredit.update_salescredit()');
arp_util.debug('---------- parameters for update_salescredit() ---------');
| delete_salescredit |
| |
| DESCRIPTION |
| Deletes a record from ra_cust_trx_line_salesreps. |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_run_auto_accounting_flag |
| p_cust_trx_line_salesrep_id |
| p_srep_rec |
| p_backout_flag |
| OUT: |
| p_status |
| IN/ OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 12-JUL-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE delete_salescredit(
p_form_name IN varchar2,
p_form_version IN number,
p_run_auto_accounting_flag IN boolean,
p_cust_trx_line_salesrep_id IN
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
p_customer_trx_id IN
ra_customer_trx.customer_trx_id%type,
p_customer_trx_line_id IN
ra_customer_trx_lines.customer_trx_line_id%type,
p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
p_backout_flag IN boolean DEFAULT FALSE,
p_backout_done_flag OUT NOCOPY boolean,
p_status OUT NOCOPY varchar2)
IS
l_backout_flag boolean;
arp_util.debug('arp_process_salescredit.delete_salescredit()+');
arp_process_salescredit.val_delete_salescredit(p_srep_rec);
TRUE, -- delete_flag
l_posted_flag,
l_salesrep_changed_flag,
l_amount_percent_changed_flag,
l_rev_amt_percent_changed_flag,
l_default_records_flag,
l_backout_flag);
| If no backout is required, do a simple delete. |
| Otherwise, create an offsetting salescredit record and optionally |
| an ofsetting distribution record. |
+---------------------------------------------------------------------*/
IF (l_backout_flag = FALSE)
THEN
/*-----------------------------------------------------------+
| call the table-handler to delete the salescredit record |
+-----------------------------------------------------------*/
arp_ctls_pkg.delete_p(p_cust_trx_line_salesrep_id,
p_customer_trx_line_id);
arp_util.debug('arp_process_salescredit.delete_salescredit()-');
arp_util.debug('EXCEPTION: arp_process_salescredit.delete_salescredit()');
arp_util.debug('---------- delete_salescredit() ---------');
| p_delete_scredits_first_flag |
| p_run_autoaccounting_flag |
| OUT: |
| p_status |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 24-JUL-95 Charlie Tomberg Created |
| 28-NOV-95 Martin Johnson nvl p_memo_line_type |
| |
+===========================================================================*/
PROCEDURE create_line_salescredits(p_customer_trx_id IN
ra_customer_trx_lines.customer_trx_id%type,
p_customer_trx_line_id IN
ra_customer_trx_lines.customer_trx_line_id%type,
p_memo_line_type IN
ar_memo_lines.line_type%type,
p_delete_scredits_first_flag IN
varchar2,
p_run_autoaccounting_flag IN varchar2,
p_status OUT NOCOPY varchar2)
IS
l_status1 VARCHAR2(100);
SELECT previous_customer_trx_id ,
primary_salesrep_id
into
prev_customer_trx_id,
p_salesrep_id
FROM ra_customer_trx
WHERE customer_trx_id = p_customer_trx_id;
| Delete salescredits first if desired |
+----------------------------------------*/
IF ( p_delete_scredits_first_flag = 'Y' )
THEN
IF ( p_customer_trx_line_id IS NOT NULL )
THEN
arp_ctls_pkg.delete_f_ctl_id( p_customer_trx_line_id );
THEN arp_ctls_pkg.delete_f_ct_id( p_customer_trx_id, FALSE );
| insert a single salescredit record that corresponds |
| to the header salesrep. |
| Otherwise, create salescredits that correspond to |
| the header default salescredits. |
+-------------------------------------------------------*/
/*-------------------------------------------------+
|Bug 1157776 If this is a Credit Memo, |
|then call arp_ctls_pkg.insert_f_cmn_ct_ctl_id |
+-------------------------------------------------*/
/*------------------------------------------------------------------+
| Bug 1485133. |
| We need to check if the RA_CUSTOMER_TRX.PRIMARY_SALESREP_ID |
| is not null before calling arp_ctls_pkg.insert_f_cmn_ct_ctl_id |
+------------------------------------------------------------------*/
IF (prev_customer_trx_id is not null) then
IF (p_salesrep_id is not null) then
arp_ctls_pkg.insert_f_cmn_ct_ctl_id( p_customer_trx_id,
p_customer_trx_line_id );
arp_ctls_pkg.insert_f_ct_ctl_id( p_customer_trx_id,
p_customer_trx_line_id );
| insert_salescredit_cover |
| |
| DESCRIPTION |
| Converts column parameters to a salescredit record and |
| inserts a salescredit line. |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_run_auto_accounting_flag |
| p_customer_trx_id |
| p_customer_trx_line_id |
| p_salesrep_id |
| p_revenue_amount_split |
| p_non_revenue_amount_split |
| p_non_revenue_percent_split |
| p_revenue_percent_split |
| p_prev_cust_trx_line_srep_id |
| p_attribute_category |
| p_attribute1 |
| p_attribute2 |
| p_attribute3 |
| p_attribute4 |
| p_attribute5 |
| p_attribute6 |
| p_attribute7 |
| p_attribute8 |
| p_attribute9 |
| p_attribute10 |
| p_attribute11 |
| p_attribute12 |
| p_attribute13 |
| p_attribute14 |
| p_attribute15 |
| p_revenue_salesgroup_id |
| p_non_revenue_salesgroup_id |
| OUT: |
| p_cust_trx_line_salesrep_id |
| p_status |
| IN/ OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 25-SEP-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE insert_salescredit_cover(
p_form_name IN varchar2,
p_form_version IN number,
p_run_auto_accounting_flag IN boolean,
p_customer_trx_id IN
ra_cust_trx_line_salesreps.customer_trx_id%type,
p_customer_trx_line_id IN
ra_cust_trx_line_salesreps.customer_trx_line_id%type,
p_salesrep_id IN
ra_cust_trx_line_salesreps.salesrep_id%type,
p_revenue_amount_split IN
ra_cust_trx_line_salesreps.revenue_amount_split%type,
p_non_revenue_amount_split IN
ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
p_non_revenue_percent_split IN
ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
p_revenue_percent_split IN
ra_cust_trx_line_salesreps.revenue_percent_split%type,
p_prev_cust_trx_line_srep_id IN
ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
p_attribute_category IN
ra_cust_trx_line_salesreps.attribute_category%type,
p_attribute1 IN
ra_cust_trx_line_salesreps.attribute1%type,
p_attribute2 IN
ra_cust_trx_line_salesreps.attribute2%type,
p_attribute3 IN
ra_cust_trx_line_salesreps.attribute3%type,
p_attribute4 IN
ra_cust_trx_line_salesreps.attribute4%type,
p_attribute5 IN
ra_cust_trx_line_salesreps.attribute5%type,
p_attribute6 IN
ra_cust_trx_line_salesreps.attribute6%type,
p_attribute7 IN
ra_cust_trx_line_salesreps.attribute7%type,
p_attribute8 IN
ra_cust_trx_line_salesreps.attribute8%type,
p_attribute9 IN
ra_cust_trx_line_salesreps.attribute9%type,
p_attribute10 IN
ra_cust_trx_line_salesreps.attribute10%type,
p_attribute11 IN
ra_cust_trx_line_salesreps.attribute11%type,
p_attribute12 IN
ra_cust_trx_line_salesreps.attribute12%type,
p_attribute13 IN
ra_cust_trx_line_salesreps.attribute13%type,
p_attribute14 IN
ra_cust_trx_line_salesreps.attribute14%type,
p_attribute15 IN
ra_cust_trx_line_salesreps.attribute15%type,
p_cust_trx_line_salesrep_id OUT NOCOPY
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
p_status OUT NOCOPY varchar2,
p_revenue_salesgroup_id IN
ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
p_non_revenue_salesgroup_id IN
ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
IS
l_srep_rec ra_cust_trx_line_salesreps%rowtype;
arp_util.debug('arp_process_salescredit.insert_salescredit_cover()+');
insert_salescredit(
p_form_name,
p_form_version,
p_run_auto_accounting_flag,
l_srep_rec,
p_cust_trx_line_salesrep_id,
p_status );
arp_util.debug('arp_process_salescredit.insert_salescredit_cover()-');
'EXCEPTION: arp_process_salescredit.insert_salescredit_cover()');
arp_util.debug('------- parameters for insert_salescredit_cover() ' ||
'---------');
| update_salescredit_cover |
| |
| DESCRIPTION |
| Converts column parameters to a salescredit record and |
| updates a salescredit line. |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_run_auto_accounting_flag |
| p_backout_flag |
| p_cust_trx_line_salesrep_id |
| p_customer_trx_id |
| p_customer_trx_line_id |
| p_salesrep_id |
| p_revenue_amount_split |
| p_non_revenue_amount_split |
| p_non_revenue_percent_split |
| p_revenue_percent_split |
| p_prev_cust_trx_line_srep_id |
| p_attribute_category |
| p_attribute1 |
| p_attribute2 |
| p_attribute3 |
| p_attribute4 |
| p_attribute5 |
| p_attribute6 |
| p_attribute7 |
| p_attribute8 |
| p_attribute9 |
| p_attribute10 |
| p_attribute11 |
| p_attribute12 |
| p_attribute13 |
| p_attribute14 |
| p_attribute15 |
| p_revenue_salesgroup_id |
| p_non_revenue_salesgroup_id |
| OUT: |
| p_backout_done_flag |
| p_status |
| IN/ OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 25-SEP-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE update_salescredit_cover(
p_form_name IN varchar2,
p_form_version IN number,
p_run_auto_accounting_flag IN boolean,
p_backout_flag IN boolean,
p_cust_trx_line_salesrep_id IN
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
p_customer_trx_id IN
ra_cust_trx_line_salesreps.customer_trx_id%type,
p_customer_trx_line_id IN
ra_cust_trx_line_salesreps.customer_trx_line_id%type,
p_salesrep_id IN
ra_cust_trx_line_salesreps.salesrep_id%type,
p_revenue_amount_split IN
ra_cust_trx_line_salesreps.revenue_amount_split%type,
p_non_revenue_amount_split IN
ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
p_non_revenue_percent_split IN
ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
p_revenue_percent_split IN
ra_cust_trx_line_salesreps.revenue_percent_split%type,
p_prev_cust_trx_line_srep_id IN
ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
p_attribute_category IN
ra_cust_trx_line_salesreps.attribute_category%type,
p_attribute1 IN
ra_cust_trx_line_salesreps.attribute1%type,
p_attribute2 IN
ra_cust_trx_line_salesreps.attribute2%type,
p_attribute3 IN
ra_cust_trx_line_salesreps.attribute3%type,
p_attribute4 IN
ra_cust_trx_line_salesreps.attribute4%type,
p_attribute5 IN
ra_cust_trx_line_salesreps.attribute5%type,
p_attribute6 IN
ra_cust_trx_line_salesreps.attribute6%type,
p_attribute7 IN
ra_cust_trx_line_salesreps.attribute7%type,
p_attribute8 IN
ra_cust_trx_line_salesreps.attribute8%type,
p_attribute9 IN
ra_cust_trx_line_salesreps.attribute9%type,
p_attribute10 IN
ra_cust_trx_line_salesreps.attribute10%type,
p_attribute11 IN
ra_cust_trx_line_salesreps.attribute11%type,
p_attribute12 IN
ra_cust_trx_line_salesreps.attribute12%type,
p_attribute13 IN
ra_cust_trx_line_salesreps.attribute13%type,
p_attribute14 IN
ra_cust_trx_line_salesreps.attribute14%type,
p_attribute15 IN
ra_cust_trx_line_salesreps.attribute15%type,
p_backout_done_flag OUT NOCOPY boolean,
p_status OUT NOCOPY varchar2,
p_revenue_salesgroup_id IN
ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
p_non_revenue_salesgroup_id IN
ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
IS
l_srep_rec ra_cust_trx_line_salesreps%rowtype;
arp_util.debug('arp_process_salescredit.update_salescredit_cover()+');
update_salescredit(
p_form_name,
p_form_version,
p_run_auto_accounting_flag,
p_backout_flag,
p_cust_trx_line_salesrep_id,
p_customer_trx_id,
p_customer_trx_line_id,
l_srep_rec,
p_backout_done_flag,
p_status );
arp_util.debug('arp_process_salescredit.update_salescredit_cover()-');
'EXCEPTION: arp_process_salescredit.update_salescredit_cover()');
arp_util.debug('------- parameters for update_salescredit_cover() ' ||
'---------');
| delete_salescredit_cover |
| |
| DESCRIPTION |
| Converts column parameters to a salescredit record and |
| delete a salescredit line. |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_run_auto_accounting_flag |
| p_backout_flag |
| p_cust_trx_line_salesrep_id |
| p_customer_trx_id |
| p_customer_trx_line_id |
| p_salesrep_id |
| p_revenue_amount_split |
| p_non_revenue_amount_split |
| p_non_revenue_percent_split |
| p_revenue_percent_split |
| p_prev_cust_trx_line_srep_id |
| p_attribute_category |
| p_attribute1 |
| p_attribute2 |
| p_attribute3 |
| p_attribute4 |
| p_attribute5 |
| p_attribute6 |
| p_attribute7 |
| p_attribute8 |
| p_attribute9 |
| p_attribute10 |
| p_attribute11 |
| p_attribute12 |
| p_attribute13 |
| p_attribute14 |
| p_attribute15 |
| p_revenue_salesgroup_id |
| p_non_revenue_salesgroup_id |
| OUT: |
| p_backout_done_flag |
| p_status |
| IN/ OUT: |
| None |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 25-SEP-95 Charlie Tomberg Created |
| |
+===========================================================================*/
PROCEDURE delete_salescredit_cover(
p_form_name IN varchar2,
p_form_version IN number,
p_run_auto_accounting_flag IN boolean,
p_backout_flag IN boolean,
p_cust_trx_line_salesrep_id IN
ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
p_customer_trx_id IN
ra_cust_trx_line_salesreps.customer_trx_id%type,
p_customer_trx_line_id IN
ra_cust_trx_line_salesreps.customer_trx_line_id%type,
p_salesrep_id IN
ra_cust_trx_line_salesreps.salesrep_id%type,
p_revenue_amount_split IN
ra_cust_trx_line_salesreps.revenue_amount_split%type,
p_non_revenue_amount_split IN
ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
p_non_revenue_percent_split IN
ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
p_revenue_percent_split IN
ra_cust_trx_line_salesreps.revenue_percent_split%type,
p_prev_cust_trx_line_srep_id IN
ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
p_attribute_category IN
ra_cust_trx_line_salesreps.attribute_category%type,
p_attribute1 IN
ra_cust_trx_line_salesreps.attribute1%type,
p_attribute2 IN
ra_cust_trx_line_salesreps.attribute2%type,
p_attribute3 IN
ra_cust_trx_line_salesreps.attribute3%type,
p_attribute4 IN
ra_cust_trx_line_salesreps.attribute4%type,
p_attribute5 IN
ra_cust_trx_line_salesreps.attribute5%type,
p_attribute6 IN
ra_cust_trx_line_salesreps.attribute6%type,
p_attribute7 IN
ra_cust_trx_line_salesreps.attribute7%type,
p_attribute8 IN
ra_cust_trx_line_salesreps.attribute8%type,
p_attribute9 IN
ra_cust_trx_line_salesreps.attribute9%type,
p_attribute10 IN
ra_cust_trx_line_salesreps.attribute10%type,
p_attribute11 IN
ra_cust_trx_line_salesreps.attribute11%type,
p_attribute12 IN
ra_cust_trx_line_salesreps.attribute12%type,
p_attribute13 IN
ra_cust_trx_line_salesreps.attribute13%type,
p_attribute14 IN
ra_cust_trx_line_salesreps.attribute14%type,
p_attribute15 IN
ra_cust_trx_line_salesreps.attribute15%type,
p_backout_done_flag OUT NOCOPY boolean,
p_status OUT NOCOPY varchar2,
p_revenue_salesgroup_id IN
ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
p_non_revenue_salesgroup_id IN
ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
IS
l_srep_rec ra_cust_trx_line_salesreps%rowtype;
arp_util.debug('arp_process_salescredit.delete_salescredit_cover()+');
delete_salescredit(
p_form_name,
p_form_version,
p_run_auto_accounting_flag,
p_cust_trx_line_salesrep_id,
p_customer_trx_id,
p_customer_trx_line_id,
l_srep_rec,
p_backout_flag,
p_backout_done_flag,
p_status);
arp_util.debug('arp_process_salescredit.delete_salescredit_cover()-');
'EXCEPTION: arp_process_salescredit.delete_salescredit_cover()');
arp_util.debug('------- parameters for delete_salescredit_cover() ' ||
'---------');