eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_SALESCREDIT dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 40: ra_cust_trx_line_salesreps%rowtype ) IS

36: +===========================================================================*/
37:
38:
39: PROCEDURE val_insert_salescredit ( p_srep_rec IN
40: ra_cust_trx_line_salesreps%rowtype ) IS
41:
42:
43: BEGIN
44:

Line 96: ra_cust_trx_line_salesreps%rowtype ) IS

92: | |
93: +===========================================================================*/
94:
95: PROCEDURE val_update_salescredit ( p_srep_rec IN
96: ra_cust_trx_line_salesreps%rowtype ) IS
97:
98:
99: BEGIN
100:

Line 153: ra_cust_trx_line_salesreps%rowtype ) IS

149: | |
150: +===========================================================================*/
151:
152: PROCEDURE val_delete_salescredit ( p_srep_rec IN
153: ra_cust_trx_line_salesreps%rowtype ) IS
154:
155:
156: BEGIN
157:

Line 220: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

216: | |
217: +===========================================================================*/
218:
219: PROCEDURE set_flags(p_cust_trx_line_salesrep_id IN
220: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
221: p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
222: p_backout_flag IN boolean,
223: p_delete_flag IN boolean,
224: p_posted_flag OUT NOCOPY boolean,

Line 221: p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

217: +===========================================================================*/
218:
219: PROCEDURE set_flags(p_cust_trx_line_salesrep_id IN
220: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
221: p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
222: p_backout_flag IN boolean,
223: p_delete_flag IN boolean,
224: p_posted_flag OUT NOCOPY boolean,
225: p_salesrep_changed_flag OUT NOCOPY boolean,

Line 231: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;

227: p_rev_amt_percent_changed_flag OUT NOCOPY boolean,
228: p_default_record_flag OUT NOCOPY boolean,
229: p_revised_backout_flag OUT NOCOPY boolean) IS
230:
231: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
232: l_posted_flag boolean;
233: l_salesrep_changed_flag boolean;
234: l_amount_percent_changed_flag boolean;
235: l_rev_amt_percent_changed_flag boolean;

Line 428: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type

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
431:
432: l_concat_segments ra_cust_trx_line_gl_dist.concatenated_segments%type;

Line 753: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

749: | |
750: +===========================================================================*/
751:
752: PROCEDURE backout_salesrep(
753: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
754: p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
755: p_run_auto_accounting_flag IN boolean,
756: p_status OUT NOCOPY varchar2 )
757: IS

Line 754: p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

750: +===========================================================================*/
751:
752: PROCEDURE backout_salesrep(
753: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
754: p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
755: p_run_auto_accounting_flag IN boolean,
756: p_status OUT NOCOPY varchar2 )
757: IS
758:

Line 760: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;

756: p_status OUT NOCOPY varchar2 )
757: IS
758:
759: l_cust_trx_line_salesrep_id
760: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
761:
762: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
763: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
764:

Line 762: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;

758:
759: l_cust_trx_line_salesrep_id
760: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
761:
762: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
763: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
764:
765: l_status1 varchar2(100);
766: l_status2 varchar2(100);

Line 763: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;

759: l_cust_trx_line_salesrep_id
760: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
761:
762: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
763: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
764:
765: l_status1 varchar2(100);
766: l_status2 varchar2(100);
767:

Line 887: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

883: +===========================================================================*/
884:
885:
886: PROCEDURE backout_amount(
887: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
888: p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
889: p_run_auto_accounting_flag IN boolean,
890: p_status OUT NOCOPY varchar2 )
891: IS

Line 888: p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

884:
885:
886: PROCEDURE backout_amount(
887: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
888: p_new_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
889: p_run_auto_accounting_flag IN boolean,
890: p_status OUT NOCOPY varchar2 )
891: IS
892:

Line 894: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;

890: p_status OUT NOCOPY varchar2 )
891: IS
892:
893: l_cust_trx_line_salesrep_id
894: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
895:
896: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
897: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
898:

Line 896: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;

892:
893: l_cust_trx_line_salesrep_id
894: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
895:
896: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
897: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
898:
899: BEGIN
900:

Line 897: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;

893: l_cust_trx_line_salesrep_id
894: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
895:
896: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
897: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
898:
899: BEGIN
900:
901: arp_util.debug('arp_process_salescredit.backout_amount()+');

Line 1021: | Inserts a record into ra_cust_trx_line_salesreps |

1017: | PROCEDURE |
1018: | insert_salescredit |
1019: | |
1020: | DESCRIPTION |
1021: | Inserts a record into ra_cust_trx_line_salesreps |
1022: | |
1023: | SCOPE - PUBLIC |
1024: | |
1025: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1053: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

1049: PROCEDURE insert_salescredit(
1050: p_form_name IN varchar2,
1051: p_form_version IN number,
1052: p_run_auto_accounting_flag IN boolean,
1053: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1054: p_cust_trx_line_salesrep_id OUT NOCOPY
1055: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1056: p_status OUT NOCOPY varchar2)
1057: IS

Line 1055: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

1051: p_form_version IN number,
1052: p_run_auto_accounting_flag IN boolean,
1053: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1054: p_cust_trx_line_salesrep_id OUT NOCOPY
1055: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1056: p_status OUT NOCOPY varchar2)
1057: IS
1058:
1059:

Line 1061: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;

1057: IS
1058:
1059:
1060: l_cust_trx_line_salesrep_id
1061: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
1062: l_status1 VARCHAR2(100);
1063: l_status2 VARCHAR2(100);
1064:
1065: BEGIN

Line 1169: | Updates a record in ra_cust_trx_line_salesreps |

1165: | PROCEDURE |
1166: | update_salescredit |
1167: | |
1168: | DESCRIPTION |
1169: | Updates a record in ra_cust_trx_line_salesreps |
1170: | |
1171: | SCOPE - PUBLIC |
1172: | |
1173: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1209: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

1205: p_form_version IN number,
1206: p_run_auto_accounting_flag IN boolean,
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,

Line 1214: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

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
1218:

Line 1221: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;

1217: IS
1218:
1219:
1220: l_cust_trx_line_salesrep_id
1221: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
1222: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
1223: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1224: l_backout_flag boolean;
1225:

Line 1222: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;

1218:
1219:
1220: l_cust_trx_line_salesrep_id
1221: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
1222: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
1223: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1224: l_backout_flag boolean;
1225:
1226: l_posted_flag boolean;

Line 1301: | Insert 2 rows into ra_cust_trx_line_salesreps |

1297: IF ( l_salesrep_changed_flag = TRUE)
1298: THEN
1299:
1300: /*------------------------------------------------+
1301: | Insert 2 rows into ra_cust_trx_line_salesreps |
1302: | 1. amount = -, |
1303: | ccid = |
1304: | 2. amount = , |
1305: | ccid = |

Line 1455: | Deletes a record from ra_cust_trx_line_salesreps. |

1451: | PROCEDURE |
1452: | delete_salescredit |
1453: | |
1454: | DESCRIPTION |
1455: | Deletes a record from ra_cust_trx_line_salesreps. |
1456: | |
1457: | SCOPE - PUBLIC |
1458: | |
1459: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1489: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

1485: p_form_name IN varchar2,
1486: p_form_version IN number,
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,

Line 1494: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

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)
1498: IS

Line 1506: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;

1502: l_salesrep_changed_flag boolean;
1503: l_amount_percent_changed_flag boolean;
1504: l_rev_amt_percent_changed_flag boolean;
1505: l_default_records_flag boolean;
1506: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
1507: l_temp_srep_rec ra_cust_trx_line_salesreps%rowtype;
1508: l_status1 varchar2(100);
1509: l_status2 varchar2(100);
1510: l_status3 varchar2(100);

Line 1507: l_temp_srep_rec ra_cust_trx_line_salesreps%rowtype;

1503: l_amount_percent_changed_flag boolean;
1504: l_rev_amt_percent_changed_flag boolean;
1505: l_default_records_flag boolean;
1506: l_old_srep_rec ra_cust_trx_line_salesreps%rowtype;
1507: l_temp_srep_rec ra_cust_trx_line_salesreps%rowtype;
1508: l_status1 varchar2(100);
1509: l_status2 varchar2(100);
1510: l_status3 varchar2(100);
1511:

Line 1917: ra_cust_trx_line_salesreps.customer_trx_id%type,

1913: p_form_version IN number,
1914: p_run_auto_accounting_flag IN boolean,
1915:
1916: p_customer_trx_id IN
1917: ra_cust_trx_line_salesreps.customer_trx_id%type,
1918: p_customer_trx_line_id IN
1919: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
1920: p_salesrep_id IN
1921: ra_cust_trx_line_salesreps.salesrep_id%type,

Line 1919: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

1915:
1916: p_customer_trx_id IN
1917: ra_cust_trx_line_salesreps.customer_trx_id%type,
1918: p_customer_trx_line_id IN
1919: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
1920: p_salesrep_id IN
1921: ra_cust_trx_line_salesreps.salesrep_id%type,
1922: p_revenue_amount_split IN
1923: ra_cust_trx_line_salesreps.revenue_amount_split%type,

Line 1921: ra_cust_trx_line_salesreps.salesrep_id%type,

1917: ra_cust_trx_line_salesreps.customer_trx_id%type,
1918: p_customer_trx_line_id IN
1919: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
1920: p_salesrep_id IN
1921: ra_cust_trx_line_salesreps.salesrep_id%type,
1922: p_revenue_amount_split IN
1923: ra_cust_trx_line_salesreps.revenue_amount_split%type,
1924: p_non_revenue_amount_split IN
1925: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

Line 1923: ra_cust_trx_line_salesreps.revenue_amount_split%type,

1919: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
1920: p_salesrep_id IN
1921: ra_cust_trx_line_salesreps.salesrep_id%type,
1922: p_revenue_amount_split IN
1923: ra_cust_trx_line_salesreps.revenue_amount_split%type,
1924: p_non_revenue_amount_split IN
1925: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
1926: p_non_revenue_percent_split IN
1927: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

Line 1925: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

1921: ra_cust_trx_line_salesreps.salesrep_id%type,
1922: p_revenue_amount_split IN
1923: ra_cust_trx_line_salesreps.revenue_amount_split%type,
1924: p_non_revenue_amount_split IN
1925: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
1926: p_non_revenue_percent_split IN
1927: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
1928: p_revenue_percent_split IN
1929: ra_cust_trx_line_salesreps.revenue_percent_split%type,

Line 1927: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

1923: ra_cust_trx_line_salesreps.revenue_amount_split%type,
1924: p_non_revenue_amount_split IN
1925: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
1926: p_non_revenue_percent_split IN
1927: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
1928: p_revenue_percent_split IN
1929: ra_cust_trx_line_salesreps.revenue_percent_split%type,
1930: p_prev_cust_trx_line_srep_id IN
1931: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

Line 1929: ra_cust_trx_line_salesreps.revenue_percent_split%type,

1925: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
1926: p_non_revenue_percent_split IN
1927: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
1928: p_revenue_percent_split IN
1929: ra_cust_trx_line_salesreps.revenue_percent_split%type,
1930: p_prev_cust_trx_line_srep_id IN
1931: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
1932: p_attribute_category IN
1933: ra_cust_trx_line_salesreps.attribute_category%type,

Line 1931: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

1927: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
1928: p_revenue_percent_split IN
1929: ra_cust_trx_line_salesreps.revenue_percent_split%type,
1930: p_prev_cust_trx_line_srep_id IN
1931: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
1932: p_attribute_category IN
1933: ra_cust_trx_line_salesreps.attribute_category%type,
1934: p_attribute1 IN
1935: ra_cust_trx_line_salesreps.attribute1%type,

Line 1933: ra_cust_trx_line_salesreps.attribute_category%type,

1929: ra_cust_trx_line_salesreps.revenue_percent_split%type,
1930: p_prev_cust_trx_line_srep_id IN
1931: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
1932: p_attribute_category IN
1933: ra_cust_trx_line_salesreps.attribute_category%type,
1934: p_attribute1 IN
1935: ra_cust_trx_line_salesreps.attribute1%type,
1936: p_attribute2 IN
1937: ra_cust_trx_line_salesreps.attribute2%type,

Line 1935: ra_cust_trx_line_salesreps.attribute1%type,

1931: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
1932: p_attribute_category IN
1933: ra_cust_trx_line_salesreps.attribute_category%type,
1934: p_attribute1 IN
1935: ra_cust_trx_line_salesreps.attribute1%type,
1936: p_attribute2 IN
1937: ra_cust_trx_line_salesreps.attribute2%type,
1938: p_attribute3 IN
1939: ra_cust_trx_line_salesreps.attribute3%type,

Line 1937: ra_cust_trx_line_salesreps.attribute2%type,

1933: ra_cust_trx_line_salesreps.attribute_category%type,
1934: p_attribute1 IN
1935: ra_cust_trx_line_salesreps.attribute1%type,
1936: p_attribute2 IN
1937: ra_cust_trx_line_salesreps.attribute2%type,
1938: p_attribute3 IN
1939: ra_cust_trx_line_salesreps.attribute3%type,
1940: p_attribute4 IN
1941: ra_cust_trx_line_salesreps.attribute4%type,

Line 1939: ra_cust_trx_line_salesreps.attribute3%type,

1935: ra_cust_trx_line_salesreps.attribute1%type,
1936: p_attribute2 IN
1937: ra_cust_trx_line_salesreps.attribute2%type,
1938: p_attribute3 IN
1939: ra_cust_trx_line_salesreps.attribute3%type,
1940: p_attribute4 IN
1941: ra_cust_trx_line_salesreps.attribute4%type,
1942: p_attribute5 IN
1943: ra_cust_trx_line_salesreps.attribute5%type,

Line 1941: ra_cust_trx_line_salesreps.attribute4%type,

1937: ra_cust_trx_line_salesreps.attribute2%type,
1938: p_attribute3 IN
1939: ra_cust_trx_line_salesreps.attribute3%type,
1940: p_attribute4 IN
1941: ra_cust_trx_line_salesreps.attribute4%type,
1942: p_attribute5 IN
1943: ra_cust_trx_line_salesreps.attribute5%type,
1944: p_attribute6 IN
1945: ra_cust_trx_line_salesreps.attribute6%type,

Line 1943: ra_cust_trx_line_salesreps.attribute5%type,

1939: ra_cust_trx_line_salesreps.attribute3%type,
1940: p_attribute4 IN
1941: ra_cust_trx_line_salesreps.attribute4%type,
1942: p_attribute5 IN
1943: ra_cust_trx_line_salesreps.attribute5%type,
1944: p_attribute6 IN
1945: ra_cust_trx_line_salesreps.attribute6%type,
1946: p_attribute7 IN
1947: ra_cust_trx_line_salesreps.attribute7%type,

Line 1945: ra_cust_trx_line_salesreps.attribute6%type,

1941: ra_cust_trx_line_salesreps.attribute4%type,
1942: p_attribute5 IN
1943: ra_cust_trx_line_salesreps.attribute5%type,
1944: p_attribute6 IN
1945: ra_cust_trx_line_salesreps.attribute6%type,
1946: p_attribute7 IN
1947: ra_cust_trx_line_salesreps.attribute7%type,
1948: p_attribute8 IN
1949: ra_cust_trx_line_salesreps.attribute8%type,

Line 1947: ra_cust_trx_line_salesreps.attribute7%type,

1943: ra_cust_trx_line_salesreps.attribute5%type,
1944: p_attribute6 IN
1945: ra_cust_trx_line_salesreps.attribute6%type,
1946: p_attribute7 IN
1947: ra_cust_trx_line_salesreps.attribute7%type,
1948: p_attribute8 IN
1949: ra_cust_trx_line_salesreps.attribute8%type,
1950: p_attribute9 IN
1951: ra_cust_trx_line_salesreps.attribute9%type,

Line 1949: ra_cust_trx_line_salesreps.attribute8%type,

1945: ra_cust_trx_line_salesreps.attribute6%type,
1946: p_attribute7 IN
1947: ra_cust_trx_line_salesreps.attribute7%type,
1948: p_attribute8 IN
1949: ra_cust_trx_line_salesreps.attribute8%type,
1950: p_attribute9 IN
1951: ra_cust_trx_line_salesreps.attribute9%type,
1952: p_attribute10 IN
1953: ra_cust_trx_line_salesreps.attribute10%type,

Line 1951: ra_cust_trx_line_salesreps.attribute9%type,

1947: ra_cust_trx_line_salesreps.attribute7%type,
1948: p_attribute8 IN
1949: ra_cust_trx_line_salesreps.attribute8%type,
1950: p_attribute9 IN
1951: ra_cust_trx_line_salesreps.attribute9%type,
1952: p_attribute10 IN
1953: ra_cust_trx_line_salesreps.attribute10%type,
1954: p_attribute11 IN
1955: ra_cust_trx_line_salesreps.attribute11%type,

Line 1953: ra_cust_trx_line_salesreps.attribute10%type,

1949: ra_cust_trx_line_salesreps.attribute8%type,
1950: p_attribute9 IN
1951: ra_cust_trx_line_salesreps.attribute9%type,
1952: p_attribute10 IN
1953: ra_cust_trx_line_salesreps.attribute10%type,
1954: p_attribute11 IN
1955: ra_cust_trx_line_salesreps.attribute11%type,
1956: p_attribute12 IN
1957: ra_cust_trx_line_salesreps.attribute12%type,

Line 1955: ra_cust_trx_line_salesreps.attribute11%type,

1951: ra_cust_trx_line_salesreps.attribute9%type,
1952: p_attribute10 IN
1953: ra_cust_trx_line_salesreps.attribute10%type,
1954: p_attribute11 IN
1955: ra_cust_trx_line_salesreps.attribute11%type,
1956: p_attribute12 IN
1957: ra_cust_trx_line_salesreps.attribute12%type,
1958: p_attribute13 IN
1959: ra_cust_trx_line_salesreps.attribute13%type,

Line 1957: ra_cust_trx_line_salesreps.attribute12%type,

1953: ra_cust_trx_line_salesreps.attribute10%type,
1954: p_attribute11 IN
1955: ra_cust_trx_line_salesreps.attribute11%type,
1956: p_attribute12 IN
1957: ra_cust_trx_line_salesreps.attribute12%type,
1958: p_attribute13 IN
1959: ra_cust_trx_line_salesreps.attribute13%type,
1960: p_attribute14 IN
1961: ra_cust_trx_line_salesreps.attribute14%type,

Line 1959: ra_cust_trx_line_salesreps.attribute13%type,

1955: ra_cust_trx_line_salesreps.attribute11%type,
1956: p_attribute12 IN
1957: ra_cust_trx_line_salesreps.attribute12%type,
1958: p_attribute13 IN
1959: ra_cust_trx_line_salesreps.attribute13%type,
1960: p_attribute14 IN
1961: ra_cust_trx_line_salesreps.attribute14%type,
1962: p_attribute15 IN
1963: ra_cust_trx_line_salesreps.attribute15%type,

Line 1961: ra_cust_trx_line_salesreps.attribute14%type,

1957: ra_cust_trx_line_salesreps.attribute12%type,
1958: p_attribute13 IN
1959: ra_cust_trx_line_salesreps.attribute13%type,
1960: p_attribute14 IN
1961: ra_cust_trx_line_salesreps.attribute14%type,
1962: p_attribute15 IN
1963: ra_cust_trx_line_salesreps.attribute15%type,
1964: p_cust_trx_line_salesrep_id OUT NOCOPY
1965: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

Line 1963: ra_cust_trx_line_salesreps.attribute15%type,

1959: ra_cust_trx_line_salesreps.attribute13%type,
1960: p_attribute14 IN
1961: ra_cust_trx_line_salesreps.attribute14%type,
1962: p_attribute15 IN
1963: ra_cust_trx_line_salesreps.attribute15%type,
1964: p_cust_trx_line_salesrep_id OUT NOCOPY
1965: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1966: p_status OUT NOCOPY varchar2,
1967: p_revenue_salesgroup_id IN

Line 1965: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

1961: ra_cust_trx_line_salesreps.attribute14%type,
1962: p_attribute15 IN
1963: ra_cust_trx_line_salesreps.attribute15%type,
1964: p_cust_trx_line_salesrep_id OUT NOCOPY
1965: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1966: p_status OUT NOCOPY varchar2,
1967: p_revenue_salesgroup_id IN
1968: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
1969: p_non_revenue_salesgroup_id IN

Line 1968: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

1964: p_cust_trx_line_salesrep_id OUT NOCOPY
1965: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1966: p_status OUT NOCOPY varchar2,
1967: p_revenue_salesgroup_id IN
1968: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
1969: p_non_revenue_salesgroup_id IN
1970: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
1971:
1972: IS

Line 1970: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)

1966: p_status OUT NOCOPY varchar2,
1967: p_revenue_salesgroup_id IN
1968: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
1969: p_non_revenue_salesgroup_id IN
1970: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
1971:
1972: IS
1973:
1974: l_srep_rec ra_cust_trx_line_salesreps%rowtype;

Line 1974: l_srep_rec ra_cust_trx_line_salesreps%rowtype;

1970: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
1971:
1972: IS
1973:
1974: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
1975:
1976: /* bug 3607146 */
1977: l_scredit_count NUMBER;
1978: BEGIN

Line 2150: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

2146: p_form_version IN number,
2147: p_run_auto_accounting_flag IN boolean,
2148: p_backout_flag IN boolean,
2149: p_cust_trx_line_salesrep_id IN
2150: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
2151: p_customer_trx_id IN
2152: ra_cust_trx_line_salesreps.customer_trx_id%type,
2153: p_customer_trx_line_id IN
2154: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

Line 2152: ra_cust_trx_line_salesreps.customer_trx_id%type,

2148: p_backout_flag IN boolean,
2149: p_cust_trx_line_salesrep_id IN
2150: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
2151: p_customer_trx_id IN
2152: ra_cust_trx_line_salesreps.customer_trx_id%type,
2153: p_customer_trx_line_id IN
2154: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
2155: p_salesrep_id IN
2156: ra_cust_trx_line_salesreps.salesrep_id%type,

Line 2154: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

2150: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
2151: p_customer_trx_id IN
2152: ra_cust_trx_line_salesreps.customer_trx_id%type,
2153: p_customer_trx_line_id IN
2154: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
2155: p_salesrep_id IN
2156: ra_cust_trx_line_salesreps.salesrep_id%type,
2157: p_revenue_amount_split IN
2158: ra_cust_trx_line_salesreps.revenue_amount_split%type,

Line 2156: ra_cust_trx_line_salesreps.salesrep_id%type,

2152: ra_cust_trx_line_salesreps.customer_trx_id%type,
2153: p_customer_trx_line_id IN
2154: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
2155: p_salesrep_id IN
2156: ra_cust_trx_line_salesreps.salesrep_id%type,
2157: p_revenue_amount_split IN
2158: ra_cust_trx_line_salesreps.revenue_amount_split%type,
2159: p_non_revenue_amount_split IN
2160: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

Line 2158: ra_cust_trx_line_salesreps.revenue_amount_split%type,

2154: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
2155: p_salesrep_id IN
2156: ra_cust_trx_line_salesreps.salesrep_id%type,
2157: p_revenue_amount_split IN
2158: ra_cust_trx_line_salesreps.revenue_amount_split%type,
2159: p_non_revenue_amount_split IN
2160: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
2161: p_non_revenue_percent_split IN
2162: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

Line 2160: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

2156: ra_cust_trx_line_salesreps.salesrep_id%type,
2157: p_revenue_amount_split IN
2158: ra_cust_trx_line_salesreps.revenue_amount_split%type,
2159: p_non_revenue_amount_split IN
2160: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
2161: p_non_revenue_percent_split IN
2162: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
2163: p_revenue_percent_split IN
2164: ra_cust_trx_line_salesreps.revenue_percent_split%type,

Line 2162: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

2158: ra_cust_trx_line_salesreps.revenue_amount_split%type,
2159: p_non_revenue_amount_split IN
2160: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
2161: p_non_revenue_percent_split IN
2162: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
2163: p_revenue_percent_split IN
2164: ra_cust_trx_line_salesreps.revenue_percent_split%type,
2165: p_prev_cust_trx_line_srep_id IN
2166: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

Line 2164: ra_cust_trx_line_salesreps.revenue_percent_split%type,

2160: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
2161: p_non_revenue_percent_split IN
2162: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
2163: p_revenue_percent_split IN
2164: ra_cust_trx_line_salesreps.revenue_percent_split%type,
2165: p_prev_cust_trx_line_srep_id IN
2166: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
2167: p_attribute_category IN
2168: ra_cust_trx_line_salesreps.attribute_category%type,

Line 2166: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

2162: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
2163: p_revenue_percent_split IN
2164: ra_cust_trx_line_salesreps.revenue_percent_split%type,
2165: p_prev_cust_trx_line_srep_id IN
2166: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
2167: p_attribute_category IN
2168: ra_cust_trx_line_salesreps.attribute_category%type,
2169: p_attribute1 IN
2170: ra_cust_trx_line_salesreps.attribute1%type,

Line 2168: ra_cust_trx_line_salesreps.attribute_category%type,

2164: ra_cust_trx_line_salesreps.revenue_percent_split%type,
2165: p_prev_cust_trx_line_srep_id IN
2166: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
2167: p_attribute_category IN
2168: ra_cust_trx_line_salesreps.attribute_category%type,
2169: p_attribute1 IN
2170: ra_cust_trx_line_salesreps.attribute1%type,
2171: p_attribute2 IN
2172: ra_cust_trx_line_salesreps.attribute2%type,

Line 2170: ra_cust_trx_line_salesreps.attribute1%type,

2166: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
2167: p_attribute_category IN
2168: ra_cust_trx_line_salesreps.attribute_category%type,
2169: p_attribute1 IN
2170: ra_cust_trx_line_salesreps.attribute1%type,
2171: p_attribute2 IN
2172: ra_cust_trx_line_salesreps.attribute2%type,
2173: p_attribute3 IN
2174: ra_cust_trx_line_salesreps.attribute3%type,

Line 2172: ra_cust_trx_line_salesreps.attribute2%type,

2168: ra_cust_trx_line_salesreps.attribute_category%type,
2169: p_attribute1 IN
2170: ra_cust_trx_line_salesreps.attribute1%type,
2171: p_attribute2 IN
2172: ra_cust_trx_line_salesreps.attribute2%type,
2173: p_attribute3 IN
2174: ra_cust_trx_line_salesreps.attribute3%type,
2175: p_attribute4 IN
2176: ra_cust_trx_line_salesreps.attribute4%type,

Line 2174: ra_cust_trx_line_salesreps.attribute3%type,

2170: ra_cust_trx_line_salesreps.attribute1%type,
2171: p_attribute2 IN
2172: ra_cust_trx_line_salesreps.attribute2%type,
2173: p_attribute3 IN
2174: ra_cust_trx_line_salesreps.attribute3%type,
2175: p_attribute4 IN
2176: ra_cust_trx_line_salesreps.attribute4%type,
2177: p_attribute5 IN
2178: ra_cust_trx_line_salesreps.attribute5%type,

Line 2176: ra_cust_trx_line_salesreps.attribute4%type,

2172: ra_cust_trx_line_salesreps.attribute2%type,
2173: p_attribute3 IN
2174: ra_cust_trx_line_salesreps.attribute3%type,
2175: p_attribute4 IN
2176: ra_cust_trx_line_salesreps.attribute4%type,
2177: p_attribute5 IN
2178: ra_cust_trx_line_salesreps.attribute5%type,
2179: p_attribute6 IN
2180: ra_cust_trx_line_salesreps.attribute6%type,

Line 2178: ra_cust_trx_line_salesreps.attribute5%type,

2174: ra_cust_trx_line_salesreps.attribute3%type,
2175: p_attribute4 IN
2176: ra_cust_trx_line_salesreps.attribute4%type,
2177: p_attribute5 IN
2178: ra_cust_trx_line_salesreps.attribute5%type,
2179: p_attribute6 IN
2180: ra_cust_trx_line_salesreps.attribute6%type,
2181: p_attribute7 IN
2182: ra_cust_trx_line_salesreps.attribute7%type,

Line 2180: ra_cust_trx_line_salesreps.attribute6%type,

2176: ra_cust_trx_line_salesreps.attribute4%type,
2177: p_attribute5 IN
2178: ra_cust_trx_line_salesreps.attribute5%type,
2179: p_attribute6 IN
2180: ra_cust_trx_line_salesreps.attribute6%type,
2181: p_attribute7 IN
2182: ra_cust_trx_line_salesreps.attribute7%type,
2183: p_attribute8 IN
2184: ra_cust_trx_line_salesreps.attribute8%type,

Line 2182: ra_cust_trx_line_salesreps.attribute7%type,

2178: ra_cust_trx_line_salesreps.attribute5%type,
2179: p_attribute6 IN
2180: ra_cust_trx_line_salesreps.attribute6%type,
2181: p_attribute7 IN
2182: ra_cust_trx_line_salesreps.attribute7%type,
2183: p_attribute8 IN
2184: ra_cust_trx_line_salesreps.attribute8%type,
2185: p_attribute9 IN
2186: ra_cust_trx_line_salesreps.attribute9%type,

Line 2184: ra_cust_trx_line_salesreps.attribute8%type,

2180: ra_cust_trx_line_salesreps.attribute6%type,
2181: p_attribute7 IN
2182: ra_cust_trx_line_salesreps.attribute7%type,
2183: p_attribute8 IN
2184: ra_cust_trx_line_salesreps.attribute8%type,
2185: p_attribute9 IN
2186: ra_cust_trx_line_salesreps.attribute9%type,
2187: p_attribute10 IN
2188: ra_cust_trx_line_salesreps.attribute10%type,

Line 2186: ra_cust_trx_line_salesreps.attribute9%type,

2182: ra_cust_trx_line_salesreps.attribute7%type,
2183: p_attribute8 IN
2184: ra_cust_trx_line_salesreps.attribute8%type,
2185: p_attribute9 IN
2186: ra_cust_trx_line_salesreps.attribute9%type,
2187: p_attribute10 IN
2188: ra_cust_trx_line_salesreps.attribute10%type,
2189: p_attribute11 IN
2190: ra_cust_trx_line_salesreps.attribute11%type,

Line 2188: ra_cust_trx_line_salesreps.attribute10%type,

2184: ra_cust_trx_line_salesreps.attribute8%type,
2185: p_attribute9 IN
2186: ra_cust_trx_line_salesreps.attribute9%type,
2187: p_attribute10 IN
2188: ra_cust_trx_line_salesreps.attribute10%type,
2189: p_attribute11 IN
2190: ra_cust_trx_line_salesreps.attribute11%type,
2191: p_attribute12 IN
2192: ra_cust_trx_line_salesreps.attribute12%type,

Line 2190: ra_cust_trx_line_salesreps.attribute11%type,

2186: ra_cust_trx_line_salesreps.attribute9%type,
2187: p_attribute10 IN
2188: ra_cust_trx_line_salesreps.attribute10%type,
2189: p_attribute11 IN
2190: ra_cust_trx_line_salesreps.attribute11%type,
2191: p_attribute12 IN
2192: ra_cust_trx_line_salesreps.attribute12%type,
2193: p_attribute13 IN
2194: ra_cust_trx_line_salesreps.attribute13%type,

Line 2192: ra_cust_trx_line_salesreps.attribute12%type,

2188: ra_cust_trx_line_salesreps.attribute10%type,
2189: p_attribute11 IN
2190: ra_cust_trx_line_salesreps.attribute11%type,
2191: p_attribute12 IN
2192: ra_cust_trx_line_salesreps.attribute12%type,
2193: p_attribute13 IN
2194: ra_cust_trx_line_salesreps.attribute13%type,
2195: p_attribute14 IN
2196: ra_cust_trx_line_salesreps.attribute14%type,

Line 2194: ra_cust_trx_line_salesreps.attribute13%type,

2190: ra_cust_trx_line_salesreps.attribute11%type,
2191: p_attribute12 IN
2192: ra_cust_trx_line_salesreps.attribute12%type,
2193: p_attribute13 IN
2194: ra_cust_trx_line_salesreps.attribute13%type,
2195: p_attribute14 IN
2196: ra_cust_trx_line_salesreps.attribute14%type,
2197: p_attribute15 IN
2198: ra_cust_trx_line_salesreps.attribute15%type,

Line 2196: ra_cust_trx_line_salesreps.attribute14%type,

2192: ra_cust_trx_line_salesreps.attribute12%type,
2193: p_attribute13 IN
2194: ra_cust_trx_line_salesreps.attribute13%type,
2195: p_attribute14 IN
2196: ra_cust_trx_line_salesreps.attribute14%type,
2197: p_attribute15 IN
2198: ra_cust_trx_line_salesreps.attribute15%type,
2199: p_backout_done_flag OUT NOCOPY boolean,
2200: p_status OUT NOCOPY varchar2,

Line 2198: ra_cust_trx_line_salesreps.attribute15%type,

2194: ra_cust_trx_line_salesreps.attribute13%type,
2195: p_attribute14 IN
2196: ra_cust_trx_line_salesreps.attribute14%type,
2197: p_attribute15 IN
2198: ra_cust_trx_line_salesreps.attribute15%type,
2199: p_backout_done_flag OUT NOCOPY boolean,
2200: p_status OUT NOCOPY varchar2,
2201: p_revenue_salesgroup_id IN
2202: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

Line 2202: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

2198: ra_cust_trx_line_salesreps.attribute15%type,
2199: p_backout_done_flag OUT NOCOPY boolean,
2200: p_status OUT NOCOPY varchar2,
2201: p_revenue_salesgroup_id IN
2202: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
2203: p_non_revenue_salesgroup_id IN
2204: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
2205: IS
2206:

Line 2204: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)

2200: p_status OUT NOCOPY varchar2,
2201: p_revenue_salesgroup_id IN
2202: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
2203: p_non_revenue_salesgroup_id IN
2204: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
2205: IS
2206:
2207: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
2208:

Line 2207: l_srep_rec ra_cust_trx_line_salesreps%rowtype;

2203: p_non_revenue_salesgroup_id IN
2204: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
2205: IS
2206:
2207: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
2208:
2209: /* bug 3607146 */
2210: l_scredit_count NUMBER;
2211:

Line 2394: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

2390: p_form_version IN number,
2391: p_run_auto_accounting_flag IN boolean,
2392: p_backout_flag IN boolean,
2393: p_cust_trx_line_salesrep_id IN
2394: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
2395: p_customer_trx_id IN
2396: ra_cust_trx_line_salesreps.customer_trx_id%type,
2397: p_customer_trx_line_id IN
2398: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

Line 2396: ra_cust_trx_line_salesreps.customer_trx_id%type,

2392: p_backout_flag IN boolean,
2393: p_cust_trx_line_salesrep_id IN
2394: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
2395: p_customer_trx_id IN
2396: ra_cust_trx_line_salesreps.customer_trx_id%type,
2397: p_customer_trx_line_id IN
2398: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
2399: p_salesrep_id IN
2400: ra_cust_trx_line_salesreps.salesrep_id%type,

Line 2398: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

2394: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
2395: p_customer_trx_id IN
2396: ra_cust_trx_line_salesreps.customer_trx_id%type,
2397: p_customer_trx_line_id IN
2398: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
2399: p_salesrep_id IN
2400: ra_cust_trx_line_salesreps.salesrep_id%type,
2401: p_revenue_amount_split IN
2402: ra_cust_trx_line_salesreps.revenue_amount_split%type,

Line 2400: ra_cust_trx_line_salesreps.salesrep_id%type,

2396: ra_cust_trx_line_salesreps.customer_trx_id%type,
2397: p_customer_trx_line_id IN
2398: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
2399: p_salesrep_id IN
2400: ra_cust_trx_line_salesreps.salesrep_id%type,
2401: p_revenue_amount_split IN
2402: ra_cust_trx_line_salesreps.revenue_amount_split%type,
2403: p_non_revenue_amount_split IN
2404: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

Line 2402: ra_cust_trx_line_salesreps.revenue_amount_split%type,

2398: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
2399: p_salesrep_id IN
2400: ra_cust_trx_line_salesreps.salesrep_id%type,
2401: p_revenue_amount_split IN
2402: ra_cust_trx_line_salesreps.revenue_amount_split%type,
2403: p_non_revenue_amount_split IN
2404: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
2405: p_non_revenue_percent_split IN
2406: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

Line 2404: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

2400: ra_cust_trx_line_salesreps.salesrep_id%type,
2401: p_revenue_amount_split IN
2402: ra_cust_trx_line_salesreps.revenue_amount_split%type,
2403: p_non_revenue_amount_split IN
2404: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
2405: p_non_revenue_percent_split IN
2406: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
2407: p_revenue_percent_split IN
2408: ra_cust_trx_line_salesreps.revenue_percent_split%type,

Line 2406: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

2402: ra_cust_trx_line_salesreps.revenue_amount_split%type,
2403: p_non_revenue_amount_split IN
2404: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
2405: p_non_revenue_percent_split IN
2406: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
2407: p_revenue_percent_split IN
2408: ra_cust_trx_line_salesreps.revenue_percent_split%type,
2409: p_prev_cust_trx_line_srep_id IN
2410: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

Line 2408: ra_cust_trx_line_salesreps.revenue_percent_split%type,

2404: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
2405: p_non_revenue_percent_split IN
2406: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
2407: p_revenue_percent_split IN
2408: ra_cust_trx_line_salesreps.revenue_percent_split%type,
2409: p_prev_cust_trx_line_srep_id IN
2410: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
2411: p_attribute_category IN
2412: ra_cust_trx_line_salesreps.attribute_category%type,

Line 2410: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

2406: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
2407: p_revenue_percent_split IN
2408: ra_cust_trx_line_salesreps.revenue_percent_split%type,
2409: p_prev_cust_trx_line_srep_id IN
2410: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
2411: p_attribute_category IN
2412: ra_cust_trx_line_salesreps.attribute_category%type,
2413: p_attribute1 IN
2414: ra_cust_trx_line_salesreps.attribute1%type,

Line 2412: ra_cust_trx_line_salesreps.attribute_category%type,

2408: ra_cust_trx_line_salesreps.revenue_percent_split%type,
2409: p_prev_cust_trx_line_srep_id IN
2410: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
2411: p_attribute_category IN
2412: ra_cust_trx_line_salesreps.attribute_category%type,
2413: p_attribute1 IN
2414: ra_cust_trx_line_salesreps.attribute1%type,
2415: p_attribute2 IN
2416: ra_cust_trx_line_salesreps.attribute2%type,

Line 2414: ra_cust_trx_line_salesreps.attribute1%type,

2410: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
2411: p_attribute_category IN
2412: ra_cust_trx_line_salesreps.attribute_category%type,
2413: p_attribute1 IN
2414: ra_cust_trx_line_salesreps.attribute1%type,
2415: p_attribute2 IN
2416: ra_cust_trx_line_salesreps.attribute2%type,
2417: p_attribute3 IN
2418: ra_cust_trx_line_salesreps.attribute3%type,

Line 2416: ra_cust_trx_line_salesreps.attribute2%type,

2412: ra_cust_trx_line_salesreps.attribute_category%type,
2413: p_attribute1 IN
2414: ra_cust_trx_line_salesreps.attribute1%type,
2415: p_attribute2 IN
2416: ra_cust_trx_line_salesreps.attribute2%type,
2417: p_attribute3 IN
2418: ra_cust_trx_line_salesreps.attribute3%type,
2419: p_attribute4 IN
2420: ra_cust_trx_line_salesreps.attribute4%type,

Line 2418: ra_cust_trx_line_salesreps.attribute3%type,

2414: ra_cust_trx_line_salesreps.attribute1%type,
2415: p_attribute2 IN
2416: ra_cust_trx_line_salesreps.attribute2%type,
2417: p_attribute3 IN
2418: ra_cust_trx_line_salesreps.attribute3%type,
2419: p_attribute4 IN
2420: ra_cust_trx_line_salesreps.attribute4%type,
2421: p_attribute5 IN
2422: ra_cust_trx_line_salesreps.attribute5%type,

Line 2420: ra_cust_trx_line_salesreps.attribute4%type,

2416: ra_cust_trx_line_salesreps.attribute2%type,
2417: p_attribute3 IN
2418: ra_cust_trx_line_salesreps.attribute3%type,
2419: p_attribute4 IN
2420: ra_cust_trx_line_salesreps.attribute4%type,
2421: p_attribute5 IN
2422: ra_cust_trx_line_salesreps.attribute5%type,
2423: p_attribute6 IN
2424: ra_cust_trx_line_salesreps.attribute6%type,

Line 2422: ra_cust_trx_line_salesreps.attribute5%type,

2418: ra_cust_trx_line_salesreps.attribute3%type,
2419: p_attribute4 IN
2420: ra_cust_trx_line_salesreps.attribute4%type,
2421: p_attribute5 IN
2422: ra_cust_trx_line_salesreps.attribute5%type,
2423: p_attribute6 IN
2424: ra_cust_trx_line_salesreps.attribute6%type,
2425: p_attribute7 IN
2426: ra_cust_trx_line_salesreps.attribute7%type,

Line 2424: ra_cust_trx_line_salesreps.attribute6%type,

2420: ra_cust_trx_line_salesreps.attribute4%type,
2421: p_attribute5 IN
2422: ra_cust_trx_line_salesreps.attribute5%type,
2423: p_attribute6 IN
2424: ra_cust_trx_line_salesreps.attribute6%type,
2425: p_attribute7 IN
2426: ra_cust_trx_line_salesreps.attribute7%type,
2427: p_attribute8 IN
2428: ra_cust_trx_line_salesreps.attribute8%type,

Line 2426: ra_cust_trx_line_salesreps.attribute7%type,

2422: ra_cust_trx_line_salesreps.attribute5%type,
2423: p_attribute6 IN
2424: ra_cust_trx_line_salesreps.attribute6%type,
2425: p_attribute7 IN
2426: ra_cust_trx_line_salesreps.attribute7%type,
2427: p_attribute8 IN
2428: ra_cust_trx_line_salesreps.attribute8%type,
2429: p_attribute9 IN
2430: ra_cust_trx_line_salesreps.attribute9%type,

Line 2428: ra_cust_trx_line_salesreps.attribute8%type,

2424: ra_cust_trx_line_salesreps.attribute6%type,
2425: p_attribute7 IN
2426: ra_cust_trx_line_salesreps.attribute7%type,
2427: p_attribute8 IN
2428: ra_cust_trx_line_salesreps.attribute8%type,
2429: p_attribute9 IN
2430: ra_cust_trx_line_salesreps.attribute9%type,
2431: p_attribute10 IN
2432: ra_cust_trx_line_salesreps.attribute10%type,

Line 2430: ra_cust_trx_line_salesreps.attribute9%type,

2426: ra_cust_trx_line_salesreps.attribute7%type,
2427: p_attribute8 IN
2428: ra_cust_trx_line_salesreps.attribute8%type,
2429: p_attribute9 IN
2430: ra_cust_trx_line_salesreps.attribute9%type,
2431: p_attribute10 IN
2432: ra_cust_trx_line_salesreps.attribute10%type,
2433: p_attribute11 IN
2434: ra_cust_trx_line_salesreps.attribute11%type,

Line 2432: ra_cust_trx_line_salesreps.attribute10%type,

2428: ra_cust_trx_line_salesreps.attribute8%type,
2429: p_attribute9 IN
2430: ra_cust_trx_line_salesreps.attribute9%type,
2431: p_attribute10 IN
2432: ra_cust_trx_line_salesreps.attribute10%type,
2433: p_attribute11 IN
2434: ra_cust_trx_line_salesreps.attribute11%type,
2435: p_attribute12 IN
2436: ra_cust_trx_line_salesreps.attribute12%type,

Line 2434: ra_cust_trx_line_salesreps.attribute11%type,

2430: ra_cust_trx_line_salesreps.attribute9%type,
2431: p_attribute10 IN
2432: ra_cust_trx_line_salesreps.attribute10%type,
2433: p_attribute11 IN
2434: ra_cust_trx_line_salesreps.attribute11%type,
2435: p_attribute12 IN
2436: ra_cust_trx_line_salesreps.attribute12%type,
2437: p_attribute13 IN
2438: ra_cust_trx_line_salesreps.attribute13%type,

Line 2436: ra_cust_trx_line_salesreps.attribute12%type,

2432: ra_cust_trx_line_salesreps.attribute10%type,
2433: p_attribute11 IN
2434: ra_cust_trx_line_salesreps.attribute11%type,
2435: p_attribute12 IN
2436: ra_cust_trx_line_salesreps.attribute12%type,
2437: p_attribute13 IN
2438: ra_cust_trx_line_salesreps.attribute13%type,
2439: p_attribute14 IN
2440: ra_cust_trx_line_salesreps.attribute14%type,

Line 2438: ra_cust_trx_line_salesreps.attribute13%type,

2434: ra_cust_trx_line_salesreps.attribute11%type,
2435: p_attribute12 IN
2436: ra_cust_trx_line_salesreps.attribute12%type,
2437: p_attribute13 IN
2438: ra_cust_trx_line_salesreps.attribute13%type,
2439: p_attribute14 IN
2440: ra_cust_trx_line_salesreps.attribute14%type,
2441: p_attribute15 IN
2442: ra_cust_trx_line_salesreps.attribute15%type,

Line 2440: ra_cust_trx_line_salesreps.attribute14%type,

2436: ra_cust_trx_line_salesreps.attribute12%type,
2437: p_attribute13 IN
2438: ra_cust_trx_line_salesreps.attribute13%type,
2439: p_attribute14 IN
2440: ra_cust_trx_line_salesreps.attribute14%type,
2441: p_attribute15 IN
2442: ra_cust_trx_line_salesreps.attribute15%type,
2443: p_backout_done_flag OUT NOCOPY boolean,
2444: p_status OUT NOCOPY varchar2,

Line 2442: ra_cust_trx_line_salesreps.attribute15%type,

2438: ra_cust_trx_line_salesreps.attribute13%type,
2439: p_attribute14 IN
2440: ra_cust_trx_line_salesreps.attribute14%type,
2441: p_attribute15 IN
2442: ra_cust_trx_line_salesreps.attribute15%type,
2443: p_backout_done_flag OUT NOCOPY boolean,
2444: p_status OUT NOCOPY varchar2,
2445: p_revenue_salesgroup_id IN
2446: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

Line 2446: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

2442: ra_cust_trx_line_salesreps.attribute15%type,
2443: p_backout_done_flag OUT NOCOPY boolean,
2444: p_status OUT NOCOPY varchar2,
2445: p_revenue_salesgroup_id IN
2446: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
2447: p_non_revenue_salesgroup_id IN
2448: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
2449: IS
2450:

Line 2448: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)

2444: p_status OUT NOCOPY varchar2,
2445: p_revenue_salesgroup_id IN
2446: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
2447: p_non_revenue_salesgroup_id IN
2448: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
2449: IS
2450:
2451: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
2452:

Line 2451: l_srep_rec ra_cust_trx_line_salesreps%rowtype;

2447: p_non_revenue_salesgroup_id IN
2448: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
2449: IS
2450:
2451: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
2452:
2453: /* bug 3607146 */
2454: l_scredit_count NUMBER;
2455: