1 PACKAGE GR_ITEM_PROPERTIES_PUB AUTHID CURRENT_USER AS
2 /* $Header: GRPIITPS.pls 120.4 2010/11/19 16:21:52 plowe noship $*/
3 /*#
4 * This interface is used to create, delete, and update item property values.
5 * This package defines and implements the procedures required
6 * to create, delete, and update item properties.
7 * @rep:scope public
8 * @rep:product GR
9 * @rep:lifecycle active
10 * @rep:displayname GR Item Properties Package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GR_ITEM_PROPERTIES
13 */
14
15 /* Define Procedures And Functions : */
16
17 /*#
18 * Create, delete, and update item property values
19 * This is a PL/SQL procedure to create, delete, and update item properties.
20 * @param p_api_version API version field
21 * @param p_init_msg_list Flag to check if message list intialized
22 * @param p_commit Flag to check for commit
23 * @param p_item_properties_tab is table of input records of type gr_item_properties_rec_type listed below
24 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
25 * @param x_msg_count Number of msg's on message stack
26 * @param x_msg_data Actual message data on message stack
27 * @rep:scope public
28 * @rep:lifecycle active
29 * @rep:displayname Create, delete, and update item properties procedure
30 * @rep:compatibility S */
31
32
33
34 TYPE gr_item_properties_rec_type IS RECORD
35 (
36 action VARCHAR2(1)
37 ,organization VARCHAR2(3)
38 ,organization_id NUMBER
39 ,item VARCHAR2(40)
40 ,inventory_item_id NUMBER
41 ,field_name_code VARCHAR2(5)
42 ,property_id varchar2(6)
43 ,numeric_value NUMBER(15,9) -- 8208515 increased decimal precision from 6 to 9.
44 ,alpha_value VARCHAR2(240)
45 ,phrase_code VARCHAR2(15)
46 ,date_value date
47 ,language_code VARCHAR2(4)
48 );
49
50 TYPE gr_item_properties_tab_type IS TABLE OF gr_item_properties_rec_type INDEX BY BINARY_INTEGER;
51
52
53 PROCEDURE ITEM_PROPERTIES
54 ( p_api_version IN NUMBER
55 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
56 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
57 , p_item_properties_tab IN GR_ITEM_PROPERTIES_PUB.gr_item_properties_tab_type
58 , x_return_status OUT NOCOPY VARCHAR2
59 , x_msg_count OUT NOCOPY NUMBER
60 , x_msg_data OUT NOCOPY VARCHAR2
61 );
62
63 END GR_ITEM_PROPERTIES_PUB;
64