[Home] [Help]
122: l_skip_credit_flag := NVL(Fnd_Profile.VALUE('CN_SKIP_CREDIT_ALLOCATION'), 'Y');
123: END IF;
124:
125: -- this is used to make it more restrict for handling reversal trx later on
126: SELECT cn_commission_headers_s.NEXTVAL
127: INTO l_init_commission_header_id FROM dual;
128:
129: FOR batch IN batches LOOP
130:
141:
142: Counter := Counter + batch.trx_count;
143:
144: IF (l_skip_credit_flag = 'Y') THEN
145: INSERT INTO cn_commission_headers_all
146: (commission_header_id,
147: direct_salesrep_id,
148: processed_date,
149: processed_period_id,
307: split_pct,
308: split_status,
309: org_id)
310: (SELECT
311: cn_commission_headers_s.nextval,
312: batch.salesrep_id,
313: Trunc(api.processed_date),
314: batch.period_id,
315: Trunc(api.rollup_date),
485: api.processed_date >= Trunc(batch.start_date) AND
486: api.processed_date < (Trunc(batch.end_date) + 1) AND
487: api.org_id = p_org_id);
488: ELSE
489: INSERT INTO cn_commission_headers_all
490: (commission_header_id,
491: direct_salesrep_id,
492: processed_date,
493: processed_period_id,
651: split_pct,
652: split_status,
653: org_id)
654: (SELECT
655: cn_commission_headers_s.nextval,
656: batch.salesrep_id,
657: Trunc(api.processed_date),
658: batch.period_id,
659: Trunc(api.rollup_date),
870: -- Handle reversal transaction add on 10/15/99
871: DECLARE
872: CURSOR l_headers IS
873: SELECT cch.commission_header_id, cch.reversal_flag, cch.reversal_header_id
874: FROM cn_commission_headers cch,
875: (SELECT DISTINCT salesrep_id
876: FROM cn_process_batches
877: WHERE physical_batch_id = p_physical_batch_id
878: AND status_code = 'IN_USE') pb
1014: -- API name : Load
1015: -- Type : Public.
1016: -- Pre-reqs : None.
1017: -- Usage : Used to load transactions from API table (CN_COMM_LINES_API)
1018: -- to HEADER table (CN_COMMISSION_HEADERS)
1019: -- Parameters :
1020: -- IN : p_api_version IN NUMBER Require
1021: -- : p_init_msg_list IN VARCHAR2 Optional
1022: -- Default = FND_API.G_FALSE
1031: -- Version : Current version 1.0
1032: -- Initial version 1.0
1033: -- Notes
1034: -- Description : This procedure loads trx from CN_COMM_LINES_API to
1035: -- CN_COMMISSION_HEADERS, update cn_process_batches,
1036: -- and perform trx classification, and trx rollup.
1037: --
1038: -- Special Notes : This public API will load trx sequentially instead
1039: -- of submitting concurrent process to load trx in parallel