1 PACKAGE EGO_GTIN_ATTRS_PVT AS
2 /* $Header: EGOVGATS.pls 120.6 2007/03/27 17:00:02 dsakalle ship $ */
3
4 /*
5 ** This function returns TRUE if check digit is invalid
6 */
7 FUNCTION Is_Check_Digit_Invalid (p_code VARCHAR2) RETURN BOOLEAN;
8
9 /*
10 ** This procedure populates the interface table rows for UCCnet attributes
11 * into pl/sql table
12 */
13 PROCEDURE Get_Gdsn_Intf_Rows( p_data_set_id IN NUMBER
14 ,p_target_proc_status IN NUMBER
15 ,p_inventory_item_id IN NUMBER
16 ,p_organization_id IN NUMBER
17 ,p_ignore_delete IN VARCHAR2 DEFAULT 'N'
18 ,x_singe_row_attrs_rec OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
19 ,x_multi_row_attrs_tbl OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
20 ,x_return_status OUT NOCOPY VARCHAR2
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_msg_data OUT NOCOPY VARCHAR2
23 );
24
25 /*
26 ** This procedure validates the interface table rows for UCCnet attributes
27 */
28 PROCEDURE Validate_Intf_Rows( p_data_set_id IN NUMBER
29 ,p_entity_id NUMBER
30 ,p_entity_code VARCHAR2
31 ,p_add_errors_to_fnd_stack VARCHAR2
32 ,x_return_status OUT NOCOPY VARCHAR2
33 );
34
35 PROCEDURE Do_Post_UCCnet_Attrs_Action ( p_data_set_id IN NUMBER
36 ,p_entity_id IN NUMBER
37 ,p_entity_code IN VARCHAR2
38 ,p_add_errors_to_fnd_stack IN VARCHAR2);
39
40 /*
41 ** This procedure validates the data passed in for UCCnet attributes
42 */
43 PROCEDURE Validate_Attributes(
44 p_inventory_item_id IN NUMBER
45 ,p_organization_id IN NUMBER
46 ,p_singe_row_attrs_rec IN EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
47 ,p_multi_row_attrs_tbl IN EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
48 ,p_extra_attrs_rec IN EGO_ITEM_PUB.UCCnet_Extra_Attrs_Rec_Typ
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 /*
55 ** This procedure creates/updates the UCCnet attributes for an item
56 */
57 PROCEDURE Process_UCCnet_Attrs_For_Item (
58 p_api_version IN NUMBER
59 ,p_inventory_item_id IN NUMBER
60 ,p_organization_id IN NUMBER
61 ,p_single_row_attrs_rec IN EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ
62 ,p_multi_row_attrs_table IN EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ
63 ,p_check_policy IN VARCHAR2 DEFAULT FND_API.G_TRUE
64 ,p_entity_id IN NUMBER DEFAULT NULL
65 ,p_entity_index IN NUMBER DEFAULT NULL
66 ,p_entity_code IN VARCHAR2 DEFAULT NULL
67 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
68 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_errorcode OUT NOCOPY NUMBER
71 ,x_msg_count OUT NOCOPY NUMBER
72 ,x_msg_data OUT NOCOPY VARCHAR2);
73
74 END EGO_GTIN_ATTRS_PVT;