[Home] [Help]
64: -- Retrieves the GL period info for the given dates.
65: -- Period information will only be found if
66: -- the date falls within a usable period (valid for both GL and PO).
67: -- If a usable period is not found for any of the given dates,
68: -- the x_invalid_period_flag will be FND_API.g_TRUE,
69: -- and the other out parameters corresponding to the date will be NULL.
70: --Parameters:
71: --IN:
72: --p_roll_logic
87: --
88: --x_invalid_period_flag
89: -- Indicates whether or not usable periods were found for each of the
90: -- given dates.
91: -- FND_API.g_TRUE a usable period was not found for at least one date
92: -- FND_API.g_FALSE usable periods were found for each date
93: --Testing:
94: --
95: --End of Comments
88: --x_invalid_period_flag
89: -- Indicates whether or not usable periods were found for each of the
90: -- given dates.
91: -- FND_API.g_TRUE a usable period was not found for at least one date
92: -- FND_API.g_FALSE usable periods were found for each date
93: --Testing:
94: --
95: --End of Comments
96: -------------------------------------------------------------------------------
255: l_progress := '100';
256:
257: -- Figure out if any periods were not found.
258:
259: x_invalid_period_flag := FND_API.G_FALSE;
260:
261: BEGIN
262:
263: l_progress := '110';
261: BEGIN
262:
263: l_progress := '110';
264:
265: SELECT FND_API.G_TRUE
266: INTO x_invalid_period_flag
267: FROM PO_SESSION_GT SES
268: WHERE SES.key = l_date_key
269: AND SES.char1 IS NULL
304: x_period_name_tbl := po_tbl_varchar30();
305: x_period_year_tbl := po_tbl_number();
306: x_period_num_tbl := po_tbl_number();
307: x_quarter_num_tbl := po_tbl_number();
308: x_invalid_period_flag := FND_API.g_FALSE;
309:
310: l_progress := '912';
311:
312: IF g_debug_stmt THEN