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 279: -- p_sectid_tbl IN JTF_NUMBER_TABLE

275: -- Parameters :
276: -- IN : p_api_version IN NUMBER Required
277: -- p_init_msg_list IN VARCHAR2 Optional
278: -- p_validation_level IN NUMBER Optional
279: -- p_sectid_tbl IN JTF_NUMBER_TABLE
280: -- p_msite_id IN NUMBER
281: --
282: -- OUT : x_return_status OUT VARCHAR2(1)
283: -- x_msg_count OUT NUMBER

Line 285: -- x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE

281: --
282: -- OUT : x_return_status OUT VARCHAR2(1)
283: -- x_msg_count OUT NUMBER
284: -- x_msg_data OUT VARCHAR2(2000)
285: -- x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE
286: -- x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE
287: -- x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE
288: -- x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE
289: -- x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE

Line 286: -- x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE

282: -- OUT : x_return_status OUT VARCHAR2(1)
283: -- x_msg_count OUT NUMBER
284: -- x_msg_data OUT VARCHAR2(2000)
285: -- x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE
286: -- x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE
287: -- x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE
288: -- x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE
289: -- x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE
290: -- x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300

Line 287: -- x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE

283: -- x_msg_count OUT NUMBER
284: -- x_msg_data OUT VARCHAR2(2000)
285: -- x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE
286: -- x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE
287: -- x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE
288: -- x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE
289: -- x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE
290: -- x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
291: -- x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300

Line 288: -- x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE

284: -- x_msg_data OUT VARCHAR2(2000)
285: -- x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE
286: -- x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE
287: -- x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE
288: -- x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE
289: -- x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE
290: -- x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
291: -- x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
292: -- x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE

Line 289: -- x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE

285: -- x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE
286: -- x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE
287: -- x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE
288: -- x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE
289: -- x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE
290: -- x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
291: -- x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
292: -- x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
293: -- x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE

Line 314: p_sectid_tbl IN JTF_NUMBER_TABLE,

310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_msg_count OUT NOCOPY NUMBER,
313: x_msg_data OUT NOCOPY VARCHAR2,
314: p_sectid_tbl IN JTF_NUMBER_TABLE,
315: p_msite_id IN NUMBER,
316: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
317: x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
318: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 316: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,

312: x_msg_count OUT NOCOPY NUMBER,
313: x_msg_data OUT NOCOPY VARCHAR2,
314: p_sectid_tbl IN JTF_NUMBER_TABLE,
315: p_msite_id IN NUMBER,
316: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
317: x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
318: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
319: x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
320: x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE,

Line 317: x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,

313: x_msg_data OUT NOCOPY VARCHAR2,
314: p_sectid_tbl IN JTF_NUMBER_TABLE,
315: p_msite_id IN NUMBER,
316: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
317: x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
318: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
319: x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
320: x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
321: x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,

Line 318: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE,

314: p_sectid_tbl IN JTF_NUMBER_TABLE,
315: p_msite_id IN NUMBER,
316: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
317: x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
318: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
319: x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
320: x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
321: x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
322: x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,

Line 319: x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE,

315: p_msite_id IN NUMBER,
316: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
317: x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
318: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
319: x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
320: x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
321: x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
322: x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
323: x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,

Line 320: x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE,

316: x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
317: x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
318: x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
319: x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
320: x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
321: x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
322: x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
323: x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
324: x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE,

Line 467: -- x_service_item_ids OUT nocopy JTF_NUMBER_TABLE

463: -- OUT :
464: -- x_return_status OUT VARCHAR2(1)
465: -- x_msg_count OUT NUMBER
466: -- x_msg_data OUT VARCHAR2(2000)
467: -- x_service_item_ids OUT nocopy JTF_NUMBER_TABLE
468: --
469: -- Version : Current version 1.0
470: --
471: -- previous version None

Line 489: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE

485: p_product_item_id IN NUMBER,
486: p_customer_id IN NUMBER,
487: p_product_revision IN VARCHAR2,
488: p_request_date IN DATE,
489: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE
490: );
491: -- Start of comments
492: -- API name : GetRelatedCatOrSectIDs
493: -- Type : Private.

Line 522: -- x_relatedid_tbl OUT nocopy JTF_NUMBER_TABLE

518: --
519: -- OUT : x_return_status OUT VARCHAR2(1)
520: -- x_msg_count OUT NUMBER
521: -- x_msg_data OUT VARCHAR2(2000)
522: -- x_relatedid_tbl OUT nocopy JTF_NUMBER_TABLE
523: --
524: -- Version : Current version 1.0
525: --
526: -- previous version None

Line 547: x_relatedid_tbl OUT nocopy JTF_NUMBER_TABLE

543: p_originid IN NUMBER,
544: p_origintype IN VARCHAR2,
545: p_reltype_code IN VARCHAR2,
546: p_dest_type IN VARCHAR2,
547: x_relatedid_tbl OUT nocopy JTF_NUMBER_TABLE
548: );
549:
550:
551:

Line 660: p_item_id_tbl IN JTF_NUMBER_TABLE,

656: x_return_status OUT NOCOPY VARCHAR2,
657: x_msg_count OUT NOCOPY NUMBER,
658: x_msg_data OUT NOCOPY VARCHAR2,
659:
660: p_item_id_tbl IN JTF_NUMBER_TABLE,
661: p_organization_id_tbl IN JTF_NUMBER_TABLE,
662: p_qty_tbl IN JTF_NUMBER_TABLE,
663: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
664: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 661: p_organization_id_tbl IN JTF_NUMBER_TABLE,

657: x_msg_count OUT NOCOPY NUMBER,
658: x_msg_data OUT NOCOPY VARCHAR2,
659:
660: p_item_id_tbl IN JTF_NUMBER_TABLE,
661: p_organization_id_tbl IN JTF_NUMBER_TABLE,
662: p_qty_tbl IN JTF_NUMBER_TABLE,
663: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
664: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
665: );

Line 662: p_qty_tbl IN JTF_NUMBER_TABLE,

658: x_msg_data OUT NOCOPY VARCHAR2,
659:
660: p_item_id_tbl IN JTF_NUMBER_TABLE,
661: p_organization_id_tbl IN JTF_NUMBER_TABLE,
662: p_qty_tbl IN JTF_NUMBER_TABLE,
663: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
664: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
665: );
666:

Line 676: p_item_id_tbl IN JTF_NUMBER_TABLE,

672: p_msite_id IN NUMBER,
673: x_return_status OUT NOCOPY VARCHAR2,
674: x_msg_count OUT NOCOPY NUMBER,
675: x_msg_data OUT NOCOPY VARCHAR2,
676: p_item_id_tbl IN JTF_NUMBER_TABLE,
677: p_organization_id_tbl IN JTF_NUMBER_TABLE,
678: p_qty_tbl IN JTF_NUMBER_TABLE,
679: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
680: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 677: p_organization_id_tbl IN JTF_NUMBER_TABLE,

673: x_return_status OUT NOCOPY VARCHAR2,
674: x_msg_count OUT NOCOPY NUMBER,
675: x_msg_data OUT NOCOPY VARCHAR2,
676: p_item_id_tbl IN JTF_NUMBER_TABLE,
677: p_organization_id_tbl IN JTF_NUMBER_TABLE,
678: p_qty_tbl IN JTF_NUMBER_TABLE,
679: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
680: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
681: );

Line 678: p_qty_tbl IN JTF_NUMBER_TABLE,

674: x_msg_count OUT NOCOPY NUMBER,
675: x_msg_data OUT NOCOPY VARCHAR2,
676: p_item_id_tbl IN JTF_NUMBER_TABLE,
677: p_organization_id_tbl IN JTF_NUMBER_TABLE,
678: p_qty_tbl IN JTF_NUMBER_TABLE,
679: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
680: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
681: );
682:

Line 741: p_itmid_tbl IN JTF_NUMBER_TABLE,

737: x_msg_data OUT NOCOPY VARCHAR2,
738:
739: p_load_level IN NUMBER,
740: p_preview_flag IN VARCHAR2,
741: p_itmid_tbl IN JTF_NUMBER_TABLE,
742: p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,
743: p_model_id_tbl IN JTF_NUMBER_TABLE,
744: p_organization_id IN NUMBER,
745: p_category_set_id IN NUMBER,

Line 743: p_model_id_tbl IN JTF_NUMBER_TABLE,

739: p_load_level IN NUMBER,
740: p_preview_flag IN VARCHAR2,
741: p_itmid_tbl IN JTF_NUMBER_TABLE,
742: p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,
743: p_model_id_tbl IN JTF_NUMBER_TABLE,
744: p_organization_id IN NUMBER,
745: p_category_set_id IN NUMBER,
746: p_retrieve_price IN VARCHAR2,
747: p_price_list_id IN NUMBER,

Line 752: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

748: p_currency_code IN VARCHAR2,
749: p_price_request_type IN VARCHAR2,
750: p_price_event IN VARCHAR2,
751: p_minisite_id IN NUMBER := NULL,
752: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
753: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
754: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
755: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
756: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 766: p_item_ids IN JTF_NUMBER_TABLE,

762: (
763: p_api_version IN NUMBER,
764: p_init_msg_list IN VARCHAR2 := NULL,
765: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
766: p_item_ids IN JTF_NUMBER_TABLE,
767: p_organization_id IN NUMBER,
768: x_item_type OUT NOCOPY JTF_VARCHAR2_TABLE_100,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,

Line 779: p_item_ids IN JTF_NUMBER_TABLE,

775: (
776: p_api_version IN NUMBER,
777: p_init_msg_list IN VARCHAR2 := NULL,
778: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
779: p_item_ids IN JTF_NUMBER_TABLE,
780: p_minisite_id IN NUMBER,
781: x_minisite_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,

Line 781: x_minisite_item_ids OUT NOCOPY JTF_NUMBER_TABLE,

777: p_init_msg_list IN VARCHAR2 := NULL,
778: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
779: p_item_ids IN JTF_NUMBER_TABLE,
780: p_minisite_id IN NUMBER,
781: x_minisite_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2
785: );