119:
120: -- Bug 13706812/13839066 - Let's make sure we update primary_item_id.
121: CURSOR Cur_get_prim_item(v_recipe_validity_rule_id NUMBER, v_organization_id NUMBER) IS
122: SELECT inventory_item_id
123: FROM gmd_recipe_validity_rules
124: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id
125: AND organization_id = v_organization_id
126: AND ROWNUM = 1;
127:
127:
128: -- Bug 13996808 - Let's check null org.
129: CURSOR Cur_get_prim_item_null(v_recipe_validity_rule_id NUMBER) IS
130: SELECT inventory_item_id
131: FROM gmd_recipe_validity_rules
132: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id
133: AND organization_id IS NULL
134: AND ROWNUM = 1;
135: