1 Package WMS_RULES_WORKBENCH_PVT AS
2 /* $Header: WMSRLWBS.pls 120.2 2005/06/30 22:36:13 appldev 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 l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
12
13 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;
14 Function get_customer_name(p_customer_id in number) return varchar2;
15 Function get_organization_code(p_organization_id in number) return varchar2;
16 Function get_freight_code_name(p_org_id in number ,p_freight_code in varchar2 ) return varchar2;
17 Function get_item(p_org_id in number , p_inventory_item_id in number) return varchar2;
18 Function get_abc_group_class(p_org_id in number , p_assignment_group_id in number, p_class_id in number ) return varchar2;
19 Function get_category_set_name(p_org_id in number , p_category_set_id in number, p_category_id in number) return varchar2;
20 Function get_order_type_name(p_transaction_type_id in number) return varchar2;
21 Function get_project_name(p_project_id in number) return varchar2;
22 Function get_task_name(p_project_id in number , p_task_id in number) return varchar2;
23 Function get_vendor_name(p_org_id in number, p_vendor_id in number) return varchar2;
24 Function get_user_name(p_user_id in number) return varchar2;
25 Function get_transaction_action_name(p_transaction_action_id in number) return varchar2;
26 Function get_reason_name(p_reason_id in number) return varchar2;
27 Function get_transaction_source_name(p_transaction_source_type_id in number) return varchar2;
28 Function get_transaction_type_name(p_transaction_type_id in number ) return varchar2;
29 Function get_unit_of_measure(p_uom_code in varchar2) return varchar2;
30 Function get_uom_class_name(p_uom_class in varchar2) return varchar2;
31 Function get_item_type_name(p_item_type_code in varchar2) return varchar2;
32
33 ---
34 Procedure Search
35 ( p_api_version IN NUMBER
36 ,p_init_msg_list IN VARCHAR2
37 ,p_validation_level IN NUMBER
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2
41 ,p_transaction_temp_id IN NUMBER
42 ,p_type_code IN NUMBER
43 ,x_return_type OUT NOCOPY VARCHAR2
44 ,x_return_type_id OUT NOCOPY NUMBER
45 ,p_organization_id IN NUMBER
46 ,x_sequence_number OUT NOCOPY NUMBER
47 );
48
49 Procedure cg_mmtt_search
50 ( p_api_version IN NUMBER
51 ,p_init_msg_list IN VARCHAR2
52 ,p_validation_level IN NUMBER
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_msg_count OUT NOCOPY NUMBER
55 ,x_msg_data OUT NOCOPY VARCHAR2
56 ,p_transaction_temp_id IN NUMBER
57 ,p_type_code IN NUMBER
58 ,x_return_type OUT NOCOPY VARCHAR2
59 ,x_return_type_id OUT NOCOPY NUMBER
60 ,p_organization_id IN NUMBER
61 ,x_sequence_number OUT NOCOPY NUMBER
62 );
63 Function get_item_type( p_org_id IN NUMBER,p_inventory_item_id IN NUMBER ) return VARCHAR2;
64
65 Function get_uom_class( p_uom_code IN VARCHAR2) return VARCHAR2;
66 Function get_vendor_id( p_reference IN VARCHAR2, p_reference_id IN NUMBER) return NUMBER;
67 Function get_order_type_id( p_move_order_line_id IN NUMBER) return NUMBER;
68
69 Function get_item_cat( p_org_id IN NUMBER,
70 p_inventory_item_id IN NUMBER ,
71 p_category_set_id IN NUMBER,
72 p_category_id IN NUMBER) return VARCHAR2;
73
74 Function get_group_class( p_inventory_item_id IN NUMBER,
75 p_assignment_group_id IN NUMBER,
76 p_class_id IN NUMBER ) return VARCHAR2;
77
78
79 Procedure get_customer_freight_details(p_transaction_temp_id IN NUMBER,
80 x_customer_id OUT NOCOPY NUMBER,
81 x_freight_code OUT NOCOPY VARCHAR2);
82
83 Function get_location_name(p_location_id IN NUMBER) Return VARCHAR2 ;
84
85 Procedure cross_dock_search(
86 p_rule_type_code IN NUMBER,
87 p_organization_id IN NUMBER,
88 p_customer_id IN NUMBER,
89 p_inventory_item_id IN NUMBER,
90 p_item_type IN VARCHAR,
91 p_vendor_id IN NUMBER,
92 p_location_id IN NUMBER,
93 p_project_id IN NUMBER,
94 p_task_id IN NUMBER,
95 p_user_id IN NUMBER,
96 p_uom_code IN VARCHAR,
97 p_uom_class IN VARCHAR,
98 x_return_type OUT NOCOPY VARCHAR2,
99 x_return_type_id OUT NOCOPY NUMBER, --criterion_id
100 x_sequence_number OUT NOCOPY NUMBER,
101 x_return_status OUT NOCOPY VARCHAR2);
102
103
104 End WMS_RULES_WORKBENCH_PVT;