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