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 1832: (x_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 1833: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 1852: x_lang_code_tbl := JTF_VARCHAR2_TABLE_100();

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

Line 1853: x_tran_lang_code_tbl := JTF_VARCHAR2_TABLE_100();

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

Line 1889: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 1913: x_tran_lang_code_tbl := JTF_VARCHAR2_TABLE_100();

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

Line 2180: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 2368: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 2378: l_uom_code_tbl JTF_VARCHAR2_TABLE_100;

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

Line 2500: p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,

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

Line 2504: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 2505: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 2616: x_configurable_tbl := JTF_VARCHAR2_TABLE_100();

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

Line 2617: x_model_bundle_flag_tbl := JTF_VARCHAR2_TABLE_100();

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

Line 2673: p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100,

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

Line 2682: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 2871: p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,

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

Line 2882: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 2883: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 2885: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 3017: x_item_type OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

Line 3069: x_item_type := JTF_VARCHAR2_TABLE_100();

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