APPS.GMD_COMMON_VAL dependencies on GMD_PROCESS_LOSS

Line 516: /* Step4 - Get the process loss from gmd_process_loss table. */

512: /* Step1 - Based on the routing_id get the routing_class from fm_rout_hdr */
513: /* Step2 - Based on routing_class get the UOM from fm_rout_cls table */
514: /* Step3 - Check if recipe uom can be converted to this UOM and convert */
515: /* total product qty to this UOM */
516: /* Step4 - Get the process loss from gmd_process_loss table. */
517: /* Step5 - apply a prorated values in routing */
518: /* Step 6 - apply prorated values in recipe for batch */
519: /* ======================================================================== */
520: /* HISTORY */

Line 540: x_recipe_theo_loss OUT NOCOPY GMD_PROCESS_LOSS.process_loss%TYPE ,

536:
537: PROCEDURE Calculate_Process_loss
538: ( process_loss IN process_loss_rec ,
539: Entity_type IN VARCHAR2 ,
540: x_recipe_theo_loss OUT NOCOPY GMD_PROCESS_LOSS.process_loss%TYPE ,
541: x_process_loss OUT NOCOPY GMD_PROCESS_LOSS.process_loss%TYPE ,
542: x_return_status OUT NOCOPY VARCHAR2 ,
543: x_msg_count OUT NOCOPY NUMBER ,
544: x_msg_data OUT NOCOPY VARCHAR2

Line 541: x_process_loss OUT NOCOPY GMD_PROCESS_LOSS.process_loss%TYPE ,

537: PROCEDURE Calculate_Process_loss
538: ( process_loss IN process_loss_rec ,
539: Entity_type IN VARCHAR2 ,
540: x_recipe_theo_loss OUT NOCOPY GMD_PROCESS_LOSS.process_loss%TYPE ,
541: x_process_loss OUT NOCOPY GMD_PROCESS_LOSS.process_loss%TYPE ,
542: x_return_status OUT NOCOPY VARCHAR2 ,
543: x_msg_count OUT NOCOPY NUMBER ,
544: x_msg_data OUT NOCOPY VARCHAR2
545: ) IS

Line 595: FROM gmd_process_loss

591: and delete_mark = 0;
592:
593: CURSOR process_loss_cur(vRouting_class VARCHAR2, qty NUMBER) IS
594: SELECT process_loss
595: FROM gmd_process_loss
596: WHERE routing_class = vRouting_class AND
597: (max_quantity >= qty OR
598: max_quantity IS NULL)
599: ORDER BY max_quantity;

Line 782: from gmd_process_loss table Cannot calculate recipe theo/planned

778: to the routing class UOM */
779: END IF;
780:
781: /* Get the theoretical/planned process loss for this recipe qty
782: from gmd_process_loss table Cannot calculate recipe theo/planned
783: loss if the recipe_qty is NULL or < 0 */
784: If (l_recipe_qty >= 0) THEN
785: open process_loss_cur(l_routing_class,l_recipe_qty);
786: fetch process_loss_cur INTO l_recipe_theo_loss;

Line 877: /* from gmd_process_loss table Cannot calculate recipe theo/planned

873: ||' rout class:'||l_routing_class
874: ||' recipe prorate:'||l_recipe_prorate_factor);
875: END IF;
876: /* Get the theoretical/planned process loss for this recipe qty */
877: /* from gmd_process_loss table Cannot calculate recipe theo/planned
878: loss if the recipe_qty is NULL or < 0 */
879: If (l_validity_qty >= 0) THEN
880: open process_loss_cur(l_routing_class,l_validity_qty);
881: fetch process_loss_cur INTO x_recipe_theo_loss;