DBA Data[Home] [Help]

APPS.GR_ITEM_SAFETY dependencies on GR_ITEM_GENERAL

Line 270: from gr_item_general_v

266: ** Get the Item Code
267: */
268: CURSOR c_get_item_code (V_item_id NUMBER) IS
269: select item_code
270: from gr_item_general_v
271: where organization_id = p_organization_id
272: and inventory_item_id = V_item_id;
273:
274: l_copy_item VARCHAR2(240);

Line 618: FROM gr_item_general ig1

614: ig1.creation_date,
615: ig1.last_updated_by,
616: ig1.last_update_date,
617: ig1.last_update_login
618: FROM gr_item_general ig1
619: WHERE ig1.item_code = p_delete_item;
620: LocalItemRecord c_get_item_general%ROWTYPE;
621: /*
622: ** Get the EMEA row

Line 695: GR_ITEM_GENERAL_PKG.Lock_Row

691: CLOSE c_get_item_general;
692: END IF;
693:
694: l_return_status := FND_API.G_RET_STS_SUCCESS;
695: GR_ITEM_GENERAL_PKG.Lock_Row
696: (l_commit,
697: l_called_by_form,
698: LocalItemRecord.ROWID,
699: LocalItemRecord.item_group_code,

Line 1062: GR_ITEM_GENERAL_PKG.Delete_Row

1058: /*
1059: ** Delete the item general row
1060: */
1061: l_return_status := FND_API.G_RET_STS_SUCCESS;
1062: GR_ITEM_GENERAL_PKG.Delete_Row
1063: (l_commit,
1064: l_called_by_form,
1065: LocalItemRecord.ROWID,
1066: LocalItemRecord.item_group_code,