7: -- Start of comments
8: -- API name : Trxapi_Import
9: -- Type : Private.
10: -- Function : programtransfer data from staging table into
11: -- cn_comm_lines_api_all
12: -- Pre-reqs : None.
13: -- Parameters :
14: -- IN p_imp_header_id IN NUMBER,
15: -- OUT : errbuf OUT VARCHAR2 Required
836:
837:
838: -- End of addition
839:
840: -- insert into cn_comm_lines_api
841: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;
842:
843: INSERT INTO cn_comm_lines_api
844: (ORG_ID,
837:
838: -- End of addition
839:
840: -- insert into cn_comm_lines_api
841: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;
842:
843: INSERT INTO cn_comm_lines_api
844: (ORG_ID,
845: comm_lines_api_id,
839:
840: -- insert into cn_comm_lines_api
841: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;
842:
843: INSERT INTO cn_comm_lines_api
844: (ORG_ID,
845: comm_lines_api_id,
846: salesrep_id,
847: processed_date,