eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_CATALOG_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 1560: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,

1556:
1557: p_item_id_tbl IN JTF_NUMBER_TABLE,
1558: p_organization_id_tbl IN JTF_NUMBER_TABLE,
1559: p_qty_tbl IN JTF_NUMBER_TABLE,
1560: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
1561: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
1562: ) is
1563:
1564: l_api_name CONSTANT VARCHAR2(30) := 'validate_quantity';

Line 1561: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

1557: p_item_id_tbl IN JTF_NUMBER_TABLE,
1558: p_organization_id_tbl IN JTF_NUMBER_TABLE,
1559: p_qty_tbl IN JTF_NUMBER_TABLE,
1560: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
1561: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
1562: ) is
1563:
1564: l_api_name CONSTANT VARCHAR2(30) := 'validate_quantity';
1565: l_api_version CONSTANT NUMBER := 1.0;

Line 1599: x_valid_qty_tbl := JTF_VARCHAR2_TABLE_100();

1595: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(+)');
1596: END IF;
1597: -- begin API body
1598:
1599: x_valid_qty_tbl := JTF_VARCHAR2_TABLE_100();
1600: x_valid_qty_tbl.extend(p_item_id_tbl.count);
1601:
1602: for i in 1..p_item_id_tbl.count loop
1603:

Line 1673: p_reqd_validation IN JTF_VARCHAR2_TABLE_100,

1669: --Bug 3063233
1670: procedure validate_de_qty_msite_check
1671: (p_api_version IN NUMBER,
1672: p_init_msg_list IN VARCHAR2 := NULL,
1673: p_reqd_validation IN JTF_VARCHAR2_TABLE_100,
1674: p_msite_id IN NUMBER,
1675: x_return_status OUT NOCOPY VARCHAR2,
1676: x_msg_count OUT NOCOPY NUMBER,
1677: x_msg_data OUT NOCOPY VARCHAR2,

Line 1681: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,

1677: x_msg_data OUT NOCOPY VARCHAR2,
1678: p_item_id_tbl IN JTF_NUMBER_TABLE,
1679: p_organization_id_tbl IN JTF_NUMBER_TABLE,
1680: p_qty_tbl IN JTF_NUMBER_TABLE,
1681: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
1682: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
1683: ) is
1684:
1685: l_api_name CONSTANT VARCHAR2(30) := 'validate_de_qty_msite_check';

Line 1682: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

1678: p_item_id_tbl IN JTF_NUMBER_TABLE,
1679: p_organization_id_tbl IN JTF_NUMBER_TABLE,
1680: p_qty_tbl IN JTF_NUMBER_TABLE,
1681: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
1682: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
1683: ) is
1684:
1685: l_api_name CONSTANT VARCHAR2(30) := 'validate_de_qty_msite_check';
1686: l_api_version CONSTANT NUMBER := 1.0;

Line 1723: x_valid_qty_tbl := JTF_VARCHAR2_TABLE_100();

1719: END IF;
1720:
1721: -- begin API body
1722:
1723: x_valid_qty_tbl := JTF_VARCHAR2_TABLE_100();
1724: x_valid_qty_tbl.extend(p_item_id_tbl.count);
1725:
1726: for i in 1..p_item_id_tbl.count loop
1727:

Line 1831: (x_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1827: end validate_de_qty_msite_check;
1828:
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

Line 1832: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 1851: x_lang_code_tbl := JTF_VARCHAR2_TABLE_100();

1847: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1848: IBE_UTIL.debug('In IBE_CATALOG_PVT.load_msite_languages...');
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

Line 1852: x_tran_lang_code_tbl := JTF_VARCHAR2_TABLE_100();

1848: IBE_UTIL.debug('In IBE_CATALOG_PVT.load_msite_languages...');
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:

Line 1888: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1884: END load_msite_languages;
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

Line 1912: x_tran_lang_code_tbl := JTF_VARCHAR2_TABLE_100();

1908: IBE_UTIL.debug('In IBE_CATALOG_PVT.LOAD_LANGUAGE...');
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:

Line 2179: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2175: p_price_request_type IN VARCHAR2,
2176: p_price_event IN VARCHAR2,
2177: p_minisite_id IN NUMBER := NULL,
2178: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
2179: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2180: x_return_status OUT NOCOPY VARCHAR2,
2181: x_return_status_text OUT NOCOPY VARCHAR2
2182: )
2183: IS

Line 2367: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2363: x_configurable OUT NOCOPY VARCHAR2,
2364: x_model_bundle_flag OUT NOCOPY VARCHAR2,
2365: x_uom_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE,
2366: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
2367: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2368: x_price_status_code OUT NOCOPY VARCHAR2,
2369: x_price_status_text OUT NOCOPY VARCHAR2
2370:
2371: )

Line 2377: l_uom_code_tbl JTF_VARCHAR2_TABLE_100;

2373:
2374: l_api_name CONSTANT VARCHAR2(30) := 'LOAD_ITEM';
2375: l_api_version CONSTANT NUMBER := 1.0;
2376:
2377: l_uom_code_tbl JTF_VARCHAR2_TABLE_100;
2378: l_itmid_tbl JTF_NUMBER_TABLE;
2379: l_model_id_tbl JTF_NUMBER_TABLE;
2380: idx BINARY_INTEGER;
2381: l_start_time NUMBER;

Line 2499: p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,

2495:
2496: Procedure FETCH_ITEMS(
2497: p_load_level IN NUMBER,
2498: p_itmid_tbl IN JTF_NUMBER_TABLE,
2499: p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,
2500: p_organization_id IN NUMBER,
2501: p_category_set_id IN NUMBER,
2502: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
2503: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 2503: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2499: p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,
2500: p_organization_id IN NUMBER,
2501: p_category_set_id IN NUMBER,
2502: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
2503: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2504: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2505: x_return_status OUT NOCOPY VARCHAR2,
2506: x_return_status_text OUT NOCOPY VARCHAR2
2507: )

Line 2504: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2500: p_organization_id IN NUMBER,
2501: p_category_set_id IN NUMBER,
2502: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
2503: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2504: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2505: x_return_status OUT NOCOPY VARCHAR2,
2506: x_return_status_text OUT NOCOPY VARCHAR2
2507: )
2508: IS

Line 2615: x_configurable_tbl := JTF_VARCHAR2_TABLE_100();

2611: END LOOP;
2612: END IF;
2613:
2614: --gzhang 01/21/01, model bundle cache
2615: x_configurable_tbl := JTF_VARCHAR2_TABLE_100();
2616: x_model_bundle_flag_tbl := JTF_VARCHAR2_TABLE_100();
2617: IF (p_itmid_tbl IS NOT NULL) THEN
2618: x_configurable_tbl.EXTEND(p_itmid_tbl.COUNT);
2619: x_model_bundle_flag_tbl.EXTEND(p_itmid_tbl.COUNT);

Line 2616: x_model_bundle_flag_tbl := JTF_VARCHAR2_TABLE_100();

2612: END IF;
2613:
2614: --gzhang 01/21/01, model bundle cache
2615: x_configurable_tbl := JTF_VARCHAR2_TABLE_100();
2616: x_model_bundle_flag_tbl := JTF_VARCHAR2_TABLE_100();
2617: IF (p_itmid_tbl IS NOT NULL) THEN
2618: x_configurable_tbl.EXTEND(p_itmid_tbl.COUNT);
2619: x_model_bundle_flag_tbl.EXTEND(p_itmid_tbl.COUNT);
2620: ELSE

Line 2672: p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100,

2668: END FETCH_ITEMS;
2669:
2670: Procedure FETCH_PRICES(
2671: p_itmid_tbl IN JTF_NUMBER_TABLE,
2672: p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100,
2673: p_model_id_tbl IN JTF_NUMBER_TABLE,
2674: p_organization_id IN NUMBER,
2675: p_price_list_id IN NUMBER,
2676: p_currency_code IN VARCHAR2,

Line 2681: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2677: p_price_request_type IN VARCHAR2,
2678: p_price_event IN VARCHAR2,
2679: p_minisite_id IN NUMBER := NULL,
2680: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
2681: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2682: x_return_status OUT NOCOPY VARCHAR2,
2683: x_return_status_text OUT NOCOPY VARCHAR2
2684:
2685: )

Line 2870: p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,

2866:
2867: p_load_level IN NUMBER,
2868: p_preview_flag IN VARCHAR2,
2869: p_itmid_tbl IN JTF_NUMBER_TABLE,
2870: p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,
2871: p_model_id_tbl IN JTF_NUMBER_TABLE,
2872: p_organization_id IN NUMBER,
2873: p_category_set_id IN NUMBER,
2874: p_retrieve_price IN VARCHAR2,

Line 2881: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2877: p_price_request_type IN VARCHAR2,
2878: p_price_event IN VARCHAR2,
2879: p_minisite_id IN NUMBER := NULL,
2880: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
2881: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2882: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2883: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
2884: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2885: x_price_status_code OUT NOCOPY VARCHAR2,

Line 2882: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2878: p_price_event IN VARCHAR2,
2879: p_minisite_id IN NUMBER := NULL,
2880: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
2881: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2882: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2883: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
2884: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2885: x_price_status_code OUT NOCOPY VARCHAR2,
2886: x_price_status_text OUT NOCOPY VARCHAR2

Line 2884: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2880: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
2881: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2882: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2883: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
2884: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2885: x_price_status_code OUT NOCOPY VARCHAR2,
2886: x_price_status_text OUT NOCOPY VARCHAR2
2887:
2888: ) IS

Line 3016: x_item_type OUT NOCOPY JTF_VARCHAR2_TABLE_100,

3012: p_init_msg_list IN VARCHAR2 := NULL,
3013: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3014: p_item_ids IN JTF_NUMBER_TABLE,
3015: p_organization_id IN NUMBER,
3016: x_item_type OUT NOCOPY JTF_VARCHAR2_TABLE_100,
3017: x_return_status OUT NOCOPY VARCHAR2,
3018: x_msg_count OUT NOCOPY NUMBER,
3019: x_msg_data OUT NOCOPY VARCHAR2
3020: )

Line 3068: x_item_type := JTF_VARCHAR2_TABLE_100();

3064:
3065: l_resp_id := FND_PROFILE.value('RESP_ID');
3066: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3067:
3068: x_item_type := JTF_VARCHAR2_TABLE_100();
3069: x_item_type.extend(p_item_ids.COUNT);
3070:
3071: FOR l_table_index IN 1..p_item_ids.COUNT LOOP
3072: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN