DBA Data[Home] [Help]

APPS.OE_ERROR_WF dependencies on FND_DATE

Line 2472: l_activity_error_date_from := fnd_date.canonical_to_date(p_activity_error_date_from);

2468: IF l_debug_level > 0 THEN
2469: oe_debug_pub.add('Entering EM_Batch_Retry_Conc_Pgm');
2470: END IF;
2471: retcode := 0;
2472: l_activity_error_date_from := fnd_date.canonical_to_date(p_activity_error_date_from);
2473: l_activity_error_date_to := fnd_date.canonical_to_date(p_activity_error_date_to) + 1 - 1/(24*60*60);
2474: SELECT display_name
2475: INTO l_item_type_display_name
2476: FROM wf_item_types_vl

Line 2473: l_activity_error_date_to := fnd_date.canonical_to_date(p_activity_error_date_to) + 1 - 1/(24*60*60);

2469: oe_debug_pub.add('Entering EM_Batch_Retry_Conc_Pgm');
2470: END IF;
2471: retcode := 0;
2472: l_activity_error_date_from := fnd_date.canonical_to_date(p_activity_error_date_from);
2473: l_activity_error_date_to := fnd_date.canonical_to_date(p_activity_error_date_to) + 1 - 1/(24*60*60);
2474: SELECT display_name
2475: INTO l_item_type_display_name
2476: FROM wf_item_types_vl
2477: WHERE name = p_item_type;