DBA Data[Home] [Help]

APPS.IBE_CATALOG_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 663: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,

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:
667: --Bug 3063233

Line 664: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

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:
667: --Bug 3063233
668: procedure validate_de_qty_msite_check

Line 671: p_reqd_validation IN JTF_VARCHAR2_TABLE_100,

667: --Bug 3063233
668: procedure validate_de_qty_msite_check
669: (p_api_version IN NUMBER,
670: p_init_msg_list IN VARCHAR2 := NULL,
671: p_reqd_validation IN JTF_VARCHAR2_TABLE_100,
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,

Line 679: p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,

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:
683: procedure load_msite_languages

Line 680: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

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:
683: procedure load_msite_languages
684: (x_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 684: (x_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

680: x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
681: );
682:
683: procedure load_msite_languages
684: (x_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
685: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
686: x_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300 --gzhang 07/19/2002, bug#2469521
687: );
688:

Line 685: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

681: );
682:
683: procedure load_msite_languages
684: (x_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
685: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
686: x_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300 --gzhang 07/19/2002, bug#2469521
687: );
688:
689: procedure load_language

Line 691: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

687: );
688:
689: procedure load_language
690: (p_lang_code IN VARCHAR2,
691: x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
692: x_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300, --gzhang 07/19/2002, bug#2469521
693: x_nls_lang OUT NOCOPY VARCHAR2 --jqu 1/19/2005
694: );
695:

Line 725: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

721: x_model_bundle_flag OUT NOCOPY VARCHAR2,
722: x_uom_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE,
723:
724: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
725: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
726: x_price_status_code OUT NOCOPY VARCHAR2,
727: x_price_status_text OUT NOCOPY VARCHAR2
728: );
729:

Line 742: p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,

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,
746: p_retrieve_price IN VARCHAR2,

Line 753: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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,
757: x_price_status_code OUT NOCOPY VARCHAR2,

Line 754: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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,
757: x_price_status_code OUT NOCOPY VARCHAR2,
758: x_price_status_text OUT NOCOPY VARCHAR2

Line 756: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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,
757: x_price_status_code OUT NOCOPY VARCHAR2,
758: x_price_status_text OUT NOCOPY VARCHAR2
759: );
760:

Line 768: x_item_type OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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,
771: x_msg_data OUT NOCOPY VARCHAR2
772: );