1 PACKAGE MTL_MGD_INV_POSITIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVTPOSS.pls 115.1 2002/12/24 23:29:30 vjavli ship $ */
3 --+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVUTOSS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Table Handler for table MTL_MGD_INVENTORY_POSITIONS |
13 --| HISTORY |
14 --| 09/01/2000 Paolo Juvara Created |
15 --+======================================================================*/
16
17
18 --===================
19 -- PROCEDURES AND FUNCTIONS
20 --===================
21
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
31 , p_bucket_name IN VARCHAR2
32 , p_organization_code IN VARCHAR2
33 , p_inventory_item_code IN VARCHAR2
34 , p_creation_date IN DATE DEFAULT NULL
35 , p_created_by IN NUMBER DEFAULT NULL
36 , p_last_update_date IN DATE DEFAULT NULL
37 , p_last_updated_by IN NUMBER DEFAULT NULL
38 , p_last_update_login IN NUMBER DEFAULT NULL
39 , p_request_id IN NUMBER DEFAULT NULL
40 , p_program_application_id IN NUMBER DEFAULT NULL
41 , p_program_id IN NUMBER DEFAULT NULL
42 , p_program_update_date IN DATE DEFAULT NULL
43 , p_hierarchy_id IN NUMBER
44 , p_hierarchy_name IN VARCHAR2
45 , p_parent_organization_code IN VARCHAR2
46 , p_parent_organization_id IN VARCHAR2
47 , p_bucket_size_code IN VARCHAR2
48 , p_bucket_start_date IN DATE
49 , p_bucket_end_date IN DATE
50 , p_inventory_item_id IN NUMBER
51 , p_organization_id IN NUMBER
52 , p_hierarchy_delta_qty IN NUMBER
53 , p_hierarchy_end_on_hand_qty IN NUMBER
54 , p_org_received_qty IN NUMBER
55 , p_org_issued_qty IN NUMBER
56 , p_org_delta_qty IN NUMBER
57 , p_org_end_on_hand_qty IN NUMBER
58 );
59
60 --========================================================================
61 -- PROCEDURE : Update_Hierarchy_Data PUBLIC
62 -- PARAMETERS: p_data_set_name identifies row (1/4)
63 -- p_bucket_name identfies row (2/4)
64 -- p_organization_id identifies_row (3/4)
65 -- p_inventory_item_id identifies_row (4/4)
66 -- p_????? one parameter per column to update
67 -- COMMENT : Updates the hierarchy data on a row in MTL_MGD_INVENTORY_POSITIONS;
68 -- standard who value are optional and defaulted from profile options
69 --=======================================================================--
70 PROCEDURE Update_Hierarchy_Data
71 ( p_data_set_name IN VARCHAR2
72 , p_bucket_name IN VARCHAR2
73 , p_organization_id IN NUMBER
74 , p_inventory_item_id IN NUMBER
75 , p_last_update_date IN DATE DEFAULT NULL
76 , p_last_updated_by IN NUMBER DEFAULT NULL
77 , p_last_update_login IN NUMBER DEFAULT NULL
78 , p_request_id IN NUMBER DEFAULT NULL
79 , p_program_application_id IN NUMBER DEFAULT NULL
80 , p_program_id IN NUMBER DEFAULT NULL
81 , p_program_update_date IN DATE DEFAULT NULL
82 , p_hierarchy_delta_qty IN NUMBER
83 , p_hierarchy_end_on_hand_qty IN NUMBER
84 );
85
86 --========================================================================
87 -- PROCEDURE : Delete PUBLIC
88 -- PARAMETERS: p_data_set_name delete specific data set name
89 -- p_created_by delete data set for specific user ID
90 -- p_creation_date delete data set created before date
91 -- COMMENT : Delete rows using one or more specified criteria (each criteria is
92 -- an additional filter
93 --=======================================================================--
94 PROCEDURE Delete
95 ( p_data_set_name IN VARCHAR2 DEFAULT NULL
96 , p_created_by IN NUMBER DEFAULT NULL
97 , p_creation_date IN DATE DEFAULT NULL
98 );
99
100 --========================================================================
101 -- PROCEDURE : Delete_All PUBLIC
102 -- COMMENT : Delete all rows
103 --=======================================================================--
104 PROCEDURE Delete_All;
105
106 END MTL_MGD_INV_POSITIONS_PKG;