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

Line 2068: /* -- obsolete the corresponding record in cn_commission_headers_all */

2064: errbuf := 'CN_SCATM_TAE_PUB.process_new_txns.others';
2065: END process_new_txns;
2066:
2067: /* This procedure does the following for txns that have been loaded for calc */
2068: /* -- obsolete the corresponding record in cn_commission_headers_all */
2069: /* -- create a reversal entry in cn_comm_lines_api_all */
2070: PROCEDURE api_negate_record(
2071: p_api_id_tbl IN OUT NOCOPY g_comm_lines_api_id_tbl_type
2072: , p_rowid_tbl IN OUT NOCOPY g_rowid_tbl_type

Line 2442: FROM cn_comm_lines_api ccla, cn_commission_headers_all ccha

2438: , ccla.split_status
2439: , ccla.org_id
2440: , ccla.terr_id
2441: , ccla.terr_name
2442: FROM cn_comm_lines_api ccla, cn_commission_headers_all ccha
2443: WHERE ccla.ROWID = p_rowid_tbl(i)
2444: AND ccha.comm_lines_api_id = ccla.comm_lines_api_id
2445: AND (ccha.adjust_status NOT IN('FROZEN', 'REVERSAL')) --OR(adjust_status IS NULL))
2446: AND ccha.trx_type NOT IN('ITD', 'GRP', 'THR');

Line 2453: FROM cn_commission_headers_all

2449: UPDATE cn_commission_headers
2450: SET adjust_status = 'FROZEN'
2451: , reversal_header_id =
2452: (SELECT commission_header_id
2453: FROM cn_commission_headers_all
2454: WHERE comm_lines_api_id = p_api_id_tbl(i)
2455: AND (adjust_status NOT IN('FROZEN', 'REVERSAL'))-- OR(adjust_status IS NULL))
2456: AND trx_type NOT IN('ITD', 'GRP', 'THR'))
2457: , reversal_flag = 'Y'