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_GET_TX_DATA_PUB

Line 57: p_adj_rec IN cn_get_tx_data_pub.adj_rec_type,

53: RETURN l_adjusted_by;
54: END;
55: --
56: PROCEDURE convert_adj_to_api(
57: p_adj_rec IN cn_get_tx_data_pub.adj_rec_type,
58: x_api_rec OUT NOCOPY cn_comm_lines_api_pkg.comm_lines_api_rec_type) IS
59: BEGIN
60: x_api_rec.salesrep_id := p_adj_rec.direct_salesrep_id;
61: x_api_rec.processed_date := p_adj_rec.processed_date;

Line 247: p_newtx_rec IN cn_get_tx_data_pub.adj_rec_type,

243:
244: -- Assumptions:
245: -- PL/SQL Table contains atleast on record.
246: PROCEDURE prepare_api_record(
247: p_newtx_rec IN cn_get_tx_data_pub.adj_rec_type,
248: p_old_adj_tbl IN cn_get_tx_data_pub.adj_tbl_type,
249: x_final_trx_rec OUT NOCOPY cn_get_tx_data_pub.adj_rec_type,
250: x_return_status OUT NOCOPY VARCHAR2) IS
251: --

Line 248: p_old_adj_tbl IN cn_get_tx_data_pub.adj_tbl_type,

244: -- Assumptions:
245: -- PL/SQL Table contains atleast on record.
246: PROCEDURE prepare_api_record(
247: p_newtx_rec IN cn_get_tx_data_pub.adj_rec_type,
248: p_old_adj_tbl IN cn_get_tx_data_pub.adj_tbl_type,
249: x_final_trx_rec OUT NOCOPY cn_get_tx_data_pub.adj_rec_type,
250: x_return_status OUT NOCOPY VARCHAR2) IS
251: --
252: l_attribute1 VARCHAR2(240);

Line 249: x_final_trx_rec OUT NOCOPY cn_get_tx_data_pub.adj_rec_type,

245: -- PL/SQL Table contains atleast on record.
246: PROCEDURE prepare_api_record(
247: p_newtx_rec IN cn_get_tx_data_pub.adj_rec_type,
248: p_old_adj_tbl IN cn_get_tx_data_pub.adj_tbl_type,
249: x_final_trx_rec OUT NOCOPY cn_get_tx_data_pub.adj_rec_type,
250: x_return_status OUT NOCOPY VARCHAR2) IS
251: --
252: l_attribute1 VARCHAR2(240);
253: l_attribute100 VARCHAR2(240);

Line 782: Step 9: Call cn_get_tx_data_pub.insert_api_record to create a new record.

778: Step 5: Get the comm_lines_api from Step 4 and negate the record.
779: Step 6: Take the record info from api_cur and construct a adj_rec record type
780: Step 7: Open new split % PL/SQL.
781: Step 8: Complete constructing adj_rec type based on Step 6 and 7.
782: Step 9: Call cn_get_tx_data_pub.insert_api_record to create a new record.
783: -----------------------------------------------------------------------------*/
784: PROCEDURE update_credit_memo(
785: p_api_version IN NUMBER,
786: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,

Line 811: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;

807: l_comm_lines_api_id NUMBER;
808: --
809: l_invoice_change_id NUMBER;
810: --
811: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;
812: --
813: CURSOR api_cur(
814: l_salesrep_id NUMBER,
815: l_invoice_number VARCHAR2,

Line 1063: cn_get_tx_data_pub.insert_api_record(

1059: l_newtx_rec.line_number := rec.line_number;
1060: l_newtx_rec.revenue_type := rec.revenue_type;
1061: l_newtx_rec.split_pct := rec.split_pct;
1062: --
1063: cn_get_tx_data_pub.insert_api_record(
1064: p_api_version => p_api_version,
1065: p_init_msg_list => p_init_msg_list,
1066: p_validation_level => p_validation_level,
1067: p_action => 'UPDATE',

Line 1090: cn_get_tx_data_pub.insert_api_record(

1086: := ROUND((rec.transaction_amount*
1087: p_new_data(i).split_pct)/100,2);
1088: END IF;
1089: -- Create a record in the cn_comm_lines_api table using this record.
1090: cn_get_tx_data_pub.insert_api_record(
1091: p_api_version => p_api_version,
1092: p_init_msg_list => p_init_msg_list,
1093: p_validation_level => p_validation_level,
1094: p_action => 'UPDATE',

Line 1108: /*cn_get_tx_data_pub.update_credit_credentials(

1104: --
1105:
1106: /* Added for Crediting Bug */
1107:
1108: /*cn_get_tx_data_pub.update_credit_credentials(
1109: rec.comm_lines_api_id,
1110: rec.terr_id,
1111: rec.org_id,
1112: rec.adjusted_by

Line 1303: cn_get_tx_data_pub.insert_api_record(

1299: l_newtx_rec.line_number := rec.line_number;
1300: l_newtx_rec.revenue_type := rec.revenue_type;
1301: l_newtx_rec.split_pct := rec.split_pct;
1302: --
1303: cn_get_tx_data_pub.insert_api_record(
1304: p_api_version => p_api_version,
1305: p_init_msg_list => p_init_msg_list,
1306: p_validation_level => p_validation_level,
1307: p_action => 'UPDATE',

Line 1329: cn_get_tx_data_pub.insert_api_record(

1325: IF (p_called_from = 'SPLIT') THEN
1326: l_newtx_rec.transaction_amount := ROUND((rec.transaction_amount*
1327: p_new_data(i).split_pct)/100,2);
1328: END IF;
1329: cn_get_tx_data_pub.insert_api_record(
1330: p_api_version => p_api_version,
1331: p_init_msg_list => p_init_msg_list,
1332: p_validation_level => p_validation_level,
1333: p_action => 'UPDATE',

Line 1346: /*cn_get_tx_data_pub.update_credit_credentials(

1342: END IF;
1343:
1344: /* Added for Crediting Bug */
1345:
1346: /*cn_get_tx_data_pub.update_credit_credentials(
1347: rec.comm_lines_api_id,
1348: rec.terr_id,
1349: rec.org_id,
1350: rec.adjusted_by

Line 1398: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,

1394: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
1395: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
1396: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
1397: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
1398: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
1399: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1400: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
1401: x_return_status OUT NOCOPY VARCHAR2,
1402: x_msg_count OUT NOCOPY NUMBER,

Line 1707: p_split_data_tbl IN cn_get_tx_data_pub.split_data_tbl,

1703: p_trx_type IN VARCHAR2,
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,

Line 1912: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;

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: --
1914: BEGIN
1915: --
1916: cn_message_pkg.begin_batch(

Line 2020: cn_get_tx_data_pub.get_api_data(

2016: LOOP
2017: --
2018: l_counter := l_counter + 1;
2019: --
2020: cn_get_tx_data_pub.get_api_data(
2021: p_comm_lines_api_id => inv_rec.comm_lines_api_id,
2022: x_adj_tbl => l_adj_tbl);
2023: --
2024: IF (l_adj_tbl.COUNT > 0) THEN