1 Package WMS_RULES_WORKBENCH_PVT AUTHID CURRENT_USER AS
2 /* $Header: WMSRLWBS.pls 120.5 2010/10/27 18:29:05 sfulzele ship $ */
3
4 -- File : WMSRLWBS.pls
5 -- Content : WMS_RULES_WORKBENCH_PVT package spec
6 -- Description : This API is created to handle all the procedures, function variables to be used by Rules WorkBench
7
8 -- Notes :
9 -- List of Pl/SQL Tables,Functions and Procedures
10
11 -- 8809951 start
12 TYPE tbl_num IS TABLE OF VARCHAR2(100) INDEX BY PLS_INTEGER;--bug 10209531
13 g_item_cat_table tbl_num;
14 g_uom_class_tbl tbl_num;
15 g_hash_base NUMBER := 1;
16 g_hash_size NUMBER := POWER(2, 25);
17 -- 8809951 end
18
19 l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
20
21 Function get_return_type_name(p_org_id number ,p_rule_type_code in number, p_return_type_code in varchar2, p_return_type_id in number) return varchar2;
22 Function get_customer_name(p_customer_id in number) return varchar2;
23 Function get_organization_code(p_organization_id in number) return varchar2;
24 Function get_freight_code_name(p_org_id in number ,p_freight_code in varchar2 ) return varchar2;
25 Function get_item(p_org_id in number , p_inventory_item_id in number) return varchar2;
26 Function get_abc_group_class(p_org_id in number , p_assignment_group_id in number, p_class_id in number ) return varchar2;
27 Function get_category_set_name(p_org_id in number , p_category_set_id in number, p_category_id in number) return varchar2;
28 Function get_order_type_name(p_transaction_type_id in number) return varchar2;
29 Function get_project_name(p_project_id in number) return varchar2;
30 Function get_task_name(p_project_id in number , p_task_id in number) return varchar2;
31 Function get_vendor_name(p_org_id in number, p_vendor_id in number) return varchar2;
32 Function get_user_name(p_user_id in number) return varchar2;
33 Function get_transaction_action_name(p_transaction_action_id in number) return varchar2;
34 Function get_reason_name(p_reason_id in number) return varchar2;
35 Function get_transaction_source_name(p_transaction_source_type_id in number) return varchar2;
36 Function get_transaction_type_name(p_transaction_type_id in number ) return varchar2;
37 Function get_unit_of_measure(p_uom_code in varchar2) return varchar2;
38 Function get_uom_class_name(p_uom_class in varchar2) return varchar2;
39 Function get_item_type_name(p_item_type_code in varchar2) return varchar2;
40
41 ---
42 Procedure Search
43 ( p_api_version IN NUMBER
44 ,p_init_msg_list IN VARCHAR2
45 ,p_validation_level IN NUMBER
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 ,p_transaction_temp_id IN NUMBER
50 ,p_type_code IN NUMBER
51 ,x_return_type OUT NOCOPY VARCHAR2
52 ,x_return_type_id OUT NOCOPY NUMBER
53 ,p_organization_id IN NUMBER
54 ,x_sequence_number OUT NOCOPY NUMBER
55 );
56
57 Procedure cg_mmtt_search
58 ( p_api_version IN NUMBER
59 ,p_init_msg_list IN VARCHAR2
60 ,p_validation_level IN NUMBER
61 ,x_return_status OUT NOCOPY VARCHAR2
62 ,x_msg_count OUT NOCOPY NUMBER
63 ,x_msg_data OUT NOCOPY VARCHAR2
64 ,p_transaction_temp_id IN NUMBER
65 ,p_type_code IN NUMBER
66 ,x_return_type OUT NOCOPY VARCHAR2
67 ,x_return_type_id OUT NOCOPY NUMBER
68 ,p_organization_id IN NUMBER
69 ,x_sequence_number OUT NOCOPY NUMBER
70 );
71 Function get_item_type( p_org_id IN NUMBER,p_inventory_item_id IN NUMBER ) return VARCHAR2;
72
73 Function get_uom_class( p_uom_code IN VARCHAR2) return VARCHAR2;
74 Function get_vendor_id( p_reference IN VARCHAR2, p_reference_id IN NUMBER) return NUMBER;
75 Function get_order_type_id( p_move_order_line_id IN NUMBER) return NUMBER;
76 --Bug#10218502,overloaded get_order_type_id
77 Function get_order_type_id( p_move_order_line_id IN NUMBER, p_transaction_source_type_id IN NUMBER, p_reference_id IN NUMBER ) return NUMBER;
78 Function get_item_cat( p_org_id IN NUMBER,
79 p_inventory_item_id IN NUMBER ,
80 p_category_set_id IN NUMBER,
81 p_category_id IN NUMBER) return VARCHAR2;
82
83 Function get_group_class( p_inventory_item_id IN NUMBER,
84 p_assignment_group_id IN NUMBER,
85 p_class_id IN NUMBER ) return VARCHAR2;
86
87
88 Procedure get_customer_freight_details(p_transaction_temp_id IN NUMBER,
89 x_customer_id OUT NOCOPY NUMBER,
90 x_freight_code OUT NOCOPY VARCHAR2);
91
92 Function get_location_name(p_location_id IN NUMBER) Return VARCHAR2 ;
93
94 Procedure cross_dock_search(
95 p_rule_type_code IN NUMBER,
96 p_organization_id IN NUMBER,
97 p_customer_id IN NUMBER,
98 p_inventory_item_id IN NUMBER,
99 p_item_type IN VARCHAR,
100 p_vendor_id IN NUMBER,
101 p_location_id IN NUMBER,
102 p_project_id IN NUMBER,
103 p_task_id IN NUMBER,
104 p_user_id IN NUMBER,
105 p_uom_code IN VARCHAR,
106 p_uom_class IN VARCHAR,
107 x_return_type OUT NOCOPY VARCHAR2,
108 x_return_type_id OUT NOCOPY NUMBER, --criterion_id
109 x_sequence_number OUT NOCOPY NUMBER,
110 x_return_status OUT NOCOPY VARCHAR2);
111
112
113 End WMS_RULES_WORKBENCH_PVT;