1 PACKAGE inv_mo_lovs AS
2 /* $Header: INVMOLS.pls 120.2 2007/01/03 18:51:21 hjogleka noship $ */
3 TYPE t_genref IS REF CURSOR;
4
5 -- Name: GET_MO_LOV_ALL
6 --
7 -- Input parameters:
8 -- p_Organization_Id which restricts LOV SQL to current org
9 -- p_mo_req_number MoveOrder request Number string to restrict LOV
10 -- output
11 --
12 -- Output parameters:
13 -- x_mo_num_lov returns LOV rows as reference cursor
14 --
15 -- Functions: This API returns MoveOrder Req. number for a given org
16 --
17 PROCEDURE get_mo_lov_all(x_mo_num_lov OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_mo_req_number IN VARCHAR2);
18
19 -- Name: GET_MO_LOV
20 --
21 -- Input parameters:
22 -- p_Organization_Id which restricts LOV SQL to current org
23 -- p_mo_req_number MoveOrder request Number string to restrict LOV
24 -- output
25 --
26 -- Output parameters:
27 -- x_mo_num_lov returns LOV rows as reference cursor
28 --
29 -- Functions: This API returns MoveOrder Req. number for an Org
30 -- for specified MO_TYPE and Trx_TYPE
31 --
32 PROCEDURE get_mo_lov(
33 x_mo_num_lov OUT NOCOPY t_genref
34 , p_organization_id IN NUMBER
35 , p_mo_type IN NUMBER
36 , p_trx_type IN NUMBER
37 , p_mo_req_number IN VARCHAR2
38 );
39
40 --
41 -- Name: GET_PickWaveMO_LOV
42 --
43 -- Input parameters:
44 -- p_Organization_Id which restricts LOV SQL to current org
45 -- p_mo_req_number MoveOrder request Number string to restrict LOV
46 -- output
47 -- p_so_number if passed, restricts LOV to the entered sales order
48 --
49 -- Output parameters:
50 -- x_mo_num_lov returns LOV rows as reference cursor
51 --
52 -- Functions: This API returns MoveOrder Req. number for an Org
53 -- for specified MO_TYPE and Trx_TYPE
54 --
55 PROCEDURE get_pickwavemo_lov(x_pwmo_lov OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_mo_req_number IN VARCHAR2, p_so_number IN VARCHAR2 := NULL);
56
57 --
58 -- Name: GET_WIPMO_LOV
59 --
60 -- Input parameters:
61 -- p_Organization_Id which restricts LOV SQL to current org
62 -- p_mo_req_number MoveOrder request Number string to restrict LOV
63 -- output
64 --
65 -- Output parameters:
66 -- x_mo_num_lov returns LOV rows as reference cursor
67 --
68 -- Functions: This API returns MoveOrder Req. number for an Org
69 -- for specified MO_TYPE and Trx_TYPE
70 --
71 PROCEDURE get_wipmo_lov(x_pwmo_lov OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_mo_req_number IN VARCHAR2);
72
73 -- Name: GET_MOLINE_LOV
74 --
75 -- Input parameters:
76 -- p_Organization_Id which restricts LOV SQL to current org
77 -- p_mo_number which restricts LOV SQL to the user input text
78 --
79 -- Output parameters:
80 -- x_mo_line_lov returns LOV rows as reference cursor
81 --
82 -- Functions: This API returns MO Line Number for a given org and
83 -- MoveOrder headerId
84 --
85
86 PROCEDURE get_moline_lov(x_mo_line_lov OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_mo_header_id IN NUMBER, p_line_number IN VARCHAR2);
87
88 -- Name: GET_MO_KANBAN
89 --
90 -- Input parameters:
91 -- p_Organization_Id which restricts LOV SQL to current org
92 -- p_kb_number which restricts LOV SQL to the user input text
93 --
94 -- Output parameters:
95 -- x_mo_kanban returns LOV rows as reference cursor
96 --
97 -- Functions: This API returns MO Line Number for a given org and
98 -- MoveOrder headerId
99 --
100 PROCEDURE get_mo_kanban(x_mo_kanban OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_kb_number IN VARCHAR2);
101
102 -- Name: GET_MO_SOHDR
103 --
104 -- Input parameters:
105 -- p_Organization_Id which restricts LOV SQL to current org
106 -- p_sohdr_id
107 --
108 -- Output parameters:
109 -- x_mo_sohdr returns LOV rows as reference cursor
110 --
111 -- Functions: This API returns SO Header Number for a given org
112 --
113 PROCEDURE get_mo_sohdr(x_mo_sohdr OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_sohdr_id IN VARCHAR2);
114
115 -- Name: GET_DELIVERY_NUM
116 --
117 -- Input parameters:
118 -- p_Organization_Id which restricts LOV SQL to current org
119 -- p_deliv_num
120 -- p_so_num if passed, restricts deliveries to entered sales order
121 -- p_mo_req_num if passed, restricts deliveries to entered move order
122 -- p_pickslip_number if passed, restricts deliveries to entered pickslip
123 --
124 -- Output parameters:
125 -- x_delivery returns LOV rows as reference cursor
126 --
127 -- Functions: This API returns DeliveryNumber and Delivery ID for
128 -- those Deliveries which have been asigned and MoveOrdersLines
129 -- created .
130 --
131 PROCEDURE get_delivery_num(x_delivery OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_deliv_num IN VARCHAR2, p_so_number IN VARCHAR2 := NULL, p_mo_req_num IN VARCHAR2 := NULL, p_pickslip_number IN VARCHAR2 := NULL);
132
133 --
134 -- Name: GET_PICKSLIP_NUM
135 --
136 -- Input parameters:
137 -- p_Organization_Id which restricts LOV SQL to current org
138 -- p_pickslip
139 -- p_so_num if passed, restricts deliveries to entered sales order
140 -- p_mo_req_num if passed, restricts deliveries to entered move order
141 --
142 -- Output parameters:
143 -- x_pickslip returns LOV rows as reference cursor
144 --
145 -- Functions: This API returns PickSlip Numbers from MMTT
146 --
147 PROCEDURE get_pickslip_num(x_pickslip OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_pickslip_num IN VARCHAR2, p_so_number IN VARCHAR2 := NULL, p_mo_req_num IN VARCHAR2 := NULL);
148
149 /**
150 * Gets the Missing Qty Actions used to process the Missing Qty during a Move Order Transaction.
151 */
152 PROCEDURE get_missing_qty_action_lov(x_miss_qty_action OUT NOCOPY t_genref, p_miss_qty_action VARCHAR2);
153
154 END inv_mo_lovs;