42: -- Retrieves the GL period info for the given dates.
43: -- Period information will only be found if
44: -- the date falls within a usable period (valid for both GL and PO).
45: -- If a usable period is not found for any of the given dates,
46: -- the x_invalid_period_flag will be FND_API.g_TRUE,
47: -- and the other out parameters corresponding to the date will be NULL.
48: --Parameters:
49: --IN:
50: --p_roll_logic
65: --
66: --x_invalid_period_flag
67: -- Indicates whether or not usable periods were found for each of the
68: -- given dates.
69: -- FND_API.g_TRUE a usable period was not found for at least one date
70: -- FND_API.g_FALSE usable periods were found for each date
71: --Testing:
72: --
73: --End of Comments
66: --x_invalid_period_flag
67: -- Indicates whether or not usable periods were found for each of the
68: -- given dates.
69: -- FND_API.g_TRUE a usable period was not found for at least one date
70: -- FND_API.g_FALSE usable periods were found for each date
71: --Testing:
72: --
73: --End of Comments
74: -------------------------------------------------------------------------------
233: l_progress := '100';
234:
235: -- Figure out if any periods were not found.
236:
237: x_invalid_period_flag := FND_API.G_FALSE;
238:
239: BEGIN
240:
241: l_progress := '110';
239: BEGIN
240:
241: l_progress := '110';
242:
243: SELECT FND_API.G_TRUE
244: INTO x_invalid_period_flag
245: FROM PO_SESSION_GT SES
246: WHERE SES.key = l_date_key
247: AND SES.char1 IS NULL
301: x_period_name_tbl := po_tbl_varchar30();
302: x_period_year_tbl := po_tbl_number();
303: x_period_num_tbl := po_tbl_number();
304: x_quarter_num_tbl := po_tbl_number();
305: x_invalid_period_flag := FND_API.g_FALSE;
306:
307: l_progress := '912';
308:
309: IF g_debug_stmt THEN