1 PACKAGE GR_INGRED_CONCENTRATIONS_PKG AS
2 /*$Header: GRHINCS.pls 120.0 2005/07/08 11:16:46 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_product_item_id IN NUMBER,
8 p_ingredient_item_id IN NUMBER,
9 p_concentration_percentage IN NUMBER,
10 p_last_update_date IN DATE,
11 p_last_updated_by IN NUMBER,
12 p_last_update_login IN NUMBER,
13 p_creation_date IN DATE,
14 p_created_by IN NUMBER,
15 x_rowid OUT NOCOPY VARCHAR2,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_oracle_error OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2);
19 PROCEDURE Update_Row
20 (p_commit IN VARCHAR2,
21 p_called_by_form IN VARCHAR2,
22 p_rowid IN VARCHAR2,
23 p_organization_id IN NUMBER,
24 p_product_item_id IN NUMBER,
25 p_ingredient_item_id IN NUMBER,
26 p_concentration_percentage IN NUMBER,
27 p_last_update_date IN DATE,
28 p_last_updated_by IN NUMBER,
29 p_last_update_login IN NUMBER,
30 p_creation_date IN DATE,
31 p_created_by IN NUMBER,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_oracle_error OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2);
35 PROCEDURE Lock_Row
36 (p_commit IN VARCHAR2,
37 p_called_by_form IN VARCHAR2,
38 p_rowid IN VARCHAR2,
39 p_organization_id IN NUMBER,
40 p_product_item_id IN NUMBER,
41 p_ingredient_item_id IN NUMBER,
42 p_concentration_percentage IN NUMBER,
43 p_last_update_date IN DATE,
44 p_last_updated_by IN NUMBER,
45 p_last_update_login IN NUMBER,
46 p_creation_date IN DATE,
47 p_created_by IN NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_oracle_error OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2);
51 PROCEDURE Delete_Row
52 (p_commit IN VARCHAR2,
53 p_called_by_form IN VARCHAR2,
54 p_rowid IN VARCHAR2,
55 p_organization_id IN NUMBER,
56 p_product_item_id IN NUMBER,
57 p_ingredient_item_id IN NUMBER,
58 p_concentration_percentage IN NUMBER,
59 p_last_update_date IN DATE,
60 p_last_updated_by IN NUMBER,
61 p_last_update_login IN NUMBER,
62 p_creation_date IN DATE,
63 p_created_by IN NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_oracle_error OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2);
67 PROCEDURE Delete_Rows
68 (p_commit IN VARCHAR2,
69 p_called_by_form IN VARCHAR2,
70 p_organization_id IN NUMBER,
71 p_product_item_id IN NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_oracle_error OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2);
75 PROCEDURE Check_Foreign_Keys
76 (p_organization_id IN NUMBER,
77 p_product_item_id IN NUMBER,
78 p_concentration_percentage IN NUMBER,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_oracle_error OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2);
82 PROCEDURE Check_Integrity
83 (p_called_by_form IN VARCHAR2,
84 p_organization_id IN NUMBER,
85 p_product_item_id IN NUMBER,
86 p_concentration_percentage IN NUMBER,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_oracle_error OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2);
90 PROCEDURE Check_Primary_Key
91 (p_organization_id IN NUMBER,
92 p_product_item_id IN NUMBER,
93 p_ingredient_item_id IN NUMBER,
94 p_called_by_form IN VARCHAR2,
95 x_rowid OUT NOCOPY VARCHAR2,
96 x_key_exists OUT NOCOPY VARCHAR2);
97 END GR_INGRED_CONCENTRATIONS_PKG;