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 830: DELETE cn_commission_headers_all

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

Line 1886: cn_commission_headers_all ch

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

Line 1902: from cn_commission_headers_all amthead,

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

Line 1915: cn_commission_headers_all ch

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

Line 2206: FROM cn_commission_headers_all

2202: FROM cn_commission_lines_all
2203: WHERE status = 'OBSOLETE'
2204: and posting_status = 'UNPOSTED'
2205: and (commission_header_id = (SELECT reversal_header_id
2206: FROM cn_commission_headers_all
2207: WHERE commission_header_id = p_commission_header_id)
2208: OR commission_header_id = (SELECT parent_header_id
2209: FROM cn_commission_headers_all
2210: WHERE commission_header_id = (SELECT reversal_header_id

Line 2209: FROM cn_commission_headers_all

2205: and (commission_header_id = (SELECT reversal_header_id
2206: FROM cn_commission_headers_all
2207: WHERE commission_header_id = p_commission_header_id)
2208: OR commission_header_id = (SELECT parent_header_id
2209: FROM cn_commission_headers_all
2210: WHERE commission_header_id = (SELECT reversal_header_id
2211: FROM cn_commission_headers_all
2212: WHERE commission_header_id = p_commission_header_id)));
2213:

Line 2211: FROM cn_commission_headers_all

2207: WHERE commission_header_id = p_commission_header_id)
2208: OR commission_header_id = (SELECT parent_header_id
2209: FROM cn_commission_headers_all
2210: WHERE commission_header_id = (SELECT reversal_header_id
2211: FROM cn_commission_headers_all
2212: WHERE commission_header_id = p_commission_header_id)));
2213:
2214: CURSOR l_orig_posted_trx IS
2215: SELECT commission_line_id

Line 2218: FROM cn_commission_headers_all

2214: CURSOR l_orig_posted_trx IS
2215: SELECT commission_line_id
2216: FROM cn_commission_lines_all
2217: WHERE (commission_header_id = (SELECT reversal_header_id
2218: FROM cn_commission_headers_all
2219: WHERE commission_header_id = p_commission_header_id)
2220: OR commission_header_id = (SELECT parent_header_id
2221: FROM cn_commission_headers_all
2222: WHERE commission_header_id = (SELECT reversal_header_id

Line 2221: FROM cn_commission_headers_all

2217: WHERE (commission_header_id = (SELECT reversal_header_id
2218: FROM cn_commission_headers_all
2219: WHERE commission_header_id = p_commission_header_id)
2220: OR commission_header_id = (SELECT parent_header_id
2221: FROM cn_commission_headers_all
2222: WHERE commission_header_id = (SELECT reversal_header_id
2223: FROM cn_commission_headers_all
2224: WHERE commission_header_id = p_commission_header_id)))
2225:

Line 2223: FROM cn_commission_headers_all

2219: WHERE commission_header_id = p_commission_header_id)
2220: OR commission_header_id = (SELECT parent_header_id
2221: FROM cn_commission_headers_all
2222: WHERE commission_header_id = (SELECT reversal_header_id
2223: FROM cn_commission_headers_all
2224: WHERE commission_header_id = p_commission_header_id)))
2225:
2226: AND status = 'CALC'
2227: AND posting_status = 'POSTED';

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

2234: -- update all trx generated from the original commission_header line
2235: -- to be obsolete
2236: UPDATE cn_commission_lines_all
2237: SET status = 'OBSOLETE', posting_status = 'UNPOSTED'
2238: WHERE (commission_header_id = (SELECT reversal_header_id FROM cn_commission_headers_all
2239: WHERE commission_header_id = p_commission_header_id)
2240: OR commission_header_id = (SELECT parent_header_id
2241: FROM cn_commission_headers_all
2242: WHERE commission_header_id = (SELECT reversal_header_id

Line 2241: FROM cn_commission_headers_all

2237: SET status = 'OBSOLETE', posting_status = 'UNPOSTED'
2238: WHERE (commission_header_id = (SELECT reversal_header_id FROM cn_commission_headers_all
2239: WHERE commission_header_id = p_commission_header_id)
2240: OR commission_header_id = (SELECT parent_header_id
2241: FROM cn_commission_headers_all
2242: WHERE commission_header_id = (SELECT reversal_header_id
2243: FROM cn_commission_headers_all
2244: WHERE commission_header_id = p_commission_header_id)));
2245:

Line 2243: FROM cn_commission_headers_all

2239: WHERE commission_header_id = p_commission_header_id)
2240: OR commission_header_id = (SELECT parent_header_id
2241: FROM cn_commission_headers_all
2242: WHERE commission_header_id = (SELECT reversal_header_id
2243: FROM cn_commission_headers_all
2244: WHERE commission_header_id = p_commission_header_id)));
2245:
2246: FOR rep IN c_affected_reps LOOP
2247: cn_mark_events_pkg.mark_notify

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

2290: -( Nvl(line.output_achieved,0)), -( Nvl(line.perf_achieved,0)),
2291: line.pay_period_id, line.pending_status,
2292: line.role_id, line.pending_date, line.credited_comp_group_id, line.org_id
2293: FROM cn_commission_lines_all line
2294: WHERE (line.commission_header_id = (SELECT reversal_header_id FROM cn_commission_headers_all
2295: WHERE commission_header_id = p_commission_header_id)
2296: OR line.commission_header_id = (SELECT parent_header_id
2297: FROM cn_commission_headers_all
2298: WHERE commission_header_id = (SELECT reversal_header_id

Line 2297: FROM cn_commission_headers_all

2293: FROM cn_commission_lines_all line
2294: WHERE (line.commission_header_id = (SELECT reversal_header_id FROM cn_commission_headers_all
2295: WHERE commission_header_id = p_commission_header_id)
2296: OR line.commission_header_id = (SELECT parent_header_id
2297: FROM cn_commission_headers_all
2298: WHERE commission_header_id = (SELECT reversal_header_id
2299: FROM cn_commission_headers_all
2300: WHERE commission_header_id = p_commission_header_id)));
2301:

Line 2299: FROM cn_commission_headers_all

2295: WHERE commission_header_id = p_commission_header_id)
2296: OR line.commission_header_id = (SELECT parent_header_id
2297: FROM cn_commission_headers_all
2298: WHERE commission_header_id = (SELECT reversal_header_id
2299: FROM cn_commission_headers_all
2300: WHERE commission_header_id = p_commission_header_id)));
2301:
2302: -- update commission_header.status to be 'OBSOLETE'
2303: UPDATE cn_commission_headers_all ch SET

Line 2303: UPDATE cn_commission_headers_all ch SET

2299: FROM cn_commission_headers_all
2300: WHERE commission_header_id = p_commission_header_id)));
2301:
2302: -- update commission_header.status to be 'OBSOLETE'
2303: UPDATE cn_commission_headers_all ch SET
2304: ch.status = 'OBSOLETE',
2305: -- clku, update the last updated info
2306: last_update_date = sysdate,
2307: last_updated_by = G_LAST_UPDATED_BY,

Line 2311: UPDATE cn_commission_headers_all ch SET

2307: last_updated_by = G_LAST_UPDATED_BY,
2308: last_update_login = G_LAST_UPDATE_LOGIN
2309: WHERE commission_header_id = p_commission_header_id;
2310:
2311: UPDATE cn_commission_headers_all ch SET
2312: ch.status = 'OBSOLETE',
2313: -- clku, update the last updated info
2314: last_update_date = sysdate,
2315: last_updated_by = G_LAST_UPDATED_BY,

Line 2319: FROM cn_commission_headers_all head

2315: last_updated_by = G_LAST_UPDATED_BY,
2316: last_update_login = G_LAST_UPDATE_LOGIN
2317: WHERE commission_header_id
2318: IN (SELECT head.reversal_header_id
2319: FROM cn_commission_headers_all head
2320: WHERE head.commission_header_id = p_commission_header_id );
2321:
2322: -- delete sum trx
2323: DELETE FROM cn_commission_headers_all

Line 2323: DELETE FROM cn_commission_headers_all

2319: FROM cn_commission_headers_all head
2320: WHERE head.commission_header_id = p_commission_header_id );
2321:
2322: -- delete sum trx
2323: DELETE FROM cn_commission_headers_all
2324: WHERE commission_header_id = (SELECT parent_header_id
2325: FROM cn_commission_headers_all
2326: WHERE commission_header_id = (SELECT reversal_header_id
2327: FROM cn_commission_headers_all

Line 2325: FROM cn_commission_headers_all

2321:
2322: -- delete sum trx
2323: DELETE FROM cn_commission_headers_all
2324: WHERE commission_header_id = (SELECT parent_header_id
2325: FROM cn_commission_headers_all
2326: WHERE commission_header_id = (SELECT reversal_header_id
2327: FROM cn_commission_headers_all
2328: WHERE commission_header_id = p_commission_header_id));
2329: -- for source trxs of the sum trx, set their parent_header_id = null

Line 2327: FROM cn_commission_headers_all

2323: DELETE FROM cn_commission_headers_all
2324: WHERE commission_header_id = (SELECT parent_header_id
2325: FROM cn_commission_headers_all
2326: WHERE commission_header_id = (SELECT reversal_header_id
2327: FROM cn_commission_headers_all
2328: WHERE commission_header_id = p_commission_header_id));
2329: -- for source trxs of the sum trx, set their parent_header_id = null
2330: UPDATE cn_commission_headers_all
2331: SET parent_header_id = NULL,

Line 2330: UPDATE cn_commission_headers_all

2326: WHERE commission_header_id = (SELECT reversal_header_id
2327: FROM cn_commission_headers_all
2328: WHERE commission_header_id = p_commission_header_id));
2329: -- for source trxs of the sum trx, set their parent_header_id = null
2330: UPDATE cn_commission_headers_all
2331: SET parent_header_id = NULL,
2332: -- clku, update the last updated info
2333: last_update_date = sysdate,
2334: last_updated_by = G_LAST_UPDATED_BY,

Line 2337: FROM cn_commission_headers_all

2333: last_update_date = sysdate,
2334: last_updated_by = G_LAST_UPDATED_BY,
2335: last_update_login = G_LAST_UPDATE_LOGIN
2336: WHERE parent_header_id = (SELECT parent_header_id
2337: FROM cn_commission_headers_all
2338: WHERE commission_header_id = (SELECT reversal_header_id
2339: FROM cn_commission_headers_all
2340: WHERE commission_header_id = p_commission_header_id));
2341: END handle_reversal_trx;

Line 2339: FROM cn_commission_headers_all

2335: last_update_login = G_LAST_UPDATE_LOGIN
2336: WHERE parent_header_id = (SELECT parent_header_id
2337: FROM cn_commission_headers_all
2338: WHERE commission_header_id = (SELECT reversal_header_id
2339: FROM cn_commission_headers_all
2340: WHERE commission_header_id = p_commission_header_id));
2341: END handle_reversal_trx;
2342:
2343: -- delete/update derived commission_lines

Line 2359: FROM cn_commission_headers_all

2355: CURSOR l_posted_trxs_csr2 IS
2356: SELECT commission_line_id
2357: FROM cn_commission_lines_all
2358: WHERE commission_header_id = (SELECT parent_header_id
2359: FROM cn_commission_headers_all
2360: WHERE commission_header_id = p_commission_header_id)
2361: AND posting_status = 'POSTED'
2362: AND status = 'CALC';
2363: BEGIN

Line 2378: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2374: DELETE cn_commission_lines_all
2375: WHERE commission_header_id = p_commission_header_id;
2376:
2377: DELETE cn_commission_lines_all
2378: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2379: WHERE commission_header_id = p_commission_header_id);
2380:
2381: DELETE cn_commission_headers_all
2382: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

Line 2381: DELETE cn_commission_headers_all

2377: DELETE cn_commission_lines_all
2378: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2379: WHERE commission_header_id = p_commission_header_id);
2380:
2381: DELETE cn_commission_headers_all
2382: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2383: WHERE commission_header_id = p_commission_header_id);
2384:
2385: UPDATE cn_commission_headers_all

Line 2382: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2378: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2379: WHERE commission_header_id = p_commission_header_id);
2380:
2381: DELETE cn_commission_headers_all
2382: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2383: WHERE commission_header_id = p_commission_header_id);
2384:
2385: UPDATE cn_commission_headers_all
2386: SET parent_header_id = NULL,

Line 2385: UPDATE cn_commission_headers_all

2381: DELETE cn_commission_headers_all
2382: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2383: WHERE commission_header_id = p_commission_header_id);
2384:
2385: UPDATE cn_commission_headers_all
2386: SET parent_header_id = NULL,
2387: last_update_date = sysdate,
2388: last_updated_by = G_LAST_UPDATED_BY,
2389: last_update_login = G_LAST_UPDATE_LOGIN

Line 2390: WHERE parent_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2386: SET parent_header_id = NULL,
2387: last_update_date = sysdate,
2388: last_updated_by = G_LAST_UPDATED_BY,
2389: last_update_login = G_LAST_UPDATE_LOGIN
2390: WHERE parent_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2391: WHERE commission_header_id = p_commission_header_id);
2392:
2393: ELSIF p_revert_state = 'ROLL' THEN
2394: -- revert posted line before deleting any commission lines

Line 2408: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2404: WHERE commission_header_id = p_commission_header_id
2405: AND created_during IN ( 'POP', 'CALC');
2406:
2407: DELETE cn_commission_lines_all
2408: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2409: WHERE commission_header_id = p_commission_header_id);
2410:
2411: DELETE cn_commission_headers_all
2412: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

Line 2411: DELETE cn_commission_headers_all

2407: DELETE cn_commission_lines_all
2408: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2409: WHERE commission_header_id = p_commission_header_id);
2410:
2411: DELETE cn_commission_headers_all
2412: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2413: WHERE commission_header_id = p_commission_header_id);
2414:
2415: UPDATE cn_commission_headers_all

Line 2412: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2408: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2409: WHERE commission_header_id = p_commission_header_id);
2410:
2411: DELETE cn_commission_headers_all
2412: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2413: WHERE commission_header_id = p_commission_header_id);
2414:
2415: UPDATE cn_commission_headers_all
2416: SET parent_header_id = NULL,

Line 2415: UPDATE cn_commission_headers_all

2411: DELETE cn_commission_headers_all
2412: WHERE commission_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2413: WHERE commission_header_id = p_commission_header_id);
2414:
2415: UPDATE cn_commission_headers_all
2416: SET parent_header_id = NULL,
2417: last_update_date = sysdate,
2418: last_updated_by = G_LAST_UPDATED_BY,
2419: last_update_login = G_LAST_UPDATE_LOGIN

Line 2420: WHERE parent_header_id = (SELECT parent_header_id FROM cn_commission_headers_all

2416: SET parent_header_id = NULL,
2417: last_update_date = sysdate,
2418: last_updated_by = G_LAST_UPDATED_BY,
2419: last_update_login = G_LAST_UPDATE_LOGIN
2420: WHERE parent_header_id = (SELECT parent_header_id FROM cn_commission_headers_all
2421: WHERE commission_header_id = p_commission_header_id);
2422:
2423: UPDATE cn_commission_lines_all
2424: SET status = 'ROLL',

Line 2541: FROM cn_commission_headers_all header

2537: SELECT line.commission_line_id
2538: FROM cn_commission_lines_all line
2539: WHERE line.commission_header_id
2540: IN ( SELECT header.commission_header_id
2541: FROM cn_commission_headers_all header
2542: WHERE header.direct_salesrep_id = l_salesrep_id
2543: AND header.processed_period_id = l_period_id
2544: AND header.processed_date BETWEEN l_start_date AND l_end_date
2545: AND header.status = 'ROLL'

Line 2580: FROM cn_commission_headers_all ch

2576: and cl.org_id = l_org_id
2577: AND cl.processed_date BETWEEN p_start_date AND p_end_date
2578: AND ((p_role_id IS NOT NULL AND cl.role_id = p_role_id ) OR p_role_id IS NULL)
2579: AND exists ( SELECT 1
2580: FROM cn_commission_headers_all ch
2581: WHERE ch.commission_header_id = cl.commission_header_id
2582: AND ch.comp_group_id = p_base_comp_group_id
2583: AND ( p_base_salesrep_id IS NULL OR ch.direct_salesrep_id = p_base_salesrep_id));
2584:

Line 2602: FROM cn_commission_headers_all ch

2598: 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))
2599: ) OR (p_role_id IS NULL AND cl.credited_salesrep_id = p_salesrep_id))
2600: AND exists
2601: ( SELECT 1
2602: FROM cn_commission_headers_all ch
2603: WHERE ch.commission_header_id = cl.commission_header_id
2604: AND ch.comp_group_id = p_comp_group_id );
2605:
2606:

Line 2753: FROM cn_commission_headers_all ch

2749: AND ( (l_log.role_id IS NOT NULL AND cl.role_id = l_log.role_id )
2750: OR l_log.role_id IS NULL )
2751: AND exists
2752: (SELECT 1
2753: FROM cn_commission_headers_all ch
2754: WHERE ch.commission_header_id = cl.commission_header_id
2755: AND ch.comp_group_id = l_log.base_comp_group_id
2756: AND ( l_log.base_salesrep_id IS NULL
2757: OR ch.direct_salesrep_id = l_log.base_salesrep_id)

Line 2787: FROM cn_commission_headers_all ch

2783: (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))
2784: )OR (l_log.role_id IS NULL and cl.credited_salesrep_id = l_log.salesrep_id))
2785: AND exists
2786: ( SELECT 1
2787: FROM cn_commission_headers_all ch
2788: WHERE ch.commission_header_id = cl.commission_header_id
2789: AND ch.comp_group_id = l_log.comp_group_id );
2790:
2791: ELSIF l_log.action = 'DELETE_DEST_XROLL' THEN

Line 2807: UPDATE cn_commission_headers_all ch

2803: AND cl.org_id = l_org_id
2804: AND ( (l_log.role_id IS NOT NULL AND cl.role_id = l_log.role_id )
2805: OR l_log.role_id IS NULL );
2806:
2807: UPDATE cn_commission_headers_all ch
2808: SET status = 'XROLL',
2809: last_update_date = sysdate,
2810: last_updated_by = g_last_updated_by,
2811: last_update_login = g_last_update_login

Line 3042: UPDATE cn_commission_headers_all

3038: AND header.trx_type NOT IN ('FORECAST', 'BONUS')
3039: AND header.org_id = l_org_id );
3040:
3041: -- 3). update header trx status to be 'CLS' ('CLS_SUM' if rolling up summarized trxs)
3042: UPDATE cn_commission_headers_all
3043: SET status = decode(parent_header_id, -1, 'CLS_SUM', 'CLS'),
3044: last_update_date = sysdate,
3045: last_updated_by = g_last_updated_by,
3046: last_update_login = g_last_update_login

Line 3081: DELETE cn_commission_headers_all header

3077:
3078:
3079: -- 2). delete 'GRP' trx created in commission_headers
3080: -- need to delete 'GRP' trxs in commission_header since its counterpart in line has been deleted
3081: DELETE cn_commission_headers_all header
3082: WHERE header.direct_salesrep_id = l_log.salesrep_id
3083: --AND header.processed_date BETWEEN l_log.start_date AND l_log.end_date
3084: AND header.processed_period_id = l_log.period_id
3085: AND header.trx_type IN ('ITD', 'GRP')

Line 3228: delete cn_commission_headers_all ch

3224: IF p_calc_type = 'COMMISSION' THEN
3225: -- need to delete 'ITD','GRP' trxs in commission_header since its counterpart in line has been deleted
3226: -- bonus trx are all non accumulative, so 'ITD', 'GRP' doesn't apply.
3227: IF (l_unique_flag = 'Y') THEN
3228: delete cn_commission_headers_all ch
3229: where ch.direct_salesrep_id in (select salesrep_id
3230: from cn_process_batches_all
3231: where physical_batch_id = p_batch_id)
3232: and ch.processed_date between l_start_date and l_end_date

Line 3236: DELETE cn_commission_headers_all head

3232: and ch.processed_date between l_start_date and l_end_date
3233: AND (ch.trx_type IN ('GRP', 'ITD') OR ch.parent_header_id = -1)
3234: and ch.org_id = l_org_id;
3235: ELSE
3236: DELETE cn_commission_headers_all head
3237: WHERE head.commission_header_id IN
3238: ( SELECT dh.commission_header_id
3239: FROM cn_commission_headers_all dh,
3240: cn_process_batches_all batch

Line 3239: FROM cn_commission_headers_all dh,

3235: ELSE
3236: DELETE cn_commission_headers_all head
3237: WHERE head.commission_header_id IN
3238: ( SELECT dh.commission_header_id
3239: FROM cn_commission_headers_all dh,
3240: cn_process_batches_all batch
3241: WHERE batch.physical_batch_id = p_batch_id
3242: AND dh.org_id = batch.org_id
3243: AND batch.salesrep_id = dh.direct_salesrep_id

Line 3250: UPDATE cn_commission_headers_all up_header

3246: END IF;
3247: END IF;
3248:
3249: IF (l_unique_flag = 'N') THEN
3250: UPDATE cn_commission_headers_all up_header
3251: SET status = 'COL',
3252: revenue_class_id = decode(substr(pre_processed_code,1,1), 'C', NULL, revenue_class_id),
3253: parent_header_id = NULL,
3254: last_update_date = sysdate,

Line 3259: FROM cn_commission_headers_all header,

3255: last_updated_by = g_last_updated_by,
3256: last_update_login = g_last_update_login
3257: WHERE up_header.commission_header_id IN
3258: ( SELECT header.commission_header_id
3259: FROM cn_commission_headers_all header,
3260: cn_process_batches_all batch
3261: WHERE batch.physical_batch_id = p_batch_id
3262: AND batch.salesrep_id = header.direct_salesrep_id
3263: AND header.org_id = batch.org_id

Line 3269: UPDATE cn_commission_headers_all

3265: AND header.processed_date BETWEEN batch.start_date AND batch.end_date
3266: AND ((p_calc_type ='FORECAST' AND header.trx_type = 'FORECAST')
3267: OR (p_calc_type = 'COMMISSION' AND header.trx_type NOT IN ('BONUS','FORECAST')) ) );
3268: ELSE
3269: UPDATE cn_commission_headers_all
3270: SET status = 'COL',
3271: revenue_class_id = decode(substr(pre_processed_code,1,1), 'C', NULL, revenue_class_id),
3272: parent_header_id = NULL,
3273: last_update_date = sysdate,

Line 3347: delete from cn_commission_headers_all

3343: revert_posting_line(l_post_line.commission_line_id);
3344: end loop;
3345:
3346: -- delete header lines
3347: delete from cn_commission_headers_all
3348: where commission_header_id in (
3349: select cl.commission_header_id
3350: from cn_commission_lines_all cl,
3351: cn_process_batches_all batch

Line 3525: INSERT INTO cn_commission_headers_all

3521: SELECT role_id, org_id INTO l_role_id, l_org_id
3522: FROM cn_srp_plan_assigns_all
3523: WHERE srp_plan_assign_id = p_trx_rec.srp_plan_assign_id;
3524:
3525: INSERT INTO cn_commission_headers_all
3526: (commission_header_id, direct_salesrep_id, processed_date,
3527: processed_period_id, trx_type, status, quota_id,
3528: last_update_date, last_updated_by, creation_date,
3529: created_by, last_update_login, org_id )