DBA Data[Home] [Help]

APPS.INV_GRADE_PKG dependencies on MTL_LOT_GRADE_HISTORY

Line 73: select mtl_lot_grade_history_s.nextval

69:
70: print_debug(' In Grade Update Package - Before Updating record ') ;
71:
72: -- BEGIN SCHANDRU INVERES
73: select mtl_lot_grade_history_s.nextval
74: into l_grade_update_id
75: from dual;
76: -- END SCHANDRU INVERES
77:

Line 144: INSERT INTO MTL_LOT_GRADE_HISTORY

140: ,x_satt => l_satt
141: ,x_satr => l_satr
142: );
143:
144: INSERT INTO MTL_LOT_GRADE_HISTORY
145: (
146: GRADE_UPDATE_ID
147: , INVENTORY_ITEM_ID
148: , ORGANIZATION_ID

Line 183: --MTL_LOT_GRADE_HISTORY_S.NEXTVAL

179: , LAST_UPDATE_LOGIN
180: ) VALUES
181: (
182: -- BEGIN SCHANDRU INVERES
183: --MTL_LOT_GRADE_HISTORY_S.NEXTVAL
184: l_grade_update_id
185: -- END SCHADRU INVERES
186: , p_inventory_item_id
187: , l_orgid--p_organization_id

Line 234: INSERT INTO MTL_LOT_GRADE_HISTORY

230: END IF;
231: --Global Lot ER END
232:
233: ELSE --l_global_profile = 'N' Global Lot ER
234: INSERT INTO MTL_LOT_GRADE_HISTORY
235: (
236: GRADE_UPDATE_ID
237: , INVENTORY_ITEM_ID
238: , ORGANIZATION_ID

Line 273: -- MTL_LOT_GRADE_HISTORY_S.NEXTVAL

269: , LAST_UPDATE_LOGIN
270: ) VALUES
271: (
272: -- BEGIN SCHANDRU INVERES
273: -- MTL_LOT_GRADE_HISTORY_S.NEXTVAL
274: l_grade_update_id
275: -- END SCHADRU INVERES
276: , p_inventory_item_id
277: , p_organization_id