APPS.CN_ADJUSTMENTS_PKG dependencies on CN_COMM_LINES_API_PKG

Line 100: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

96: l_load_status cn_comm_lines_api.load_status%TYPE;
97: l_trx_type cn_commission_headers.trx_type%TYPE;
98: l_transaction_amount_orig cn_commission_headers.transaction_amount_orig%TYPE;
99: -- PL/SQL tables/columns
100: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
101: -- Added for bug 7524578
102: l_territory_id NUMBER;
103: l_terr_name VARCHAR2(2000);
104: l_presrv_credit_override_flag VARCHAR2(1);

Line 376: cn_comm_lines_api_pkg.insert_row(l_api_rec);

372: l_api_rec.terr_id := l_territory_id;
373: l_api_rec.terr_name := l_terr_name;
374: l_api_rec.preserve_credit_override_flag := NVL(l_presrv_credit_override_flag,'N');
375: --
376: cn_comm_lines_api_pkg.insert_row(l_api_rec);
377: --
378: END LOOP;
379: EXCEPTION
380: WHEN OTHERS THEN

Line 425: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

421: l_adjust_date DATE := SYSDATE;
422: l_comm_lines_api_id NUMBER;
423: l_counter NUMBER := 0;
424: -- PL/SQL tables/columns
425: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
426: l_existing_data cn_invoice_changes_pvt.invoice_tbl;
427: l_new_data cn_invoice_changes_pvt.invoice_tbl;
428: --
429: BEGIN

Line 994: cn_comm_lines_api_pkg.insert_row(l_api_rec);

990: l_api_rec.preserve_credit_override_flag := 'Y';
991: END IF;
992:
993: l_api_rec.adj_comm_lines_api_id := x_adj_data(i).comm_lines_api_id;
994: cn_comm_lines_api_pkg.insert_row(l_api_rec);
995:
996: --
997: IF ((g_track_invoice = 'Y') AND (l_api_rec.trx_type = 'INV')) THEN
998: l_counter := l_counter + 1;

Line 1096: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

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
1100: deal_select_cursor := DBMS_SQL.open_cursor;

Line 1173: cn_comm_lines_api_pkg.insert_row(l_api_rec);

1169: cn_invoice_changes_pvt.convert_adj_to_api(
1170: p_adj_rec => o_newtx_rec,
1171: x_api_rec => l_api_rec);
1172: --
1173: cn_comm_lines_api_pkg.insert_row(l_api_rec);
1174: --
1175: END IF;
1176: ELSE
1177: EXIT;

Line 1215: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

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: --
1219: BEGIN

Line 1324: cn_comm_lines_api_pkg.insert_row(l_api_rec);

1320: cn_invoice_changes_pvt.convert_adj_to_api(
1321: p_adj_rec => o_newtx_rec,
1322: x_api_rec => l_api_rec);
1323: --
1324: cn_comm_lines_api_pkg.insert_row(l_api_rec);
1325: --
1326: END IF;
1327: ELSE
1328: exit;