DBA Data[Home] [Help]

APPS.PO_PERIODS_SV dependencies on PO_TBL_NUMBER

Line 79: x_period_year_tbl OUT NOCOPY po_tbl_number,

75: PROCEDURE get_period_info(p_roll_logic IN VARCHAR2,
76: p_set_of_books_id IN NUMBER,
77: p_date_tbl IN po_tbl_date,
78: x_period_name_tbl OUT NOCOPY po_tbl_varchar30,
79: x_period_year_tbl OUT NOCOPY po_tbl_number,
80: x_period_num_tbl OUT NOCOPY po_tbl_number,
81: x_quarter_num_tbl OUT NOCOPY po_tbl_number,
82: x_invalid_period_flag OUT NOCOPY VARCHAR2) IS
83:

Line 80: x_period_num_tbl OUT NOCOPY po_tbl_number,

76: p_set_of_books_id IN NUMBER,
77: p_date_tbl IN po_tbl_date,
78: x_period_name_tbl OUT NOCOPY po_tbl_varchar30,
79: x_period_year_tbl OUT NOCOPY po_tbl_number,
80: x_period_num_tbl OUT NOCOPY po_tbl_number,
81: x_quarter_num_tbl OUT NOCOPY po_tbl_number,
82: x_invalid_period_flag OUT NOCOPY VARCHAR2) IS
83:
84: l_log_head CONSTANT VARCHAR2(100) := g_log_head || 'GET_PERIOD_INFO';

Line 81: x_quarter_num_tbl OUT NOCOPY po_tbl_number,

77: p_date_tbl IN po_tbl_date,
78: x_period_name_tbl OUT NOCOPY po_tbl_varchar30,
79: x_period_year_tbl OUT NOCOPY po_tbl_number,
80: x_period_num_tbl OUT NOCOPY po_tbl_number,
81: x_quarter_num_tbl OUT NOCOPY po_tbl_number,
82: x_invalid_period_flag OUT NOCOPY VARCHAR2) IS
83:
84: l_log_head CONSTANT VARCHAR2(100) := g_log_head || 'GET_PERIOD_INFO';
85: l_progress VARCHAR2(3) := '000';

Line 302: x_period_year_tbl := po_tbl_number();

298:
299: l_progress := '910';
300:
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:

Line 303: x_period_num_tbl := po_tbl_number();

299: l_progress := '910';
300:
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';

Line 304: x_quarter_num_tbl := po_tbl_number();

300:
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:

Line 378: l_period_year_tbl po_tbl_number;

374: l_log_head CONSTANT VARCHAR2(100) := g_log_head || 'GET_PERIOD_NAME';
375: l_progress VARCHAR2(3) := '000';
376:
377: l_period_name_tbl po_tbl_varchar30;
378: l_period_year_tbl po_tbl_number;
379: l_period_num_tbl po_tbl_number;
380: l_quarter_num_tbl po_tbl_number;
381: l_invalid_period_flag VARCHAR2(1);
382:

Line 379: l_period_num_tbl po_tbl_number;

375: l_progress VARCHAR2(3) := '000';
376:
377: l_period_name_tbl po_tbl_varchar30;
378: l_period_year_tbl po_tbl_number;
379: l_period_num_tbl po_tbl_number;
380: l_quarter_num_tbl po_tbl_number;
381: l_invalid_period_flag VARCHAR2(1);
382:
383: BEGIN

Line 380: l_quarter_num_tbl po_tbl_number;

376:
377: l_period_name_tbl po_tbl_varchar30;
378: l_period_year_tbl po_tbl_number;
379: l_period_num_tbl po_tbl_number;
380: l_quarter_num_tbl po_tbl_number;
381: l_invalid_period_flag VARCHAR2(1);
382:
383: BEGIN
384: