APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_PROCESS_LOSS

Line 71: SELECT gmd_recipe_process_loss_id_s.nextval

67: /* Generate RECIPE_PROCESS_LOSS_ID */
68: /* based on sequence number generator */
69: /* ================================== */
70: IF (p_recipe_detail_rec.recipe_process_loss_id IS NULL) THEN
71: SELECT gmd_recipe_process_loss_id_s.nextval
72: INTO l_recipe_process_loss_id
73: FROM sys.dual;
74: ELSE
75: l_recipe_process_loss_id := p_recipe_detail_rec.recipe_process_loss_id;

Line 79: INSERT INTO GMD_RECIPE_PROCESS_LOSS(

75: l_recipe_process_loss_id := p_recipe_detail_rec.recipe_process_loss_id;
76: END IF;
77:
78: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
79: INSERT INTO GMD_RECIPE_PROCESS_LOSS(
80: recipe_process_loss_id
81: ,recipe_id
82: ,organization_id
83: ,process_loss

Line 623: UPDATE gmd_recipe_process_loss

619: END IF;
620:
621: /* Update into the recipe process loss table */
622: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
623: UPDATE gmd_recipe_process_loss
624: SET recipe_id = p_recipe_detail_rec.recipe_id ,
625: organization_id = p_recipe_detail_rec.organization_id,
626: text_code = p_recipe_detail_rec.text_code,
627: process_loss = p_recipe_detail_rec.process_loss,