1 PACKAGE INV_MWB_CONTROLLER AUTHID CURRENT_USER AS
2 /* $Header: INVMWCTS.pls 120.21 2010/12/08 11:53:33 ksaripal ship $ */
3
4 PROCEDURE PROCESS_QUERY(
5 p_organization_id IN NUMBER DEFAULT NULL
6 , p_organization_code IN VARCHAR2 DEFAULT NULL
7 , p_locator_name IN VARCHAR2 DEFAULT NULL
8 , p_item_name IN VARCHAR2 DEFAULT NULL
9 , p_cost_group IN VARCHAR2 DEFAULT NULL
10 , p_project_number IN VARCHAR2 DEFAULT NULL
11 , p_task_number IN VARCHAR2 DEFAULT NULL
12 , p_owning_party IN VARCHAR2 DEFAULT NULL
13 , p_planning_party IN VARCHAR2 DEFAULT NULL
14 , p_lpn_state IN VARCHAR2 DEFAULT NULL
15 , p_status IN VARCHAR2 DEFAULT NULL
16 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
17 , p_locator_id IN NUMBER DEFAULT NULL
18 , p_client_code IN VARCHAR2 DEFAULT NULL -- ER(9158529 client)
19 , p_inventory_item_id IN NUMBER DEFAULT NULL
20 , p_revision IN VARCHAR2 DEFAULT NULL
21 , p_status_id IN NUMBER DEFAULT NULL
22 , p_cost_group_id IN NUMBER DEFAULT NULL
23 , p_category_set_id IN NUMBER DEFAULT NULL -- ER(9158529)
24 , p_category_id IN NUMBER DEFAULT NULL -- ER(9158529)
25 , p_lpn_from IN VARCHAR2 DEFAULT NULL
26 , p_lpn_from_id IN NUMBER DEFAULT NULL
27 , p_lpn_to IN VARCHAR2 DEFAULT NULL
28 , p_lpn_to_id IN NUMBER DEFAULT NULL
29 , p_lot_from IN VARCHAR2 DEFAULT NULL
30 , p_lot_to IN VARCHAR2 DEFAULT NULL
31 , p_supplier_lot_from IN VARCHAR2 DEFAULT NULL -- Bug 8396954
32 , p_supplier_lot_to IN VARCHAR2 DEFAULT NULL -- Bug 8396954
33 , p_serial_from IN VARCHAR2 DEFAULT NULL
34 , p_serial_to IN VARCHAR2 DEFAULT NULL
35 , p_workbench_vb IN NUMBER DEFAULT NULL
36 , p_prepacked IN VARCHAR2 DEFAULT NULL
37 , p_project_id IN NUMBER DEFAULT NULL
38 , p_task_id IN NUMBER DEFAULT NULL
39 , p_unit_number IN VARCHAR2 DEFAULT NULL -- Bug 9486070
40 , p_planning_org IN VARCHAR2 DEFAULT NULL
41 , p_owning_org IN VARCHAR2 DEFAULT NULL
42 , p_po_header_id IN NUMBER DEFAULT NULL
43 , p_po_release_id IN NUMBER DEFAULT NULL
44 , p_shipment_header_id_asn IN NUMBER DEFAULT NULL
45 , p_shipment_header_id_interorg IN NUMBER DEFAULT NULL
46 , p_req_header_id IN NUMBER DEFAULT NULL
47 , p_vendor_id IN NUMBER DEFAULT NULL
48 , p_vendor_site_id IN NUMBER DEFAULT NULL
49 , p_source_org_id IN NUMBER DEFAULT NULL
50 , p_chk_inbound IN NUMBER DEFAULT NULL
51 , p_chk_receiving IN NUMBER DEFAULT NULL
52 , p_chk_onhand IN NUMBER DEFAULT NULL
53 , p_include_po_without_asn IN NUMBER DEFAULT NULL
54 , p_expected_from_date IN DATE DEFAULT NULL
55 , p_expected_to_date IN DATE DEFAULT NULL
56 , p_internal_order_id IN NUMBER DEFAULT NULL
57 , p_vendor_item IN VARCHAR2 DEFAULT NULL
58 , p_grade_from IN VARCHAR2 DEFAULT NULL
59 , p_planning_query_mode IN NUMBER DEFAULT NULL
60 , p_owning_query_mode IN NUMBER DEFAULT NULL
61 , p_wms_enabled_flag IN NUMBER DEFAULT NULL
62 , p_subinventory_type IN NUMBER DEFAULT NULL
63 , p_rcv_query_mode IN NUMBER DEFAULT NULL
64 , p_detailed IN NUMBER DEFAULT 0
65 , p_item_description IN VARCHAR2 DEFAULT NULL
66 , p_qty_from IN NUMBER DEFAULT NULL
67 , p_qty_to IN NUMBER DEFAULT NULL
68 , p_view_by IN VARCHAR2 DEFAULT NULL
69 , p_locator_control_code IN NUMBER DEFAULT NULL
70 , p_wms_installed_flag IN NUMBER DEFAULT NULL
71 , p_check IN NUMBER DEFAULT NULL
72 , p_serial_attr_query IN VARCHAR2 DEFAULT NULL -- Bug 6429880
73 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL -- Bug 7566588
74 , p_responsibility_id IN NUMBER DEFAULT NULL
75 , p_resp_application_id IN NUMBER DEFAULT NULL
76 , p_is_projects_enabled_org IN NUMBER DEFAULT 0
77 ,p_expired_lots IN VARCHAR2 DEFAULT NULL
78 ,p_expiration_date IN DATE DEFAULT NULL
79 , p_parent_lot IN VARCHAR2 DEFAULT NULL -- BUG 7556505
80 ,p_shipment_header_id IN NUMBER DEFAULT NULL -- Bug 6633612
81 );
82
83 PROCEDURE SET_TREE_GLOBALS(
84 p_tree_organization_id IN NUMBER DEFAULT NULL
85 , p_view_by IN VARCHAR2 DEFAULT NULL
86 , p_tree_subinventory_code IN VARCHAR2 DEFAULT NULL
87 , p_tree_loc_id IN NUMBER DEFAULT NULL
88 , p_tree_item_id IN NUMBER DEFAULT NULL
89 , p_tree_plpn_id IN NUMBER DEFAULT NULL
90 , p_tree_mat_loc_id IN NUMBER DEFAULT NULL
91 , p_tree_doc_type_id IN NUMBER DEFAULT NULL
92 , p_tree_doc_num IN VARCHAR2 DEFAULT NULL
93 , p_tree_doc_header_id IN NUMBER DEFAULT NULL
94 , p_tree_st_id IN NUMBER DEFAULT NULL
95 , p_tree_rev IN VARCHAR2 DEFAULT NULL
96 , p_tree_cg_id IN VARCHAR2 DEFAULT NULL
97 , p_tree_grade IN VARCHAR2 DEFAULT NULL
98 , p_tree_lot IN VARCHAR2 DEFAULT NULL
99 , p_tree_serial IN VARCHAR2 DEFAULT NULL
100 , p_tree_node_type IN VARCHAR2 DEFAULT NULL
101 , p_tree_node_value IN VARCHAR2 DEFAULT NULL
102 , p_tree_node_state IN NUMBER DEFAULT NULL
103 , p_tree_node_high_value IN NUMBER DEFAULT NULL
104 , p_tree_node_low_value IN NUMBER DEFAULT NULL
105 , p_tree_serial_attr_query IN VARCHAR2 DEFAULT NULL -- Bug 6429880
106 , p_tree_lot_attr_query IN VARCHAR2 DEFAULT NULL -- Bug 7566588
107 , p_tree_event IN VARCHAR2 DEFAULT NULL
108 , p_tree_attribute_qf_lot IN VARCHAR2 DEFAULT NULL
109 , p_attribute_qf_serial IN VARCHAR2 DEFAULT NULL
110 , p_query_lot_attr IN VARCHAR2 DEFAULT NULL
111 , p_query_serial_attr IN VARCHAR2 DEFAULT NULL
112 , p_is_containerized IN NUMBER DEFAULT NULL
113 );
114
115 PROCEDURE EVENT (
116 x_node_value IN OUT NOCOPY NUMBER
117 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
118 , x_tbl_index IN OUT NOCOPY NUMBER
119 );
120
121 FUNCTION GET_LAST_QUERY RETURN LONG;
122
123 END INV_MWB_CONTROLLER;