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_GET_TX_DATA_PUB dependencies on CN_INVOICE_CHANGES_PVT

Line 1458: cn_invoice_changes_pvt.convert_adj_to_api(

1454: /* most of the code for this module is based on cn_adjustment_v view
1455: and adj_rec_type is a record corresponding to this view. So
1456: we have to convert this record type to table handler record type
1457: before we call the table handler. */
1458: cn_invoice_changes_pvt.convert_adj_to_api(
1459: p_adj_rec => l_newtx_rec,
1460: x_api_rec => l_api_rec);
1461: --
1462: cn_comm_lines_api_pkg.insert_row(l_api_rec);

Line 1528: l_existing_data cn_invoice_changes_pvt.invoice_tbl;

1524: l_api_query_flag CHAR(1) := 'Y';
1525: l_source_counter NUMBER := 0;
1526: l_return_status VARCHAR2(30);
1527: -- PL/SQL Tables and Records
1528: l_existing_data cn_invoice_changes_pvt.invoice_tbl;
1529: l_new_data cn_invoice_changes_pvt.invoice_tbl;
1530: l_adj_rec adj_rec_type;
1531: --
1532: BEGIN

Line 1529: l_new_data cn_invoice_changes_pvt.invoice_tbl;

1525: l_source_counter NUMBER := 0;
1526: l_return_status VARCHAR2(30);
1527: -- PL/SQL Tables and Records
1528: l_existing_data cn_invoice_changes_pvt.invoice_tbl;
1529: l_new_data cn_invoice_changes_pvt.invoice_tbl;
1530: l_adj_rec adj_rec_type;
1531: --
1532: BEGIN
1533: --cn_mydebug.delete;

Line 1555: cn_invoice_changes_pvt.update_mass_invoices(

1551: IF (g_track_invoice = 'Y') THEN
1552: /* First identify the unique invoices based on the search criteria
1553: and delete the records from cn_invoice_changes table based on
1554: these invoices */
1555: cn_invoice_changes_pvt.update_mass_invoices(
1556: p_api_version => l_api_version,
1557: p_salesrep_id => p_salesrep_id,
1558: p_pr_date_to => p_pr_date_to,
1559: p_pr_date_from => p_pr_date_from,

Line 1619: cn_invoice_changes_pvt.update_credit_memo(

1615: --
1616: IF (g_track_invoice = 'Y') THEN
1617: IF (l_existing_data.COUNT > 0) THEN
1618: -- Update the corresponding credit memos.
1619: cn_invoice_changes_pvt.update_credit_memo(
1620: p_api_version => l_api_version,
1621: p_existing_data => l_existing_data,
1622: p_new_data => l_new_data,
1623: p_to_salesrep_id => p_adj_rec.direct_salesrep_id,

Line 1798: l_existing_data cn_invoice_changes_pvt.invoice_tbl;

1794:
1795: -- PL/SQL tables/records
1796: l_newtx_rec adj_rec_type;
1797: l_adj_tbl adj_tbl_type;
1798: l_existing_data cn_invoice_changes_pvt.invoice_tbl;
1799: l_new_data cn_invoice_changes_pvt.invoice_tbl;
1800: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1801: o_newtx_rec adj_rec_type;
1802: l_deal_data_tbl cn_invoice_changes_pvt.deal_data_tbl;

Line 1799: l_new_data cn_invoice_changes_pvt.invoice_tbl;

1795: -- PL/SQL tables/records
1796: l_newtx_rec adj_rec_type;
1797: l_adj_tbl adj_tbl_type;
1798: l_existing_data cn_invoice_changes_pvt.invoice_tbl;
1799: l_new_data cn_invoice_changes_pvt.invoice_tbl;
1800: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1801: o_newtx_rec adj_rec_type;
1802: l_deal_data_tbl cn_invoice_changes_pvt.deal_data_tbl;
1803: CURSOR order_cur IS

Line 1802: l_deal_data_tbl cn_invoice_changes_pvt.deal_data_tbl;

1798: l_existing_data cn_invoice_changes_pvt.invoice_tbl;
1799: l_new_data cn_invoice_changes_pvt.invoice_tbl;
1800: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1801: o_newtx_rec adj_rec_type;
1802: l_deal_data_tbl cn_invoice_changes_pvt.deal_data_tbl;
1803: CURSOR order_cur IS
1804: SELECT comm_lines_api_id
1805: FROM cn_comm_lines_api_all api
1806: WHERE api.order_number = l_order_number

Line 1917: cn_invoice_changes_pvt.update_invoice_changes(

1913: l_new_data(1).revenue_type := NULL;
1914: l_new_data(1).split_pct := NULL;
1915: l_new_data(1).comm_lines_api_id := NULL;
1916: --
1917: cn_invoice_changes_pvt.update_invoice_changes(
1918: p_api_version => l_api_version,
1919: p_init_msg_list => p_init_msg_list,
1920: p_validation_level => p_validation_level,
1921: p_existing_data => l_existing_data,

Line 2011: cn_invoice_changes_pvt.prepare_api_record(

2007: l_newtx_rec.terr_id := -999;
2008: END IF;
2009:
2010: --
2011: cn_invoice_changes_pvt.prepare_api_record(
2012: p_newtx_rec => l_newtx_rec,
2013: p_old_adj_tbl => l_adj_tbl,
2014: x_final_trx_rec => o_newtx_rec,
2015: x_return_status => x_return_status);

Line 2062: cn_invoice_changes_pvt.update_invoice_changes(

2058: IF ((l_adj_tbl(1).trx_type = 'INV') AND
2059: (g_track_invoice = 'Y') AND
2060: (l_new_data.COUNT > 0)) THEN -- 6
2061: --
2062: cn_invoice_changes_pvt.update_invoice_changes(
2063: p_api_version => p_api_version,
2064: p_existing_data => l_existing_data,
2065: p_new_data => l_new_data,
2066: p_exist_data_check => 'N',

Line 2086: cn_invoice_changes_pvt.update_credit_memo(

2082: END IF; -- 6 end
2083: --
2084: IF (g_track_invoice = 'Y') THEN -- 7
2085: IF (l_adj_tbl(1).trx_type = 'INV') THEN
2086: cn_invoice_changes_pvt.update_credit_memo(
2087: p_api_version => p_api_version,
2088: p_existing_data => l_existing_data,
2089: p_new_data => l_new_data,
2090: p_called_from => 'SPLIT',

Line 2308: cn_invoice_changes_pvt.prepare_api_record(

2304: l_newtx_rec.terr_id := -999;
2305: END IF;
2306:
2307: --
2308: cn_invoice_changes_pvt.prepare_api_record(
2309: p_newtx_rec => l_newtx_rec,
2310: p_old_adj_tbl => l_adj_tbl,
2311: x_final_trx_rec => o_newtx_rec,
2312: x_return_status => x_return_status);

Line 2346: cn_invoice_changes_pvt.capture_deal_invoice(

2342:
2343: END IF; -- 9 end
2344:
2345: IF (p_invoice_number <> FND_API.G_MISS_CHAR) THEN -- 10
2346: cn_invoice_changes_pvt.capture_deal_invoice(
2347: p_api_version => p_api_version,
2348: p_trx_type => 'INV',
2349: p_split_nonrevenue_line => l_split_nonrevenue_line,
2350: p_invoice_number => p_invoice_number,

Line 2438: cn_invoice_changes_pvt.prepare_api_record(

2434: l_newtx_rec.terr_id := -999;
2435: END IF;
2436:
2437:
2438: cn_invoice_changes_pvt.prepare_api_record(
2439: p_newtx_rec => l_newtx_rec,
2440: p_old_adj_tbl => l_adj_tbl,
2441: x_final_trx_rec => o_newtx_rec,
2442: x_return_status => x_return_status);

Line 2495: cn_invoice_changes_pvt.update_invoice_changes(

2491: l_existing_data(1).revenue_type := NULL;
2492: l_existing_data(1).split_pct := NULL;
2493: l_existing_data(1).comm_lines_api_id:= NULL;
2494: --
2495: cn_invoice_changes_pvt.update_invoice_changes(
2496: p_api_version => p_api_version,
2497: p_existing_data => l_existing_data,
2498: p_new_data => l_new_data,
2499: p_exist_data_check => 'N',

Line 2527: cn_invoice_changes_pvt.capture_deal_invoice

2523: END IF;
2524: --
2525: l_deal_data_tbl.DELETE;
2526: --
2527: cn_invoice_changes_pvt.capture_deal_invoice
2528: (
2529: p_api_version => p_api_version,
2530: p_trx_type => l_trx_type,
2531: p_split_nonrevenue_line => l_split_nonrevenue_line,

Line 2624: cn_invoice_changes_pvt.prepare_api_record(

2620: END IF;
2621:
2622:
2623: --
2624: cn_invoice_changes_pvt.prepare_api_record(
2625: p_newtx_rec => l_newtx_rec,
2626: p_old_adj_tbl => l_adj_tbl,
2627: x_final_trx_rec => o_newtx_rec,
2628: x_return_status => x_return_status);

Line 3022: l_existing_data cn_invoice_changes_pvt.invoice_tbl;

3018: l_api_version CONSTANT NUMBER := 1.0;
3019: l_comm_lines_api_id NUMBER;
3020: -- PL/SQL tables/records
3021: l_old_adj_tbl adj_tbl_type;
3022: l_existing_data cn_invoice_changes_pvt.invoice_tbl;
3023: l_new_data cn_invoice_changes_pvt.invoice_tbl;
3024: l_newtx_rec adj_rec_type;
3025: o_newtx_rec adj_rec_type;
3026: --

Line 3023: l_new_data cn_invoice_changes_pvt.invoice_tbl;

3019: l_comm_lines_api_id NUMBER;
3020: -- PL/SQL tables/records
3021: l_old_adj_tbl adj_tbl_type;
3022: l_existing_data cn_invoice_changes_pvt.invoice_tbl;
3023: l_new_data cn_invoice_changes_pvt.invoice_tbl;
3024: l_newtx_rec adj_rec_type;
3025: o_newtx_rec adj_rec_type;
3026: --
3027:

Line 3074: cn_invoice_changes_pvt.update_invoice_changes(

3070: l_new_data(1).revenue_type := NULL;
3071: l_new_data(1).split_pct := NULL;
3072: l_new_data(1).comm_lines_api_id := NULL;
3073: --
3074: cn_invoice_changes_pvt.update_invoice_changes(
3075: p_api_version => l_api_version,
3076: p_init_msg_list => p_init_msg_list,
3077: p_validation_level => p_validation_level,
3078: p_existing_data => l_existing_data,

Line 3127: cn_invoice_changes_pvt.prepare_api_record(

3123: (g_track_invoice = 'Y')) THEN
3124: l_newtx_rec.split_status := 'DELINKED';
3125: END IF;
3126: --
3127: cn_invoice_changes_pvt.prepare_api_record(
3128: p_newtx_rec => l_newtx_rec,
3129: p_old_adj_tbl => l_old_adj_tbl,
3130: x_final_trx_rec => o_newtx_rec,
3131: x_return_status => x_return_status);

Line 3162: cn_invoice_changes_pvt.update_invoice_changes(

3158: l_new_data(1).direct_salesrep_number
3159: := o_newtx_rec.direct_salesrep_number;
3160: l_new_data(1).comm_lines_api_id := x_api_id;
3161: --
3162: cn_invoice_changes_pvt.update_invoice_changes(
3163: p_api_version => p_api_version,
3164: p_validation_level => p_validation_level,
3165: p_existing_data => l_existing_data,
3166: p_new_data => l_new_data,

Line 3188: cn_invoice_changes_pvt.update_credit_memo(

3184: --
3185: IF ((g_track_invoice = 'Y') AND
3186: (l_old_adj_tbl.COUNT > 0) AND
3187: (l_old_adj_tbl(1).trx_type = 'INV')) THEN
3188: cn_invoice_changes_pvt.update_credit_memo(
3189: p_api_version => p_api_version,
3190: p_init_msg_list => p_init_msg_list,
3191: p_validation_level => p_validation_level,
3192: p_existing_data => l_existing_data,