DBA Data[Home] [Help]

APPS.GMIVDBL dependencies on MTL_CATEGORIES_V

Line 766: p_category_concat_segs mtl_categories_v.category_concat_segs%TYPE,

762: END GMI_ITEM_CATEGORIES;
763:
764: PROCEDURE GMI_ITEM_CATEGORIES_INSERT (p_ic_item_mst_row IN ic_item_mst%ROWTYPE,
765: p_category_set_id NUMBER,
766: p_category_concat_segs mtl_categories_v.category_concat_segs%TYPE,
767: p_structure_id NUMBER,
768: p_category_id IN OUT NOCOPY NUMBER)
769: IS
770: Cursor get_category_id(Vcategory_concat_segs mtl_categories_v.category_concat_segs%TYPE,

Line 770: Cursor get_category_id(Vcategory_concat_segs mtl_categories_v.category_concat_segs%TYPE,

766: p_category_concat_segs mtl_categories_v.category_concat_segs%TYPE,
767: p_structure_id NUMBER,
768: p_category_id IN OUT NOCOPY NUMBER)
769: IS
770: Cursor get_category_id(Vcategory_concat_segs mtl_categories_v.category_concat_segs%TYPE,
771: Vstructure_id NUMBER) IS
772: SELECT category_id
773: FROM mtl_categories_v
774: WHERE category_concat_segs = Vcategory_concat_segs

Line 773: FROM mtl_categories_v

769: IS
770: Cursor get_category_id(Vcategory_concat_segs mtl_categories_v.category_concat_segs%TYPE,
771: Vstructure_id NUMBER) IS
772: SELECT category_id
773: FROM mtl_categories_v
774: WHERE category_concat_segs = Vcategory_concat_segs
775: AND structure_id = Vstructure_id;
776:
777: BEGIN