APPS.GR_ITEM_CONC_DETAILS_PKG dependencies on GR_ITEM_CONC_DETAILS

Line 1: PACKAGE BODY GR_ITEM_CONC_DETAILS_PKG AS

1: PACKAGE BODY GR_ITEM_CONC_DETAILS_PKG AS
2: /*$Header: GRHIICDB.pls 115.6 2002/10/25 20:11:58 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 79: INSERT INTO gr_item_conc_details

75: IF FND_API.To_Boolean(l_key_exists) THEN
76: RAISE Item_Exists_Error;
77: END IF;
78:
79: INSERT INTO gr_item_conc_details
80: (item_code,
81: ingredient_item_code,
82: source_item_code,
83: level_hierarchy_code,

Line 244: UPDATE gr_item_conc_details

240:
241: IF l_return_status <> 'S' THEN
242: RAISE Foreign_Key_Error;
243: ELSE
244: UPDATE gr_item_conc_details
245: SET item_code = p_item_code,
246: ingredient_item_code = p_ingredient_item_code,
247: source_item_code = p_source_item_code,
248: level_hierarchy_code = p_level_hierarchy_code,

Line 351: FROM gr_item_conc_details

347:
348: CURSOR c_lock_concs_tl
349: IS
350: SELECT *
351: FROM gr_item_conc_details
352: WHERE rowid = p_rowid
353: FOR UPDATE NOWAIT;
354: LockConcRcd c_lock_concs_tl%ROWTYPE;
355: BEGIN

Line 486: DELETE FROM gr_item_conc_details

482: IF l_return_status <> 'S' THEN
483: RAISE Check_Integrity_Error;
484: END IF;
485:
486: DELETE FROM gr_item_conc_details
487: WHERE rowid = p_rowid;
488:
489: /* Check the commit flag and if set, then commit the work. */
490:

Line 572: DELETE FROM gr_item_conc_details

568: x_oracle_error := 0;
569: x_msg_data := NULL;
570: l_msg_token := p_item_code;
571:
572: DELETE FROM gr_item_conc_details
573: WHERE item_code = p_item_code;
574:
575: IF FND_API.To_Boolean(p_commit) THEN
576: COMMIT WORK;

Line 739: FROM gr_item_conc_details icd

735:
736: CURSOR c_get_concs_rowid
737: IS
738: SELECT icd.rowid
739: FROM gr_item_conc_details icd
740: WHERE icd.item_code = p_item_code
741: AND icd.ingredient_item_code = p_ingredient_item_code
742: AND icd.source_item_code = p_source_item_code;
743: ConcRecord c_get_concs_rowid%ROWTYPE;

Line 775: END GR_ITEM_CONC_DETAILS_PKG;

771: END IF;
772:
773: END Check_Primary_Key;
774:
775: END GR_ITEM_CONC_DETAILS_PKG;