APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_COMMISSION_HEADERS

Line 12: -- Procedures TO load trx FROM cn_comm_lines_api TO cn_commission_headers

8:
9: -- Package Name
10: -- cn_transaction_load_pkg
11: -- Purpose
12: -- Procedures TO load trx FROM cn_comm_lines_api TO cn_commission_headers
13: -- History
14: -- 10/21/99 Harlen Chen Created
15: -- 08/28/01 Rao Chenna acctd_transaction_amount column update logic
16: -- is modified.

Line 1159: -- This procedure loads trx from CN_COMM_LINES_API to CN_COMMISSION_HEADERS,

1155:
1156: -- Name:
1157: -- Load
1158: -- Purpose:
1159: -- This procedure loads trx from CN_COMM_LINES_API to CN_COMMISSION_HEADERS,
1160: -- update cn_process_batches, and perform classification, and rollup phases
1161: PROCEDURE load(
1162: errbuf OUT NOCOPY VARCHAR2
1163: , retcode OUT NOCOPY NUMBER

Line 1406: SELECT cn_commission_headers_s.NEXTVAL

1402: l_skip_credit_flag := NVL(fnd_profile.VALUE('CN_SKIP_CREDIT_ALLOCATION'), 'Y');
1403: END IF;
1404:
1405: -- this is used to make it more restrict for handling reversal trx later on
1406: SELECT cn_commission_headers_s.NEXTVAL
1407: INTO l_init_commission_header_id
1408: FROM DUAL;
1409:
1410: FOR batch IN batches LOOP

Line 1432: INSERT INTO cn_commission_headers

1428: );
1429: counter := counter + batch.trx_count;
1430:
1431: IF (l_skip_credit_flag = 'Y') THEN
1432: INSERT INTO cn_commission_headers
1433: (
1434: commission_header_id
1435: , direct_salesrep_id
1436: , processed_date

Line 1599: (SELECT cn_commission_headers_s.NEXTVAL

1595: , split_pct
1596: , split_status
1597: , org_id
1598: ) -- vensrini transaction load fix
1599: (SELECT cn_commission_headers_s.NEXTVAL
1600: , batch.salesrep_id
1601: , TRUNC(api.processed_date)
1602: , batch.period_id
1603: , TRUNC(api.rollup_date)

Line 1773: FROM cn_commission_headers_all cmh

1769: AND api.salesrep_id = batch.salesrep_id
1770: AND api.processed_date >= TRUNC(batch.start_date)
1771: AND api.processed_date <(TRUNC(batch.end_date) + 1)
1772: AND NOT EXISTS(SELECT 'this transaction has already been loaded'
1773: FROM cn_commission_headers_all cmh
1774: WHERE cmh.comm_lines_api_id = api.comm_lines_api_id));
1775: ELSE
1776: INSERT INTO cn_commission_headers
1777: (

Line 1776: INSERT INTO cn_commission_headers

1772: AND NOT EXISTS(SELECT 'this transaction has already been loaded'
1773: FROM cn_commission_headers_all cmh
1774: WHERE cmh.comm_lines_api_id = api.comm_lines_api_id));
1775: ELSE
1776: INSERT INTO cn_commission_headers
1777: (
1778: commission_header_id
1779: , direct_salesrep_id
1780: , processed_date

Line 1943: (SELECT cn_commission_headers_s.NEXTVAL

1939: , split_pct
1940: , split_status
1941: , org_id
1942: ) -- vensrini transaction load fix
1943: (SELECT cn_commission_headers_s.NEXTVAL
1944: , batch.salesrep_id
1945: , TRUNC(api.processed_date)
1946: , batch.period_id
1947: , TRUNC(api.rollup_date)

Line 2118: FROM cn_commission_headers_all cmh

2114: AND api.processed_date >= TRUNC(batch.start_date)
2115: AND api.processed_date <(TRUNC(batch.end_date) + 1)
2116: AND (api.terr_id IS NOT NULL OR api.preserve_credit_override_flag = 'Y')
2117: AND NOT EXISTS(SELECT 'this transaction has already been loaded'
2118: FROM cn_commission_headers_all cmh
2119: WHERE cmh.comm_lines_api_id = api.comm_lines_api_id));
2120: END IF; /* end if l_skip_credit_flag */
2121:
2122: debugmsg('Loader : number of loaded trx = ' || TO_CHAR(SQL%ROWCOUNT));

Line 2169: FROM cn_commission_headers cch

2165: CURSOR l_headers IS
2166: SELECT cch.commission_header_id
2167: , cch.reversal_flag
2168: , cch.reversal_header_id
2169: FROM cn_commission_headers cch
2170: , (SELECT DISTINCT salesrep_id
2171: FROM cn_process_batches
2172: WHERE physical_batch_id = p_physical_batch_id AND status_code = 'IN_USE') pb
2173: WHERE cch.direct_salesrep_id = pb.salesrep_id