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.CN_INVOICE_CHANGES_PVT dependencies on CN_INVOICE_CHANGES

Line 1: PACKAGE BODY CN_INVOICE_CHANGES_PVT AS

1: PACKAGE BODY CN_INVOICE_CHANGES_PVT AS
2: --$Header: cnvinvb.pls 120.7.12000000.2 2007/08/07 15:05:20 apink ship $
3: -- +======================================================================+
4: -- | Copyright (c) 1994 Oracle Corporation |
5: -- | Redwood Shores, California, USA |

Line 10: -- cn_invoice_changes_pvt

6: -- | All rights reserved. |
7: -- +======================================================================+
8: --
9: -- Package Name
10: -- cn_invoice_changes_pvt
11: -- Purpose
12: -- Package Body for Procedures related to cn_invoice_changes table changes.
13: -- History
14: -- 08/07/01 Rao.Chenna Created

Line 12: -- Package Body for Procedures related to cn_invoice_changes table changes.

8: --
9: -- Package Name
10: -- cn_invoice_changes_pvt
11: -- Purpose
12: -- Package Body for Procedures related to cn_invoice_changes table changes.
13: -- History
14: -- 08/07/01 Rao.Chenna Created
15: --
16: -- Nov 22, 2005 vensrini Bug Fix 4202682. Changed cursor c1 in

Line 28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_INVOICE_CHANGES_PVT';

24: --
25: -- Jul 5, 2006 vensrini Bug fix 5349170
26:
27:
28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_INVOICE_CHANGES_PVT';
29: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvinvb.pls';
30: --
31: FUNCTION g_track_invoice
32: RETURN VARCHAR2 IS

Line 681: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;

677: l_api_version CONSTANT NUMBER := 1.0;
678: --
679: l_invoice_change_id NUMBER;
680: -- PL/SQL tables and records
681: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;
682: --
683: CURSOR c1(
684: l_comm_lines_api_id NUMBER) IS
685: SELECT invoice_change_id

Line 686: FROM cn_invoice_changes

682: --
683: CURSOR c1(
684: l_comm_lines_api_id NUMBER) IS
685: SELECT invoice_change_id
686: FROM cn_invoice_changes
687: WHERE comm_lines_api_id = l_comm_lines_api_id;
688: --
689: BEGIN
690: -- Standard Start of API savepoint

Line 707: -- Delete the existing records in cn_invoice_changes table.

703: -- Initialize API return status to success
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
705: x_loading_status := 'CN_INSERTED';
706: -- API body
707: -- Delete the existing records in cn_invoice_changes table.
708: -- apiId: I need to change here. update_api is OK with api_id.
709: -- apiId: trx split uses this and it is OK with api_id.
710: -- apiId: Move credits also uses and it is OK with api_id.
711: IF (NVL(p_exist_data_check,'Y') = 'Y') THEN

Line 715: cn_invoice_changes_pkg.delete_row(c1_rec.invoice_change_id);

711: IF (NVL(p_exist_data_check,'Y') = 'Y') THEN
712: FOR i IN p_existing_data.FIRST..p_existing_data.LAST
713: LOOP
714: FOR c1_rec IN c1(p_existing_data(i).comm_lines_api_id) LOOP
715: cn_invoice_changes_pkg.delete_row(c1_rec.invoice_change_id);
716: END LOOP;
717: END LOOP;
718: END IF;
719: -- Create new records in the same table.

Line 736: cn_invoice_changes_pkg.insert_row(

732: l_insert_rec.revenue_type := p_new_data(i).revenue_type;
733: l_insert_rec.split_pct := p_new_data(i).split_pct;
734: l_insert_rec.comm_lines_api_id := p_new_data(i).comm_lines_api_id;
735: --
736: cn_invoice_changes_pkg.insert_row(
737: p_invoice_changes_all_rec => l_insert_rec);
738: --
739: END LOOP;
740: END IF;

Line 1650: cn_invoice_changes_pvt.update_invoice_changes(

1646: l_new_data(1).revenue_type := NULL;
1647: l_new_data(1).split_pct := NULL;
1648: l_new_data(1).direct_salesrep_number := NULL;
1649: IF ((l_existing_data.COUNT <> 0) AND (l_new_data.COUNT <> 0)) THEN
1650: cn_invoice_changes_pvt.update_invoice_changes(
1651: p_api_version => l_api_version,
1652: p_validation_level => p_validation_level,
1653: p_existing_data => l_existing_data,
1654: p_new_data => l_new_data,

Line 1708: x_deal_data_tbl OUT NOCOPY cn_invoice_changes_pvt.deal_data_tbl,

1704: p_split_nonrevenue_line IN VARCHAR2,
1705: p_invoice_number IN VARCHAR2,
1706: p_org_id IN NUMBER,
1707: p_split_data_tbl IN cn_get_tx_data_pub.split_data_tbl,
1708: x_deal_data_tbl OUT NOCOPY cn_invoice_changes_pvt.deal_data_tbl,
1709: x_return_status OUT NOCOPY VARCHAR2,
1710: x_msg_count OUT NOCOPY NUMBER,
1711: x_msg_data OUT NOCOPY VARCHAR2,
1712: x_loading_status OUT NOCOPY VARCHAR2) IS

Line 1738: FROM cn_invoice_changes

1734: AND (ch.adjust_status NOT IN ('FROZEN','REVERSAL') OR
1735: ch.adjust_status IS NULL);
1736: CURSOR c2 IS
1737: SELECT invoice_change_id, revenue_type
1738: FROM cn_invoice_changes
1739: WHERE invoice_number = p_invoice_number
1740: AND org_id = p_org_id; -- vensrini
1741:
1742: --

Line 1749: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;

1745: l_api_version CONSTANT NUMBER := 1.0;
1746: l_invoice_change_id NUMBER;
1747: l_counter NUMBER := 0;
1748: -- PL/SQL tables and records
1749: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;
1750: --
1751: BEGIN
1752: -- Standard Start of API savepoint
1753: SAVEPOINT capture_deal_invoice;

Line 1776: cn_invoice_changes_pkg.delete_row(c2_rec.invoice_change_id);

1772: IF ((c2_rec.revenue_type = 'NONREVENUE') AND
1773: (p_split_nonrevenue_line = 'N'))THEN
1774: NULL;
1775: ELSE
1776: cn_invoice_changes_pkg.delete_row(c2_rec.invoice_change_id);
1777: END IF;
1778: END LOOP;
1779: END IF;
1780: FOR c1_rec IN c1

Line 1831: o Based on c2, collect the invoice split data from cn_invoice_changes table

1827: o Collect the new CMs matching with the stored invoice split data based on
1828: invoice/line/revenue type(group by) using cursor c2
1829: o Based on c2, collect the individual transactions from cn_comm_lines_api
1830: table (using api_cur) and NEGATE them.
1831: o Based on c2, collect the invoice split data from cn_invoice_changes table
1832: and recreate the new records in the cn_comm_lines_api table.
1833: -----------------------------------------------------------------------------*/
1834: PROCEDURE invoice_split_batch(
1835: x_errbuf OUT NOCOPY VARCHAR2,

Line 1860: FROM cn_invoice_changes inv

1856: sum(api.transaction_amount) transaction_amount
1857: FROM cn_comm_lines_api api
1858: WHERE EXISTS (
1859: SELECT 1
1860: FROM cn_invoice_changes inv
1861: WHERE api.invoice_number = inv.invoice_number
1862: AND api.line_number = inv.line_number
1863: AND api.revenue_type = inv.revenue_type)
1864: AND (api.split_status NOT IN ('LINKED','DELINKED') OR

Line 1891: FROM cn_invoice_changes inv,

1887: l_invoice_number VARCHAR2,
1888: l_line_number NUMBER,
1889: l_revenue_type VARCHAR2) IS
1890: SELECT inv.*,rep.employee_number
1891: FROM cn_invoice_changes inv,
1892: cn_salesreps rep
1893: WHERE inv.salesrep_id = rep.salesrep_id
1894: AND inv.invoice_number = l_invoice_number
1895: AND inv.line_number = l_line_number

Line 1909: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;

1905: l_adjust_comments VARCHAR2(300);
1906: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
1907: l_trx_type VARCHAR2(30);
1908: -- PL/SQL tables and records
1909: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;
1910: l_invoice_tbl invoice_tbl;
1911: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1912: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1913: --

Line 1962: cn_invoice_changes_pkg.insert_row(

1958: l_insert_rec.revenue_type := c1_rec.revenue_type;
1959: l_insert_rec.split_pct := c1_rec.split_pct;
1960: l_insert_rec.comm_lines_api_id := c1_rec.comm_lines_api_id;
1961: --
1962: cn_invoice_changes_pkg.insert_row(
1963: p_invoice_changes_all_rec => l_insert_rec);
1964: --
1965: UPDATE cn_comm_lines_api
1966: SET adjust_status = 'INVLOAD'