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 633: UPDATE gmd_recipe_process_loss

629: END IF;
630:
631: /* Update into the recipe process loss table */
632: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
633: UPDATE gmd_recipe_process_loss
634: SET recipe_id = p_recipe_detail_rec.recipe_id ,
635: organization_id = p_recipe_detail_rec.organization_id,
636: text_code = p_recipe_detail_rec.text_code,
637: process_loss = p_recipe_detail_rec.process_loss,