DBA Data[Home] [Help]

APPS.GMIVDBL dependencies on GMI_CATEGORY_SETS

Line 418: Cursor get_category_set_id(Vopm_class gmi_category_sets.opm_class%TYPE) IS

414:
415: -- TKW 9/11/2003 B2378017 Changed signature of proc below.
416: PROCEDURE GMI_ITEM_CATEGORIES (p_item_rec IN GMIGAPI.item_rec_typ, p_ic_item_mst_row IN ic_item_mst%ROWTYPE)
417: IS
418: Cursor get_category_set_id(Vopm_class gmi_category_sets.opm_class%TYPE) IS
419: SELECT gmi.category_set_id,mtl.structure_id
420: FROM gmi_category_sets gmi,
421: mtl_category_sets mtl
422: WHERE gmi.opm_class = Vopm_class

Line 420: FROM gmi_category_sets gmi,

416: PROCEDURE GMI_ITEM_CATEGORIES (p_item_rec IN GMIGAPI.item_rec_typ, p_ic_item_mst_row IN ic_item_mst%ROWTYPE)
417: IS
418: Cursor get_category_set_id(Vopm_class gmi_category_sets.opm_class%TYPE) IS
419: SELECT gmi.category_set_id,mtl.structure_id
420: FROM gmi_category_sets gmi,
421: mtl_category_sets mtl
422: WHERE gmi.opm_class = Vopm_class
423: AND mtl.category_set_id = gmi.category_set_id;
424: