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_COMM_LINES_API

Line 57: FROM cn_comm_lines_api_all l,

53: x_adj_tbl OUT NOCOPY adj_tbl_type) IS
54: --
55: CURSOR api_cur IS
56: SELECT l.*, s.name
57: FROM cn_comm_lines_api_all l,
58: cn_salesreps s
59: WHERE comm_lines_api_id = p_comm_lines_api_id
60: AND l.salesrep_id = s.salesrep_id;
61: --

Line 482: get the data from cn_comm_lines_api and cn_commission_headers tables. */

478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479: x_loading_status := 'CN_INSERTED';
480: -- API body
481: /* This API take the parameters and construct the SQL. Based on the SQL
482: get the data from cn_comm_lines_api and cn_commission_headers tables. */
483: cn_mass_adjust_util.search_result(
484: p_salesrep_id => p_salesrep_id,
485: p_pr_date_to => p_pr_date_to,
486: p_pr_date_from => p_pr_date_from,

Line 738: FROM cn_comm_lines_api l,

734: CURSOR api_cur IS
735: SELECT l.*,s.employee_number srp_employee_number,s.name,
736: clad.meaning adjust_status_disp,
737: clt.meaning trx_type_disp
738: FROM cn_comm_lines_api l,
739: cn_salesreps s,
740: cn_lookups clad,
741: cn_lookups clt
742: WHERE l.trx_type = clt.lookup_code(+)

Line 1287: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

1283: l_created_by NUMBER := fnd_global.user_id;
1284: l_last_update_login NUMBER := fnd_global.login_id;
1285: -- PL/SQL tables/records
1286: l_newtx_rec adj_rec_type;
1287: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1288:
1289: ------+
1290: -- Bug#2969534 Start
1291: ------+

Line 1363: SELECT cn_comm_lines_api_s.NEXTVAL

1359: WHEN OTHERS THEN
1360: NULL; -- I need to check once again to avoid NULL.
1361: END;
1362: --
1363: SELECT cn_comm_lines_api_s.NEXTVAL
1364: INTO l_comm_lines_api_id
1365: FROM SYS.DUAL;
1366: --
1367: l_newtx_rec := p_newtx_rec;

Line 1462: cn_comm_lines_api_pkg.insert_row(l_api_rec);

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);
1463: --
1464: x_api_id := l_comm_lines_api_id;
1465: --
1466:

Line 1579: get the data from cn_comm_lines_api and cn_commission_headers tables. */

1575: --CN_mydebug.ADD('Adjusted table length before search : '||l_adj_tbl.count);
1576:
1577:
1578: /* This API take the parameters and construct the SQL. Based on the SQL
1579: get the data from cn_comm_lines_api and cn_commission_headers tables. */
1580: cn_mass_adjust_util.search_result(
1581: p_salesrep_id => p_salesrep_id,
1582: p_pr_date_to => p_pr_date_to,
1583: p_pr_date_from => p_pr_date_from,

Line 1681: l_invoice_number cn_comm_lines_api.invoice_number%TYPE;

1677: x_loading_status OUT NOCOPY VARCHAR2) IS
1678: --
1679: l_api_name CONSTANT VARCHAR2(30) := 'call_deal_assign';
1680: l_api_version CONSTANT NUMBER := 1.0;
1681: l_invoice_number cn_comm_lines_api.invoice_number%TYPE;
1682: l_order_number cn_comm_lines_api.order_number%TYPE;
1683: l_adjusted_by cn_comm_lines_api.adjusted_by%TYPE;
1684: l_adjust_comments cn_comm_lines_api.adjust_comments%TYPE;
1685: --

Line 1682: l_order_number cn_comm_lines_api.order_number%TYPE;

1678: --
1679: l_api_name CONSTANT VARCHAR2(30) := 'call_deal_assign';
1680: l_api_version CONSTANT NUMBER := 1.0;
1681: l_invoice_number cn_comm_lines_api.invoice_number%TYPE;
1682: l_order_number cn_comm_lines_api.order_number%TYPE;
1683: l_adjusted_by cn_comm_lines_api.adjusted_by%TYPE;
1684: l_adjust_comments cn_comm_lines_api.adjust_comments%TYPE;
1685: --
1686:

Line 1683: l_adjusted_by cn_comm_lines_api.adjusted_by%TYPE;

1679: l_api_name CONSTANT VARCHAR2(30) := 'call_deal_assign';
1680: l_api_version CONSTANT NUMBER := 1.0;
1681: l_invoice_number cn_comm_lines_api.invoice_number%TYPE;
1682: l_order_number cn_comm_lines_api.order_number%TYPE;
1683: l_adjusted_by cn_comm_lines_api.adjusted_by%TYPE;
1684: l_adjust_comments cn_comm_lines_api.adjust_comments%TYPE;
1685: --
1686:
1687: BEGIN

Line 1684: l_adjust_comments cn_comm_lines_api.adjust_comments%TYPE;

1680: l_api_version CONSTANT NUMBER := 1.0;
1681: l_invoice_number cn_comm_lines_api.invoice_number%TYPE;
1682: l_order_number cn_comm_lines_api.order_number%TYPE;
1683: l_adjusted_by cn_comm_lines_api.adjusted_by%TYPE;
1684: l_adjust_comments cn_comm_lines_api.adjust_comments%TYPE;
1685: --
1686:
1687: BEGIN
1688: -- Standard Start of API savepoint

Line 1800: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

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
1804: SELECT comm_lines_api_id

Line 1805: FROM cn_comm_lines_api_all api

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
1807: AND api.org_id = l_org_id
1808: AND api.trx_type = 'ORD'
1809: AND api.load_status NOT IN ('LOADED', 'FILTERED') -- vensrini Bug fix 4202682

Line 1962: FROM CN_COMM_LINES_API

1958: l_terr_id := NULL;
1959: l_terr_name := NULL;
1960: BEGIN
1961: SELECT TERR_ID, TERR_NAME INTO l_terr_id, l_terr_name
1962: FROM CN_COMM_LINES_API
1963: WHERE
1964: COMM_LINES_API_ID = p_comm_lines_api_id
1965: AND ORG_ID = p_org_id;
1966: EXCEPTION

Line 2133: FROM cn_comm_lines_api_all

2129: l_deal_type := 'REVENUE';
2130: ELSE
2131: SELECT count(order_number)
2132: INTO l_deal_count
2133: FROM cn_comm_lines_api_all
2134: WHERE order_number = l_order_number
2135: AND revenue_type = 'REVENUE'
2136: AND org_id = l_org_id;
2137: IF (l_deal_count > 0) THEN

Line 2165: FROM cn_comm_lines_api_all

2161: l_deal_type := 'REVENUE';
2162: ELSE
2163: SELECT count(invoice_number)
2164: INTO l_deal_count
2165: FROM cn_comm_lines_api_all
2166: WHERE invoice_number = p_invoice_number
2167: AND revenue_type = 'REVENUE'
2168: AND org_id = l_org_id;
2169: IF (l_deal_count > 0) THEN

Line 2238: FROM CN_COMM_LINES_API

2234: l_terr_name := NULL;
2235: /* Added for Crediting Bug */
2236: BEGIN
2237: SELECT TERR_ID, TERR_NAME INTO l_terr_id, l_terr_name
2238: FROM CN_COMM_LINES_API
2239: WHERE
2240: COMM_LINES_API_ID = order_rec.comm_lines_api_id
2241: AND ORG_ID = p_org_id;
2242:

Line 2390: FROM CN_COMM_LINES_API

2386: l_terr_id := NULL;
2387: l_terr_name := NULL;
2388: BEGIN
2389: SELECT TERR_ID, TERR_NAME INTO l_terr_id, l_terr_name
2390: FROM CN_COMM_LINES_API
2391: WHERE
2392: COMM_LINES_API_ID = l_deal_data_tbl(j).comm_lines_api_id
2393: AND ORG_ID = p_org_id;
2394:

Line 2560: FROM CN_COMM_LINES_API

2556: l_terr_id := NULL;
2557: l_terr_name := NULL;
2558: BEGIN
2559: SELECT TERR_ID, TERR_NAME INTO l_terr_id, l_terr_name
2560: FROM CN_COMM_LINES_API
2561: WHERE
2562: COMM_LINES_API_ID = l_deal_data_tbl(j).comm_lines_api_id
2563: AND ORG_ID = p_org_id;
2564:

Line 2822: FROM cn_comm_lines_api ccla,

2818: s.salesrep_number employee_number,
2819: ccla.processed_date,clt.meaning,ccla.order_number,ccla.booked_date,
2820: ccla.invoice_number,ccla.invoice_date,ccla.quantity,
2821: ccla.acctd_transaction_amount,ccla.transaction_amount
2822: FROM cn_comm_lines_api ccla,
2823: jtf_rs_resource_extns_vl re,
2824: jtf_rs_salesreps s,
2825: cn_lookups clt,
2826: cn_period_statuses cpsp