APPS.XDPCORE_FA dependencies on XDP_ERROR_COUNT

Line 5346: FROM xdp_error_count

5342:
5343: --Lock the row so that no body else can read it..
5344: CURSOR cur_error_count IS
5345: SELECT error_count
5346: FROM xdp_error_count
5347: WHERE object_key = p_fp_name
5348: AND object_type = XDP_UTILITIES.g_fp_object_type FOR UPDATE;
5349:
5350: BEGIN

Line 5432: FROM xdp_error_count

5428:
5429: --Lock the row so that no body else can read it..
5430: CURSOR cur_error_count IS
5431: SELECT error_count
5432: FROM xdp_error_count
5433: WHERE object_key = p_fp_name
5434: AND object_type = XDP_UTILITIES.g_fp_object_type FOR UPDATE;
5435:
5436: BEGIN

Line 5468: UPDATE xdp_error_count

5464: -- we have to update the error count in any case..
5465:
5466: lv_error_count := lv_error_count + 1;
5467:
5468: UPDATE xdp_error_count
5469: SET error_count = lv_error_count,
5470: last_updated_by = FND_GLOBAL.USER_ID,
5471: last_update_date = sysdate,
5472: last_update_login = FND_GLOBAL.USER_ID

Line 5482: INSERT INTO XDP_ERROR_COUNT(

5478:
5479: -- If there is no row for this fp_name then the FP has never gone into error..
5480: -- So insert the first record with error count 1..
5481: IF lv_no_data_found = 0 THEN
5482: INSERT INTO XDP_ERROR_COUNT(
5483: object_type,
5484: object_key,
5485: error_count,
5486: created_by,

Line 5525: FROM xdp_error_count

5521:
5522: --Lock the row so that no body else can read it..
5523: CURSOR cur_error_count IS
5524: SELECT error_count
5525: FROM xdp_error_count
5526: WHERE object_key = p_fp_name
5527: AND object_type = XDP_UTILITIES.g_fp_object_type FOR UPDATE;
5528:
5529: BEGIN

Line 5565: UPDATE xdp_error_count

5561: AND status_code = XDP_UTILITIES.g_system_hold;
5562: END IF;
5563:
5564: -- finally set the error count to Zero..
5565: UPDATE xdp_error_count
5566: SET error_count = 0,
5567: last_updated_by = FND_GLOBAL.USER_ID,
5568: last_update_date = sysdate,
5569: last_update_login = FND_GLOBAL.USER_ID