98: p_roll_logic IN VARCHAR2
99: , p_set_of_books_id IN NUMBER
100: , p_date_tbl IN po_tbl_date
101: , x_period_name_tbl OUT NOCOPY po_tbl_varchar30
102: , x_period_year_tbl OUT NOCOPY po_tbl_number
103: , x_period_num_tbl OUT NOCOPY po_tbl_number
104: , x_quarter_num_tbl OUT NOCOPY po_tbl_number
105: , x_invalid_period_flag OUT NOCOPY VARCHAR2
106: )
99: , p_set_of_books_id IN NUMBER
100: , p_date_tbl IN po_tbl_date
101: , x_period_name_tbl OUT NOCOPY po_tbl_varchar30
102: , x_period_year_tbl OUT NOCOPY po_tbl_number
103: , x_period_num_tbl OUT NOCOPY po_tbl_number
104: , x_quarter_num_tbl OUT NOCOPY po_tbl_number
105: , x_invalid_period_flag OUT NOCOPY VARCHAR2
106: )
107: IS
100: , p_date_tbl IN po_tbl_date
101: , x_period_name_tbl OUT NOCOPY po_tbl_varchar30
102: , x_period_year_tbl OUT NOCOPY po_tbl_number
103: , x_period_num_tbl OUT NOCOPY po_tbl_number
104: , x_quarter_num_tbl OUT NOCOPY po_tbl_number
105: , x_invalid_period_flag OUT NOCOPY VARCHAR2
106: )
107: IS
108:
301:
302: l_progress := '910';
303:
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:
302: l_progress := '910';
303:
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';
303:
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:
368: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_PERIOD_NAME';
369: l_progress VARCHAR2(3) := '000';
370:
371: l_period_name_tbl po_tbl_varchar30;
372: l_period_year_tbl po_tbl_number;
373: l_period_num_tbl po_tbl_number;
374: l_quarter_num_tbl po_tbl_number;
375: l_invalid_period_flag VARCHAR2(1);
376:
369: l_progress VARCHAR2(3) := '000';
370:
371: l_period_name_tbl po_tbl_varchar30;
372: l_period_year_tbl po_tbl_number;
373: l_period_num_tbl po_tbl_number;
374: l_quarter_num_tbl po_tbl_number;
375: l_invalid_period_flag VARCHAR2(1);
376:
377: BEGIN
370:
371: l_period_name_tbl po_tbl_varchar30;
372: l_period_year_tbl po_tbl_number;
373: l_period_num_tbl po_tbl_number;
374: l_quarter_num_tbl po_tbl_number;
375: l_invalid_period_flag VARCHAR2(1);
376:
377: BEGIN
378: