APPS.IEC_REPORTS_PVT dependencies on IEC_G_MKTG_ITEM_CC_TZS

Line 30: /* Reset record counts for subsets in IEC_G_REP_SUBSET_COUNTS and IEC_G_MKTG_ITEM_CC_TZS

26:
27: END Log;
28:
29:
30: /* Reset record counts for subsets in IEC_G_REP_SUBSET_COUNTS and IEC_G_MKTG_ITEM_CC_TZS
31: Three entry points - Reset_AllRecordCounts
32: - Reset_CampaignRecordCounts
33: - Reset_ListRecordCounts
34: */

Line 237: --Update Record Counts by CC_TZ_ID in IEC_G_MKTG_ITEM_CC_TZS (Used to derive available and unavailable record counts)

233: , l_subset_id_col
234: , l_subset_record_loaded_col
235: , l_subset_record_called_col);
236:
237: --Update Record Counts by CC_TZ_ID in IEC_G_MKTG_ITEM_CC_TZS (Used to derive available and unavailable record counts)
238: BEGIN
239:
240: EXECUTE IMMEDIATE
241: 'BEGIN

Line 254: 'UPDATE IEC_G_MKTG_ITEM_CC_TZS

250: , OUT l_cc_tz_count_col
251: , p_list_id;
252:
253: EXECUTE IMMEDIATE
254: 'UPDATE IEC_G_MKTG_ITEM_CC_TZS
255: SET RECORD_COUNT = 0
256: , LAST_UPDATE_DATE = SYSDATE
257: WHERE LIST_HEADER_ID = :list_id'
258: USING p_list_id;

Line 262: UPDATE IEC_G_MKTG_ITEM_CC_TZS

258: USING p_list_id;
259:
260: IF l_cc_tz_id_col IS NOT NULL AND l_cc_tz_id_col.COUNT > 0 THEN
261: FORALL i IN 1..l_cc_tz_id_col.LAST
262: UPDATE IEC_G_MKTG_ITEM_CC_TZS
263: SET RECORD_COUNT = l_cc_tz_count_col(i)
264: , LAST_UPDATE_DATE = SYSDATE
265: WHERE ITM_CC_TZ_ID = l_cc_tz_id_col(i);
266:

Line 271: Log( 'Reset of record counts in IEC_G_MKTG_ITEM_CC_TZS for list ' || p_list_id

267: END IF;
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: Log( 'Reset of record counts in IEC_G_MKTG_ITEM_CC_TZS for list ' || p_list_id
272: , 'Reset_ListRecordCounts'
273: , 'UPDATE_CALLABLE_ZONE_COUNTS'
274: , SQLCODE
275: , SQLERRM