32: -- x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE
33: -- x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE
34: -- x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
35: -- x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
36: -- x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
37: -- x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
38: -- x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
39: -- x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
40: --
33: -- x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE
34: -- x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
35: -- x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
36: -- x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
37: -- x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
38: -- x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
39: -- x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
40: --
41: -- Version : Current version 1.0
34: -- x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
35: -- x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
36: -- x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
37: -- x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
38: -- x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
39: -- x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
40: --
41: -- Version : Current version 1.0
42: --
35: -- x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
36: -- x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
37: -- x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
38: -- x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
39: -- x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
40: --
41: -- Version : Current version 1.0
42: --
43: -- Previous version None
63: x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
64: x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
65: x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
66: x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
67: x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
68: x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE,
69: x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
70: x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
71: ) IS
64: x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
65: x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
66: x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
67: x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
68: x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE,
69: x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
70: x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
71: ) IS
72:
65: x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
66: x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
67: x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
68: x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE,
69: x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
70: x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
71: ) IS
72:
73:
66: x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
67: x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
68: x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE,
69: x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
70: x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
71: ) IS
72:
73:
74: cursor l_orderby_csr(p_sectid NUMBER) IS
285: x_sctitm_itmid_tbl := JTF_NUMBER_TABLE();
286: x_sctitm_orgid_tbl := JTF_NUMBER_TABLE();
287: x_sctitm_usage_tbl := JTF_VARCHAR2_TABLE_300();
288: x_sctitm_flags_tbl := JTF_VARCHAR2_TABLE_300();
289: x_sctitm_startdt_tbl := JTF_DATE_TABLE();
290: x_sctitm_enddt_tbl := JTF_DATE_TABLE();
291: x_sctitm_assoc_startdt_tbl := JTF_DATE_TABLE();
292: x_sctitm_assoc_enddt_tbl := JTF_DATE_TABLE();
293:
286: x_sctitm_orgid_tbl := JTF_NUMBER_TABLE();
287: x_sctitm_usage_tbl := JTF_VARCHAR2_TABLE_300();
288: x_sctitm_flags_tbl := JTF_VARCHAR2_TABLE_300();
289: x_sctitm_startdt_tbl := JTF_DATE_TABLE();
290: x_sctitm_enddt_tbl := JTF_DATE_TABLE();
291: x_sctitm_assoc_startdt_tbl := JTF_DATE_TABLE();
292: x_sctitm_assoc_enddt_tbl := JTF_DATE_TABLE();
293:
294:
287: x_sctitm_usage_tbl := JTF_VARCHAR2_TABLE_300();
288: x_sctitm_flags_tbl := JTF_VARCHAR2_TABLE_300();
289: x_sctitm_startdt_tbl := JTF_DATE_TABLE();
290: x_sctitm_enddt_tbl := JTF_DATE_TABLE();
291: x_sctitm_assoc_startdt_tbl := JTF_DATE_TABLE();
292: x_sctitm_assoc_enddt_tbl := JTF_DATE_TABLE();
293:
294:
295: -- Get the number of items per section.
288: x_sctitm_flags_tbl := JTF_VARCHAR2_TABLE_300();
289: x_sctitm_startdt_tbl := JTF_DATE_TABLE();
290: x_sctitm_enddt_tbl := JTF_DATE_TABLE();
291: x_sctitm_assoc_startdt_tbl := JTF_DATE_TABLE();
292: x_sctitm_assoc_enddt_tbl := JTF_DATE_TABLE();
293:
294:
295: -- Get the number of items per section.
296: l_str_itms_per_sct := FND_PROFILE.value_specific('IBE_ITEMS_PER_SECTION', NULL, NULL, 671);