DBA Data[Home] [Help]

APPS.CN_IMP_TRXAPI_PVT dependencies on CN_COMM_LINES_API

Line 11: -- cn_comm_lines_api_all

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

Line 782: -- insert into cn_comm_lines_api

778: GOTO end_loop;
779:
780: END IF;
781:
782: -- insert into cn_comm_lines_api
783: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;
784:
785: INSERT INTO cn_comm_lines_api
786: (ORG_ID,

Line 783: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;

779:
780: END IF;
781:
782: -- insert into cn_comm_lines_api
783: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;
784:
785: INSERT INTO cn_comm_lines_api
786: (ORG_ID,
787: comm_lines_api_id,

Line 785: INSERT INTO cn_comm_lines_api

781:
782: -- insert into cn_comm_lines_api
783: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;
784:
785: INSERT INTO cn_comm_lines_api
786: (ORG_ID,
787: comm_lines_api_id,
788: salesrep_id,
789: processed_date,