DBA Data[Home] [Help]

APPS.IBE_CATALOG_PVT dependencies on JTF_DATE_TABLE

Line 36: -- x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE

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

Line 37: -- x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_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: --
41: -- Version : Current version 1.0

Line 38: -- x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_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
42: --

Line 39: -- x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE

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

Line 67: x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,

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

Line 68: x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_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
72:

Line 69: x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_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:
73:

Line 70: x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE

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

Line 289: x_sctitm_startdt_tbl := JTF_DATE_TABLE();

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:

Line 290: x_sctitm_enddt_tbl := JTF_DATE_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:
294:

Line 291: x_sctitm_assoc_startdt_tbl := JTF_DATE_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:
295: -- Get the number of items per section.

Line 292: x_sctitm_assoc_enddt_tbl := JTF_DATE_TABLE();

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);