DBA Data[Home] [Help]

APPS.IBE_CATALOG_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 34: -- x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300

30: -- x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE
31: -- x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_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

Line 35: -- x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300

31: -- x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_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

Line 65: x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,

61: x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
62: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_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,

Line 66: x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,

62: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_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

Line 287: x_sctitm_usage_tbl := JTF_VARCHAR2_TABLE_300();

283: -- Initialize final output arrays.
284: x_sctitm_sectid_tbl := JTF_NUMBER_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();

Line 288: x_sctitm_flags_tbl := JTF_VARCHAR2_TABLE_300();

284: x_sctitm_sectid_tbl := JTF_NUMBER_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();

Line 1834: x_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300 --gzhang 07/19/2002, bug#2469521

1830: -- gzhang, 04/23/02, new APIs for Global Store Selection phase 2
1831: procedure load_msite_languages
1832: (x_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1833: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1834: x_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300 --gzhang 07/19/2002, bug#2469521
1835: )
1836: IS
1837: CURSOR l_lang_csr IS
1838: SELECT language_code, language, description

Line 1854: x_desc_tbl := JTF_VARCHAR2_TABLE_300(); --gzhang 07/19/2002, bug#2469521

1850: END IF;
1851:
1852: x_lang_code_tbl := JTF_VARCHAR2_TABLE_100();
1853: x_tran_lang_code_tbl := JTF_VARCHAR2_TABLE_100();
1854: x_desc_tbl := JTF_VARCHAR2_TABLE_300(); --gzhang 07/19/2002, bug#2469521
1855:
1856: FOR l_lang_rec IN l_lang_csr LOOP
1857:
1858: x_lang_code_tbl.EXTEND;

Line 1890: x_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300, --gzhang 07/19/2002, bug#2469521

1886:
1887: procedure load_language
1888: (p_lang_code IN VARCHAR2,
1889: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1890: x_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300, --gzhang 07/19/2002, bug#2469521
1891: x_nls_lang OUT NOCOPY VARCHAR2 --jqu 1/19/2005
1892: )
1893: IS
1894: CURSOR l_lang_csr (l_lang_code VARCHAR2) IS

Line 1914: x_desc_tbl := JTF_VARCHAR2_TABLE_300(); --gzhang 07/19/2002, bug#2469521

1910: IBE_UTIL.debug('p_lang_code ='||p_lang_code);
1911: END IF;
1912:
1913: x_tran_lang_code_tbl := JTF_VARCHAR2_TABLE_100();
1914: x_desc_tbl := JTF_VARCHAR2_TABLE_300(); --gzhang 07/19/2002, bug#2469521
1915:
1916: FOR l_lang_rec IN l_lang_csr(p_lang_code) LOOP
1917:
1918: x_tran_lang_code_tbl.EXTEND;