1 PACKAGE GR_INV_ITEM_PROPERTIES_PKG AS
2 /*$Header: GRHIIIPS.pls 120.0 2005/07/08 11:10:34 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_sequence_number IN NUMBER,
9 p_property_id IN VARCHAR2,
10 p_label_code IN VARCHAR2,
11 p_number_value IN NUMBER,
12 p_alpha_value IN VARCHAR2,
13 p_date_value IN DATE,
14 p_created_by IN NUMBER,
15 p_creation_date IN DATE,
16 p_last_updated_by IN NUMBER,
17 p_last_update_date IN DATE,
18 p_last_update_login IN NUMBER,
19 x_rowid OUT NOCOPY VARCHAR2,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_oracle_error OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2);
23 PROCEDURE Update_Row
24 (p_commit IN VARCHAR2,
25 p_called_by_form IN VARCHAR2,
26 p_rowid IN VARCHAR2,
27 p_organization_id IN NUMBER,
28 p_inventory_item_id IN NUMBER,
29 p_sequence_number IN NUMBER,
30 p_property_id IN VARCHAR2,
31 p_label_code IN VARCHAR2,
32 p_number_value IN NUMBER,
33 p_alpha_value IN VARCHAR2,
34 p_date_value IN DATE,
35 p_created_by IN NUMBER,
36 p_creation_date IN DATE,
37 p_last_updated_by IN NUMBER,
38 p_last_update_date IN DATE,
39 p_last_update_login IN NUMBER,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_oracle_error OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2);
43 PROCEDURE Lock_Row
44 (p_commit IN VARCHAR2,
45 p_called_by_form IN VARCHAR2,
46 p_rowid IN VARCHAR2,
47 p_organization_id IN NUMBER,
48 p_inventory_item_id IN NUMBER,
49 p_sequence_number IN NUMBER,
50 p_property_id IN VARCHAR2,
51 p_label_code IN VARCHAR2,
52 p_number_value IN NUMBER,
53 p_alpha_value IN VARCHAR2,
54 p_date_value IN DATE,
55 p_created_by IN NUMBER,
56 p_creation_date IN DATE,
57 p_last_updated_by IN NUMBER,
58 p_last_update_date IN DATE,
59 p_last_update_login 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_Row
64 (p_commit IN VARCHAR2,
65 p_called_by_form IN VARCHAR2,
66 p_rowid IN VARCHAR2,
67 p_organization_id IN NUMBER,
68 p_inventory_item_id IN NUMBER,
69 p_sequence_number IN NUMBER,
70 p_property_id IN VARCHAR2,
71 p_label_code IN VARCHAR2,
72 p_number_value IN NUMBER,
73 p_alpha_value IN VARCHAR2,
74 p_date_value IN DATE,
75 p_created_by IN NUMBER,
76 p_creation_date IN DATE,
77 p_last_updated_by IN NUMBER,
78 p_last_update_date IN DATE,
79 p_last_update_login 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 Delete_Rows
84 (p_commit IN VARCHAR2,
85 p_called_by_form IN VARCHAR2,
86 p_delete_option IN VARCHAR2,
87 p_organization_id IN NUMBER,
88 p_inventory_item_id IN NUMBER,
89 p_label_code IN VARCHAR2,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_oracle_error OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2);
93 PROCEDURE Check_Foreign_Keys
94 (p_organization_id IN NUMBER,
95 p_inventory_item_id IN NUMBER,
96 p_sequence_number IN NUMBER,
97 p_property_id IN VARCHAR2,
98 p_label_code IN VARCHAR2,
99 p_number_value IN NUMBER,
100 p_alpha_value IN VARCHAR2,
101 p_date_value IN DATE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_oracle_error OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2);
105 PROCEDURE Check_Integrity
106 (p_called_by_form IN VARCHAR2,
107 p_organization_id IN NUMBER,
108 p_inventory_item_id IN NUMBER,
109 p_sequence_number IN NUMBER,
110 p_property_id IN VARCHAR2,
111 p_label_code IN VARCHAR2,
112 p_number_value IN NUMBER,
113 p_alpha_value IN VARCHAR2,
114 p_date_value IN DATE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_oracle_error OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2);
118 PROCEDURE Check_Primary_Key
119 (p_organization_id IN NUMBER,
120 p_inventory_item_id IN NUMBER,
121 p_label_code IN VARCHAR2,
122 p_property_id IN VARCHAR2,
123 p_called_by_form IN VARCHAR2,
124 x_rowid OUT NOCOPY VARCHAR2,
125 x_key_exists OUT NOCOPY VARCHAR2);
126 END GR_INV_ITEM_PROPERTIES_PKG;