DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on CN_INVOICE_CHANGES_PVT

Line 1459: cn_invoice_changes_pvt.convert_adj_to_api(

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

Line 1529: l_existing_data cn_invoice_changes_pvt.invoice_tbl;

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

Line 1530: l_new_data cn_invoice_changes_pvt.invoice_tbl;

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

Line 1556: cn_invoice_changes_pvt.update_mass_invoices(

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

Line 1620: cn_invoice_changes_pvt.update_credit_memo(

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

Line 1799: l_existing_data cn_invoice_changes_pvt.invoice_tbl;

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

Line 1800: l_new_data cn_invoice_changes_pvt.invoice_tbl;

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

Line 1803: l_deal_data_tbl cn_invoice_changes_pvt.deal_data_tbl;

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

Line 1918: cn_invoice_changes_pvt.update_invoice_changes(

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

Line 2012: cn_invoice_changes_pvt.prepare_api_record(

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

Line 2063: cn_invoice_changes_pvt.update_invoice_changes(

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

Line 2087: cn_invoice_changes_pvt.update_credit_memo(

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

Line 2309: cn_invoice_changes_pvt.prepare_api_record(

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

Line 2347: cn_invoice_changes_pvt.capture_deal_invoice(

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

Line 2439: cn_invoice_changes_pvt.prepare_api_record(

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

Line 2496: cn_invoice_changes_pvt.update_invoice_changes(

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

Line 2528: cn_invoice_changes_pvt.capture_deal_invoice

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

Line 2625: cn_invoice_changes_pvt.prepare_api_record(

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

Line 3023: l_existing_data cn_invoice_changes_pvt.invoice_tbl;

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

Line 3024: l_new_data cn_invoice_changes_pvt.invoice_tbl;

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

Line 3100: cn_invoice_changes_pvt.update_invoice_changes(

3096: l_new_data(1).revenue_type := NULL;
3097: l_new_data(1).split_pct := NULL;
3098: l_new_data(1).comm_lines_api_id := NULL;
3099: --
3100: cn_invoice_changes_pvt.update_invoice_changes(
3101: p_api_version => l_api_version,
3102: p_init_msg_list => p_init_msg_list,
3103: p_validation_level => p_validation_level,
3104: p_existing_data => l_existing_data,

Line 3153: cn_invoice_changes_pvt.prepare_api_record(

3149: (g_track_invoice = 'Y')) THEN
3150: l_newtx_rec.split_status := 'DELINKED';
3151: END IF;
3152: --
3153: cn_invoice_changes_pvt.prepare_api_record(
3154: p_newtx_rec => l_newtx_rec,
3155: p_old_adj_tbl => l_old_adj_tbl,
3156: x_final_trx_rec => o_newtx_rec,
3157: x_return_status => x_return_status);

Line 3188: cn_invoice_changes_pvt.update_invoice_changes(

3184: l_new_data(1).direct_salesrep_number
3185: := o_newtx_rec.direct_salesrep_number;
3186: l_new_data(1).comm_lines_api_id := x_api_id;
3187: --
3188: cn_invoice_changes_pvt.update_invoice_changes(
3189: p_api_version => p_api_version,
3190: p_validation_level => p_validation_level,
3191: p_existing_data => l_existing_data,
3192: p_new_data => l_new_data,

Line 3214: cn_invoice_changes_pvt.update_credit_memo(

3210: --
3211: IF ((g_track_invoice = 'Y') AND
3212: (l_old_adj_tbl.COUNT > 0) AND
3213: (l_old_adj_tbl(1).trx_type = 'INV')) THEN
3214: cn_invoice_changes_pvt.update_credit_memo(
3215: p_api_version => p_api_version,
3216: p_init_msg_list => p_init_msg_list,
3217: p_validation_level => p_validation_level,
3218: p_existing_data => l_existing_data,