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_HEADERS_ALL

Line 81: FROM cn_commission_headers_all ch, cn_process_batches_all pb

77: CURSOR sum_trxs IS
78: SELECT ch.direct_salesrep_id, ch.processed_period_id, ch.processed_date
79: , NVL( ch.rollup_date, ch.processed_date ), ch.comp_group_id, ch.revenue_class_id, ch.trx_type
80: , SUM( ch.transaction_amount ), SUM( ch.quantity )
81: FROM cn_commission_headers_all ch, cn_process_batches_all pb
82: WHERE pb.physical_batch_id = p_physical_batch_id
83: AND ch.direct_salesrep_id = pb.salesrep_id
84: AND ch.processed_date BETWEEN pb.start_date AND pb.end_date
85: AND ch.org_id = pb.org_id

Line 120: INSERT INTO cn_commission_headers_all

116: CLOSE sum_trxs;
117:
118: IF rep_ids.COUNT > 0 THEN
119: FORALL i IN rep_ids.FIRST .. rep_ids.LAST
120: INSERT INTO cn_commission_headers_all
121: ( commission_header_id, direct_salesrep_id, processed_date, processed_period_id
122: , trx_type, status, rollup_date, comp_group_id, revenue_class_id, transaction_amount
123: , quantity, pre_processed_code, parent_header_id, creation_date, created_by, org_id )
124: VALUES ( cn_commission_headers_s.NEXTVAL, rep_ids( i ), processed_dates( i ), period_ids( i )

Line 130: UPDATE cn_commission_headers_all

126: , units( i ), 'CRPC', -1, SYSDATE, g_created_by, g_org_id )
127: RETURNING commission_header_id
128: BULK COLLECT INTO header_ids;
129: FORALL i IN rep_ids.FIRST .. rep_ids.LAST
130: UPDATE cn_commission_headers_all
131: SET parent_header_id = header_ids( i )
132: , last_update_date = sysdate
133: , last_updated_by = g_last_updated_by
134: , last_update_login = g_last_update_login

Line 216: FROM cn_commission_headers_all

212: ( SELECT cn_commission_lines_s.NEXTVAL, commission_header_id, direct_salesrep_id, pre_processed_code
213: , revenue_class_id, p_salesrep_id, p_credited_comp_group_id, l_pending_status
214: , DECODE( l_pending_status, 'Y', SYSDATE, NULL ), 'ROLL', 'ROLL', processed_date, processed_period_id
215: , trx_type, g_created_by, g_creation_date, p_rollup_level, org_id
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

Line 232: FROM cn_commission_headers_all head

228: ( SELECT cn_commission_lines_s.NEXTVAL, commission_header_id, direct_salesrep_id, pre_processed_code
229: , revenue_class_id, p_salesrep_id, p_credited_comp_group_id, l_pending_status
230: , DECODE( l_pending_status, 'Y', SYSDATE, NULL ), 'ROLL', 'ROLL', processed_date, processed_period_id
231: , trx_type, g_created_by, g_creation_date, p_rollup_level, org_id
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

Line 276: UPDATE cn_commission_headers_all

272: l_msg_data VARCHAR2( 2000 );
273: BEGIN
274: IF p_salesrep_id IS NOT NULL THEN
275: -- This is for event: add a group member role
276: UPDATE cn_commission_headers_all
277: SET status = DECODE( parent_header_id, -1, 'CLS_SUM', 'CLS' )
278: , last_update_date = sysdate
279: , last_updated_by = g_last_updated_by
280: , last_update_login = g_last_update_login

Line 302: UPDATE cn_commission_headers_all

298: , p_org_id => g_org_id );
299:
300: IF l_group_member.COUNT > 0 THEN
301: FOR eachsrp IN l_group_member.FIRST .. l_group_member.LAST LOOP
302: UPDATE cn_commission_headers_all
303: SET status = DECODE( parent_header_id, -1, 'CLS_SUM', 'CLS' )
304: , last_update_date = sysdate
305: , last_updated_by = g_last_updated_by
306: , last_update_login = g_last_update_login

Line 336: FROM cn_commission_headers_all header

332: WHERE line.posting_status = 'POSTED'
333: AND line.status = 'CALC'
334: AND line.commission_header_id IN(
335: SELECT header.commission_header_id
336: FROM cn_commission_headers_all header
337: WHERE header.direct_salesrep_id = p_salesrep_id
338: AND header.processed_date = p_processed_date
339: AND header.org_id = g_org_id
340: AND NVL( header.parent_header_id, -1 ) = -1

Line 345: FROM cn_commission_headers_all

341: AND NVL( header.rollup_date, header.processed_date ) = NVL( p_rollup_date, p_processed_date ) );
342:
343: CURSOR l_transaction_date IS
344: SELECT DISTINCT processed_date, rollup_date, processed_period_id
345: FROM cn_commission_headers_all
346: WHERE direct_salesrep_id = p_salesrep_id
347: AND org_id = g_org_id
348: -- AND comp_group_id = p_comp_group_id
349: AND ( NVL( rollup_date, processed_date ) BETWEEN p_start_date AND p_end_date

Line 396: UPDATE cn_commission_headers_all

392: IF ( l_active_group.COUNT = 0 ) THEN
393: l_status := 'XROLL';
394: END IF;
395:
396: UPDATE cn_commission_headers_all
397: SET status = NVL( l_status, DECODE( parent_header_id, -1, 'CLS_SUM', 'CLS' ) )
398: , comp_group_id = NULL
399: , last_update_date = sysdate
400: , last_updated_by = g_last_updated_by

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 431: FROM cn_commission_headers_all header

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
433: AND header.org_id = g_org_id
434: AND header.processed_date = eachdate.processed_date
435: AND NVL( header.parent_header_id, -1 ) = -1

Line 468: FROM cn_commission_headers_all

464: l_temp_counter NUMBER;
465:
466: CURSOR l_transactions_cr( p_salesrep_id NUMBER, p_comp_group_id NUMBER, p_start_date DATE, p_end_date DATE ) IS
467: SELECT commission_header_id, processed_date, processed_period_id
468: FROM cn_commission_headers_all
469: WHERE direct_salesrep_id = p_salesrep_id
470: AND org_id = g_org_id
471: -- AND comp_group_id = p_comp_group_id
472: AND g_system_rollup_flag = 'Y'

Line 690: FROM cn_commission_headers_all

686: AND p_rollup_date BETWEEN start_date_active AND NVL( end_date_active, p_rollup_date );
687:
688: CURSOR l_transactions_cr( l_salesrep_id NUMBER, l_comp_group_id NUMBER, l_start_date DATE, l_end_date DATE ) IS
689: SELECT commission_header_id, processed_date, processed_period_id, NVL( rollup_date, processed_date ) rollup_date
690: FROM cn_commission_headers_all
691: WHERE direct_salesrep_id = l_salesrep_id
692: AND org_id = g_org_id
693: AND comp_group_id = l_comp_group_id
694: AND g_system_rollup_flag = 'Y'

Line 858: FROM cn_commission_headers_all ch

854: CURSOR l_no_rollup_transactions_cr IS
855: SELECT ch.commission_header_id commission_header_id, ch.direct_salesrep_id direct_salesrep_id, ch.comp_group_id
856: , NVL( ch.rollup_date, ch.processed_date ) rollup_date, ch.processed_date processed_date
857: , ch.processed_period_id
858: FROM cn_commission_headers_all ch
859: WHERE ch.direct_salesrep_id = p_salesrep_id
860: AND ch.org_id = g_org_id
861: AND ch.processed_date BETWEEN p_start_date AND p_end_date
862: AND ch.trx_type NOT IN( 'FORECAST', 'GRP', 'BONUS' )

Line 872: FROM cn_commission_headers_all ch

868: SELECT ch.commission_header_id commission_header_id, ch.direct_salesrep_id direct_salesrep_id
869: , ch.comp_group_id comp_group_id, NVL( ch.rollup_date, ch.processed_date ) rollup_date
870: , ch.processed_date processed_date, ch.processed_period_id, ch.trx_type, ch.revenue_class_id
871: , ch.pre_processed_code
872: FROM cn_commission_headers_all ch
873: WHERE ch.direct_salesrep_id = p_salesrep_id
874: AND ch.org_id = g_org_id
875: AND ch.processed_date BETWEEN p_start_date AND p_end_date
876: AND ch.trx_type NOT IN( 'FORECAST', 'GRP', 'BONUS' )

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 916: UPDATE cn_commission_headers_all

912: , p_processed_period_id => eachtrx.processed_period_id
913: , p_rollup_level => 0 );
914: l_comp_group_id := l_active_group( l_active_group.FIRST ).GROUP_ID;
915:
916: UPDATE cn_commission_headers_all
917: SET status = 'ROLL'
918: , comp_group_id = l_comp_group_id
919: , last_update_date = sysdate
920: , last_updated_by = g_last_updated_by

Line 926: UPDATE cn_commission_headers_all

922: WHERE commission_header_id = eachtrx.commission_header_id;
923: ELSE
924: -- No group information is available on transaction.
925: -- Change the status to 'XROLL'
926: UPDATE cn_commission_headers_all
927: SET status = 'XROLL'
928: , last_update_date = sysdate
929: , last_updated_by = g_last_updated_by
930: , last_update_login = g_last_update_login

Line 968: UPDATE cn_commission_headers_all

964: , p_processed_date => eachtrx.processed_date
965: , p_processed_period_id => eachtrx.processed_period_id
966: , p_rollup_level => 0 );
967:
968: UPDATE cn_commission_headers_all
969: SET status = 'ROLL'
970: , comp_group_id = l_comp_group_id
971: , last_update_date = sysdate
972: , last_updated_by = g_last_updated_by

Line 976: UPDATE cn_commission_headers_all

972: , last_updated_by = g_last_updated_by
973: , last_update_login = g_last_update_login
974: WHERE commission_header_id = eachtrx.commission_header_id;
975: ELSE
976: UPDATE cn_commission_headers_all
977: SET status = 'XROLL'
978: , last_update_date = sysdate
979: , last_updated_by = g_last_updated_by
980: , last_update_login = g_last_update_login

Line 991: UPDATE cn_commission_headers_all

987: IF ( eachtrx.direct_salesrep_id = l_current_salesrep_id
988: AND ( eachtrx.comp_group_id IS NULL OR g_multi_rollup_profile = 'Y' )
989: AND NVL( eachtrx.rollup_date, eachtrx.processed_date ) = l_current_rollup_date
990: AND eachtrx.processed_date = l_current_processed_date ) THEN
991: UPDATE cn_commission_headers_all
992: SET status = l_prev_status
993: , comp_group_id = DECODE( l_prev_status, 'ROLL', l_prev_comp_group_id, NULL )
994: , last_update_date = sysdate
995: , last_updated_by = g_last_updated_by

Line 1041: UPDATE cn_commission_headers_all

1037: END IF;
1038: END IF;
1039:
1040: IF ( l_active_group.COUNT = 0 AND( eachtrx.comp_group_id IS NULL OR g_multi_rollup_profile = 'Y' ) ) THEN
1041: UPDATE cn_commission_headers_all
1042: SET status = 'XROLL'
1043: , last_update_date = sysdate
1044: , last_updated_by = g_last_updated_by
1045: , last_update_login = g_last_update_login

Line 1068: UPDATE cn_commission_headers_all

1064: CLOSE GROUP_ID;
1065: END IF;
1066:
1067: IF ( l_comp_group_id IS NULL ) THEN
1068: UPDATE cn_commission_headers_all
1069: SET status = 'XROLL'
1070: , last_update_date = sysdate
1071: , last_updated_by = g_last_updated_by
1072: , last_update_login = g_last_update_login

Line 1085: UPDATE cn_commission_headers_all

1081: IF ( g_multi_rollup_profile = 'Y' ) THEN
1082: NULL;
1083: ELSE
1084: IF ( l_active_group.COUNT > 1 ) THEN
1085: UPDATE cn_commission_headers_all
1086: SET status = 'XROLL'
1087: , last_update_date = sysdate
1088: , last_updated_by = g_last_updated_by
1089: , last_update_login = g_last_update_login

Line 1146: UPDATE cn_commission_headers_all

1142: , p_srp => l_srp_group
1143: , x_srp => l_srp_group_ancestor );
1144:
1145: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1146: UPDATE cn_commission_headers_all
1147: SET status = 'XROLL'
1148: , last_update_date = sysdate
1149: , last_updated_by = g_last_updated_by
1150: , last_update_login = g_last_update_login

Line 1162: UPDATE cn_commission_headers_all

1158: END IF; -- end of check api return status
1159: END IF; -- end of check of whether to call API again
1160:
1161: IF ( l_iteration_count < 2 ) THEN
1162: UPDATE cn_commission_headers_all
1163: SET status = 'ROLL'
1164: , comp_group_id = l_comp_group_id
1165: , last_update_date = sysdate
1166: , last_updated_by = g_last_updated_by