APPS.MTL_MGD_INV_POSITIONS_PKG dependencies on MTL_MGD_INVENTORY_POSITIONS

Line 12: --| Table Handler for table MTL_MGD_INVENTORY_POSITIONS |

8: --| FILENAME |
9: --| INVUTOSB.pls |
10: --| |
11: --| DESCRIPTION |
12: --| Table Handler for table MTL_MGD_INVENTORY_POSITIONS |
13: --| HISTORY |
14: --| 09/01/2000 Paolo Juvara Created |
15: --+======================================================================*/
16:

Line 26: -- COMMENT : Inserts a row in MTL_MGD_INVENTORY_POSITIONS; standard who

22: --========================================================================
23: -- PROCEDURE : Insert_Row PUBLIC
24: -- PARAMETERS: p_????? one parameter per column
25: -- x_rowid rowid of the inserted row
26: -- COMMENT : Inserts a row in MTL_MGD_INVENTORY_POSITIONS; standard who
27: -- value are optional and defaulted from profile options
28: --=======================================================================--
29: PROCEDURE Insert_Row
30: ( p_data_set_name IN VARCHAR2

Line 61: INSERT INTO mtl_mgd_inventory_positions

57: , p_org_end_on_hand_qty IN NUMBER
58: )
59: IS
60: BEGIN
61: INSERT INTO mtl_mgd_inventory_positions
62: ( data_set_name
63: , bucket_name
64: , organization_code
65: , inventory_item_code

Line 130: -- COMMENT : Updates the hierarchy data on a row in MTL_MGD_INVENTORY_POSITIONS;

126: -- p_bucket_name identfies row (2/4)
127: -- p_organization_id identifies_row (3/4)
128: -- p_inventory_item_id identifies_row (4/4)
129: -- p_????? one parameter per column to update
130: -- COMMENT : Updates the hierarchy data on a row in MTL_MGD_INVENTORY_POSITIONS;
131: -- standard who value are optional and defaulted from profile options
132: --=======================================================================--
133: PROCEDURE Update_Hierarchy_Data
134: ( p_data_set_name IN VARCHAR2

Line 151: UPDATE mtl_mgd_inventory_positions

147: )
148: IS
149: BEGIN
150:
151: UPDATE mtl_mgd_inventory_positions
152: SET last_update_date = NVL(p_last_update_date, SYSDATE)
153: , last_updated_by = NVL
154: ( p_last_updated_by
155: , NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0)

Line 201: FROM mtl_mgd_inventory_positions

197: )
198: IS
199: BEGIN
200: DELETE
201: FROM mtl_mgd_inventory_positions
202: WHERE data_set_name = NVL(p_data_set_name, data_set_name)
203: AND created_by = NVL(p_created_by, created_by)
204: AND creation_date <= NVL(p_creation_date, creation_date);
205: END Delete;

Line 215: FROM mtl_mgd_inventory_positions;

211: PROCEDURE Delete_All
212: IS
213: BEGIN
214: DELETE
215: FROM mtl_mgd_inventory_positions;
216: END Delete_All;
217:
218: END MTL_MGD_INV_POSITIONS_PKG;