[Home] [Help]
2172: attribute11, attribute12, attribute13, attribute14, attribute15,
2173: attribute16, attribute17, attribute18, attribute19, attribute20,
2174: attribute21, attribute22, attribute23, attribute24,attribute25,
2175: attribute26, attribute27, attribute28, attribute29, attribute30
2176: From gmd_recipe_routing_steps
2177: where recipe_id = NVL(vRecipe_id,-1) AND
2178: RoutingStep_id = NVL(vRoutingStep_id,-1);
2179:
2180: CURSOR update_rt_cur(vRecipe_id NUMBER, vRoutingStep_id NUMBER) IS
2178: RoutingStep_id = NVL(vRoutingStep_id,-1);
2179:
2180: CURSOR update_rt_cur(vRecipe_id NUMBER, vRoutingStep_id NUMBER) IS
2181: Select mass_qty, volume_qty, mass_std_uom, volume_std_uom
2182: From gmd_recipe_routing_steps
2183: where recipe_id = NVL(vRecipe_id,-1) AND
2184: RoutingStep_id = NVL(vRoutingStep_id,-1);
2185:
2186: setup_failure EXCEPTION;
2318:
2319: /* ================================ */
2320: /* Check for all G_MISS_CHAR values */
2321: /* for nullable fields in */
2322: /* gmd_recipe_routing_steps table */
2323: /* ================================= */
2324:
2325: /* Thomas Daniel - Bug 2652200 */
2326: /* Reversed the handling of FND_API.G_MISS_CHAR, now if the user */
2763:
2764: /* ================================ */
2765: /* Check for all G_MISS_CHAR values */
2766: /* for nullable fields in */
2767: /* gmd_recipe_routing_steps table */
2768: /* ================================= */
2769:
2770: /* Thomas Daniel - Bug 2652200 */
2771: /* Reversed the handling of FND_API.G_MISS_CHAR, now if the user */
3307:
3308: /* ================================ */
3309: /* Check for all G_MISS_CHAR values */
3310: /* for nullable fields in */
3311: /* gmd_recipe_routing_steps table */
3312: /* ================================= */
3313:
3314: /* Thomas Daniel - Bug 2652200 */
3315: /* Reversed the handling of FND_API.G_MISS_CHAR, now if the user */