APPS.GR_INGRED_CONCENTRATIONS_PKG dependencies on GR_INGREDIENT_CONCENTRATIONS

Line 77: INSERT INTO gr_ingredient_concentrations

73: IF FND_API.To_Boolean(l_key_exists) THEN
74: RAISE Item_Exists_Error;
75: END IF;
76:
77: INSERT INTO gr_ingredient_concentrations
78: (organization_id,
79: product_item_id,
80: ingredient_item_id,
81: concentration_percentage,

Line 243: UPDATE gr_ingredient_concentrations

239:
240: IF l_return_status <> 'S' THEN
241: RAISE Foreign_Key_Error;
242: ELSE
243: UPDATE gr_ingredient_concentrations
244: SET organization_id = p_organization_id,
245: product_item_id = p_product_item_id,
246: ingredient_item_id = p_ingredient_item_id,
247: concentration_percentage = p_concentration_percentage,

Line 355: FROM gr_ingredient_concentrations

351:
352: CURSOR c_lock_concs_tl
353: IS
354: SELECT *
355: FROM gr_ingredient_concentrations
356: WHERE rowid = p_rowid
357: FOR UPDATE NOWAIT;
358: LockConcRcd c_lock_concs_tl%ROWTYPE;
359: BEGIN

Line 490: DELETE FROM gr_ingredient_concentrations

486: IF l_return_status <> 'S' THEN
487: RAISE Check_Integrity_Error;
488: END IF;
489:
490: DELETE FROM gr_ingredient_concentrations
491: WHERE rowid = p_rowid;
492:
493: /* Check the commit flag and if set, then commit the work. */
494:

Line 577: DELETE FROM gr_ingredient_concentrations

573: x_oracle_error := 0;
574: x_msg_data := NULL;
575: l_msg_token := p_product_item_id;
576:
577: DELETE FROM gr_ingredient_concentrations
578: WHERE organization_id = p_organization_id
579: AND product_item_id = p_product_item_id;
580:
581: IF FND_API.To_Boolean(p_commit) THEN

Line 738: FROM gr_ingredient_concentrations ic

734:
735: CURSOR c_get_concs_rowid
736: IS
737: SELECT ic.rowid
738: FROM gr_ingredient_concentrations ic
739: WHERE ic.organization_id = p_organization_id
740: AND ic.product_item_id = p_product_item_id
741: AND ic.ingredient_item_id = p_ingredient_item_id;
742: ConcRecord c_get_concs_rowid%ROWTYPE;