460: -- Defining REF CURSOR
461: TYPE rc IS REF CURSOR;
462: query_cur rc;
463: BEGIN
464: -- Standard Start of API savepoint
465: SAVEPOINT get_adj;
466: -- Standard call to check for call compatibility.
467: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
468: p_api_version ,
462: query_cur rc;
463: BEGIN
464: -- Standard Start of API savepoint
465: SAVEPOINT get_adj;
466: -- Standard call to check for call compatibility.
467: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
468: p_api_version ,
469: l_api_name,
470: G_PKG_NAME ) THEN
783: l_cust_id NUMBER;
784: l_space VARCHAR2(10) := '&'||'nbsp;';
785: --
786: BEGIN
787: -- Standard Start of API savepoint
788: SAVEPOINT get_split_data;
789: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
790: p_api_version ,
791: l_api_name,
1311: -- Bug#2969534 End
1312: ------+
1313:
1314: BEGIN
1315: -- Standard Start of API savepoint
1316: SAVEPOINT insert_api_record;
1317: -- Standard call to check for call compatibility.
1318: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1319: p_api_version ,
1313:
1314: BEGIN
1315: -- Standard Start of API savepoint
1316: SAVEPOINT insert_api_record;
1317: -- Standard call to check for call compatibility.
1318: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1319: p_api_version ,
1320: l_api_name,
1321: G_PKG_NAME ) THEN
1531: l_adj_rec adj_rec_type;
1532: --
1533: BEGIN
1534: --cn_mydebug.delete;
1535: -- Standard Start of API savepoint
1536: SAVEPOINT call_mass_update;
1537: -- Standard call to check for call compatibility.
1538: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1539: p_api_version ,
1533: BEGIN
1534: --cn_mydebug.delete;
1535: -- Standard Start of API savepoint
1536: SAVEPOINT call_mass_update;
1537: -- Standard call to check for call compatibility.
1538: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1539: p_api_version ,
1540: l_api_name,
1541: G_PKG_NAME ) THEN
1685: l_adjust_comments cn_comm_lines_api.adjust_comments%TYPE;
1686: --
1687:
1688: BEGIN
1689: -- Standard Start of API savepoint
1690: SAVEPOINT call_deal_assign;
1691:
1692: -- Standard call to check for call compatibility.
1693: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1688: BEGIN
1689: -- Standard Start of API savepoint
1690: SAVEPOINT call_deal_assign;
1691:
1692: -- Standard call to check for call compatibility.
1693: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1694: p_api_version ,
1695: l_api_name,
1696: G_PKG_NAME ) THEN
1819: AND (ch.adjust_status NOT IN ('FROZEN','REVERSAL') );--OR
1820: -- ch.adjust_status IS NULL);
1821:
1822: BEGIN
1823: -- Standard Start of API savepoint
1824: SAVEPOINT call_split;
1825: -- Standard call to check for call compatibility.
1826: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1827: p_api_version ,
1821:
1822: BEGIN
1823: -- Standard Start of API savepoint
1824: SAVEPOINT call_split;
1825: -- Standard call to check for call compatibility.
1826: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1827: p_api_version ,
1828: l_api_name,
1829: G_PKG_NAME ) THEN
2711: l_api_version CONSTANT NUMBER := 1.0;
2712: l_tbl_count NUMBER := 0;
2713: --
2714: BEGIN
2715: -- Standard Start of API savepoint
2716: SAVEPOINT get_trx_lines;
2717: -- Standard call to check for call compatibility.
2718: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2719: p_api_version ,
2713: --
2714: BEGIN
2715: -- Standard Start of API savepoint
2716: SAVEPOINT get_trx_lines;
2717: -- Standard call to check for call compatibility.
2718: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2719: p_api_version ,
2720: l_api_name,
2721: G_PKG_NAME ) THEN
2837: l_api_version CONSTANT NUMBER := 1.0;
2838: l_tbl_count NUMBER := 1;
2839: --
2840: BEGIN
2841: -- Standard Start of API savepoint
2842: SAVEPOINT get_trx_history;
2843:
2844: -- Standard call to check for call compatibility.
2845: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2840: BEGIN
2841: -- Standard Start of API savepoint
2842: SAVEPOINT get_trx_history;
2843:
2844: -- Standard call to check for call compatibility.
2845: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2846: p_api_version ,
2847: l_api_name,
2848: G_PKG_NAME ) THEN
2931: l_tbl_count NUMBER := 1;
2932: l_cust_info_rec cn_adjustments_pkg.cust_info_rec;
2933: --
2934: BEGIN
2935: -- Standard Start of API savepoint
2936: SAVEPOINT get_cust_info;
2937:
2938: -- Standard call to check for call compatibility.
2939: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2934: BEGIN
2935: -- Standard Start of API savepoint
2936: SAVEPOINT get_cust_info;
2937:
2938: -- Standard call to check for call compatibility.
2939: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2940: p_api_version ,
2941: l_api_name,
2942: G_PKG_NAME ) THEN
3029: l_comm_line_count NUMBER;
3030:
3031:
3032: BEGIN
3033: -- Standard Start of API savepoint
3034: SAVEPOINT update_api_record;
3035: -- Standard call to check for call compatibility.
3036: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3037: p_api_version ,
3031:
3032: BEGIN
3033: -- Standard Start of API savepoint
3034: SAVEPOINT update_api_record;
3035: -- Standard call to check for call compatibility.
3036: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3037: p_api_version ,
3038: l_api_name,
3039: G_PKG_NAME ) THEN
3275: l_salesrep_id NUMBER;
3276: l_cls_rol_flag CHAR(1) := 'Y';
3277: --
3278: BEGIN
3279: -- Standard Start of API savepoint
3280: SAVEPOINT call_load;
3281: -- Standard call to check for call compatibility.
3282: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3283: p_api_version ,
3277: --
3278: BEGIN
3279: -- Standard Start of API savepoint
3280: SAVEPOINT call_load;
3281: -- Standard call to check for call compatibility.
3282: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3283: p_api_version ,
3284: l_api_name,
3285: G_PKG_NAME ) THEN