eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_SPF_COLLECT_HISTORY_DATA dependencies on FND_DATE

Line 791: p_sr_instance_id, p_collection_method, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date));

787: /*var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCHD', NULL, NULL, FALSE,
788: p_sr_instance_id, p_collection_group, p_collection_method, null, p_date_range_type, p_collection_window, p_char_from_date, p_char_to_date,
789: G_NO, G_NO, G_NO, G_NO, G_YES, G_NO, G_NO, G_NO, G_NO, G_YES, null, null, p_auto_run_download, G_YES);*/
790: var_request_id := fnd_request.submit_request('MSD', 'MSDSPFCSSH', NULL, NULL, FALSE,
791: p_sr_instance_id, p_collection_method, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date));
792: EXCEPTION
793: WHEN OTHERS THEN
794: retcode := -1;
795: errbuf := substr(SQLERRM,1,150);

Line 824: p_sr_instance_id, p_collection_method, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date), G_YES);

820: /* Usage */
821: BEGIN
822: var_request_id := null;
823: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFCSUH', NULL, NULL, FALSE,
824: p_sr_instance_id, p_collection_method, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date), G_YES);
825: EXCEPTION
826: WHEN OTHERS THEN
827: retcode := -1;
828: errbuf := substr(SQLERRM,1,150);

Line 1001: p_sr_instance_id, p_collection_method, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date), p_custom_ibuc_hist_view);

997: THEN
998: BEGIN
999: var_request_id := null;
1000: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFCID', NULL, NULL, FALSE,
1001: p_sr_instance_id, p_collection_method, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date), p_custom_ibuc_hist_view);
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: retcode := -1;
1005: errbuf := substr(SQLERRM,1,150);

Line 1031: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFDSB', NULL, NULL, FALSE, p_sr_instance_id, p_install_base, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date), p_custom_ibuc_hist_view);

1027: IF (p_usage_data = G_YES OR p_install_base = G_YES OR p_shipment_data = G_YES) -- Bug#12675064
1028: THEN
1029: BEGIN
1030: var_request_id := null;
1031: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFDSB', NULL, NULL, FALSE, p_sr_instance_id, p_install_base, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date), p_custom_ibuc_hist_view);
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: retcode := -1;
1035: errbuf := substr(SQLERRM,1,150);

Line 2101: var_from_date := fnd_date.canonical_to_date (p_from_date);

2097: /* Absolute */
2098: IF (p_date_range_type = 1)
2099: THEN
2100:
2101: var_from_date := fnd_date.canonical_to_date (p_from_date);
2102: var_to_date := fnd_date.canonical_to_date (p_to_date);
2103:
2104: /* For Net change, for Absolute type, the field from date should be less than or equal to date If not, log error and exit */
2105: IF (var_from_date > var_to_date)

Line 2102: var_to_date := fnd_date.canonical_to_date (p_to_date);

2098: IF (p_date_range_type = 1)
2099: THEN
2100:
2101: var_from_date := fnd_date.canonical_to_date (p_from_date);
2102: var_to_date := fnd_date.canonical_to_date (p_to_date);
2103:
2104: /* For Net change, for Absolute type, the field from date should be less than or equal to date If not, log error and exit */
2105: IF (var_from_date > var_to_date)
2106: THEN

Line 2722: WHERE fnd_date.canonical_to_date(p_from_date) BETWEEN start_date AND end_date;

2718: /* Get bucket start date for start date */
2719: SELECT start_date
2720: INTO var_from_date_dt
2721: FROM msd_dem_dates
2722: WHERE fnd_date.canonical_to_date(p_from_date) BETWEEN start_date AND end_date;
2723:
2724: /* Get bucket end date for end date */
2725: SELECT end_date
2726: INTO var_to_date_dt

Line 2728: WHERE fnd_date.canonical_to_date(p_to_date) BETWEEN start_date AND end_date;

2724: /* Get bucket end date for end date */
2725: SELECT end_date
2726: INTO var_to_date_dt
2727: FROM msd_dem_dates
2728: WHERE fnd_date.canonical_to_date(p_to_date) BETWEEN start_date AND end_date;
2729:
2730:
2731: ELSE /* Daily system or complete refresh - assign the same dates */
2732:

Line 2733: var_from_date_dt := fnd_date.canonical_to_date(p_from_date);

2729:
2730:
2731: ELSE /* Daily system or complete refresh - assign the same dates */
2732:
2733: var_from_date_dt := fnd_date.canonical_to_date(p_from_date);
2734: var_to_date_dt := fnd_date.canonical_to_date(p_to_date);
2735:
2736: END IF;
2737:

Line 2734: var_to_date_dt := fnd_date.canonical_to_date(p_to_date);

2730:
2731: ELSE /* Daily system or complete refresh - assign the same dates */
2732:
2733: var_from_date_dt := fnd_date.canonical_to_date(p_from_date);
2734: var_to_date_dt := fnd_date.canonical_to_date(p_to_date);
2735:
2736: END IF;
2737:
2738: var_retcode := 0;

Line 3208: x_from_date := fnd_date.canonical_to_date(p_from_date);

3204: else
3205: /* Table to collect spare usage history initially */
3206: x_dest_table := C_SPARE_USAGE_HISTORY_TABLE;
3207:
3208: x_from_date := fnd_date.canonical_to_date(p_from_date);
3209: x_to_date := fnd_date.canonical_to_date(p_to_date);
3210:
3211: msd_dem_common_utilities.log_message (' Collect Spare History Data - Actions');
3212: msd_dem_common_utilities.log_message ('------------------------------------');

Line 3209: x_to_date := fnd_date.canonical_to_date(p_to_date);

3205: /* Table to collect spare usage history initially */
3206: x_dest_table := C_SPARE_USAGE_HISTORY_TABLE;
3207:
3208: x_from_date := fnd_date.canonical_to_date(p_from_date);
3209: x_to_date := fnd_date.canonical_to_date(p_to_date);
3210:
3211: msd_dem_common_utilities.log_message (' Collect Spare History Data - Actions');
3212: msd_dem_common_utilities.log_message ('------------------------------------');
3213: msd_dem_common_utilities.log_message (' ');

Line 3308: x_from_date := fnd_date.canonical_to_date(p_from_date);

3304:
3305: /* Table to collect spare usage history initially */
3306: x_dest_table := C_SPARE_USAGE_HISTORY_TABLE;
3307:
3308: x_from_date := fnd_date.canonical_to_date(p_from_date);
3309: x_to_date := fnd_date.canonical_to_date(p_to_date);
3310:
3311: msd_dem_common_utilities.log_message (' Collect Spare Shipment History - Actions');
3312: msd_dem_common_utilities.log_message ('------------------------------------------');

Line 3309: x_to_date := fnd_date.canonical_to_date(p_to_date);

3305: /* Table to collect spare usage history initially */
3306: x_dest_table := C_SPARE_USAGE_HISTORY_TABLE;
3307:
3308: x_from_date := fnd_date.canonical_to_date(p_from_date);
3309: x_to_date := fnd_date.canonical_to_date(p_to_date);
3310:
3311: msd_dem_common_utilities.log_message (' Collect Spare Shipment History - Actions');
3312: msd_dem_common_utilities.log_message ('------------------------------------------');
3313: msd_dem_common_utilities.log_message (' ');

Line 3417: x_from_date := fnd_date.canonical_to_date(p_from_date);

3413:
3414: -- get demantra time level
3415: x_dm_time_level := lower(msd_dem_common_utilities.dm_time_level);
3416:
3417: x_from_date := fnd_date.canonical_to_date(p_from_date);
3418: x_to_date := fnd_date.canonical_to_date(p_to_date);
3419:
3420: -- get max_sales_date
3421: x_sql := 'select trunc(max(max_date), ''dd'') from ( '||

Line 3418: x_to_date := fnd_date.canonical_to_date(p_to_date);

3414: -- get demantra time level
3415: x_dm_time_level := lower(msd_dem_common_utilities.dm_time_level);
3416:
3417: x_from_date := fnd_date.canonical_to_date(p_from_date);
3418: x_to_date := fnd_date.canonical_to_date(p_to_date);
3419:
3420: -- get max_sales_date
3421: x_sql := 'select trunc(max(max_date), ''dd'') from ( '||
3422: ' select max(sdate) max_date from ' || nvl(p_custom_ibuc_hist_view, 'MSD_SPF_INSTALL_BASE_UC_V') ||

Line 4413: fnd_date.canonical_to_date(p_from_date),

4409: p_series_id,
4410: p_dest_table,
4411: p_sr_instance_id,
4412: p_collection_method,
4413: fnd_date.canonical_to_date(p_from_date),
4414: fnd_date.canonical_to_date(p_to_date),
4415: p_sim_plan_name
4416: );
4417:

Line 4414: fnd_date.canonical_to_date(p_to_date),

4410: p_dest_table,
4411: p_sr_instance_id,
4412: p_collection_method,
4413: fnd_date.canonical_to_date(p_from_date),
4414: fnd_date.canonical_to_date(p_to_date),
4415: p_sim_plan_name
4416: );
4417:
4418: IF (x_retcode = -1) THEN

Line 4853: ' ''' || fnd_date.date_to_canonical(x_from_date) || ''', ' ||

4849: msd_dem_common_utilities.log_debug(x_sql);
4850:
4851: x_params := ' ''MSD'', ''MSDSPFEAMCMRO'', NULL, NULL, FALSE, ' ||
4852: ' ' || p_sr_instance_id || ', ''' || p_collection_group || ''', ' ||
4853: ' ''' || fnd_date.date_to_canonical(x_from_date) || ''', ' ||
4854: ' ''' || fnd_date.date_to_canonical(x_to_date) || ''', ' ||
4855: ' ''' || x_dest_dblink || ''', ' ||
4856: ' ''CMRO'' ';
4857: execute immediate x_sql using out x_errbuf, out x_retcode,

Line 4854: ' ''' || fnd_date.date_to_canonical(x_to_date) || ''', ' ||

4850:
4851: x_params := ' ''MSD'', ''MSDSPFEAMCMRO'', NULL, NULL, FALSE, ' ||
4852: ' ' || p_sr_instance_id || ', ''' || p_collection_group || ''', ' ||
4853: ' ''' || fnd_date.date_to_canonical(x_from_date) || ''', ' ||
4854: ' ''' || fnd_date.date_to_canonical(x_to_date) || ''', ' ||
4855: ' ''' || x_dest_dblink || ''', ' ||
4856: ' ''CMRO'' ';
4857: execute immediate x_sql using out x_errbuf, out x_retcode,
4858: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,

Line 5655: ' ''' || fnd_date.date_to_canonical(x_from_date) || ''', ' ||

5651: msd_dem_common_utilities.log_debug(x_sql);
5652:
5653: x_params := ' ''MSD'', ''MSDSPFEAMCMRO'', NULL, NULL, FALSE, ' ||
5654: ' ' || p_sr_instance_id || ', ''' || p_collection_group || ''', ' ||
5655: ' ''' || fnd_date.date_to_canonical(x_from_date) || ''', ' ||
5656: ' ''' || fnd_date.date_to_canonical(x_to_date) || ''', ' ||
5657: ' ''' || x_dest_dblink || ''', ' ||
5658: ' ''FLEET'', ' || '''' || p_sim_plan_name || ''' ';
5659: execute immediate x_sql using out x_errbuf, out x_retcode,

Line 5656: ' ''' || fnd_date.date_to_canonical(x_to_date) || ''', ' ||

5652:
5653: x_params := ' ''MSD'', ''MSDSPFEAMCMRO'', NULL, NULL, FALSE, ' ||
5654: ' ' || p_sr_instance_id || ', ''' || p_collection_group || ''', ' ||
5655: ' ''' || fnd_date.date_to_canonical(x_from_date) || ''', ' ||
5656: ' ''' || fnd_date.date_to_canonical(x_to_date) || ''', ' ||
5657: ' ''' || x_dest_dblink || ''', ' ||
5658: ' ''FLEET'', ' || '''' || p_sim_plan_name || ''' ';
5659: execute immediate x_sql using out x_errbuf, out x_retcode,
5660: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,

Line 6015: || '''' || fnd_date.date_to_canonical(x_from_date) || ''','

6011:
6012: x_params := ' ''MSD'', ''MSDSPFEAMCMRO'', NULL, NULL, FALSE, '
6013: || p_sr_instance_id || ','
6014: || '''' || p_collection_group || ''','
6015: || '''' || fnd_date.date_to_canonical(x_from_date) || ''','
6016: || '''' || fnd_date.date_to_canonical(x_to_date) || ''','
6017: || '''' || var_S2D_dblink || ''','
6018: || ' ''EAM'' ' ;
6019:

Line 6016: || '''' || fnd_date.date_to_canonical(x_to_date) || ''','

6012: x_params := ' ''MSD'', ''MSDSPFEAMCMRO'', NULL, NULL, FALSE, '
6013: || p_sr_instance_id || ','
6014: || '''' || p_collection_group || ''','
6015: || '''' || fnd_date.date_to_canonical(x_from_date) || ''','
6016: || '''' || fnd_date.date_to_canonical(x_to_date) || ''','
6017: || '''' || var_S2D_dblink || ''','
6018: || ' ''EAM'' ' ;
6019:
6020: EXECUTE IMMEDIATE sql_request USING OUT var_errbuf, OUT var_retcode,