DBA Data[Home] [Help]

APPS.INV_MGD_MVT_CONC_PGM dependencies on FND_DATE

Line 86: l_le_start_date := TRUNC(FND_DATE.canonical_to_date(p_start_date));

82: -- initialize the message stack
83: FND_MSG_PUB.Initialize;
84:
85: --Convert legal entity char date to date format
86: l_le_start_date := TRUNC(FND_DATE.canonical_to_date(p_start_date));
87:
88: --Fix bug5047762, deduct 1 second from 00:00:00 of next day to make
89: --sure it is within last second of p_end_date
90: IF p_end_date IS NOT NULL

Line 92: l_le_end_date := TRUNC(FND_DATE.canonical_to_date(p_end_date) + 1) - 1/(24*60*60);

88: --Fix bug5047762, deduct 1 second from 00:00:00 of next day to make
89: --sure it is within last second of p_end_date
90: IF p_end_date IS NOT NULL
91: THEN
92: l_le_end_date := TRUNC(FND_DATE.canonical_to_date(p_end_date) + 1) - 1/(24*60*60);
93: END IF;
94:
95: --Fix bug3731618, no movement record generated if the end date is not specified
96: --Set correct legal entity end date

Line 101: l_le_end_date := TRUNC(FND_DATE.canonical_to_date(p_end_date) + 1);

97: /*IF p_end_date IS NULL
98: THEN
99: l_le_end_date := TRUNC(sysdate+1);
100: ELSE
101: l_le_end_date := TRUNC(FND_DATE.canonical_to_date(p_end_date) + 1);
102: END IF;
103: */
104:
105: --Timezone support, convert legal entity time to server time