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_FORMULA_COMMON_PKG dependencies on CN_COMMISSION_HEADERS_ALL

Line 831: DELETE cn_commission_headers_all

827: IF l_itd_trx.posting_status = 'POSTED' THEN
828: revert_posting_line ( l_itd_trx.commission_line_id);
829: END IF;
830:
831: DELETE cn_commission_headers_all
832: WHERE commission_header_id = l_itd_trx.commission_header_id;
833:
834: DELETE cn_commission_lines_all
835: WHERE commission_line_id = l_itd_trx.commission_line_id;

Line 1887: cn_commission_headers_all ch

1883: WHERE line.commission_line_id in
1884: (SELECT line2.commission_line_id
1885: FROM cn_process_batches_all batch,
1886: cn_commission_lines_all line2,
1887: cn_commission_headers_all ch
1888: WHERE batch.physical_batch_id = p_physical_batch_id
1889: AND line2.commission_header_id = ch.commission_header_id
1890: AND line2.credited_salesrep_id = batch.salesrep_id
1891: AND line2.processed_period_id BETWEEN batch.period_id AND batch.end_period_id

Line 1903: from cn_commission_headers_all amthead,

1899:
1900: UPDATE cn_commission_lines_all line
1901: SET line.status = 'CALC',
1902: line.commission_amount = (select amthead.commission_amount
1903: from cn_commission_headers_all amthead,
1904: cn_commission_lines_all amtline
1905: where amthead.commission_header_id = amtline.commission_header_id
1906: and amtline.commission_line_id = line.commission_line_id
1907: ),

Line 1916: cn_commission_headers_all ch

1912: WHERE line.commission_line_id in
1913: (SELECT line2.commission_line_id
1914: FROM cn_process_batches_all batch,
1915: cn_commission_lines_all line2,
1916: cn_commission_headers_all ch
1917: WHERE batch.physical_batch_id = p_physical_batch_id
1918: AND line2.commission_header_id = ch.commission_header_id
1919: AND line2.credited_salesrep_id = batch.salesrep_id
1920: AND line2.processed_period_id BETWEEN batch.period_id AND batch.end_period_id

Line 2222: FROM cn_commission_headers_all

2218: FROM cn_commission_lines_all
2219: WHERE status = 'OBSOLETE'
2220: and posting_status = 'UNPOSTED'
2221: and (commission_header_id = (SELECT reversal_header_id
2222: FROM cn_commission_headers_all
2223: WHERE commission_header_id = p_commission_header_id)
2224: OR commission_header_id = (SELECT parent_header_id
2225: FROM cn_commission_headers_all
2226: WHERE commission_header_id = (SELECT reversal_header_id

Line 2225: FROM cn_commission_headers_all

2221: and (commission_header_id = (SELECT reversal_header_id
2222: FROM cn_commission_headers_all
2223: WHERE commission_header_id = p_commission_header_id)
2224: OR commission_header_id = (SELECT parent_header_id
2225: FROM cn_commission_headers_all
2226: WHERE commission_header_id = (SELECT reversal_header_id
2227: FROM cn_commission_headers_all
2228: WHERE commission_header_id = p_commission_header_id)));
2229:

Line 2227: FROM cn_commission_headers_all

2223: WHERE commission_header_id = p_commission_header_id)
2224: OR commission_header_id = (SELECT parent_header_id
2225: FROM cn_commission_headers_all
2226: WHERE commission_header_id = (SELECT reversal_header_id
2227: FROM cn_commission_headers_all
2228: WHERE commission_header_id = p_commission_header_id)));
2229:
2230: CURSOR l_orig_posted_trx IS
2231: SELECT commission_line_id

Line 2234: FROM cn_commission_headers_all

2230: CURSOR l_orig_posted_trx IS
2231: SELECT commission_line_id
2232: FROM cn_commission_lines_all
2233: WHERE (commission_header_id = (SELECT reversal_header_id
2234: FROM cn_commission_headers_all
2235: WHERE commission_header_id = p_commission_header_id)
2236: OR commission_header_id = (SELECT parent_header_id
2237: FROM cn_commission_headers_all
2238: WHERE commission_header_id = (SELECT reversal_header_id

Line 2237: FROM cn_commission_headers_all

2233: WHERE (commission_header_id = (SELECT reversal_header_id
2234: FROM cn_commission_headers_all
2235: WHERE commission_header_id = p_commission_header_id)
2236: OR commission_header_id = (SELECT parent_header_id
2237: FROM cn_commission_headers_all
2238: WHERE commission_header_id = (SELECT reversal_header_id
2239: FROM cn_commission_headers_all
2240: WHERE commission_header_id = p_commission_header_id)))
2241:

Line 2239: FROM cn_commission_headers_all

2235: WHERE commission_header_id = p_commission_header_id)
2236: OR commission_header_id = (SELECT parent_header_id
2237: FROM cn_commission_headers_all
2238: WHERE commission_header_id = (SELECT reversal_header_id
2239: FROM cn_commission_headers_all
2240: WHERE commission_header_id = p_commission_header_id)))
2241:
2242: AND status = 'CALC'
2243: AND posting_status = 'POSTED';

Line 2254: WHERE (commission_header_id = (SELECT reversal_header_id FROM cn_commission_headers_all

2250: -- update all trx generated from the original commission_header line
2251: -- to be obsolete
2252: UPDATE cn_commission_lines_all
2253: SET status = 'OBSOLETE', posting_status = 'UNPOSTED'
2254: WHERE (commission_header_id = (SELECT reversal_header_id FROM cn_commission_headers_all
2255: WHERE commission_header_id = p_commission_header_id)
2256: OR commission_header_id = (SELECT parent_header_id
2257: FROM cn_commission_headers_all
2258: WHERE commission_header_id = (SELECT reversal_header_id

Line 2257: FROM cn_commission_headers_all

2253: SET status = 'OBSOLETE', posting_status = 'UNPOSTED'
2254: WHERE (commission_header_id = (SELECT reversal_header_id FROM cn_commission_headers_all
2255: WHERE commission_header_id = p_commission_header_id)
2256: OR commission_header_id = (SELECT parent_header_id
2257: FROM cn_commission_headers_all
2258: WHERE commission_header_id = (SELECT reversal_header_id
2259: FROM cn_commission_headers_all
2260: WHERE commission_header_id = p_commission_header_id)));
2261:

Line 2259: FROM cn_commission_headers_all

2255: WHERE commission_header_id = p_commission_header_id)
2256: OR commission_header_id = (SELECT parent_header_id
2257: FROM cn_commission_headers_all
2258: WHERE commission_header_id = (SELECT reversal_header_id
2259: FROM cn_commission_headers_all
2260: WHERE commission_header_id = p_commission_header_id)));
2261:
2262: FOR rep IN c_affected_reps LOOP
2263: cn_mark_events_pkg.mark_notify

Line 2310: WHERE (line.commission_header_id = (SELECT reversal_header_id FROM cn_commission_headers_all

2306: -( Nvl(line.output_achieved,0)), -( Nvl(line.perf_achieved,0)),
2307: line.pay_period_id, line.pending_status,
2308: line.role_id, line.pending_date, line.credited_comp_group_id, line.org_id
2309: FROM cn_commission_lines_all line
2310: WHERE (line.commission_header_id = (SELECT reversal_header_id FROM cn_commission_headers_all
2311: WHERE commission_header_id = p_commission_header_id)
2312: OR line.commission_header_id = (SELECT parent_header_id
2313: FROM cn_commission_headers_all
2314: WHERE commission_header_id = (SELECT reversal_header_id

Line 2313: FROM cn_commission_headers_all

2309: FROM cn_commission_lines_all line
2310: WHERE (line.commission_header_id = (SELECT reversal_header_id FROM cn_commission_headers_all
2311: WHERE commission_header_id = p_commission_header_id)
2312: OR line.commission_header_id = (SELECT parent_header_id
2313: FROM cn_commission_headers_all
2314: WHERE commission_header_id = (SELECT reversal_header_id
2315: FROM cn_commission_headers_all
2316: WHERE commission_header_id = p_commission_header_id)));
2317:

Line 2315: FROM cn_commission_headers_all

2311: WHERE commission_header_id = p_commission_header_id)
2312: OR line.commission_header_id = (SELECT parent_header_id
2313: FROM cn_commission_headers_all
2314: WHERE commission_header_id = (SELECT reversal_header_id
2315: FROM cn_commission_headers_all
2316: WHERE commission_header_id = p_commission_header_id)));
2317:
2318: -- update commission_header.status to be 'OBSOLETE'
2319: UPDATE cn_commission_headers_all ch SET

Line 2319: UPDATE cn_commission_headers_all ch SET

2315: FROM cn_commission_headers_all
2316: WHERE commission_header_id = p_commission_header_id)));
2317:
2318: -- update commission_header.status to be 'OBSOLETE'
2319: UPDATE cn_commission_headers_all ch SET
2320: ch.status = 'OBSOLETE',
2321: -- clku, update the last updated info
2322: last_update_date = sysdate,
2323: last_updated_by = G_LAST_UPDATED_BY,

Line 2327: UPDATE cn_commission_headers_all ch SET

2323: last_updated_by = G_LAST_UPDATED_BY,
2324: last_update_login = G_LAST_UPDATE_LOGIN
2325: WHERE commission_header_id = p_commission_header_id;
2326:
2327: UPDATE cn_commission_headers_all ch SET
2328: ch.status = 'OBSOLETE',
2329: -- clku, update the last updated info
2330: last_update_date = sysdate,
2331: last_updated_by = G_LAST_UPDATED_BY,

Line 2335: FROM cn_commission_headers_all head

2331: last_updated_by = G_LAST_UPDATED_BY,
2332: last_update_login = G_LAST_UPDATE_LOGIN
2333: WHERE commission_header_id
2334: IN (SELECT head.reversal_header_id
2335: FROM cn_commission_headers_all head
2336: WHERE head.commission_header_id = p_commission_header_id );
2337:
2338: -- delete sum trx
2339: DELETE FROM cn_commission_headers_all

Line 2339: DELETE FROM cn_commission_headers_all

2335: FROM cn_commission_headers_all head
2336: WHERE head.commission_header_id = p_commission_header_id );
2337:
2338: -- delete sum trx
2339: DELETE FROM cn_commission_headers_all
2340: WHERE commission_header_id = (SELECT parent_header_id
2341: FROM cn_commission_headers_all
2342: WHERE commission_header_id = (SELECT reversal_header_id
2343: FROM cn_commission_headers_all

Line 2341: FROM cn_commission_headers_all

2337:
2338: -- delete sum trx
2339: DELETE FROM cn_commission_headers_all
2340: WHERE commission_header_id = (SELECT parent_header_id
2341: FROM cn_commission_headers_all
2342: WHERE commission_header_id = (SELECT reversal_header_id
2343: FROM cn_commission_headers_all
2344: WHERE commission_header_id = p_commission_header_id));
2345: -- for source trxs of the sum trx, set their parent_header_id = null

Line 2343: FROM cn_commission_headers_all

2339: DELETE FROM cn_commission_headers_all
2340: WHERE commission_header_id = (SELECT parent_header_id
2341: FROM cn_commission_headers_all
2342: WHERE commission_header_id = (SELECT reversal_header_id
2343: FROM cn_commission_headers_all
2344: WHERE commission_header_id = p_commission_header_id));
2345: -- for source trxs of the sum trx, set their parent_header_id = null
2346: UPDATE cn_commission_headers_all
2347: SET parent_header_id = NULL,

Line 2346: UPDATE cn_commission_headers_all

2342: WHERE commission_header_id = (SELECT reversal_header_id
2343: FROM cn_commission_headers_all
2344: WHERE commission_header_id = p_commission_header_id));
2345: -- for source trxs of the sum trx, set their parent_header_id = null
2346: UPDATE cn_commission_headers_all
2347: SET parent_header_id = NULL,
2348: -- clku, update the last updated info
2349: last_update_date = sysdate,
2350: last_updated_by = G_LAST_UPDATED_BY,

Line 2353: FROM cn_commission_headers_all

2349: last_update_date = sysdate,
2350: last_updated_by = G_LAST_UPDATED_BY,
2351: last_update_login = G_LAST_UPDATE_LOGIN
2352: WHERE parent_header_id = (SELECT parent_header_id
2353: FROM cn_commission_headers_all
2354: WHERE commission_header_id = (SELECT reversal_header_id
2355: FROM cn_commission_headers_all
2356: WHERE commission_header_id = p_commission_header_id));
2357: END handle_reversal_trx;

Line 2355: FROM cn_commission_headers_all

2351: last_update_login = G_LAST_UPDATE_LOGIN
2352: WHERE parent_header_id = (SELECT parent_header_id
2353: FROM cn_commission_headers_all
2354: WHERE commission_header_id = (SELECT reversal_header_id
2355: FROM cn_commission_headers_all
2356: WHERE commission_header_id = p_commission_header_id));
2357: END handle_reversal_trx;
2358:
2359: -- delete/update derived commission_lines

Line 2375: FROM cn_commission_headers_all

2371: CURSOR l_posted_trxs_csr2 IS
2372: SELECT commission_line_id
2373: FROM cn_commission_lines_all
2374: WHERE commission_header_id = (SELECT parent_header_id
2375: FROM cn_commission_headers_all
2376: WHERE commission_header_id = p_commission_header_id)
2377: AND posting_status = 'POSTED'
2378: AND status = 'CALC';
2379: BEGIN

Line 2394: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2390: DELETE cn_commission_lines_all
2391: WHERE commission_header_id = p_commission_header_id;
2392:
2393: DELETE cn_commission_lines_all
2394: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2395: WHERE commission_header_id = p_commission_header_id);
2396:
2397: DELETE cn_commission_headers_all
2398: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

Line 2397: DELETE cn_commission_headers_all

2393: DELETE cn_commission_lines_all
2394: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2395: WHERE commission_header_id = p_commission_header_id);
2396:
2397: DELETE cn_commission_headers_all
2398: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2399: WHERE commission_header_id = p_commission_header_id);
2400:
2401: UPDATE cn_commission_headers_all

Line 2398: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2394: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2395: WHERE commission_header_id = p_commission_header_id);
2396:
2397: DELETE cn_commission_headers_all
2398: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2399: WHERE commission_header_id = p_commission_header_id);
2400:
2401: UPDATE cn_commission_headers_all
2402: SET parent_header_id = NULL,

Line 2401: UPDATE cn_commission_headers_all

2397: DELETE cn_commission_headers_all
2398: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2399: WHERE commission_header_id = p_commission_header_id);
2400:
2401: UPDATE cn_commission_headers_all
2402: SET parent_header_id = NULL,
2403: last_update_date = sysdate,
2404: last_updated_by = G_LAST_UPDATED_BY,
2405: last_update_login = G_LAST_UPDATE_LOGIN

Line 2406: WHERE parent_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2402: SET parent_header_id = NULL,
2403: last_update_date = sysdate,
2404: last_updated_by = G_LAST_UPDATED_BY,
2405: last_update_login = G_LAST_UPDATE_LOGIN
2406: WHERE parent_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2407: WHERE commission_header_id = p_commission_header_id);
2408:
2409: ELSIF p_revert_state = 'ROLL' THEN
2410: -- revert posted line before deleting any commission lines

Line 2424: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2420: WHERE commission_header_id = p_commission_header_id
2421: AND created_during IN ( 'POP', 'CALC');
2422:
2423: DELETE cn_commission_lines_all
2424: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2425: WHERE commission_header_id = p_commission_header_id);
2426:
2427: DELETE cn_commission_headers_all
2428: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

Line 2427: DELETE cn_commission_headers_all

2423: DELETE cn_commission_lines_all
2424: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2425: WHERE commission_header_id = p_commission_header_id);
2426:
2427: DELETE cn_commission_headers_all
2428: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2429: WHERE commission_header_id = p_commission_header_id);
2430:
2431: UPDATE cn_commission_headers_all

Line 2428: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2424: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2425: WHERE commission_header_id = p_commission_header_id);
2426:
2427: DELETE cn_commission_headers_all
2428: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2429: WHERE commission_header_id = p_commission_header_id);
2430:
2431: UPDATE cn_commission_headers_all
2432: SET parent_header_id = NULL,

Line 2431: UPDATE cn_commission_headers_all

2427: DELETE cn_commission_headers_all
2428: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2429: WHERE commission_header_id = p_commission_header_id);
2430:
2431: UPDATE cn_commission_headers_all
2432: SET parent_header_id = NULL,
2433: last_update_date = sysdate,
2434: last_updated_by = G_LAST_UPDATED_BY,
2435: last_update_login = G_LAST_UPDATE_LOGIN

Line 2436: WHERE parent_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2432: SET parent_header_id = NULL,
2433: last_update_date = sysdate,
2434: last_updated_by = G_LAST_UPDATED_BY,
2435: last_update_login = G_LAST_UPDATE_LOGIN
2436: WHERE parent_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2437: WHERE commission_header_id = p_commission_header_id);
2438:
2439: UPDATE cn_commission_lines_all
2440: SET status = 'ROLL',

Line 2557: FROM cn_commission_headers_all header

2553: SELECT line.commission_line_id
2554: FROM cn_commission_lines_all line
2555: WHERE line.commission_header_id
2556: IN ( SELECT header.commission_header_id
2557: FROM cn_commission_headers_all header
2558: WHERE header.direct_salesrep_id = l_salesrep_id
2559: AND header.processed_period_id = l_period_id
2560: AND header.processed_date BETWEEN l_start_date AND l_end_date
2561: AND header.status = 'ROLL'

Line 2596: FROM cn_commission_headers_all ch

2592: and cl.org_id = l_org_id
2593: AND cl.processed_date BETWEEN p_start_date AND p_end_date
2594: AND ((p_role_id IS NOT NULL AND cl.role_id = p_role_id ) OR p_role_id IS NULL)
2595: AND exists ( SELECT 1
2596: FROM cn_commission_headers_all ch
2597: WHERE ch.commission_header_id = cl.commission_header_id
2598: AND ch.comp_group_id = p_base_comp_group_id
2599: AND ( p_base_salesrep_id IS NULL OR ch.direct_salesrep_id = p_base_salesrep_id));
2600:

Line 2618: FROM cn_commission_headers_all ch

2614: OR (l_mgr_role_flag = 'N' and l_mem_role_flag = 'Y' and cl.credited_salesrep_id = p_salesrep_id and cl.direct_salesrep_id <> p_salesrep_id))
2615: ) OR (p_role_id IS NULL AND cl.credited_salesrep_id = p_salesrep_id))
2616: AND exists
2617: ( SELECT 1
2618: FROM cn_commission_headers_all ch
2619: WHERE ch.commission_header_id = cl.commission_header_id
2620: AND ch.comp_group_id = p_comp_group_id );
2621:
2622:

Line 2769: FROM cn_commission_headers_all ch

2765: AND ( (l_log.role_id IS NOT NULL AND cl.role_id = l_log.role_id )
2766: OR l_log.role_id IS NULL )
2767: AND exists
2768: (SELECT 1
2769: FROM cn_commission_headers_all ch
2770: WHERE ch.commission_header_id = cl.commission_header_id
2771: AND ch.comp_group_id = l_log.base_comp_group_id
2772: AND ( l_log.base_salesrep_id IS NULL
2773: OR ch.direct_salesrep_id = l_log.base_salesrep_id)

Line 2803: FROM cn_commission_headers_all ch

2799: (l_mgr_role_flag = 'N' and l_mem_role_flag = 'Y' and cl.credited_salesrep_id = l_log.salesrep_id and cl.direct_salesrep_id <> l_log.salesrep_id))
2800: )OR (l_log.role_id IS NULL and cl.credited_salesrep_id = l_log.salesrep_id))
2801: AND exists
2802: ( SELECT 1
2803: FROM cn_commission_headers_all ch
2804: WHERE ch.commission_header_id = cl.commission_header_id
2805: AND ch.comp_group_id = l_log.comp_group_id );
2806:
2807: ELSIF l_log.action = 'DELETE_DEST_XROLL' THEN

Line 2823: UPDATE cn_commission_headers_all ch

2819: AND cl.org_id = l_org_id
2820: AND ( (l_log.role_id IS NOT NULL AND cl.role_id = l_log.role_id )
2821: OR l_log.role_id IS NULL );
2822:
2823: UPDATE cn_commission_headers_all ch
2824: SET status = 'XROLL',
2825: last_update_date = sysdate,
2826: last_updated_by = g_last_updated_by,
2827: last_update_login = g_last_update_login

Line 3058: UPDATE cn_commission_headers_all

3054: AND header.trx_type NOT IN ('FORECAST', 'BONUS')
3055: AND header.org_id = l_org_id );
3056:
3057: -- 3). update header trx status to be 'CLS' ('CLS_SUM' if rolling up summarized trxs)
3058: UPDATE cn_commission_headers_all
3059: SET status = decode(parent_header_id, -1, 'CLS_SUM', 'CLS'),
3060: last_update_date = sysdate,
3061: last_updated_by = g_last_updated_by,
3062: last_update_login = g_last_update_login

Line 3097: DELETE cn_commission_headers_all header

3093:
3094:
3095: -- 2). delete 'GRP' trx created in commission_headers
3096: -- need to delete 'GRP' trxs in commission_header since its counterpart in line has been deleted
3097: DELETE cn_commission_headers_all header
3098: WHERE header.direct_salesrep_id = l_log.salesrep_id
3099: --AND header.processed_date BETWEEN l_log.start_date AND l_log.end_date
3100: AND header.processed_period_id = l_log.period_id
3101: AND header.trx_type IN ('ITD', 'GRP')

Line 3244: delete cn_commission_headers_all ch

3240: IF p_calc_type = 'COMMISSION' THEN
3241: -- need to delete 'ITD','GRP' trxs in commission_header since its counterpart in line has been deleted
3242: -- bonus trx are all non accumulative, so 'ITD', 'GRP' doesn't apply.
3243: IF (l_unique_flag = 'Y') THEN
3244: delete cn_commission_headers_all ch
3245: where ch.direct_salesrep_id in (select salesrep_id
3246: from cn_process_batches_all
3247: where physical_batch_id = p_batch_id)
3248: and ch.processed_date between l_start_date and l_end_date

Line 3252: DELETE cn_commission_headers_all head

3248: and ch.processed_date between l_start_date and l_end_date
3249: AND (ch.trx_type IN ('GRP', 'ITD') OR ch.parent_header_id = -1)
3250: and ch.org_id = l_org_id;
3251: ELSE
3252: DELETE cn_commission_headers_all head
3253: WHERE head.commission_header_id IN
3254: ( SELECT dh.commission_header_id
3255: FROM cn_commission_headers_all dh,
3256: cn_process_batches_all batch

Line 3255: FROM cn_commission_headers_all dh,

3251: ELSE
3252: DELETE cn_commission_headers_all head
3253: WHERE head.commission_header_id IN
3254: ( SELECT dh.commission_header_id
3255: FROM cn_commission_headers_all dh,
3256: cn_process_batches_all batch
3257: WHERE batch.physical_batch_id = p_batch_id
3258: AND dh.org_id = batch.org_id
3259: AND batch.salesrep_id = dh.direct_salesrep_id

Line 3266: UPDATE cn_commission_headers_all up_header

3262: END IF;
3263: END IF;
3264:
3265: IF (l_unique_flag = 'N') THEN
3266: UPDATE cn_commission_headers_all up_header
3267: SET status = 'COL',
3268: revenue_class_id = decode(substr(pre_processed_code,1,1), 'C', NULL, revenue_class_id),
3269: parent_header_id = NULL,
3270: last_update_date = sysdate,

Line 3275: FROM cn_commission_headers_all header,

3271: last_updated_by = g_last_updated_by,
3272: last_update_login = g_last_update_login
3273: WHERE up_header.commission_header_id IN
3274: ( SELECT header.commission_header_id
3275: FROM cn_commission_headers_all header,
3276: cn_process_batches_all batch
3277: WHERE batch.physical_batch_id = p_batch_id
3278: AND batch.salesrep_id = header.direct_salesrep_id
3279: AND header.org_id = batch.org_id

Line 3285: UPDATE cn_commission_headers_all

3281: AND header.processed_date BETWEEN batch.start_date AND batch.end_date
3282: AND ((p_calc_type ='FORECAST' AND header.trx_type = 'FORECAST')
3283: OR (p_calc_type = 'COMMISSION' AND header.trx_type NOT IN ('BONUS','FORECAST')) ) );
3284: ELSE
3285: UPDATE cn_commission_headers_all
3286: SET status = 'COL',
3287: revenue_class_id = decode(substr(pre_processed_code,1,1), 'C', NULL, revenue_class_id),
3288: parent_header_id = NULL,
3289: last_update_date = sysdate,

Line 3363: delete from cn_commission_headers_all

3359: revert_posting_line(l_post_line.commission_line_id);
3360: end loop;
3361:
3362: -- delete header lines
3363: delete from cn_commission_headers_all
3364: where commission_header_id in (
3365: select cl.commission_header_id
3366: from cn_commission_lines_all cl,
3367: cn_process_batches_all batch

Line 3554: INSERT INTO cn_commission_headers_all

3550: SELECT role_id, org_id INTO l_role_id, l_org_id
3551: FROM cn_srp_plan_assigns_all
3552: WHERE srp_plan_assign_id = p_trx_rec.srp_plan_assign_id;
3553:
3554: INSERT INTO cn_commission_headers_all
3555: (commission_header_id, direct_salesrep_id, processed_date,
3556: processed_period_id, trx_type, status, quota_id,
3557: last_update_date, last_updated_by, creation_date,
3558: created_by, last_update_login, org_id )