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 := l_presrv_credit_override_flag;
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 993: cn_comm_lines_api_pkg.insert_row(l_api_rec);

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

Line 1094: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

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

Line 1171: cn_comm_lines_api_pkg.insert_row(l_api_rec);

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

Line 1213: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

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

Line 1322: cn_comm_lines_api_pkg.insert_row(l_api_rec);

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