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_CTLS_PKG dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 65: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

61: +===========================================================================*/
62:
63:
64: PROCEDURE erase_foreign_key_references( p_cust_trx_line_salesrep_id IN
65: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
66: p_customer_trx_id IN
67: ra_customer_trx.customer_trx_id%type,
68: p_customer_trx_line_id IN
69: ra_customer_trx_lines.customer_trx_line_id%type)

Line 72: l_srep_rec ra_cust_trx_line_salesreps%rowtype;

68: p_customer_trx_line_id IN
69: ra_customer_trx_lines.customer_trx_line_id%type)
70: IS
71:
72: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
73: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
74:
75: BEGIN
76:

Line 83: | ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id |

79:
80:
81: /*------------------------------------------------------------------+
82: | Erase foreign key references to the salescredit being deleted: |
83: | ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id |
84: | ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id |
85: +------------------------------------------------------------------*/
86:
87: /*-------------------------------------------------------------------+

Line 88: | Erase ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id |

84: | ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id |
85: +------------------------------------------------------------------*/
86:
87: /*-------------------------------------------------------------------+
88: | Erase ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id |
89: | and erase ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id |
90: +-------------------------------------------------------------------*/
91:
92: BEGIN

Line 205: | p_srep_rec - ra_cust_trx_line_salesreps record |

201: | arp_util.debug |
202: | |
203: | ARGUMENTS : IN: |
204: | p_update_cursor - ID of the update cursor |
205: | p_srep_rec - ra_cust_trx_line_salesreps record |
206: | OUT: |
207: | None |
208: | |
209: | RETURNS : NONE |

Line 220: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype)

216: +===========================================================================*/
217:
218:
219: PROCEDURE bind_srep_variables(p_update_cursor IN integer,
220: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype)
221: IS
222:
223: BEGIN
224:

Line 415: 'UPDATE ra_cust_trx_line_salesreps

411: BEGIN
412: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()+');
413:
414: update_text :=
415: 'UPDATE ra_cust_trx_line_salesreps
416: SET cust_trx_line_salesrep_id =
417: DECODE(:cust_trx_line_salesrep_id,
418: :ar_number_dummy, cust_trx_line_salesrep_id,
419: :cust_trx_line_salesrep_id),

Line 574: | This procedure Updates records in ra_cust_trx_line_salesreps |

570: | PROCEDURE |
571: | generic_update |
572: | |
573: | DESCRIPTION |
574: | This procedure Updates records in ra_cust_trx_line_salesreps |
575: | identified by the where clause that is passed in as a parameter. Only |
576: | those columns in the srep record parameter that do not contain the |
577: | special dummy values are updated. |
578: | |

Line 608: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype)

604:
605: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
606: p_where_clause IN varchar2,
607: p_where1 IN number,
608: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype)
609: IS
610:
611: l_count number;
612: l_update_statement varchar2(25000);

Line 744: FROM ra_cust_trx_line_salesreps

740: INTO p_amount_total,
741: p_amount_total_rtot_db,
742: p_percent_total,
743: p_percent_total_rtot_db
744: FROM ra_cust_trx_line_salesreps
745: WHERE customer_trx_id = p_customer_trx_id
746: AND NVL( customer_trx_line_id, -10 ) =
747: DECODE(p_mode,
748: 'LINE', p_customer_trx_line_id,

Line 797: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)

793: | |
794: +===========================================================================*/
795:
796: PROCEDURE display_salescredit( p_cust_trx_line_salesrep_id IN
797: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)
798: IS
799:
800: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
801:

Line 800: l_srep_rec ra_cust_trx_line_salesreps%rowtype;

796: PROCEDURE display_salescredit( p_cust_trx_line_salesrep_id IN
797: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)
798: IS
799:
800: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
801:
802: BEGIN
803:
804: arp_util.debug('arp_ctls_pkg.display_salescredit()+');

Line 849: ra_cust_trx_line_salesreps%rowtype)

845: | |
846: +===========================================================================*/
847:
848: PROCEDURE display_salescredit_rec( p_srep_rec IN
849: ra_cust_trx_line_salesreps%rowtype)
850: IS
851:
852:
853: BEGIN

Line 857: arp_util.debug('************** Dump of ra_cust_trx_line_salesreps record '||

853: BEGIN
854:
855: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()+');
856:
857: arp_util.debug('************** Dump of ra_cust_trx_line_salesreps record '||
858: '**************');
859:
860: arp_util.debug('cust_trx_line_salesrep_id: ' ||
861: p_srep_rec.cust_trx_line_salesrep_id);

Line 903: arp_util.debug('************** End ra_cust_trx_line_salesreps record ' ||

899: arp_util.debug('program_application_id: ' ||
900: p_srep_rec.program_application_id);
901: arp_util.debug('program_id: ' || p_srep_rec.program_id);
902:
903: arp_util.debug('************** End ra_cust_trx_line_salesreps record ' ||
904: '**************');
905:
906: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()-');
907:

Line 952: FROM ra_cust_trx_line_salesreps

948:
949:
950: CURSOR srep_cursor IS
951: SELECT *
952: FROM ra_cust_trx_line_salesreps
953: WHERE customer_trx_line_id = p_customeR_trx_line_id
954: ORDER BY salesrep_id,
955: revenue_amount_split,
956: non_revenue_amount_split,

Line 967: ' Dump of ra_cust_trx_line_salesreps records for ctlid: '||

963:
964: arp_util.debug('=====================================================' ||
965: '==========================');
966: arp_util.debug('========= ' ||
967: ' Dump of ra_cust_trx_line_salesreps records for ctlid: '||
968: to_char( p_customer_trx_line_id ) || ' ' ||
969: '=========');
970:
971: FOR l_srep_rec IN srep_cursor LOOP

Line 976: ' Dump of ra_cust_trx_line_salesreps records for ctlid: '||

972: display_salescredit(l_srep_rec.cust_trx_line_salesrep_id);
973: END LOOP;
974:
975: arp_util.debug('===== End ' ||
976: ' Dump of ra_cust_trx_line_salesreps records for ctlid: '||
977: to_char( p_customer_trx_line_id ) || ' ' ||
978: '=========');
979: arp_util.debug('=====================================================' ||
980: '==========================');

Line 1023: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

1019: | |
1020: +===========================================================================*/
1021:
1022: PROCEDURE merge_srep_recs(
1023: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1024: p_new_srep_rec IN
1025: ra_cust_trx_line_salesreps%rowtype,
1026: p_out_srep_rec IN OUT NOCOPY
1027: ra_cust_trx_line_salesreps%rowtype)

Line 1025: ra_cust_trx_line_salesreps%rowtype,

1021:
1022: PROCEDURE merge_srep_recs(
1023: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1024: p_new_srep_rec IN
1025: ra_cust_trx_line_salesreps%rowtype,
1026: p_out_srep_rec IN OUT NOCOPY
1027: ra_cust_trx_line_salesreps%rowtype)
1028: IS
1029:

Line 1027: ra_cust_trx_line_salesreps%rowtype)

1023: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1024: p_new_srep_rec IN
1025: ra_cust_trx_line_salesreps%rowtype,
1026: p_out_srep_rec IN OUT NOCOPY
1027: ra_cust_trx_line_salesreps%rowtype)
1028: IS
1029:
1030: BEGIN
1031:

Line 1224: PROCEDURE set_to_dummy( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype) IS

1220: | 08-JUN-95 Charlie Tomberg Created |
1221: | |
1222: +===========================================================================*/
1223:
1224: PROCEDURE set_to_dummy( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype) IS
1225:
1226: BEGIN
1227:
1228: arp_util.debug('arp_ctls_pkg.set_to_dummy()+');

Line 1326: | This procedure locks the ra_cust_trx_line_salesreps row identified by |

1322: | PROCEDURE |
1323: | lock_p |
1324: | |
1325: | DESCRIPTION |
1326: | This procedure locks the ra_cust_trx_line_salesreps row identified by |
1327: | p_cust_trx_line_salesrep_id parameter. |
1328: | |
1329: | SCOPE - PUBLIC |
1330: | |

Line 1349: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type

1345: | |
1346: +===========================================================================*/
1347:
1348: PROCEDURE lock_p( p_cust_trx_line_salesrep_id
1349: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type
1350: )
1351: IS
1352:
1353: l_cust_trx_line_salesrep_id

Line 1354: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;

1350: )
1351: IS
1352:
1353: l_cust_trx_line_salesrep_id
1354: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
1355:
1356: BEGIN
1357: arp_util.debug('arp_ctls_pkg.lock_p()+');
1358:

Line 1362: FROM ra_cust_trx_line_salesreps

1358:
1359:
1360: SELECT cust_trx_line_salesrep_id
1361: INTO l_cust_trx_line_salesrep_id
1362: FROM ra_cust_trx_line_salesreps
1363: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
1364: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1365:
1366: arp_util.debug('arp_ctls_pkg.lock_p()-');

Line 1379: | This procedure locks the ra_cust_trx_line_salesreps rows identified by |

1375: | PROCEDURE |
1376: | lock_f_ct_id |
1377: | |
1378: | DESCRIPTION |
1379: | This procedure locks the ra_cust_trx_line_salesreps rows identified by |
1380: | p_customer_trx_id parameter. |
1381: | |
1382: | SCOPE - PUBLIC |
1383: | |

Line 1407: FROM ra_cust_trx_line_salesreps

1403: IS
1404:
1405: CURSOR LOCK_C IS
1406: SELECT cust_trx_line_salesrep_id
1407: FROM ra_cust_trx_line_salesreps
1408: WHERE customer_trx_id = p_customer_trx_id
1409: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1410:
1411:

Line 1431: | This procedure locks the ra_cust_trx_line_salesreps rows identified by |

1427: | PROCEDURE |
1428: | lock_f_ctl_id |
1429: | |
1430: | DESCRIPTION |
1431: | This procedure locks the ra_cust_trx_line_salesreps rows identified by |
1432: | p_customer_trx_line_id parameter. |
1433: | |
1434: | SCOPE - PUBLIC |
1435: | |

Line 1459: FROM ra_cust_trx_line_salesreps

1455: IS
1456:
1457: CURSOR lock_c IS
1458: SELECT cust_trx_line_salesrep_id
1459: FROM ra_cust_trx_line_salesreps
1460: WHERE customer_trx_line_id = p_customer_trx_line_id
1461: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1462:
1463: BEGIN

Line 1482: | This procedure locks the ra_cust_trx_line_salesreps row identified |

1478: | PROCEDURE |
1479: | lock_fetch_p |
1480: | |
1481: | DESCRIPTION |
1482: | This procedure locks the ra_cust_trx_line_salesreps row identified |
1483: | by the p_cust_trx_line_salesrep_id parameter and populates the |
1484: | p_srep_rec parameter with the row that was locked. |
1485: | |
1486: | SCOPE - PUBLIC |

Line 1505: PROCEDURE lock_fetch_p( p_srep_rec IN OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,

1501: | 08-JUN-95 Charlie Tomberg Created |
1502: | |
1503: +===========================================================================*/
1504:
1505: PROCEDURE lock_fetch_p( p_srep_rec IN OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
1506: p_cust_trx_line_salesrep_id IN
1507: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type) IS
1508:
1509: BEGIN

Line 1507: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type) IS

1503: +===========================================================================*/
1504:
1505: PROCEDURE lock_fetch_p( p_srep_rec IN OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
1506: p_cust_trx_line_salesrep_id IN
1507: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type) IS
1508:
1509: BEGIN
1510: arp_util.debug('arp_ctls_pkg.lock_fetch_p()+');
1511:

Line 1514: FROM ra_cust_trx_line_salesreps

1510: arp_util.debug('arp_ctls_pkg.lock_fetch_p()+');
1511:
1512: SELECT *
1513: INTO p_srep_rec
1514: FROM ra_cust_trx_line_salesreps
1515: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
1516: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1517:
1518: arp_util.debug('arp_ctls_pkg.lock_fetch_p()-');

Line 1531: | This procedure locks the ra_cust_trx_line_salesreps row identified |

1527: | PROCEDURE |
1528: | lock_compare_p |
1529: | |
1530: | DESCRIPTION |
1531: | This procedure locks the ra_cust_trx_line_salesreps row identified |
1532: | by the p_cust_trx_line_salesrep_id parameter only if no columns in |
1533: | that row have changed from when they were first selected in the form. |
1534: | |
1535: | SCOPE - PUBLIC |

Line 1557: PROCEDURE lock_compare_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

1553: | 29-JUN-95 Charlie Tomberg Modified to use select for update |
1554: | |
1555: +===========================================================================*/
1556:
1557: PROCEDURE lock_compare_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1558: p_cust_trx_line_salesrep_id IN
1559: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1560: p_ignore_who_flag BOOLEAN DEFAULT FALSE) IS
1561:

Line 1559: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

1555: +===========================================================================*/
1556:
1557: PROCEDURE lock_compare_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
1558: p_cust_trx_line_salesrep_id IN
1559: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1560: p_ignore_who_flag BOOLEAN DEFAULT FALSE) IS
1561:
1562: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
1563: l_temp_srep_rec ra_cust_trx_line_salesreps%rowtype;

Line 1562: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;

1558: p_cust_trx_line_salesrep_id IN
1559: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1560: p_ignore_who_flag BOOLEAN DEFAULT FALSE) IS
1561:
1562: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
1563: l_temp_srep_rec ra_cust_trx_line_salesreps%rowtype;
1564: l_ignore_who_flag varchar2(2);
1565:
1566: BEGIN

Line 1563: l_temp_srep_rec ra_cust_trx_line_salesreps%rowtype;

1559: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
1560: p_ignore_who_flag BOOLEAN DEFAULT FALSE) IS
1561:
1562: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
1563: l_temp_srep_rec ra_cust_trx_line_salesreps%rowtype;
1564: l_ignore_who_flag varchar2(2);
1565:
1566: BEGIN
1567: arp_util.debug('arp_ctls_pkg.lock_compare_p()+');

Line 1576: FROM ra_cust_trx_line_salesreps tls

1572: END IF;
1573:
1574: SELECT *
1575: INTO l_new_srep_rec
1576: FROM ra_cust_trx_line_salesreps tls
1577: WHERE tls.cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
1578: AND
1579: (
1580: NVL(tls.cust_trx_line_salesrep_id, AR_NUMBER_DUMMY) =

Line 1988: | This procedure fetches a single row from ra_cust_trx_line_salesreps |

1984: | PROCEDURE |
1985: | fetch_p |
1986: | |
1987: | DESCRIPTION |
1988: | This procedure fetches a single row from ra_cust_trx_line_salesreps |
1989: | into a variable specified as a parameter based on the table's primary |
1990: | key, cust_trx_line_salesrep_id |
1991: | |
1992: | SCOPE - PUBLIC |

Line 2011: PROCEDURE fetch_p( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,

2007: | 08-JUN-95 Charlie Tomberg Created |
2008: | |
2009: +===========================================================================*/
2010:
2011: PROCEDURE fetch_p( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
2012: p_cust_trx_line_salesrep_id IN
2013: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)
2014: IS
2015:

Line 2013: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)

2009: +===========================================================================*/
2010:
2011: PROCEDURE fetch_p( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
2012: p_cust_trx_line_salesrep_id IN
2013: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)
2014: IS
2015:
2016: BEGIN
2017: arp_util.debug('arp_ctls_pkg.fetch_p()+');

Line 2021: FROM ra_cust_trx_line_salesreps

2017: arp_util.debug('arp_ctls_pkg.fetch_p()+');
2018:
2019: SELECT *
2020: INTO p_srep_rec
2021: FROM ra_cust_trx_line_salesreps
2022: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id;
2023:
2024: arp_util.debug('arp_ctls_pkg.fetch_p()-');
2025:

Line 2037: | This procedure deletes the ra_cust_trx_line_salesreps row identified |

2033: | PROCEDURE |
2034: | delete_p |
2035: | |
2036: | DESCRIPTION |
2037: | This procedure deletes the ra_cust_trx_line_salesreps row identified |
2038: | by the p_cust_trx_line_salesrep_id parameter. |
2039: | |
2040: | SCOPE - PUBLIC |
2041: | |

Line 2061: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

2057: | |
2058: +===========================================================================*/
2059:
2060: procedure delete_p( p_cust_trx_line_salesrep_id
2061: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
2062: p_customer_trx_line_id
2063: IN ra_customer_trx_lines.customer_trx_line_id%type )
2064: IS
2065:

Line 2078: DELETE FROM ra_cust_trx_line_salesreps

2074: p_event_name => 'oracle.apps.ar.transaction.SalesCredit.delete',
2075: p_event_key => to_char(p_cust_trx_line_salesrep_id) || '_' ||
2076: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2077:
2078: DELETE FROM ra_cust_trx_line_salesreps
2079: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id;
2080:
2081: rows := SQL%ROWCOUNT;
2082:

Line 2117: | This procedure deletes the ra_cust_trx_line_salesreps rows identified |

2113: | PROCEDURE |
2114: | delete_f_ct_id |
2115: | |
2116: | DESCRIPTION |
2117: | This procedure deletes the ra_cust_trx_line_salesreps rows identified |
2118: | by the p_customer_trx_id parameter. |
2119: | |
2120: | SCOPE - PUBLIC |
2121: | |

Line 2146: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

2142: p_delete_default_recs_flag IN boolean DEFAULT TRUE)
2143: IS
2144:
2145: CURSOR srep_trx_cursor IS
2146: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps
2147: where customer_trx_id = p_customer_trx_id;
2148:
2149: CURSOR srep_trx_line_cursor IS
2150: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

Line 2150: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

2146: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps
2147: where customer_trx_id = p_customer_trx_id;
2148:
2149: CURSOR srep_trx_line_cursor IS
2150: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps
2151: where customer_trx_id = p_customer_trx_id
2152: and customer_trx_line_id IS NOT NULL;
2153:
2154: BEGIN

Line 2168: DELETE FROM ra_cust_trx_line_salesreps

2164: p_event_key => to_char(l_srep_rec.cust_trx_line_salesrep_id) || '_' ||
2165: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2166: END LOOP;
2167:
2168: DELETE FROM ra_cust_trx_line_salesreps
2169: WHERE customer_trx_id = p_customer_trx_id;
2170:
2171: ELSE
2172:

Line 2180: DELETE FROM ra_cust_trx_line_salesreps

2176: p_event_key => to_char(l_srep_rec.cust_trx_line_salesrep_id) || '_' ||
2177: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2178: END LOOP;
2179:
2180: DELETE FROM ra_cust_trx_line_salesreps
2181: WHERE customer_trx_id = p_customer_trx_id
2182: AND customer_trx_line_id IS NOT NULL;
2183:
2184: END IF;

Line 2205: | This procedure deletes the ra_cust_trx_line_salesreps rows identified |

2201: | PROCEDURE |
2202: | delete_f_ctl_id |
2203: | |
2204: | DESCRIPTION |
2205: | This procedure deletes the ra_cust_trx_line_salesreps rows identified |
2206: | by the p_customer_trx_line_id parameter. |
2207: | |
2208: | SCOPE - PUBLIC |
2209: | |

Line 2232: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

2228: IN ra_customer_trx_lines.customer_trx_line_id%type)
2229: IS
2230:
2231: CURSOR srep_cursor IS
2232: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps
2233: where customer_trx_line_id = p_customer_trx_line_id;
2234:
2235: BEGIN
2236:

Line 2247: DELETE FROM ra_cust_trx_line_salesreps

2243: p_event_key => to_char(l_srep_rec.cust_trx_line_salesrep_id) || '_' ||
2244: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2245: END LOOP;
2246:
2247: DELETE FROM ra_cust_trx_line_salesreps
2248: WHERE customer_trx_line_id = p_customer_trx_line_id;
2249:
2250: erase_foreign_key_references( NULL,
2251: NULL,

Line 2269: | This procedure updates the ra_cust_trx_line_salesreps row identified |

2265: | PROCEDURE |
2266: | update_p |
2267: | |
2268: | DESCRIPTION |
2269: | This procedure updates the ra_cust_trx_line_salesreps row identified |
2270: | by the p_cust_trx_line_salesrep_id parameter. |
2271: | |
2272: | SCOPE - PUBLIC |
2273: | |

Line 2294: PROCEDURE update_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

2290: | 08-JUN-95 Charlie Tomberg Created |
2291: | |
2292: +===========================================================================*/
2293:
2294: PROCEDURE update_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
2295: p_cust_trx_line_salesrep_id IN
2296: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)
2297: IS
2298:

Line 2296: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)

2292: +===========================================================================*/
2293:
2294: PROCEDURE update_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
2295: p_cust_trx_line_salesrep_id IN
2296: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)
2297: IS
2298:
2299:
2300: BEGIN

Line 2331: | This procedure updates the ra_cust_trx_line_salesreps rows identified |

2327: | PROCEDURE |
2328: | update_f_ct_id |
2329: | |
2330: | DESCRIPTION |
2331: | This procedure updates the ra_cust_trx_line_salesreps rows identified |
2332: | by the p_customer_trx_id parameter. |
2333: | |
2334: | SCOPE - PUBLIC |
2335: | |

Line 2356: PROCEDURE update_f_ct_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

2352: | 08-JUN-95 Charlie Tomberg Created |
2353: | |
2354: +===========================================================================*/
2355:
2356: PROCEDURE update_f_ct_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
2357: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)
2358: IS
2359:
2360: CURSOR srep_trx_cursor IS

Line 2361: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

2357: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)
2358: IS
2359:
2360: CURSOR srep_trx_cursor IS
2361: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps
2362: where customer_trx_id = p_customer_trx_id;
2363:
2364: BEGIN
2365:

Line 2397: | This procedure updates the ra_cust_trx_line_salesreps rows identified |

2393: | PROCEDURE |
2394: | update_f_ctl_id |
2395: | |
2396: | DESCRIPTION |
2397: | This procedure updates the ra_cust_trx_line_salesreps rows identified |
2398: | by the p_customer_trx_line_id parameter. |
2399: | |
2400: | SCOPE - PUBLIC |
2401: | |

Line 2422: PROCEDURE update_f_ctl_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

2418: | 08-JUN-95 Charlie Tomberg Created |
2419: | |
2420: +===========================================================================*/
2421:
2422: PROCEDURE update_f_ctl_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
2423: p_customer_trx_line_id IN
2424: ra_customer_trx_lines.customer_trx_line_id%type)
2425: IS
2426:

Line 2428: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

2424: ra_customer_trx_lines.customer_trx_line_id%type)
2425: IS
2426:
2427: CURSOR srep_cursor IS
2428: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps
2429: where customer_trx_line_id = p_customer_trx_line_id;
2430:
2431: BEGIN
2432:

Line 2463: | This procedure updates the ra_cust_trx_line_salesreps rows identified |

2459: | PROCEDURE |
2460: | update_f_psr_id |
2461: | |
2462: | DESCRIPTION |
2463: | This procedure updates the ra_cust_trx_line_salesreps rows identified |
2464: | by the prev_cust_trx_line_salesrep_id parameter. |
2465: | |
2466: | SCOPE - PUBLIC |
2467: | |

Line 2489: PROCEDURE update_f_psr_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

2485: | 08-JUN-95 Charlie Tomberg Created |
2486: | |
2487: +===========================================================================*/
2488:
2489: PROCEDURE update_f_psr_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
2490: p_prev_cust_trx_line_srep_id
2491: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type)
2492: IS
2493:

Line 2491: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type)

2487: +===========================================================================*/
2488:
2489: PROCEDURE update_f_psr_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
2490: p_prev_cust_trx_line_srep_id
2491: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type)
2492: IS
2493:
2494: CURSOR srep_cursor IS
2495: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

Line 2495: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

2491: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type)
2492: IS
2493:
2494: CURSOR srep_cursor IS
2495: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps
2496: where prev_cust_trx_line_salesrep_id = p_prev_cust_trx_line_srep_id;
2497:
2498: BEGIN
2499:

Line 2531: | This procedure updates the ra_cust_trx_line_salesreps rows identified |

2527: | PROCEDURE |
2528: | update_amounts_f_ctl_id |
2529: | |
2530: | DESCRIPTION |
2531: | This procedure updates the ra_cust_trx_line_salesreps rows identified |
2532: | by the p_customer_trx_id parameter. |
2533: | |
2534: | SCOPE - PUBLIC |
2535: | |

Line 2566: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps

2562: fnd_currencies.currency_code%type)
2563: IS
2564:
2565: CURSOR srep_cursor IS
2566: select cust_trx_line_salesrep_id from ra_cust_trx_line_salesreps
2567: where customer_trx_line_id = p_customer_trx_line_id;
2568:
2569: BEGIN
2570:

Line 2585: update ra_cust_trx_line_salesreps

2581: p_event_key => to_char(l_srep_rec.cust_trx_line_salesrep_id) || '_' ||
2582: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2583: END LOOP;
2584:
2585: update ra_cust_trx_line_salesreps
2586: set last_updated_by = pg_user_id,
2587: last_update_date = sysdate,
2588: last_update_login = pg_login_id,
2589: revenue_amount_split = arpcurr.CurrRound(

Line 2619: | This procedure inserts a row into ra_cust_trx_line_salesreps that |

2615: | PROCEDURE |
2616: | insert_p |
2617: | |
2618: | DESCRIPTION |
2619: | This procedure inserts a row into ra_cust_trx_line_salesreps that |
2620: | contains the column values specified in the p_srep_rec parameter. |
2621: | |
2622: | SCOPE - PUBLIC |
2623: | |

Line 2642: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,

2638: | |
2639: +===========================================================================*/
2640:
2641: PROCEDURE insert_p(
2642: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
2643: p_cust_trx_line_salesrep_id
2644: OUT NOCOPY ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type
2645:
2646: ) IS

Line 2644: OUT NOCOPY ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type

2640:
2641: PROCEDURE insert_p(
2642: p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
2643: p_cust_trx_line_salesrep_id
2644: OUT NOCOPY ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type
2645:
2646: ) IS
2647:
2648:

Line 2650: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;

2646: ) IS
2647:
2648:
2649: l_cust_trx_line_salesrep_id
2650: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
2651:
2652:
2653: BEGIN
2654:

Line 2663: SELECT RA_CUST_TRX_LINE_SALESREPS_S.NEXTVAL

2659: /*---------------------------*
2660: | Get the unique identifier |
2661: *---------------------------*/
2662:
2663: SELECT RA_CUST_TRX_LINE_SALESREPS_S.NEXTVAL
2664: INTO l_cust_trx_line_salesrep_id
2665: FROM DUAL;
2666:
2667:

Line 2672: INSERT INTO ra_cust_trx_line_salesreps

2668: /*-------------------*
2669: | Insert the record |
2670: *-------------------*/
2671:
2672: INSERT INTO ra_cust_trx_line_salesreps
2673: (
2674: cust_trx_line_salesrep_id,
2675: customer_trx_id,
2676: customer_trx_line_id,

Line 2773: | This procedure inserts rows into ra_cust_trx_line_salesreps that |

2769: | PROCEDURE |
2770: | insert_f_ct_ctl_id |
2771: | |
2772: | DESCRIPTION |
2773: | This procedure inserts rows into ra_cust_trx_line_salesreps that |
2774: | correspond to the default salescredits for the transaction |
2775: | |
2776: | SCOPE - PUBLIC |
2777: | |

Line 2826: INSERT INTO ra_cust_trx_line_salesreps

2822:
2823: IF (p_customer_trx_line_id IS NOT NULL)
2824: THEN
2825:
2826: INSERT INTO ra_cust_trx_line_salesreps
2827: (
2828: cust_trx_line_salesrep_id,
2829: last_update_date,
2830: last_updated_by,

Line 2845: SELECT ra_cust_trx_line_salesreps_s.nextval,

2841: non_revenue_amount_split,
2842: non_revenue_salesgroup_id,
2843: org_id
2844: )
2845: SELECT ra_cust_trx_line_salesreps_s.nextval,
2846: sysdate, /* last_update_date */
2847: pg_user_id, /* last_updated_by */
2848: sysdate, /* creation_date */
2849: pg_user_id, /* created_by */

Line 2894: ra_cust_trx_line_salesreps ctls,

2890: ),
2891: ctls.non_revenue_salesgroup_id,
2892: ct.org_id
2893: FROM ra_customer_trx ct,
2894: ra_cust_trx_line_salesreps ctls,
2895: ra_customer_trx_lines ctl
2896: WHERE ctl.customer_trx_id = ctls.customer_trx_id(+)
2897: AND ctl.customer_trx_id = ct.customer_trx_id
2898: AND ct.customer_trx_id = p_customer_trx_id

Line 2920: INSERT INTO ra_cust_trx_line_salesreps

2916: );
2917:
2918: ELSE
2919: /* p_customer_trx_line_id is NULL */
2920: INSERT INTO ra_cust_trx_line_salesreps
2921: (
2922: cust_trx_line_salesrep_id,
2923: last_update_date,
2924: last_updated_by,

Line 2939: SELECT ra_cust_trx_line_salesreps_s.nextval,

2935: non_revenue_amount_split
2936: ,non_revenue_salesgroup_id -- added here and in SELECT - bug 3067675
2937: ,org_id
2938: )
2939: SELECT ra_cust_trx_line_salesreps_s.nextval,
2940: sysdate, /* last_update_date */
2941: pg_user_id, /* last_updated_by */
2942: sysdate, /* creation_date */
2943: pg_user_id, /* created_by */

Line 2988: ra_cust_trx_line_salesreps ctls,

2984: )
2985: ,ctls.non_revenue_salesgroup_id
2986: ,ct.org_id
2987: FROM ra_customer_trx ct,
2988: ra_cust_trx_line_salesreps ctls,
2989: ra_customer_trx_lines ctl
2990: WHERE ctl.customer_trx_id = ctls.customer_trx_id(+)
2991: AND ctl.customer_trx_id = ct.customer_trx_id
2992: AND ct.customer_trx_id = p_customer_trx_id

Line 3024: | This procedure inserts rows into ra_cust_trx_line_salesreps that |

3020: | PROCEDURE |
3021: | insert_f_cm_ct_ctl_id |
3022: | |
3023: | DESCRIPTION |
3024: | This procedure inserts rows into ra_cust_trx_line_salesreps that |
3025: | correspond to salescredits for the credited transaction or |
3026: | a credited transaction line |
3027: | |
3028: | SCOPE - PUBLIC |

Line 3065: INSERT INTO ra_cust_trx_line_salesreps

3061: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3062: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3063: arp_util.debug('p_currency_code = ' || p_currency_code);
3064:
3065: INSERT INTO ra_cust_trx_line_salesreps
3066: (
3067: cust_trx_line_salesrep_id,
3068: last_update_date,
3069: last_updated_by,

Line 3085: SELECT ra_cust_trx_line_salesreps_s.nextval,

3081: non_revenue_percent_split,
3082: non_revenue_amount_split
3083: ,org_id
3084: )
3085: SELECT ra_cust_trx_line_salesreps_s.nextval,
3086: sysdate, /* last_update_date */
3087: pg_user_id, /* last_updated_by */
3088: sysdate, /* creation_date */
3089: pg_user_id, /* created_by */

Line 3117: FROM ra_cust_trx_line_salesreps prev_ctls,

3113: ctl.extended_amount,
3114: p_currency_code
3115: ) /* non_revenue_amount_split */
3116: ,cm_ct.org_id
3117: FROM ra_cust_trx_line_salesreps prev_ctls,
3118: ra_customer_trx_lines ctl,
3119: ra_customer_trx cm_ct
3120: WHERE ctl.previous_customer_trx_id = prev_ctls.customer_trx_id(+)
3121: AND ctl.previous_customer_trx_line_id =

Line 3148: | This procedure inserts rows into ra_cust_trx_line_salesreps that |

3144: | PROCEDURE |
3145: | insert_f_cmn_ct_ctl_id |
3146: | |
3147: | DESCRIPTION |
3148: | This procedure inserts rows into ra_cust_trx_line_salesreps that |
3149: | correspond to salescredits for the credit memo for a credited
3150: | transaction line |
3151: | |
3152: | SCOPE - PUBLIC |

Line 3185: INSERT INTO ra_cust_trx_line_salesreps

3181:
3182: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3183: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3184:
3185: INSERT INTO ra_cust_trx_line_salesreps
3186: (
3187: cust_trx_line_salesrep_id,
3188: last_update_date,
3189: last_updated_by,

Line 3205: SELECT ra_cust_trx_line_salesreps_s.nextval,

3201: non_revenue_percent_split,
3202: non_revenue_amount_split
3203: ,org_id
3204: )
3205: SELECT ra_cust_trx_line_salesreps_s.nextval,
3206: sysdate, /* last_update_date */
3207: pg_user_id, /* last_updated_by */
3208: sysdate, /* creation_date */
3209: pg_user_id, /* created_by */

Line 3254: FROM ra_cust_trx_line_salesreps prev_ctls,

3250: ctl.extended_amount,
3251: cm_ct.invoice_currency_code
3252: ) /* non_revenue_amount_split */
3253: ,cm_ct.org_id
3254: FROM ra_cust_trx_line_salesreps prev_ctls,
3255: ra_customer_trx_lines ctl,
3256: ra_customer_trx cm_ct
3257: WHERE ctl.previous_customer_trx_id = prev_ctls.customer_trx_id(+)
3258: AND ctl.previous_customer_trx_line_id =

Line 3337: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,

3333: +===========================================================================*/
3334:
3335: PROCEDURE lock_compare_cover(
3336: p_cust_trx_line_salesrep_id IN
3337: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
3338: p_customer_trx_id IN
3339: ra_cust_trx_line_salesreps.customer_trx_id%type,
3340: p_customer_trx_line_id IN
3341: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

Line 3339: ra_cust_trx_line_salesreps.customer_trx_id%type,

3335: PROCEDURE lock_compare_cover(
3336: p_cust_trx_line_salesrep_id IN
3337: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
3338: p_customer_trx_id IN
3339: ra_cust_trx_line_salesreps.customer_trx_id%type,
3340: p_customer_trx_line_id IN
3341: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
3342: p_salesrep_id IN
3343: ra_cust_trx_line_salesreps.salesrep_id%type,

Line 3341: ra_cust_trx_line_salesreps.customer_trx_line_id%type,

3337: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
3338: p_customer_trx_id IN
3339: ra_cust_trx_line_salesreps.customer_trx_id%type,
3340: p_customer_trx_line_id IN
3341: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
3342: p_salesrep_id IN
3343: ra_cust_trx_line_salesreps.salesrep_id%type,
3344: p_revenue_amount_split IN
3345: ra_cust_trx_line_salesreps.revenue_amount_split%type,

Line 3343: ra_cust_trx_line_salesreps.salesrep_id%type,

3339: ra_cust_trx_line_salesreps.customer_trx_id%type,
3340: p_customer_trx_line_id IN
3341: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
3342: p_salesrep_id IN
3343: ra_cust_trx_line_salesreps.salesrep_id%type,
3344: p_revenue_amount_split IN
3345: ra_cust_trx_line_salesreps.revenue_amount_split%type,
3346: p_non_revenue_amount_split IN
3347: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

Line 3345: ra_cust_trx_line_salesreps.revenue_amount_split%type,

3341: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
3342: p_salesrep_id IN
3343: ra_cust_trx_line_salesreps.salesrep_id%type,
3344: p_revenue_amount_split IN
3345: ra_cust_trx_line_salesreps.revenue_amount_split%type,
3346: p_non_revenue_amount_split IN
3347: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
3348: p_non_revenue_percent_split IN
3349: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

Line 3347: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,

3343: ra_cust_trx_line_salesreps.salesrep_id%type,
3344: p_revenue_amount_split IN
3345: ra_cust_trx_line_salesreps.revenue_amount_split%type,
3346: p_non_revenue_amount_split IN
3347: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
3348: p_non_revenue_percent_split IN
3349: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
3350: p_revenue_percent_split IN
3351: ra_cust_trx_line_salesreps.revenue_percent_split%type,

Line 3349: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,

3345: ra_cust_trx_line_salesreps.revenue_amount_split%type,
3346: p_non_revenue_amount_split IN
3347: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
3348: p_non_revenue_percent_split IN
3349: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
3350: p_revenue_percent_split IN
3351: ra_cust_trx_line_salesreps.revenue_percent_split%type,
3352: p_prev_cust_trx_line_srep_id IN
3353: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

Line 3351: ra_cust_trx_line_salesreps.revenue_percent_split%type,

3347: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
3348: p_non_revenue_percent_split IN
3349: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
3350: p_revenue_percent_split IN
3351: ra_cust_trx_line_salesreps.revenue_percent_split%type,
3352: p_prev_cust_trx_line_srep_id IN
3353: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
3354: p_attribute_category IN
3355: ra_cust_trx_line_salesreps.attribute_category%type,

Line 3353: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,

3349: ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
3350: p_revenue_percent_split IN
3351: ra_cust_trx_line_salesreps.revenue_percent_split%type,
3352: p_prev_cust_trx_line_srep_id IN
3353: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
3354: p_attribute_category IN
3355: ra_cust_trx_line_salesreps.attribute_category%type,
3356: p_attribute1 IN
3357: ra_cust_trx_line_salesreps.attribute1%type,

Line 3355: ra_cust_trx_line_salesreps.attribute_category%type,

3351: ra_cust_trx_line_salesreps.revenue_percent_split%type,
3352: p_prev_cust_trx_line_srep_id IN
3353: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
3354: p_attribute_category IN
3355: ra_cust_trx_line_salesreps.attribute_category%type,
3356: p_attribute1 IN
3357: ra_cust_trx_line_salesreps.attribute1%type,
3358: p_attribute2 IN
3359: ra_cust_trx_line_salesreps.attribute2%type,

Line 3357: ra_cust_trx_line_salesreps.attribute1%type,

3353: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
3354: p_attribute_category IN
3355: ra_cust_trx_line_salesreps.attribute_category%type,
3356: p_attribute1 IN
3357: ra_cust_trx_line_salesreps.attribute1%type,
3358: p_attribute2 IN
3359: ra_cust_trx_line_salesreps.attribute2%type,
3360: p_attribute3 IN
3361: ra_cust_trx_line_salesreps.attribute3%type,

Line 3359: ra_cust_trx_line_salesreps.attribute2%type,

3355: ra_cust_trx_line_salesreps.attribute_category%type,
3356: p_attribute1 IN
3357: ra_cust_trx_line_salesreps.attribute1%type,
3358: p_attribute2 IN
3359: ra_cust_trx_line_salesreps.attribute2%type,
3360: p_attribute3 IN
3361: ra_cust_trx_line_salesreps.attribute3%type,
3362: p_attribute4 IN
3363: ra_cust_trx_line_salesreps.attribute4%type,

Line 3361: ra_cust_trx_line_salesreps.attribute3%type,

3357: ra_cust_trx_line_salesreps.attribute1%type,
3358: p_attribute2 IN
3359: ra_cust_trx_line_salesreps.attribute2%type,
3360: p_attribute3 IN
3361: ra_cust_trx_line_salesreps.attribute3%type,
3362: p_attribute4 IN
3363: ra_cust_trx_line_salesreps.attribute4%type,
3364: p_attribute5 IN
3365: ra_cust_trx_line_salesreps.attribute5%type,

Line 3363: ra_cust_trx_line_salesreps.attribute4%type,

3359: ra_cust_trx_line_salesreps.attribute2%type,
3360: p_attribute3 IN
3361: ra_cust_trx_line_salesreps.attribute3%type,
3362: p_attribute4 IN
3363: ra_cust_trx_line_salesreps.attribute4%type,
3364: p_attribute5 IN
3365: ra_cust_trx_line_salesreps.attribute5%type,
3366: p_attribute6 IN
3367: ra_cust_trx_line_salesreps.attribute6%type,

Line 3365: ra_cust_trx_line_salesreps.attribute5%type,

3361: ra_cust_trx_line_salesreps.attribute3%type,
3362: p_attribute4 IN
3363: ra_cust_trx_line_salesreps.attribute4%type,
3364: p_attribute5 IN
3365: ra_cust_trx_line_salesreps.attribute5%type,
3366: p_attribute6 IN
3367: ra_cust_trx_line_salesreps.attribute6%type,
3368: p_attribute7 IN
3369: ra_cust_trx_line_salesreps.attribute7%type,

Line 3367: ra_cust_trx_line_salesreps.attribute6%type,

3363: ra_cust_trx_line_salesreps.attribute4%type,
3364: p_attribute5 IN
3365: ra_cust_trx_line_salesreps.attribute5%type,
3366: p_attribute6 IN
3367: ra_cust_trx_line_salesreps.attribute6%type,
3368: p_attribute7 IN
3369: ra_cust_trx_line_salesreps.attribute7%type,
3370: p_attribute8 IN
3371: ra_cust_trx_line_salesreps.attribute8%type,

Line 3369: ra_cust_trx_line_salesreps.attribute7%type,

3365: ra_cust_trx_line_salesreps.attribute5%type,
3366: p_attribute6 IN
3367: ra_cust_trx_line_salesreps.attribute6%type,
3368: p_attribute7 IN
3369: ra_cust_trx_line_salesreps.attribute7%type,
3370: p_attribute8 IN
3371: ra_cust_trx_line_salesreps.attribute8%type,
3372: p_attribute9 IN
3373: ra_cust_trx_line_salesreps.attribute9%type,

Line 3371: ra_cust_trx_line_salesreps.attribute8%type,

3367: ra_cust_trx_line_salesreps.attribute6%type,
3368: p_attribute7 IN
3369: ra_cust_trx_line_salesreps.attribute7%type,
3370: p_attribute8 IN
3371: ra_cust_trx_line_salesreps.attribute8%type,
3372: p_attribute9 IN
3373: ra_cust_trx_line_salesreps.attribute9%type,
3374: p_attribute10 IN
3375: ra_cust_trx_line_salesreps.attribute10%type,

Line 3373: ra_cust_trx_line_salesreps.attribute9%type,

3369: ra_cust_trx_line_salesreps.attribute7%type,
3370: p_attribute8 IN
3371: ra_cust_trx_line_salesreps.attribute8%type,
3372: p_attribute9 IN
3373: ra_cust_trx_line_salesreps.attribute9%type,
3374: p_attribute10 IN
3375: ra_cust_trx_line_salesreps.attribute10%type,
3376: p_attribute11 IN
3377: ra_cust_trx_line_salesreps.attribute11%type,

Line 3375: ra_cust_trx_line_salesreps.attribute10%type,

3371: ra_cust_trx_line_salesreps.attribute8%type,
3372: p_attribute9 IN
3373: ra_cust_trx_line_salesreps.attribute9%type,
3374: p_attribute10 IN
3375: ra_cust_trx_line_salesreps.attribute10%type,
3376: p_attribute11 IN
3377: ra_cust_trx_line_salesreps.attribute11%type,
3378: p_attribute12 IN
3379: ra_cust_trx_line_salesreps.attribute12%type,

Line 3377: ra_cust_trx_line_salesreps.attribute11%type,

3373: ra_cust_trx_line_salesreps.attribute9%type,
3374: p_attribute10 IN
3375: ra_cust_trx_line_salesreps.attribute10%type,
3376: p_attribute11 IN
3377: ra_cust_trx_line_salesreps.attribute11%type,
3378: p_attribute12 IN
3379: ra_cust_trx_line_salesreps.attribute12%type,
3380: p_attribute13 IN
3381: ra_cust_trx_line_salesreps.attribute13%type,

Line 3379: ra_cust_trx_line_salesreps.attribute12%type,

3375: ra_cust_trx_line_salesreps.attribute10%type,
3376: p_attribute11 IN
3377: ra_cust_trx_line_salesreps.attribute11%type,
3378: p_attribute12 IN
3379: ra_cust_trx_line_salesreps.attribute12%type,
3380: p_attribute13 IN
3381: ra_cust_trx_line_salesreps.attribute13%type,
3382: p_attribute14 IN
3383: ra_cust_trx_line_salesreps.attribute14%type,

Line 3381: ra_cust_trx_line_salesreps.attribute13%type,

3377: ra_cust_trx_line_salesreps.attribute11%type,
3378: p_attribute12 IN
3379: ra_cust_trx_line_salesreps.attribute12%type,
3380: p_attribute13 IN
3381: ra_cust_trx_line_salesreps.attribute13%type,
3382: p_attribute14 IN
3383: ra_cust_trx_line_salesreps.attribute14%type,
3384: p_attribute15 IN
3385: ra_cust_trx_line_salesreps.attribute15%type,

Line 3383: ra_cust_trx_line_salesreps.attribute14%type,

3379: ra_cust_trx_line_salesreps.attribute12%type,
3380: p_attribute13 IN
3381: ra_cust_trx_line_salesreps.attribute13%type,
3382: p_attribute14 IN
3383: ra_cust_trx_line_salesreps.attribute14%type,
3384: p_attribute15 IN
3385: ra_cust_trx_line_salesreps.attribute15%type,
3386: /* BEGIN bug 3067675 */
3387: p_revenue_salesgroup_id IN

Line 3385: ra_cust_trx_line_salesreps.attribute15%type,

3381: ra_cust_trx_line_salesreps.attribute13%type,
3382: p_attribute14 IN
3383: ra_cust_trx_line_salesreps.attribute14%type,
3384: p_attribute15 IN
3385: ra_cust_trx_line_salesreps.attribute15%type,
3386: /* BEGIN bug 3067675 */
3387: p_revenue_salesgroup_id IN
3388: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
3389: p_non_revenue_salesgroup_id IN

Line 3388: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,

3384: p_attribute15 IN
3385: ra_cust_trx_line_salesreps.attribute15%type,
3386: /* BEGIN bug 3067675 */
3387: p_revenue_salesgroup_id IN
3388: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
3389: p_non_revenue_salesgroup_id IN
3390: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
3391: /* END bug 3067675 */
3392: IS

Line 3390: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)

3386: /* BEGIN bug 3067675 */
3387: p_revenue_salesgroup_id IN
3388: ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
3389: p_non_revenue_salesgroup_id IN
3390: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
3391: /* END bug 3067675 */
3392: IS
3393:
3394: l_srep_rec ra_cust_trx_line_salesreps%rowtype;

Line 3394: l_srep_rec ra_cust_trx_line_salesreps%rowtype;

3390: ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null)
3391: /* END bug 3067675 */
3392: IS
3393:
3394: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
3395:
3396: BEGIN
3397:
3398: arp_util.debug('arp_ctls_pkg.lock_compare_cover()+');