DBA Data[Home] [Help]

APPS.GMD_QUALITY_GRP dependencies on GMD_SPEC_MATCH_GRP

Line 689: l_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;

685: , x_return_status OUT NOCOPY VARCHAR2
686: )
687: IS
688: l_api_name VARCHAR2(100) := 'GET_INV_SPEC_TEST_VALUE';
689: l_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;
690: l_level_rec GMD_QUALITY_GRP.inv_inp_rec_type;
691: x_spec_id NUMBER;
692: x_spec_vr_id NUMBER;
693: x_msg_data VARCHAR2(2000);

Line 728: IF GMD_SPEC_MATCH_GRP.find_inventory_spec

724: l_inventory_spec_rec.date_effective := SYSDATE;
725: l_inventory_spec_rec.exact_match := 'N' ;
726:
727: -- get the inventory spec match
728: IF GMD_SPEC_MATCH_GRP.find_inventory_spec
729: ( p_inventory_spec_rec => l_inventory_spec_rec
730: , x_spec_id => x_spec_id
731: , x_spec_vr_id => x_spec_vr_id
732: , x_return_status => x_return_status