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 739: FROM cn_comm_lines_api l,

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

Line 1288: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

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

Line 1364: SELECT cn_comm_lines_api_s.NEXTVAL

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

Line 1463: cn_comm_lines_api_pkg.insert_row(l_api_rec);

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

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

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

Line 1682: l_invoice_number cn_comm_lines_api.invoice_number%TYPE;

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

Line 1683: l_order_number cn_comm_lines_api.order_number%TYPE;

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

Line 1684: l_adjusted_by cn_comm_lines_api.adjusted_by%TYPE;

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

Line 1685: l_adjust_comments cn_comm_lines_api.adjust_comments%TYPE;

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

Line 1801: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

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

Line 1806: FROM cn_comm_lines_api_all api

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

Line 1963: FROM CN_COMM_LINES_API

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

Line 2134: FROM cn_comm_lines_api_all

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

Line 2166: FROM cn_comm_lines_api_all

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

Line 2239: FROM CN_COMM_LINES_API

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

Line 2391: FROM CN_COMM_LINES_API

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

Line 2561: FROM CN_COMM_LINES_API

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

Line 2823: FROM cn_comm_lines_api ccla,

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

Line 3054: FROM cn_comm_lines_api a, cn_commission_headers h

3050:
3051: ---- Bug 8882352 ----
3052: SELECT count(a.comm_lines_api_id)
3053: INTO l_comm_line_count
3054: FROM cn_comm_lines_api a, cn_commission_headers h
3055: WHERE a.comm_lines_api_id = p_newtx_rec.comm_lines_api_id
3056: AND a.comm_lines_api_id = h.comm_lines_api_id (+)
3057: AND (a.load_status IN ('FILTERED') OR
3058: a.adjust_status IN ('FROZEN','REVERSAL', 'SCA_PENDING') OR h.adjust_status IN ('FROZEN', 'REVERSAL') OR