PACKAGE: APPS.GR_ITEM_SAFETY

Source

1 PACKAGE GR_ITEM_SAFETY AS
2 /*$Header: GRFMISS.pls 120.1 2005/07/08 13:24:28 methomas noship $*/
3 /*	This record definition maintains the list of columns returned the form. */
4 
5    TYPE item_property_rec IS RECORD
6 	(description 		  gr_properties_tl.description%TYPE,
7 	 sequence_number	  gr_label_properties.sequence_number%TYPE,
8 	 property_id		  gr_label_properties.property_id%TYPE,
9 	 label_code  		  gr_label_properties.label_code%TYPE,
10 	 property_type_indicator  gr_properties_b.property_type_indicator%TYPE,
11 	 length			  gr_properties_b.length%TYPE,
12 	 precision 		  gr_properties_b.precision%TYPE,
13 	 range_min 		  gr_properties_b.range_min%TYPE,
14 	 range_max 		  gr_properties_b.range_max%TYPE,
15 	 rowid 			  VARCHAR2(18),
16 	 organization_id          gr_inv_item_properties.organization_id%TYPE,
17 	 inventory_item_id        gr_inv_item_properties.inventory_item_id%TYPE,
18 	 number_value 		  gr_inv_item_properties.number_value%TYPE,
19 	 alpha_value 		  gr_inv_item_properties.alpha_value%TYPE,
20 	 date_value 		  gr_inv_item_properties.date_value%TYPE,
21 	 meaning		  gr_property_values_tl.meaning%TYPE,
22 	 created_by		  gr_inv_item_properties.created_by%TYPE,
23 	 creation_date		  gr_inv_item_properties.creation_date%TYPE,
24 	 last_updated_by	  gr_inv_item_properties.last_updated_by%TYPE,
25 	 last_update_date	  gr_inv_item_properties.last_update_date%TYPE,
26 	 last_update_login	  gr_inv_item_properties.last_update_login%TYPE
27 	 );
28 
29 /*  This table is the PL/SQL table returned to the form. */
30 
31    TYPE t_property_data IS TABLE OF item_property_rec
32       INDEX BY BINARY_INTEGER;
33 
34 
35    PROCEDURE get_properties
36     			(p_organization_id   IN NUMBER,
37                          p_inventory_item_id IN NUMBER,
38     			 p_label_code        IN VARCHAR2,
39 			 x_prop_data         IN OUT NOCOPY t_property_data);
40 
41    PROCEDURE paste_item_safety
42 			(p_organization_id   IN NUMBER,
43                          p_copy_from_item    IN NUMBER,
44 			 p_paste_to_item     IN NUMBER,
45 			 x_return_status    OUT NOCOPY VARCHAR2,
46 			 x_oracle_error     OUT NOCOPY NUMBER,
47 			 x_msg_data         OUT NOCOPY VARCHAR2);
48 
49    PROCEDURE delete_item_safety
50 			(p_delete_item IN VARCHAR2,
51 			 x_return_status OUT NOCOPY VARCHAR2,
52 			 x_oracle_error OUT NOCOPY NUMBER,
53 			 x_msg_data OUT NOCOPY VARCHAR2);
54 
55    PROCEDURE delete_item_document
56 			(p_delete_item IN VARCHAR2,
57                          p_document_code IN VARCHAR2,
58                          p_delete_option IN VARCHAR2,
59 			 x_return_status OUT NOCOPY VARCHAR2,
60 			 x_oracle_error OUT NOCOPY NUMBER,
61 			 x_msg_data OUT NOCOPY VARCHAR2);
62 
63 END GR_ITEM_SAFETY;