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.FEM_DATA_LOADER_PKG dependencies on FND_DATE

Line 2560: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date

2556: WHERE a.attribute_id = g_start_date_attr
2557: AND b.attribute_id = g_end_date_attr
2558: AND a.cal_period_id = fcpb.cal_period_id
2559: AND a.cal_period_id = b.cal_period_id
2560: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date
2561: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2562:
2563: ELSIF gs_ledger_tab(i) <> - 1 AND gs_cal_grp_tab(i) = -1 AND gs_valid_rows(i) > 0.0 THEN
2564:

Line 2561: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );

2557: AND b.attribute_id = g_end_date_attr
2558: AND a.cal_period_id = fcpb.cal_period_id
2559: AND a.cal_period_id = b.cal_period_id
2560: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date
2561: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2562:
2563: ELSIF gs_ledger_tab(i) <> - 1 AND gs_cal_grp_tab(i) = -1 AND gs_valid_rows(i) > 0.0 THEN
2564:
2565: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)

Line 2588: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date

2584: WHERE a.attribute_id = g_start_date_attr
2585: AND b.attribute_id = g_end_date_attr
2586: AND a.cal_period_id = fcpb.cal_period_id
2587: AND a.cal_period_id = b.cal_period_id
2588: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date
2589: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2590:
2591: ELSIF gs_ledger_tab(i) = - 1 AND gs_cal_grp_tab(i) = -1 AND gs_valid_rows(i) > 0.0 THEN
2592:

Line 2589: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );

2585: AND b.attribute_id = g_end_date_attr
2586: AND a.cal_period_id = fcpb.cal_period_id
2587: AND a.cal_period_id = b.cal_period_id
2588: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date
2589: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2590:
2591: ELSIF gs_ledger_tab(i) = - 1 AND gs_cal_grp_tab(i) = -1 AND gs_valid_rows(i) > 0.0 THEN
2592:
2593: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)

Line 2618: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date

2614: WHERE a.attribute_id = g_start_date_attr
2615: AND b.attribute_id = g_end_date_attr
2616: AND a.cal_period_id = fcpb.cal_period_id
2617: AND a.cal_period_id = b.cal_period_id
2618: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date
2619: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2620:
2621: ELSIF gs_ledger_tab(i) = - 1 AND gs_cal_grp_tab(i) <> -1 AND gs_valid_rows(i) > 0.0 THEN
2622:

Line 2619: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );

2615: AND b.attribute_id = g_end_date_attr
2616: AND a.cal_period_id = fcpb.cal_period_id
2617: AND a.cal_period_id = b.cal_period_id
2618: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date
2619: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2620:
2621: ELSIF gs_ledger_tab(i) = - 1 AND gs_cal_grp_tab(i) <> -1 AND gs_valid_rows(i) > 0.0 THEN
2622:
2623: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)

Line 2648: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date

2644: WHERE a.attribute_id = g_start_date_attr
2645: AND b.attribute_id = g_end_date_attr
2646: AND a.cal_period_id = fcpb.cal_period_id
2647: AND a.cal_period_id = b.cal_period_id
2648: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date
2649: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2650:
2651: END IF;
2652:

Line 2649: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );

2645: AND b.attribute_id = g_end_date_attr
2646: AND a.cal_period_id = fcpb.cal_period_id
2647: AND a.cal_period_id = b.cal_period_id
2648: AND fnd_date.date_to_canonical(a.date_assign_value) >= g_start_date
2649: AND fnd_date.date_to_canonical(b.date_assign_value) <= g_end_date );
2650:
2651: END IF;
2652:
2653: IF SQL%ROWCOUNT = 0.0 THEN