1 PACKAGE GR_INGRED_CONC_DETAILS_PKG AS
2 /*$Header: GRHINCDS.pls 120.0 2005/07/08 11:23:29 methomas noship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_organization_id IN NUMBER,
7 p_inventory_item_id IN NUMBER,
8 p_ingredient_item_id IN NUMBER,
9 p_source_item_id IN NUMBER,
10 p_level_hierarchy_code IN NUMBER,
11 p_work_concentration IN NUMBER,
12 p_uom IN VARCHAR2,
13 p_quantity IN NUMBER,
14 x_rowid OUT NOCOPY VARCHAR2,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_oracle_error OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2);
18 PROCEDURE Update_Row
19 (p_commit IN VARCHAR2,
20 p_called_by_form IN VARCHAR2,
21 p_rowid IN VARCHAR2,
22 p_organization_id IN NUMBER,
23 p_inventory_item_id IN NUMBER,
24 p_ingredient_item_id IN NUMBER,
25 p_source_item_id IN NUMBER,
26 p_level_hierarchy_code IN NUMBER,
27 p_work_concentration IN NUMBER,
28 p_uom IN VARCHAR2,
29 p_quantity IN NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_oracle_error OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2);
33 PROCEDURE Lock_Row
34 (p_commit IN VARCHAR2,
35 p_called_by_form IN VARCHAR2,
36 p_rowid IN VARCHAR2,
37 p_organization_id IN NUMBER,
38 p_inventory_item_id IN NUMBER,
39 p_ingredient_item_id IN NUMBER,
40 p_source_item_id IN NUMBER,
41 p_level_hierarchy_code IN NUMBER,
42 p_work_concentration IN NUMBER,
43 p_uom IN VARCHAR2,
44 p_quantity IN NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_oracle_error OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2);
48 PROCEDURE Delete_Row
49 (p_commit IN VARCHAR2,
50 p_called_by_form IN VARCHAR2,
51 p_rowid IN VARCHAR2,
52 p_organization_id IN NUMBER,
53 p_inventory_item_id IN NUMBER,
54 p_ingredient_item_id IN NUMBER,
55 p_source_item_id IN NUMBER,
56 p_level_hierarchy_code IN NUMBER,
57 p_work_concentration IN NUMBER,
58 p_uom IN VARCHAR2,
59 p_quantity IN NUMBER,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_oracle_error OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2);
63 PROCEDURE Delete_Rows
64 (p_commit IN VARCHAR2,
65 p_called_by_form IN VARCHAR2,
66 p_organization_id IN NUMBER,
67 p_inventory_item_id IN NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_oracle_error OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2);
71 PROCEDURE Check_Foreign_Keys
72 (p_organization_id IN NUMBER,
73 p_inventory_item_id IN NUMBER,
74 p_ingredient_item_id IN NUMBER,
75 p_source_item_id IN NUMBER,
76 p_level_hierarchy_code IN NUMBER,
77 p_work_concentration IN NUMBER,
78 p_uom IN VARCHAR2,
79 p_quantity IN NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_oracle_error OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2);
83 PROCEDURE Check_Integrity
84 (p_called_by_form IN VARCHAR2,
85 p_organization_id IN NUMBER,
86 p_inventory_item_id IN NUMBER,
87 p_ingredient_item_id IN NUMBER,
88 p_source_item_id IN NUMBER,
89 p_level_hierarchy_code IN NUMBER,
90 p_work_concentration IN NUMBER,
91 p_uom IN VARCHAR2,
92 p_quantity IN NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_oracle_error OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2);
96 PROCEDURE Check_Primary_Key
97 (p_organization_id IN NUMBER,
98 p_inventory_item_id IN NUMBER,
99 p_ingredient_item_id IN NUMBER,
100 p_source_item_id IN NUMBER,
101 p_called_by_form IN VARCHAR2,
102 x_rowid OUT NOCOPY VARCHAR2,
103 x_key_exists OUT NOCOPY VARCHAR2);
104 END GR_INGRED_CONC_DETAILS_PKG;