eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_CALC_ROLLUP_PVT dependencies on CN_COMMISSION_LINES_ALL

Line 208: INSERT INTO cn_commission_lines_all

204: FETCH l_sum_flag INTO l_srp_sum_flag;
205: CLOSE l_sum_flag;
206:
207: IF ( ( l_srp_sum_flag = 'Y' ) OR( g_roll_sum_trx_flag = 'N' ) ) THEN
208: INSERT INTO cn_commission_lines_all
209: ( commission_line_id, commission_header_id, direct_salesrep_id, pre_processed_code, revenue_class_id
210: , credited_salesrep_id, credited_comp_group_id, pending_status, pending_date, created_during, status
211: , processed_date, processed_period_id, trx_type, created_by, creation_date, rollup_level, org_id )
212: ( SELECT cn_commission_lines_s.NEXTVAL, commission_header_id, direct_salesrep_id, pre_processed_code

Line 220: FROM cn_commission_lines_all

216: FROM cn_commission_headers_all
217: WHERE commission_header_id = p_commission_header_id
218: AND ( NOT EXISTS(
219: SELECT 1
220: FROM cn_commission_lines_all
221: WHERE commission_header_id = p_commission_header_id
222: AND credited_salesrep_id = p_salesrep_id ) ) );
223: ELSE
224: INSERT INTO cn_commission_lines_all

Line 224: INSERT INTO cn_commission_lines_all

220: FROM cn_commission_lines_all
221: WHERE commission_header_id = p_commission_header_id
222: AND credited_salesrep_id = p_salesrep_id ) ) );
223: ELSE
224: INSERT INTO cn_commission_lines_all
225: ( commission_line_id, commission_header_id, direct_salesrep_id, pre_processed_code, revenue_class_id
226: , credited_salesrep_id, credited_comp_group_id, pending_status, pending_date, created_during, status
227: , processed_date, processed_period_id, trx_type, created_by, creation_date, rollup_level, org_id )
228: ( SELECT cn_commission_lines_s.NEXTVAL, commission_header_id, direct_salesrep_id, pre_processed_code

Line 236: FROM cn_commission_lines_all line

232: FROM cn_commission_headers_all head
233: WHERE head.parent_header_id = p_commission_header_id
234: AND ( NOT EXISTS(
235: SELECT 1
236: FROM cn_commission_lines_all line
237: WHERE line.commission_header_id = head.commission_header_id
238: AND line.credited_salesrep_id = p_salesrep_id ) ) );
239: END IF;
240:

Line 331: FROM cn_commission_lines_all line

327:
328: PROCEDURE source_cls( p_salesrep_id NUMBER, p_comp_group_id NUMBER, p_start_date DATE, p_end_date DATE ) IS
329: CURSOR revert_lines( p_salesrep_id NUMBER, p_processed_date DATE, p_rollup_date DATE ) IS
330: SELECT commission_line_id
331: FROM cn_commission_lines_all line
332: WHERE line.posting_status = 'POSTED'
333: AND line.status = 'CALC'
334: AND line.commission_header_id IN(
335: SELECT header.commission_header_id

Line 415: FROM cn_commission_lines_all line, cn_commission_headers_all header

411: WHERE period_id = eachdate.processed_period_id
412: AND org_id = g_org_id
413: AND salesrep_id IN(
414: SELECT DISTINCT line.credited_salesrep_id
415: FROM cn_commission_lines_all line, cn_commission_headers_all header
416: WHERE line.commission_header_id = header.commission_header_id
417: AND header.direct_salesrep_id = p_salesrep_id
418: AND header.processed_date = eachdate.processed_date
419: AND header.org_id = g_org_id

Line 428: DELETE FROM cn_commission_lines_all line

424: FOR line IN revert_lines( p_salesrep_id, eachdate.processed_date, eachdate.rollup_date ) LOOP
425: cn_formula_common_pkg.revert_posting_line( line.commission_line_id );
426: END LOOP;
427:
428: DELETE FROM cn_commission_lines_all line
429: WHERE line.commission_header_id IN(
430: SELECT header.commission_header_id
431: FROM cn_commission_headers_all header
432: WHERE header.direct_salesrep_id = p_salesrep_id

Line 650: FROM cn_commission_lines_all

646: l_rollup_level PLS_INTEGER;
647:
648: CURSOR revert_lines( p_salesrep_id NUMBER, p_commission_header_id NUMBER ) IS
649: SELECT commission_line_id
650: FROM cn_commission_lines_all
651: WHERE credited_salesrep_id = p_salesrep_id
652: AND org_id = g_org_id
653: AND status = 'CALC'
654: AND posting_status = 'POSTED'

Line 799: DELETE cn_commission_lines_all

795: FOR line IN revert_lines( l_ancestors_tbl( l_ancestor ).salesrep_id, eachtrx.commission_header_id ) LOOP
796: cn_formula_common_pkg.revert_posting_line( line.commission_line_id );
797: END LOOP;
798:
799: DELETE cn_commission_lines_all
800: WHERE credited_salesrep_id = l_ancestors_tbl( l_ancestor ).salesrep_id
801: AND commission_header_id IN (
802: SELECT commission_header_id FROM cn_commission_headers
803: WHERE eachtrx.commission_header_id IN (commission_header_id, parent_header_id)

Line 885: FROM cn_commission_lines_all

881: ORDER BY ch.direct_salesrep_id, ch.comp_group_id, NVL( ch.rollup_date, ch.processed_date ), ch.processed_date;
882:
883: CURSOR rollup_lines( p_commission_header_id NUMBER ) IS
884: SELECT DISTINCT credited_salesrep_id, credited_comp_group_id, rollup_level
885: FROM cn_commission_lines_all
886: WHERE commission_header_id = p_commission_header_id
887: UNION
888: SELECT DISTINCT lines.credited_salesrep_id, lines.credited_comp_group_id, lines.rollup_level
889: FROM cn_commission_headers_all head, cn_commission_lines_all lines

Line 889: FROM cn_commission_headers_all head, cn_commission_lines_all lines

885: FROM cn_commission_lines_all
886: WHERE commission_header_id = p_commission_header_id
887: UNION
888: SELECT DISTINCT lines.credited_salesrep_id, lines.credited_comp_group_id, lines.rollup_level
889: FROM cn_commission_headers_all head, cn_commission_lines_all lines
890: WHERE head.parent_header_id = p_commission_header_id
891: AND head.commission_header_id = lines.commission_header_id;
892: BEGIN
893: -- Processing no rollup transaction

Line 1095: DELETE FROM cn_commission_lines_all

1091:
1092: l_prev_status := 'XROLL';
1093:
1094: IF ( l_iteration_count = 2 ) THEN
1095: DELETE FROM cn_commission_lines_all
1096: WHERE commission_header_id = eachtrx.commission_header_id;
1097: END IF;
1098:
1099: EXIT;

Line 1153: DELETE FROM cn_commission_lines_all

1149: , last_updated_by = g_last_updated_by
1150: , last_update_login = g_last_update_login
1151: WHERE commission_header_id = eachtrx.commission_header_id;
1152:
1153: DELETE FROM cn_commission_lines_all
1154: WHERE commission_header_id = eachtrx.commission_header_id;
1155:
1156: l_prev_status := 'XROLL';
1157: RAISE fnd_api.g_exc_unexpected_error;

Line 1271: FROM cn_commission_lines_all cl, cn_process_batches_all pb

1267:
1268: CURSOR l_transactions_cr IS
1269: SELECT cl.commission_header_id commission_header_id, cl.commission_line_id commission_line_id
1270: , cl.credited_salesrep_id credited_salesrep_id
1271: FROM cn_commission_lines_all cl, cn_process_batches_all pb
1272: WHERE pb.physical_batch_id = p_physical_batch_id
1273: AND pb.salesrep_id = cl.credited_salesrep_id
1274: AND cl.org_id = g_org_id
1275: AND cl.processed_period_id BETWEEN pb.period_id AND pb.end_period_id

Line 1296: UPDATE cn_commission_lines_all

1292: IF ( l_return_status = fnd_api.g_ret_sts_success ) THEN
1293: IF ( l_validation_status = 'Y' ) THEN
1294: l_pending_status := 'N';
1295:
1296: UPDATE cn_commission_lines_all
1297: SET pending_status = 'N'
1298: WHERE commission_line_id = eachtrx.commission_line_id;
1299: END IF;
1300: END IF;