420: | |
421: +===========================================================================*/
422:
423: PROCEDURE run_autoacc_for_scredits( p_customer_trx_id IN
424: ra_customer_trx.customer_trx_id%type,
425: p_customer_trx_line_id IN
426: ra_customer_trx_lines.customer_trx_line_id%type,
427: p_cust_trx_line_salesrep_id IN
428: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type
422:
423: PROCEDURE run_autoacc_for_scredits( p_customer_trx_id IN
424: ra_customer_trx.customer_trx_id%type,
425: p_customer_trx_line_id IN
426: ra_customer_trx_lines.customer_trx_line_id%type,
427: p_cust_trx_line_salesrep_id IN
428: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type
429: DEFAULT NULL,
430: p_status OUT NOCOPY varchar2 ) IS
993: +===========================================================================*/
994:
995:
996: PROCEDURE val_tax_from_revenue (
997: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
998: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
999: p_run_auto_accounting_flag IN BOOLEAN,
1000: p_status OUT NOCOPY VARCHAR2 ) IS
1001:
994:
995:
996: PROCEDURE val_tax_from_revenue (
997: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
998: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
999: p_run_auto_accounting_flag IN BOOLEAN,
1000: p_status OUT NOCOPY VARCHAR2 ) IS
1001:
1002: BEGIN
1207: p_backout_flag IN boolean,
1208: p_cust_trx_line_salesrep_id IN
1209: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1210: p_customer_trx_id IN
1211: ra_customer_trx.customer_trx_id%type,
1212: p_customer_trx_line_id IN
1213: ra_customer_trx_lines.customer_trx_line_id%type,
1214: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1215: p_backout_done_flag OUT NOCOPY boolean,
1209: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1210: p_customer_trx_id IN
1211: ra_customer_trx.customer_trx_id%type,
1212: p_customer_trx_line_id IN
1213: ra_customer_trx_lines.customer_trx_line_id%type,
1214: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1215: p_backout_done_flag OUT NOCOPY boolean,
1216: p_status OUT NOCOPY varchar2)
1217: IS
1487: p_run_auto_accounting_flag IN boolean,
1488: p_cust_trx_line_salesrep_id IN
1489: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1490: p_customer_trx_id IN
1491: ra_customer_trx.customer_trx_id%type,
1492: p_customer_trx_line_id IN
1493: ra_customer_trx_lines.customer_trx_line_id%type,
1494: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1495: p_backout_flag IN boolean DEFAULT FALSE,
1489: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1490: p_customer_trx_id IN
1491: ra_customer_trx.customer_trx_id%type,
1492: p_customer_trx_line_id IN
1493: ra_customer_trx_lines.customer_trx_line_id%type,
1494: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1495: p_backout_flag IN boolean DEFAULT FALSE,
1496: p_backout_done_flag OUT NOCOPY boolean,
1497: p_status OUT NOCOPY varchar2)
1695: +===========================================================================*/
1696:
1697:
1698: PROCEDURE create_line_salescredits(p_customer_trx_id IN
1699: ra_customer_trx_lines.customer_trx_id%type,
1700: p_customer_trx_line_id IN
1701: ra_customer_trx_lines.customer_trx_line_id%type,
1702: p_memo_line_type IN
1703: ar_memo_lines.line_type%type,
1697:
1698: PROCEDURE create_line_salescredits(p_customer_trx_id IN
1699: ra_customer_trx_lines.customer_trx_id%type,
1700: p_customer_trx_line_id IN
1701: ra_customer_trx_lines.customer_trx_line_id%type,
1702: p_memo_line_type IN
1703: ar_memo_lines.line_type%type,
1704: p_delete_scredits_first_flag IN
1705: varchar2,
1708: IS
1709:
1710: l_status1 VARCHAR2(100);
1711: l_status2 VARCHAR2(100);
1712: prev_customer_trx_id ra_customer_trx.previous_customer_trx_id%type;
1713: p_salesrep_id ra_customer_trx.primary_salesrep_id%type;
1714:
1715: BEGIN
1716:
1709:
1710: l_status1 VARCHAR2(100);
1711: l_status2 VARCHAR2(100);
1712: prev_customer_trx_id ra_customer_trx.previous_customer_trx_id%type;
1713: p_salesrep_id ra_customer_trx.primary_salesrep_id%type;
1714:
1715: BEGIN
1716:
1717: arp_util.debug('arp_process_salescredit.create_line_salescredits()+');
1724: primary_salesrep_id
1725: into
1726: prev_customer_trx_id,
1727: p_salesrep_id
1728: FROM ra_customer_trx
1729: WHERE customer_trx_id = p_customer_trx_id;
1730:
1731: /*--------------------------------------+
1732: | Charges do not have salescredits. |
1772: |then call arp_ctls_pkg.insert_f_cmn_ct_ctl_id |
1773: +-------------------------------------------------*/
1774: /*------------------------------------------------------------------+
1775: | Bug 1485133. |
1776: | We need to check if the RA_CUSTOMER_TRX.PRIMARY_SALESREP_ID |
1777: | is not null before calling arp_ctls_pkg.insert_f_cmn_ct_ctl_id |
1778: +------------------------------------------------------------------*/
1779:
1780: IF (prev_customer_trx_id is not null) then