DBA Data[Home] [Help]

PACKAGE BODY: APPS.WMS_EPC_PUB

Source


1 PACKAGE BODY WMS_EPC_PUB  AS
2 /* $Header: WMSEPCPB.pls 120.1.12020000.4 2012/08/30 18:50:24 sahmahes ship $ */
3 
4 PROCEDURE GET_CUSTOM_COMPANY_PREFIX(
5 				    p_org_id IN NUMBER,
6 				    p_label_request_id  IN NUMBER,
7 				    X_company_prefix out nocopy VARCHAR2,
8 				    X_RETURN_STATUS out nocopy VARCHAR2)
9 
10 
11   IS
12 BEGIN
13    x_return_status := fnd_api.g_ret_sts_success;
14    X_company_prefix := NULL;
15 
16 END GET_CUSTOM_COMPANY_PREFIX;
17 
18 
19 PROCEDURE GET_CUSTOM_COMP_PREFIX_INDEX(
20 				       p_org_id IN NUMBER,
21 				       p_label_request_id  IN NUMBER,
22 				       X_comp_prefix_index out nocopy VARCHAR2,
23 				       X_RETURN_STATUS out nocopy VARCHAR2)
24 
25 
26   IS
27 BEGIN
28    x_return_status := fnd_api.g_ret_sts_success;
29    X_comp_prefix_index := NULL;
30 
31 END GET_CUSTOM_COMP_PREFIX_INDEX;
32 
33 -- Added for Bug 13740139
34 PROCEDURE GET_CUSTOM_UCC_128_SUFFIX(
35               p_org_id IN NUMBER,
36               x_honor_org_param OUT NOCOPY VARCHAR2
37               )
38  IS
39 BEGIN
40       x_honor_org_param := NULL;
41 
42 END GET_CUSTOM_UCC_128_SUFFIX;
43 -- End of Bug 13740139
44 
45 --BUG8796558
46 	PROCEDURE get_custom_epc(p_org_id IN VARCHAR2,
47 			 p_category_id IN VARCHAR2,
48 			 p_epc_rule_type_id IN VARCHAR2,
49 			 p_filter_value IN NUMBER,
50 			 p_label_request_id IN NUMBER,
51 			 x_return_status OUT nocopy VARCHAR2,
52 			 x_return_mesg OUT nocopy VARCHAR2,
53 			 x_epc OUT nocopy VARCHAR2 )
54 	IS
55 	BEGIN
56 	x_return_status := fnd_api.g_ret_sts_success;
57 	x_return_mesg := NULL;
58 	x_epc := NULL;
59 
60 	END get_custom_epc;
61 
62 
63 END wms_epc_pub;