APPS.GR_FIELD_NAME_MASKS_B_PKG dependencies on GR_ITEM_FIELD_NAME_MASKS_B

Line 104: INSERT INTO gr_item_field_name_masks_b

100: IF FND_API.To_Boolean(l_key_exists) THEN
101: RAISE Label_Exists_Error;
102: END IF;
103:
104: INSERT INTO gr_item_field_name_masks_b
105: (item_code,
106: disclosure_code,
107: label_code,
108: created_by,

Line 290: UPDATE gr_item_field_name_masks_b

286:
287: IF l_return_status <> 'S' THEN
288: RAISE Foreign_Key_Error;
289: ELSE
290: UPDATE gr_item_field_name_masks_b
291: SET item_code = p_item_code,
292: disclosure_code = p_disclosure_code,
293: label_code = p_label_code,
294: created_by = p_created_by,

Line 426: FROM gr_item_field_name_masks_b

422:
423: CURSOR c_lock_item
424: IS
425: SELECT *
426: FROM gr_item_field_name_masks_b
427: WHERE rowid = p_rowid
428: FOR UPDATE NOWAIT;
429: LockItemRcd c_lock_item%ROWTYPE;
430:

Line 587: DELETE FROM gr_item_field_name_masks_b

583: IF l_return_status <> 'S' THEN
584: RAISE Check_Integrity_Error;
585: END IF;
586:
587: DELETE FROM gr_item_field_name_masks_b
588: WHERE rowid = p_rowid;
589:
590: /* Check the commit flag and if set, then commit the work. */
591:

Line 796: FROM gr_item_field_name_masks_b dc

792:
793: CURSOR c_get_item_rowid
794: IS
795: SELECT dc.rowid
796: FROM gr_item_field_name_masks_b dc
797: WHERE dc.item_code = p_item_code
798: AND dc.disclosure_code = p_disclosure_code
799: AND dc.label_code = p_label_code;
800: