APPS.GR_INGRED_CONC_DETAILS_PKG dependencies on GR_INGREDIENT_CONC_DETAILS

Line 82: INSERT INTO gr_ingredient_conc_details

78: IF FND_API.To_Boolean(l_key_exists) THEN
79: RAISE Item_Exists_Error;
80: END IF;
81:
82: INSERT INTO gr_ingredient_conc_details
83: (organization_id,
84: inventory_item_id,
85: ingredient_item_id,
86: source_item_id,

Line 252: UPDATE gr_ingredient_conc_details

248:
249: IF l_return_status <> 'S' THEN
250: RAISE Foreign_Key_Error;
251: ELSE
252: UPDATE gr_ingredient_conc_details
253: SET organization_id = p_organization_id,
254: inventory_item_id = p_inventory_item_id,
255: ingredient_item_id = p_ingredient_item_id,
256: source_item_id = p_source_item_id,

Line 361: FROM gr_ingredient_conc_details

357:
358: CURSOR c_lock_concs_tl
359: IS
360: SELECT *
361: FROM gr_ingredient_conc_details
362: WHERE rowid = p_rowid
363: FOR UPDATE NOWAIT;
364: LockConcRcd c_lock_concs_tl%ROWTYPE;
365: BEGIN

Line 498: DELETE FROM gr_ingredient_conc_details

494: IF l_return_status <> 'S' THEN
495: RAISE Check_Integrity_Error;
496: END IF;
497:
498: DELETE FROM gr_ingredient_conc_details
499: WHERE rowid = p_rowid;
500:
501: /* Check the commit flag and if set, then commit the work. */
502:

Line 585: DELETE FROM gr_ingredient_conc_details

581: x_oracle_error := 0;
582: x_msg_data := NULL;
583: l_msg_token := p_inventory_item_id;
584:
585: DELETE FROM gr_ingredient_conc_details
586: WHERE organization_id = p_organization_id
587: AND inventory_item_id = p_inventory_item_id;
588:
589: IF FND_API.To_Boolean(p_commit) THEN

Line 756: FROM gr_ingredient_conc_details icd

752:
753: CURSOR c_get_concs_rowid
754: IS
755: SELECT icd.rowid
756: FROM gr_ingredient_conc_details icd
757: WHERE icd.organization_id = p_organization_id
758: AND icd.inventory_item_id = p_inventory_item_id
759: AND icd.ingredient_item_id = p_ingredient_item_id
760: AND icd.source_item_id = p_source_item_id;