APPS.ARP_PROCESS_SALESCREDIT dependencies on RA_CUSTOMER_TRX

Line 424: ra_customer_trx.customer_trx_id%type,

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

Line 426: ra_customer_trx_lines.customer_trx_line_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

Line 997: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

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:

Line 998: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

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

Line 1211: ra_customer_trx.customer_trx_id%type,

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,

Line 1213: ra_customer_trx_lines.customer_trx_line_id%type,

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

Line 1491: ra_customer_trx.customer_trx_id%type,

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,

Line 1493: ra_customer_trx_lines.customer_trx_line_id%type,

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)

Line 1699: ra_customer_trx_lines.customer_trx_id%type,

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,

Line 1701: ra_customer_trx_lines.customer_trx_line_id%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,

Line 1712: prev_customer_trx_id ra_customer_trx.previous_customer_trx_id%type;

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:

Line 1713: p_salesrep_id ra_customer_trx.primary_salesrep_id%type;

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()+');

Line 1728: FROM ra_customer_trx

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. |

Line 1776: | We need to check if the RA_CUSTOMER_TRX.PRIMARY_SALESREP_ID |

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