DBA Data[Home] [Help]

APPS.EDW_COLLECTION_UTIL dependencies on FND_DATE

Line 209: || fnd_date.date_to_displaydt (g_start_time),FND_LOG.LEVEL_PROCEDURE

205: );
206: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
207: edw_log.put_line (
208: 'System time at the start of the process is :'
209: || fnd_date.date_to_displaydt (g_start_time),FND_LOG.LEVEL_PROCEDURE
210: );
211: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
212:
213:

Line 857: l_date := fnd_date.date_to_displaydt (SYSDATE);

853: c_item_key VARCHAR2 (50);
854: c_process VARCHAR2 (30);
855: BEGIN
856: put_debug_msg ('************* Running sendnote procedure');
857: l_date := fnd_date.date_to_displaydt (SYSDATE);
858: l_username := NVL (fnd_profile.VALUE ('EDW_WF_ROLE'), 'MFG');
859: c_item_type := 'EDW_NOTE';
860: c_item_key := NVL (name_of_conc_program, '1')
861: || NVL (TYPE, '1')

Line 998: fnd_date.displaydt_to_date (

994: BEGIN
995:
996: -- for bug 2135826
997: g_local_last_push_start_date :=
998: fnd_date.displaydt_to_date (
999: get_last_push_date (p_staging_table_name)
1000: );
1001:
1002:

Line 1039: fnd_date.date_to_displaydt (g_local_curr_push_start_date)

1035: || g_instance_code
1036: );
1037: put_debug_msg (' Start push time in wh clock IS :');
1038: put_debug_msg (
1039: fnd_date.date_to_displaydt (g_local_curr_push_start_date)
1040: );
1041: put_debug_msg (' Last local_push_start_date IS : ');
1042: put_debug_msg (
1043: fnd_date.date_to_displaydt (g_local_last_push_start_date)

Line 1043: fnd_date.date_to_displaydt (g_local_last_push_start_date)

1039: fnd_date.date_to_displaydt (g_local_curr_push_start_date)
1040: );
1041: put_debug_msg (' Last local_push_start_date IS : ');
1042: put_debug_msg (
1043: fnd_date.date_to_displaydt (g_local_last_push_start_date)
1044: );
1045: put_debug_msg ( 'User ID is :'
1046: || g_user_id);
1047: put_debug_msg ( 'Login ID is :'

Line 1213: put_debug_msg (fnd_date.date_to_displaydt (g_wh_curr_push_end_date));

1209:
1210: DBMS_SQL.close_cursor (l_cursor);
1211: g_local_curr_push_end_date := SYSDATE;
1212: put_debug_msg (' G_wh_curr_push_end_date IS :');
1213: put_debug_msg (fnd_date.date_to_displaydt (g_wh_curr_push_end_date));
1214: put_debug_msg ('********** End Procedure : Set_Push_End_Dates');
1215: END set_push_end_dates;
1216:
1217:

Line 1592: l_datedt := fnd_date.date_to_displaydt (l_date);

1588: END IF;
1589:
1590: DBMS_SQL.close_cursor (l_cid);
1591: l_date := NVL (l_date, TO_DATE ('01/01/1950', 'MM/DD/YYYY'));
1592: l_datedt := fnd_date.date_to_displaydt (l_date);
1593: put_debug_msg ('********** End Function : get_last_push_date');
1594: RETURN l_datedt;
1595: END get_last_push_date;
1596:

Line 2359: edw_log.put_line (fnd_date.date_to_displaydt (SYSDATE),FND_LOG.LEVEL_STATEMENT);

2355: IS
2356: BEGIN
2357: IF g_debug
2358: THEN
2359: edw_log.put_line (fnd_date.date_to_displaydt (SYSDATE),FND_LOG.LEVEL_STATEMENT);
2360: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
2361: END IF;
2362: END put_timestamp;
2363: