APPS.CN_FORMULA_COMMON_PKG dependencies on CN_NOTIFY_LOG_ALL

Line 1759: FROM cn_notify_log_all

1755: order by spq.srp_plan_assign_id, qa.quota_sequence;
1756:
1757: CURSOR l_check_calc_entry_csr (l_salesrep_id NUMBER, l_period_id NUMBER ) IS
1758: SELECT 1
1759: FROM cn_notify_log_all
1760: WHERE (salesrep_id = l_salesrep_id OR salesrep_id = -1000)
1761: AND period_id = l_period_id
1762: AND revert_state = 'CALC'
1763: AND status = 'INCOMPLETE'

Line 1774: FROM cn_notify_log_all nlog

1770: CURSOR l_notify_log_csr (l_salesrep_id NUMBER,
1771: l_period_id NUMBER,
1772: l_quota_id number ) IS
1773: SELECT 1
1774: FROM cn_notify_log_all nlog
1775: WHERE nlog.salesrep_id = l_salesrep_id
1776: AND nlog.period_id = l_period_id
1777: AND nlog.status = 'INCOMPLETE'
1778: AND nlog.quota_id = l_quota_id

Line 2099: UPDATE cn_notify_log_all Log

2095:
2096: commit;
2097:
2098: -- obsolete the entries in cn_notify_log for single salesrep_id, for all salesrep entries, those are handled in processor
2099: UPDATE cn_notify_log_all Log
2100: SET Log.status = 'COMPLETE'
2101: WHERE Log.notify_log_id IN
2102: (SELECT log2.notify_log_id
2103: FROM cn_notify_log_all log2,

Line 2103: FROM cn_notify_log_all log2,

2099: UPDATE cn_notify_log_all Log
2100: SET Log.status = 'COMPLETE'
2101: WHERE Log.notify_log_id IN
2102: (SELECT log2.notify_log_id
2103: FROM cn_notify_log_all log2,
2104: cn_process_batches_all batch
2105: WHERE batch.physical_batch_id = p_physical_batch_id
2106: AND log2.org_id = batch.org_id
2107: AND log2.salesrep_id = batch.salesrep_id

Line 2114: UPDATE cn_notify_log_all Log

2110: AND log2.start_date >= batch.start_date);
2111: commit;
2112:
2113: -- Update all records in notify log that are related to Hierarchical changes.
2114: UPDATE cn_notify_log_all Log
2115: SET Log.status = 'COMPLETE'
2116: WHERE Log.notify_log_id IN (
2117: SELECT event.notify_log_id
2118: FROM cn_notify_log_all event

Line 2118: FROM cn_notify_log_all event

2114: UPDATE cn_notify_log_all Log
2115: SET Log.status = 'COMPLETE'
2116: WHERE Log.notify_log_id IN (
2117: SELECT event.notify_log_id
2118: FROM cn_notify_log_all event
2119: WHERE event.physical_batch_id = p_physical_batch_id
2120: AND event.action IN ('SOURCE_CLS', 'XROLL', 'ROLL_PULL', 'DELETE_ROLL_PULL')
2121: AND event.status = 'INCOMPLETE'
2122: UNION

Line 2124: FROM cn_notify_log_all event, cn_process_batches_all batch

2120: AND event.action IN ('SOURCE_CLS', 'XROLL', 'ROLL_PULL', 'DELETE_ROLL_PULL')
2121: AND event.status = 'INCOMPLETE'
2122: UNION
2123: SELECT event.notify_log_id
2124: FROM cn_notify_log_all event, cn_process_batches_all batch
2125: WHERE batch.physical_batch_id = p_physical_batch_id
2126: AND batch.salesrep_id = event.salesrep_id
2127: AND event.org_id = batch.org_id
2128: AND event.period_id between batch.period_id and batch.end_period_id

Line 2475: cn_notify_log_all Log

2471: Log.revert_state, Log.comp_group_id,
2472: Log.base_salesrep_id, Log.base_comp_group_id,
2473: Log.role_id, Log.action
2474: FROM cn_process_batches_all batch,
2475: cn_notify_log_all Log
2476: WHERE batch.physical_batch_id = p_physical_batch_id
2477: AND log.org_id = batch.org_id
2478: AND Log.period_id BETWEEN batch.period_id AND batch.end_period_id
2479: AND Log.salesrep_id = batch.salesrep_id

Line 2492: cn_notify_log_all Log

2488: Log.revert_state, Log.comp_group_id,
2489: Log.base_salesrep_id, Log.base_comp_group_id,
2490: Log.quota_id
2491: FROM cn_process_batches_all batch,
2492: cn_notify_log_all Log
2493: WHERE batch.physical_batch_id = p_physical_batch_id
2494: AND log.org_id = batch.org_id
2495: AND Log.period_id BETWEEN batch.period_id AND batch.end_period_id
2496: AND ( Log.salesrep_id = batch.salesrep_id

Line 2704: cn_notify_log_all Log

2700: WHERE org_id = l_org_id
2701: AND ( salesrep_id, period_id ) IN
2702: ( SELECT DISTINCT batch.salesrep_id, Log.period_id
2703: FROM cn_process_batches_all batch,
2704: cn_notify_log_all Log
2705: WHERE batch.physical_batch_id = p_physical_batch_id
2706: AND log.org_id = batch.org_id
2707: AND Log.period_id BETWEEN batch.period_id AND batch.end_period_id
2708: AND ( Log.salesrep_id = batch.salesrep_id