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_NUMBER_TABLE

Line 24: -- p_sectid_tbl IN JTF_NUMBER_TABLE

20: -- Parameters :
21: -- IN : p_api_version IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional
23: -- p_validation_level IN NUMBER Optional
24: -- p_sectid_tbl IN JTF_NUMBER_TABLE
25: -- p_msite_id IN NUMBER
26: --
27: -- OUT : x_return_status OUT VARCHAR2(1)
28: -- x_msg_count OUT NUMBER

Line 30: -- x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE

26: --
27: -- OUT : x_return_status OUT VARCHAR2(1)
28: -- x_msg_count OUT NUMBER
29: -- x_msg_data OUT VARCHAR2(2000)
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

Line 31: -- x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE

27: -- OUT : x_return_status OUT VARCHAR2(1)
28: -- x_msg_count OUT NUMBER
29: -- x_msg_data OUT VARCHAR2(2000)
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

Line 32: -- x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE

28: -- x_msg_count OUT NUMBER
29: -- x_msg_data OUT VARCHAR2(2000)
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

Line 33: -- x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE

29: -- x_msg_data OUT VARCHAR2(2000)
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

Line 58: p_sectid_tbl IN JTF_NUMBER_TABLE,

54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2,
58: p_sectid_tbl IN JTF_NUMBER_TABLE,
59: p_msite_id IN NUMBER,
60: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
61: x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
62: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 60: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,

56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2,
58: p_sectid_tbl IN JTF_NUMBER_TABLE,
59: p_msite_id IN NUMBER,
60: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
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,

Line 61: x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,

57: x_msg_data OUT NOCOPY VARCHAR2,
58: p_sectid_tbl IN JTF_NUMBER_TABLE,
59: p_msite_id IN NUMBER,
60: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
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,

Line 62: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE,

58: p_sectid_tbl IN JTF_NUMBER_TABLE,
59: p_msite_id IN NUMBER,
60: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
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,

Line 63: x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE,

59: p_msite_id IN NUMBER,
60: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
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,

Line 64: x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE,

60: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
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,

Line 116: l_sectid_tbl JTF_NUMBER_TABLE;

112: l_api_version CONSTANT NUMBER := 1.0;
113: l_init_msg_list VARCHAR2(5);
114: l_stmt VARCHAR2(32767);
115:
116: l_sectid_tbl JTF_NUMBER_TABLE;
117: l_table_index NUMBER;
118:
119: l_supersectid_csr IBE_CATALOG_REFCURSOR_CSR_TYPE;
120: l_get_supersects BOOLEAN;

Line 121: l_processed_sectid_tbl JTF_NUMBER_TABLE;

117: l_table_index NUMBER;
118:
119: l_supersectid_csr IBE_CATALOG_REFCURSOR_CSR_TYPE;
120: l_get_supersects BOOLEAN;
121: l_processed_sectid_tbl JTF_NUMBER_TABLE;
122: l_processed_sectid_index NUMBER;
123: l_tmp_id NUMBER;
124:
125: l_str_itms_per_sct VARCHAR2(20);

Line 198: x_supersect_sect_tbl := JTF_NUMBER_TABLE();

194: -- Get supersection information
195: ----------------------
196:
197: -- Initialize final output arrays.
198: x_supersect_sect_tbl := JTF_NUMBER_TABLE();
199: x_supersect_supersect_tbl := JTF_NUMBER_TABLE();
200:
201:
202: -- Loop through our list of requested section IDs and retrieve supersection information.

Line 199: x_supersect_supersect_tbl := JTF_NUMBER_TABLE();

195: ----------------------
196:
197: -- Initialize final output arrays.
198: x_supersect_sect_tbl := JTF_NUMBER_TABLE();
199: x_supersect_supersect_tbl := JTF_NUMBER_TABLE();
200:
201:
202: -- Loop through our list of requested section IDs and retrieve supersection information.
203: l_table_index := 1;

Line 204: l_processed_sectid_tbl := JTF_NUMBER_TABLE();

200:
201:
202: -- Loop through our list of requested section IDs and retrieve supersection information.
203: l_table_index := 1;
204: l_processed_sectid_tbl := JTF_NUMBER_TABLE();
205: l_processed_sectid_index := 1;
206:
207: FOR j IN 1..l_sectid_tbl.COUNT LOOP
208: l_get_supersects := true;

Line 284: x_sctitm_sectid_tbl := JTF_NUMBER_TABLE();

280: -- Get item information
281: ----------------------
282:
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();

Line 285: x_sctitm_itmid_tbl := JTF_NUMBER_TABLE();

281: ----------------------
282:
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();

Line 286: x_sctitm_orgid_tbl := JTF_NUMBER_TABLE();

282:
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();

Line 848: -- x_service_item_ids OUT nocopy JTF_NUMBER_TABLE

844: -- OUT :
845: -- x_return_status OUT VARCHAR2(1)
846: -- x_msg_count OUT NUMBER
847: -- x_msg_data OUT VARCHAR2(2000)
848: -- x_service_item_ids OUT nocopy JTF_NUMBER_TABLE
849: --
850: -- Version : Current version 1.0
851: --
852: -- previous version None

Line 870: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE

866: p_product_item_id IN NUMBER,
867: p_customer_id IN NUMBER,
868: p_product_revision IN VARCHAR2,
869: p_request_date IN DATE,
870: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE
871: ) IS
872: --l_avail_service_rec ASO_SERVICE_CONTRACTS_INT.Avail_Service_Rec_Type;
873: --l_orderable_Service_tbl ASO_SERVICE_CONTRACTS_INT.order_service_tbl_type;
874: l_count NUMBER;

Line 955: x_service_item_ids := JTF_NUMBER_TABLE();

951: IBE_UTIL.Debug(' OKS_OMINT_PUB.Available_Services Finishes ' || x_return_status || ' ' ||
952: 'l_orderable_service_tbl.COUNT=' || l_count);
953: END IF;
954:
955: x_service_item_ids := JTF_NUMBER_TABLE();
956:
957: IF l_count > 0 THEN
958: x_service_item_ids.extend(l_count);
959: FOR i IN 1..l_count LOOP

Line 1039: -- x_relatedid_tbl OUT nocopy JTF_NUMBER_TABLE

1035: --
1036: -- OUT : x_return_status OUT VARCHAR2(1)
1037: -- x_msg_count OUT NUMBER
1038: -- x_msg_data OUT VARCHAR2(2000)
1039: -- x_relatedid_tbl OUT nocopy JTF_NUMBER_TABLE
1040: --
1041: -- Version : Current version 1.0
1042: --
1043: -- previous version None

Line 1064: x_relatedid_tbl OUT NOCOPY JTF_NUMBER_TABLE

1060: p_originid IN NUMBER,
1061: p_origintype IN VARCHAR2,
1062: p_reltype_code IN VARCHAR2,
1063: p_dest_type IN VARCHAR2,
1064: x_relatedid_tbl OUT NOCOPY JTF_NUMBER_TABLE
1065: ) IS
1066: cursor l_reltype_csr IS
1067: SELECT start_date_active, end_date_active
1068: FROM FND_LOOKUPS

Line 1141: x_relatedid_tbl := JTF_NUMBER_TABLE();

1137: RETURN;
1138: END IF;
1139:
1140: -- initialize return value x_relatedid_tbl
1141: x_relatedid_tbl := JTF_NUMBER_TABLE();
1142:
1143: -- initialize table index
1144: l_table_index := 1;
1145:

Line 1557: p_item_id_tbl IN JTF_NUMBER_TABLE,

1553: x_return_status OUT NOCOPY VARCHAR2,
1554: x_msg_count OUT NOCOPY NUMBER,
1555: x_msg_data OUT NOCOPY VARCHAR2,
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

Line 1558: p_organization_id_tbl IN JTF_NUMBER_TABLE,

1554: x_msg_count OUT NOCOPY NUMBER,
1555: x_msg_data OUT NOCOPY VARCHAR2,
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

Line 1559: p_qty_tbl IN JTF_NUMBER_TABLE,

1555: x_msg_data OUT NOCOPY VARCHAR2,
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:

Line 1678: p_item_id_tbl IN JTF_NUMBER_TABLE,

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

Line 1679: p_organization_id_tbl IN JTF_NUMBER_TABLE,

1675: x_return_status OUT NOCOPY VARCHAR2,
1676: x_msg_count OUT NOCOPY NUMBER,
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

Line 1680: p_qty_tbl IN JTF_NUMBER_TABLE,

1676: x_msg_count OUT NOCOPY NUMBER,
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:

Line 2190: l_model_id_tbl JTF_NUMBER_TABLE;

2186: l_api_version CONSTANT NUMBER := 1.0;
2187:
2188: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2189: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2190: l_model_id_tbl JTF_NUMBER_TABLE;
2191: l_model_id NUMBER;
2192: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2193: idx BINARY_INTEGER;
2194: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 2232: l_model_id_tbl := JTF_NUMBER_TABLE();

2228: --l_model_id := FND_API.G_MISS_NUM;
2229: --ELSE
2230: l_model_id := p_model_id;
2231: --END IF;
2232: l_model_id_tbl := JTF_NUMBER_TABLE();
2233: idx := 1;
2234: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2235: IF p_model_bundle_flag = FND_API.G_TRUE OR l_retrieve_all_uom = 'N' THEN
2236: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 2378: l_itmid_tbl JTF_NUMBER_TABLE;

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;
2382: l_end_time NUMBER;

Line 2379: l_model_id_tbl JTF_NUMBER_TABLE;

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;
2382: l_end_time NUMBER;
2383: l_init_msg_list VARCHAR2(5);

Line 2498: p_itmid_tbl IN JTF_NUMBER_TABLE,

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

Line 2502: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 2532: l_itmid_tbl JTF_NUMBER_TABLE;

2528: AND MSIB.organization_id = MIC.organization_id
2529: AND mic.CATEGORY_SET_ID = l_category_set_id;
2530:
2531: l_itmid NUMBER;
2532: l_itmid_tbl JTF_NUMBER_TABLE;
2533: l_table_index NUMBER;
2534: l_partnum VARCHAR2(40);
2535: l_category_id NUMBER;
2536: l_resp_id NUMBER;

Line 2553: l_itmid_tbl := JTF_NUMBER_TABLE();

2549: END IF;
2550: l_start_time := DBMS_UTILITY.GET_TIME;
2551:
2552: -- get the select and from clauses of the query
2553: l_itmid_tbl := JTF_NUMBER_TABLE();
2554:
2555: IF p_itmid_tbl IS NULL THEN
2556: IF p_partnum_tbl IS NULL THEN
2557: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 2598: x_category_id_tbl := JTF_NUMBER_TABLE();

2594:
2595: -- populate x_category_id_tbl
2596: x_category_id_tbl := NULL;
2597: IF (p_category_set_id IS NOT NULL) THEN
2598: x_category_id_tbl := JTF_NUMBER_TABLE();
2599: FOR j IN 1..l_itmid_tbl.COUNT LOOP
2600: OPEN l_category_id_csr(l_itmid_tbl(j),
2601: p_organization_id,
2602: p_category_set_id);

Line 2671: p_itmid_tbl IN JTF_NUMBER_TABLE,

2667: x_return_status_text :=SQLERRM;
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,

Line 2673: p_model_id_tbl IN JTF_NUMBER_TABLE,

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,
2677: p_price_request_type IN VARCHAR2,

Line 2694: l_model_id_tbl JTF_NUMBER_TABLE;

2690: l_itmid NUMBER;
2691: l_primary_uom VARCHAR2(40);
2692: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2693: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2694: l_model_id_tbl JTF_NUMBER_TABLE;
2695: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2696: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2697: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2698: l_table_index NUMBER;

Line 2729: l_model_id_tbl := JTF_NUMBER_TABLE();

2725: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':BEGIN');
2726: END IF;
2727: l_start_time := DBMS_UTILITY.GET_TIME;
2728: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2729: l_model_id_tbl := JTF_NUMBER_TABLE();
2730: idx := 1;
2731: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2732: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':l_retrieve_all_uom='||l_retrieve_all_uom);
2733: END IF;

Line 2869: p_itmid_tbl IN JTF_NUMBER_TABLE,

2865: x_msg_data OUT NOCOPY VARCHAR2,
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,

Line 2871: p_model_id_tbl IN JTF_NUMBER_TABLE,

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,
2875: p_price_list_id IN NUMBER,

Line 2880: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

2876: p_currency_code IN VARCHAR2,
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,

Line 3014: p_item_ids IN JTF_NUMBER_TABLE,

3010: (
3011: p_api_version IN NUMBER,
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,

Line 3169: p_item_ids IN JTF_NUMBER_TABLE,

3165: (
3166: p_api_version IN NUMBER,
3167: p_init_msg_list IN VARCHAR2 := NULL,
3168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3169: p_item_ids IN JTF_NUMBER_TABLE,
3170: p_minisite_id IN NUMBER,
3171: x_minisite_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
3172: x_return_status OUT NOCOPY VARCHAR2,
3173: x_msg_count OUT NOCOPY NUMBER,

Line 3171: x_minisite_item_ids OUT NOCOPY JTF_NUMBER_TABLE,

3167: p_init_msg_list IN VARCHAR2 := NULL,
3168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3169: p_item_ids IN JTF_NUMBER_TABLE,
3170: p_minisite_id IN NUMBER,
3171: x_minisite_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
3172: x_return_status OUT NOCOPY VARCHAR2,
3173: x_msg_count OUT NOCOPY NUMBER,
3174: x_msg_data OUT NOCOPY VARCHAR2
3175: )

Line 3217: x_minisite_item_ids := JTF_NUMBER_TABLE();

3213: LOOP
3214: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);
3215: END LOOP;
3216:
3217: x_minisite_item_ids := JTF_NUMBER_TABLE();
3218: l_item_index :=1;
3219:
3220: OPEN l_itms_msite_csr(l_temp_key,p_minisite_id);
3221: LOOP