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 1833: x_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300 --gzhang 07/19/2002, bug#2469521

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

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

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

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

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

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

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