PACKAGE: APPS.WMS_EPC_PUB

Source

1 PACKAGE WMS_EPC_PUB AS
2 /* $Header: WMSEPCPS.pls 120.3 2006/11/17 18:48:15 wlau noship $ */
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, if implemented, provides customers an opportunity to
18     * generate non-Standard custom EPC or unimplemented EPC that can be
19     * used by stored in WMS product and used for subsquent transactions.
20     *
21     * @ param p_org_id Orgnization id of the transaction source
22     * @ paraminfo {@rep:required}
23     * @ param p_category_id EPC category id defined in Oracle DB EPC generation utility
24     * @ paraminfo {@rep:required}
25     * @ param p_epc_rule_type_id  EPC generation rule type id defined in Oracle DB EPC generation utility
26     * @ paraminfo {@rep:required}
27     * @ param p_filter_value To identify the object type (Pallet, Case,Inner-pack etc
28     * @ paraminfo {@rep:required}
29     * @ param p_label_request_id Provides all information for current transaction from wms_label_requests table
30     * @ paraminfo {@rep:required}
31     * @ param x_return_status "S"- SUCCESS /"E" - ERROR /"U" - UNEXPECTED ERROR
32     * @ paraminfo {@rep:required}
33     * @ param x_return_mesg message in case there is error in custom EPC generation
34     * @ paraminfo {@rep:required}
35     * @ param x_EPC returned EPC in HEX system
36     * @ paraminfo {@rep:required}
37     * @rep:scope public
38     * @rep:lifecycle active
39     * @rep:displayname API to implement custom/unimplemented EPC generation
40     * @rep:businessevent get_custom_epc
41   */
42 
43     PROCEDURE get_custom_epc(p_org_id IN VARCHAR2,
44 			 p_category_id IN VARCHAR2,
45 			 p_epc_rule_type_id IN VARCHAR2,
46 			 p_filter_value IN NUMBER,
47 			 p_label_request_id IN NUMBER,
48 			 x_return_status OUT nocopy VARCHAR2,
49 			 x_return_mesg OUT nocopy VARCHAR2,
50 			 x_epc OUT nocopy VARCHAR2 );
51 
52 
53 
54   /*#
55   * This API lets customer implement its own logic to pick
56     * company-prefix if the customer has multiple company-prefix after merger
57     * and acquisition. The default company-prefix is set at the Organization parameter level
58     *
59     * @ param p_org_id Orgnization id of the transaction source
60     * @ paraminfo {@rep:required}
61     * @ param p_label_request_id Provides all information for current transaction from wms_label_requests table
62     * @ paraminfo {@rep:required}
63     * @ param X_company_prefix returned company-prefix
64     * @ paraminfo {@rep:required}
65     * @ param x_return_status "S"- SUCCESS /"E" - ERROR /"U" - UNEXPECTED ERROR
66     * @ paraminfo {@rep:required}
67     * @rep:scope public
68     * @rep:lifecycle active
69     * @rep:displayname API to get custom company-prefix
70     * @rep:businessevent get_custom_company_prefix
71   */
72 
73   PROCEDURE get_custom_company_prefix
74     ( p_org_id IN NUMBER,
75       p_label_request_id  IN NUMBER,
76       X_company_prefix out nocopy VARCHAR2,
77       X_RETURN_STATUS out nocopy VARCHAR2);
78 
79   /*#
80   * This API lets customer implement its own logic to pick
81     * company-prefix-index if the customer has multiple company-prefix-index after merger
82     * and acquisition. The default company-prefix-index is set at the Organization parameter level
83     *
84     * @ param p_org_id Orgnization id of the transaction source
85     * @ paraminfo {@rep:required}
86     * @ param p_label_request_id Provides all information for current transaction from wms_label_requests table
87     * @ paraminfo {@rep:required}
88     * @ param x_comp_prefix_index returned company-prefix-index
89     * @ paraminfo {@rep:required}
90     * @ param x_return_status "S"- SUCCESS /"E" - ERROR /"U" - UNEXPECTED ERROR
91     * @ paraminfo {@rep:required}
92     * @rep:scope public
93     * @rep:lifecycle active
94     * @rep:displayname API to get custom company-prefix-index
95     * @rep:businessevent get_custom_comp_prefix_index
96   */
97 
98 
99   PROCEDURE get_custom_comp_prefix_index
100     ( p_org_id IN NUMBER,
101       p_label_request_id  IN NUMBER,
102       x_comp_prefix_index out nocopy VARCHAR2,
103       x_RETURN_STATUS out nocopy VARCHAR2);
104 
105 
106 END wms_epc_pub;