1 PACKAGE WMS_EPC_PUB AUTHID CURRENT_USER AS
2 /* $Header: WMSEPCPS.pls 120.3.12020000.5 2012/08/30 18:48:32 sahmahes ship $ */
3 /*#
4 * This object provides extension APIs to support EPC generation of
5 * custom/unimplemented EPC Types
6 * @rep:scope public
7 * @rep:product WMS
8 * @rep:lifecycle active
9 * @rep:displayname Extension API for EPC generation in WMS
10 * @rep:category BUSINESS_ENTITY WMS_EPC_PUB
11 */
12
13
14
15
16 /*#
17 * This API lets customer implement its own logic to pick
18 * company-prefix if the customer has multiple company-prefix after merger
19 * and acquisition. The default company-prefix is set at the Organization parameter level
20 *
21 * @ param p_org_id Orgnization id of the transaction source
22 * @ paraminfo {@rep:required}
23 * @ param p_label_request_id Provides all information for current transaction from wms_label_requests table
24 * @ paraminfo {@rep:required}
25 * @ param X_company_prefix returned company-prefix
26 * @ paraminfo {@rep:required}
27 * @ param x_return_status "S"- SUCCESS /"E" - ERROR /"U" - UNEXPECTED ERROR
28 * @ paraminfo {@rep:required}
29 * @rep:scope public
30 * @rep:lifecycle active
31 * @rep:displayname API to get custom company-prefix
32 * @rep:businessevent get_custom_company_prefix
33 */
34
35 PROCEDURE get_custom_company_prefix
36 ( p_org_id IN NUMBER,
37 p_label_request_id IN NUMBER,
38 X_company_prefix out nocopy VARCHAR2,
39 X_RETURN_STATUS out nocopy VARCHAR2);
40
41 /*#
42 * This API lets customer implement its own logic to pick
43 * company-prefix-index if the customer has multiple company-prefix-index after merger
44 * and acquisition. The default company-prefix-index is set at the Organization parameter level
45 *
46 * @ param p_org_id Orgnization id of the transaction source
47 * @ paraminfo {@rep:required}
48 * @ param p_label_request_id Provides all information for current transaction from wms_label_requests table
49 * @ paraminfo {@rep:required}
50 * @ param x_comp_prefix_index returned company-prefix-index
51 * @ paraminfo {@rep:required}
52 * @ param x_return_status "S"- SUCCESS /"E" - ERROR /"U" - UNEXPECTED ERROR
53 * @ paraminfo {@rep:required}
54 * @rep:scope public
55 * @rep:lifecycle active
56 * @rep:displayname API to get custom company-prefix-index
57 * @rep:businessevent get_custom_comp_prefix_index
58 */
59
60
61 PROCEDURE get_custom_comp_prefix_index
62 ( p_org_id IN NUMBER,
63 p_label_request_id IN NUMBER,
64 x_comp_prefix_index out nocopy VARCHAR2,
65 x_RETURN_STATUS out nocopy VARCHAR2);
66
67 /*#
68 * This API, if implemented provides customers an opportunity to decide whether to honor
69 * ucc_128_suffix_flag set in the organization parameters form or not when generating LPN
70 * in the mobile pages.
71 * @ param p_org_id Orgnization id of the transaction source
72 * @ paraminfo {@rep:required}
73 * @ param x_honor_org_param returned "YES" - Honor ucc_128_suffix_flag as set in the organization parameters form
74 * "NO" - Do not honor ucc_128_suffix_flag set in the organization parameters, by default taken as checkbox disabled
75 * "NULL" - By default taken as "NO"
76 * @ paraminfo {@rep:required}
77 * @ rep:scope public
78 * @ rep:lifecycle active
79 * @ rep:displayname API to honor organization parameters or not
80 * @ rep:businessevent GET_CUSTOM_UCC_128_SUFFIX
81 */
82
83 -- Added for Bug 13740139
84 PROCEDURE GET_CUSTOM_UCC_128_SUFFIX(
85 p_org_id IN NUMBER,
86 x_honor_org_param OUT NOCOPY VARCHAR2
87 );
88 -- End of Bug 13740139
89
90
91 /*#
92 * This API, if implemented, provides customers an opportunity to
93 * generate non-Standard custom EPC or unimplemented EPC that can be
94 * used by stored in WMS product and used for subsquent transactions.
95 *
96 * @ param p_org_id Orgnization id of the transaction source
97 * @ paraminfo {@rep:required}
98 * @ param p_category_id EPC category id defined in Oracle DB EPC generation utility
99 * @ paraminfo {@rep:required}
100 * @ param p_epc_rule_type_id EPC generation rule type id defined in Oracle DB EPC generation utility.
101 * In both old and new RFID model the p_epc_rule_type_id would be taken as input but in new model it represents the rule name from MGD_ID_SCHEME.
102 * The naming convention for EPC rule types in new model is changed from EPC_XXX_## to XXX-##, e.g in new model EPC_SSCC_64 is changed to SSCC-64.
103 * @ paraminfo {@rep:required}
104 * @ param p_filter_value To identify the object type (Pallet, Case,Inner-pack etc
105 * @ paraminfo {@rep:required}
106 * @ param p_label_request_id Provides all information for current transaction from wms_label_requests table
107 * @ paraminfo {@rep:required}
108 * @ param x_return_status "S"- SUCCESS /"E" - ERROR /"U" - UNEXPECTED ERROR
109 * @ paraminfo {@rep:required}
110 * @ param x_return_mesg message in case there is error in custom EPC generation
111 * @ paraminfo {@rep:required}
112 * @ param x_EPC returned EPC in HEX system
113 * @ paraminfo {@rep:required}
114 * @rep:scope public
115 * @rep:lifecycle active
116 * @rep:displayname API to implement custom/unimplemented EPC generation
117 * @rep:businessevent get_custom_epc
118 */
119 --BUG8796558
120 PROCEDURE get_custom_epc(p_org_id IN VARCHAR2,
121 p_category_id IN VARCHAR2,
122 p_epc_rule_type_id IN VARCHAR2,
123 p_filter_value IN NUMBER,
124 p_label_request_id IN NUMBER,
125 x_return_status OUT nocopy VARCHAR2,
126 x_return_mesg OUT nocopy VARCHAR2,
127 x_epc OUT nocopy VARCHAR2 );
128
129
130 END wms_epc_pub;