DBA Data[Home] [Help]

APPS.CST_MGD_INFL_ADJUSTMENT_RPT dependencies on FND_DATE

Line 919: l_rpt_date_from := TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));

915:
916: DELETE FROM CST_MGD_INFL_ADJ_KARDEX_DATA;
917:
918: -- From Date is set at midnight for the day
919: l_rpt_date_from := TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));
920: -- To date set to mid night 23:59:59
921: l_rpt_date_to := TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date)) + (86399/86400);
922:
923: -- Date range for accounting periods

Line 921: l_rpt_date_to := TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date)) + (86399/86400);

917:
918: -- From Date is set at midnight for the day
919: l_rpt_date_from := TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));
920: -- To date set to mid night 23:59:59
921: l_rpt_date_to := TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date)) + (86399/86400);
922:
923: -- Date range for accounting periods
924: -- used to get the accounting periods
925: l_date_from := FND_DATE.canonical_to_date(p_rpt_from_date);

Line 925: l_date_from := FND_DATE.canonical_to_date(p_rpt_from_date);

921: l_rpt_date_to := TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date)) + (86399/86400);
922:
923: -- Date range for accounting periods
924: -- used to get the accounting periods
925: l_date_from := FND_DATE.canonical_to_date(p_rpt_from_date);
926: l_date_to := FND_DATE.canonical_to_date(p_rpt_to_date);
927:
928: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
929: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 926: l_date_to := FND_DATE.canonical_to_date(p_rpt_to_date);

922:
923: -- Date range for accounting periods
924: -- used to get the accounting periods
925: l_date_from := FND_DATE.canonical_to_date(p_rpt_from_date);
926: l_date_to := FND_DATE.canonical_to_date(p_rpt_to_date);
927:
928: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
929: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
930: ,G_MODULE_HEAD || l_routine || '.rptdatefrom'