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 1163: -- This procedure loads trx from CN_COMM_LINES_API to CN_COMMISSION_HEADERS,

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

Line 1418: SELECT cn_commission_headers_s.NEXTVAL

1414: l_skip_credit_flag := NVL(fnd_profile.VALUE('CN_SKIP_CREDIT_ALLOCATION'), 'Y');
1415: END IF;
1416:
1417: -- this is used to make it more restrict for handling reversal trx later on
1418: SELECT cn_commission_headers_s.NEXTVAL
1419: INTO l_init_commission_header_id
1420: FROM DUAL;
1421:
1422: FOR batch IN batches LOOP

Line 1444: INSERT INTO cn_commission_headers

1440: );
1441: counter := counter + batch.trx_count;
1442:
1443: IF (l_skip_credit_flag = 'Y') THEN
1444: INSERT INTO cn_commission_headers
1445: (
1446: commission_header_id
1447: , direct_salesrep_id
1448: , processed_date

Line 1611: (SELECT cn_commission_headers_s.NEXTVAL

1607: , split_pct
1608: , split_status
1609: , org_id
1610: ) -- vensrini transaction load fix
1611: (SELECT cn_commission_headers_s.NEXTVAL
1612: , batch.salesrep_id
1613: , TRUNC(api.processed_date)
1614: , batch.period_id
1615: , TRUNC(api.rollup_date)

Line 1785: FROM cn_commission_headers_all cmh

1781: AND api.salesrep_id = batch.salesrep_id
1782: AND api.processed_date >= TRUNC(batch.start_date)
1783: AND api.processed_date <(TRUNC(batch.end_date) + 1)
1784: AND NOT EXISTS(SELECT 'this transaction has already been loaded'
1785: FROM cn_commission_headers_all cmh
1786: WHERE cmh.comm_lines_api_id = api.comm_lines_api_id));
1787: ELSE
1788: INSERT INTO cn_commission_headers
1789: (

Line 1788: INSERT INTO cn_commission_headers

1784: AND NOT EXISTS(SELECT 'this transaction has already been loaded'
1785: FROM cn_commission_headers_all cmh
1786: WHERE cmh.comm_lines_api_id = api.comm_lines_api_id));
1787: ELSE
1788: INSERT INTO cn_commission_headers
1789: (
1790: commission_header_id
1791: , direct_salesrep_id
1792: , processed_date

Line 1955: (SELECT cn_commission_headers_s.NEXTVAL

1951: , split_pct
1952: , split_status
1953: , org_id
1954: ) -- vensrini transaction load fix
1955: (SELECT cn_commission_headers_s.NEXTVAL
1956: , batch.salesrep_id
1957: , TRUNC(api.processed_date)
1958: , batch.period_id
1959: , TRUNC(api.rollup_date)

Line 2130: FROM cn_commission_headers_all cmh

2126: AND api.processed_date >= TRUNC(batch.start_date)
2127: AND api.processed_date <(TRUNC(batch.end_date) + 1)
2128: AND (api.terr_id IS NOT NULL OR api.preserve_credit_override_flag = 'Y')
2129: AND NOT EXISTS(SELECT 'this transaction has already been loaded'
2130: FROM cn_commission_headers_all cmh
2131: WHERE cmh.comm_lines_api_id = api.comm_lines_api_id));
2132: END IF; /* end if l_skip_credit_flag */
2133:
2134: debugmsg('Loader : number of loaded trx = ' || TO_CHAR(SQL%ROWCOUNT));

Line 2181: FROM cn_commission_headers cch

2177: CURSOR l_headers IS
2178: SELECT cch.commission_header_id
2179: , cch.reversal_flag
2180: , cch.reversal_header_id
2181: FROM cn_commission_headers cch
2182: , (SELECT DISTINCT salesrep_id
2183: FROM cn_process_batches
2184: WHERE physical_batch_id = p_physical_batch_id AND status_code = 'IN_USE') pb
2185: WHERE cch.direct_salesrep_id = pb.salesrep_id