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_ADJUSTMENTS_PKG dependencies on CN_GET_TX_DATA_PUB

Line 407: x_adj_data cn_get_tx_data_pub.adj_tbl_type,

403: END api_negate_record;
404:
405: --
406: PROCEDURE mass_update_values(
407: x_adj_data cn_get_tx_data_pub.adj_tbl_type,
408: x_adj_rec cn_get_tx_data_pub.adj_rec_type,
409: x_mass_adj_type VARCHAR2,
410: x_proc_comp OUT NOCOPY VARCHAR2) IS
411:

Line 408: x_adj_rec cn_get_tx_data_pub.adj_rec_type,

404:
405: --
406: PROCEDURE mass_update_values(
407: x_adj_data cn_get_tx_data_pub.adj_tbl_type,
408: x_adj_rec cn_get_tx_data_pub.adj_rec_type,
409: x_mass_adj_type VARCHAR2,
410: x_proc_comp OUT NOCOPY VARCHAR2) IS
411:
412: l_api_name CONSTANT VARCHAR2(30) := 'mass_update_values';

Line 1025: /*CN_GET_TX_DATA_PUB.update_credit_credentials(

1021: x_adj_rec.adjust_comments,
1022: x_adj_data(i).direct_salesrep_number);
1023:
1024: --Added for Crediting
1025: /*CN_GET_TX_DATA_PUB.update_credit_credentials(
1026: x_adj_data(i).comm_lines_api_id,
1027: x_adj_data(i).terr_id,
1028: x_adj_data(i).org_id,
1029: x_adj_rec.adjusted_by

Line 1092: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;

1088: l_acctd_transaction_amount NUMBER;
1089: l_salesrep_number VARCHAR2(30);
1090: l_revenue_type VARCHAR2(15);
1091: l_revenue VARCHAR2(12) := 'REVENUE';
1092: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1093: -- PL/SQL tables/records
1094: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1095: o_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1096: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

Line 1094: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;

1090: l_revenue_type VARCHAR2(15);
1091: l_revenue VARCHAR2(12) := 'REVENUE';
1092: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1093: -- PL/SQL tables/records
1094: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1095: o_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1096: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1097: -- To mask this non-standard API
1098: x_return_status VARCHAR2(1000);

Line 1095: o_newtx_rec cn_get_tx_data_pub.adj_rec_type;

1091: l_revenue VARCHAR2(12) := 'REVENUE';
1092: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1093: -- PL/SQL tables/records
1094: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1095: o_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1096: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1097: -- To mask this non-standard API
1098: x_return_status VARCHAR2(1000);
1099: BEGIN

Line 1133: cn_get_tx_data_pub.get_api_data(l_comm_lines_api_id,l_adj_tbl);

1129: IF (dbms_sql.fetch_rows(deal_select_cursor) > 0) THEN
1130: DBMS_SQL.column_value (deal_select_cursor,1,l_comm_lines_api_id);
1131: --
1132: --cn_adjustments_pkg.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1133: cn_get_tx_data_pub.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1134: --
1135: IF (l_adj_tbl.COUNT > 0) THEN
1136: l_transaction_amount := ((NVL(l_adj_tbl(1).transaction_amount,0) *
1137: x_split_percent)/100);

Line 1212: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;

1208: l_salesrep_number VARCHAR2(30);
1209: l_revenue VARCHAR2(12) := 'REVENUE';
1210: l_load_status VARCHAR2(30);
1211: -- PL/SQL tables/records
1212: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1213: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1214: o_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1215: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1216: -- To mask this non-standard API

Line 1213: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;

1209: l_revenue VARCHAR2(12) := 'REVENUE';
1210: l_load_status VARCHAR2(30);
1211: -- PL/SQL tables/records
1212: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1213: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1214: o_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1215: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1216: -- To mask this non-standard API
1217: x_return_status VARCHAR2(1000);

Line 1214: o_newtx_rec cn_get_tx_data_pub.adj_rec_type;

1210: l_load_status VARCHAR2(30);
1211: -- PL/SQL tables/records
1212: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1213: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1214: o_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1215: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1216: -- To mask this non-standard API
1217: x_return_status VARCHAR2(1000);
1218: --

Line 1276: cn_get_tx_data_pub.get_api_data(l_comm_lines_api_id,l_adj_tbl);

1272: END LOOP;
1273: END IF;
1274: --
1275: --cn_adjustments_pkg.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1276: cn_get_tx_data_pub.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1277: --
1278: IF (l_adj_tbl.COUNT > 0) THEN
1279: /* codeCheck: I need to revisit this code */
1280: l_transaction_amount := NVL(l_adj_tbl(1).transaction_amount,0);