1 PACKAGE WSMPGENE AUTHID CURRENT_USER AS
2 /* $Header: WSMGENES.pls 115.4 2000/06/19 12:41:24 pkm ship $ */
3
4
5 PROCEDURE one_inv_g(
6 wip_ent_id NUMBER,
7 level_no NUMBER,
8 ent_name IN OUT VARCHAR2,
9 ent_id IN OUT NUMBER,
10 qty IN OUT NUMBER,
11 org_id IN OUT number,
12 x_err_code OUT NUMBER,
13 x_err_msg OUT VARCHAR2 );
14
15 PROCEDURE first_wip_g(wip_ent_id NUMBER,
16 item_number IN OUT VARCHAR2,
17 org_id IN OUT number,
18 x_err_code OUT NUMBER,
19 x_err_msg OUT VARCHAR2);
20
21 PROCEDURE issue_to_wip_n(trans_id NUMBER,
22 wip_ent_id IN OUT NUMBER,
23 x_err_code OUT NUMBER,
24 x_err_msg OUT VARCHAR2);
25
26 PROCEDURE fes_txn_n(trans_ref IN NUMBER,
27 lot_name IN VARCHAR2,
28 item_id IN NUMBER,
29 cur_trans_id IN OUT NUMBER,
30 next_trans_id IN OUT NUMBER,
31 next_indicator IN OUT VARCHAR2,
32 next_trans_ref IN OUT NUMBER,
33 tran_name IN OUT VARCHAR2,
34 inv_or_wip IN OUT VARCHAR2,
35 txn_type IN OUT VARCHAR2,
36 txn_type_id OUT NUMBER,
37 x_err_code OUT NUMBER,
38 x_err_msg OUT VARCHAR2 );
39
40 PROCEDURE wip_to_complete_n(wip_ent_id NUMBER,org_id NUMBER,
41 no_trans IN OUT NUMBER,
42 x_err_code OUT NUMBER,
43 x_err_msg OUT VARCHAR2);
44
45 PROCEDURE inv_n(item_id NUMBER,
46 lot_name VARCHAR2,
47 cur_trans_id NUMBER,
48 no_of_trans IN OUT NUMBER,
49 x_err_code OUT NUMBER,
50 x_err_msg OUT VARCHAR2);
51
52 PROCEDURE new_qty_n(trans_id NUMBER,wip_ent_id NUMBER,
53 qty IN OUT NUMBER,
54 x_err_code OUT NUMBER,
55 x_err_msg OUT VARCHAR2);
56
57 PROCEDURE completed_qty_n(wip_ent_id NUMBER,
58 qty IN OUT NUMBER,
59 x_err_code OUT NUMBER,
60 x_err_msg OUT VARCHAR2);
61
62 PROCEDURE first_wip_w(wip_ent_id NUMBER,
63 item_number IN OUT VARCHAR2,
64 org_id IN OUT NUMBER,
65 x_err_code OUT NUMBER,
66 x_err_msg OUT VARCHAR2);
67
68 PROCEDURE one_inv_w(wip_ent_id NUMBER,
69 level_no NUMBER,
70 ent_name IN OUT VARCHAR2,
71 ent_id IN OUT NUMBER,
72 qty IN OUT NUMBER,
73 item_number IN OUT VARCHAR2,
74 org_id IN OUT NUMBER,
75 x_err_code OUT NUMBER,
76 x_err_msg OUT VARCHAR2);
77
78 PROCEDURE subxsfer_refs_p(trans_id NUMBER,
79 from_sub IN OUT VARCHAR2,
80 to_sub IN OUT VARCHAR2,
81 x_err_code OUT NUMBER,
82 x_err_msg OUT VARCHAR2);
83
84 FUNCTION complete_from_wip(trans_id NUMBER,
85 x_err_code OUT NUMBER,
86 x_err_msg OUT VARCHAR2) RETURN NUMBER;
87
88 PROCEDURE fes_txn_o(trans_ref IN NUMBER,
89 lot_name IN VARCHAR2,
90 item_id IN NUMBER,
91 cur_trans_id IN OUT NUMBER,
92 next_indicator IN OUT VARCHAR2,
93 inv_or_wip IN OUT VARCHAR2,
94 next_trans_id IN OUT NUMBER,
95 txn_type IN OUT VARCHAR2,
96 txn_type_id OUT NUMBER,
97 next_trans_ref IN OUT NUMBER,
98 tran_name IN OUT VARCHAR2,
99 wip_id IN OUT NUMBER,
100 x_err_code OUT NUMBER,
101 x_err_msg OUT VARCHAR2);
102
103 PROCEDURE issue_from_inv_o(wip_ent_id NUMBER,org_id NUMBER,
104 no_trans IN OUT NUMBER,
105 x_err_code OUT NUMBER,
106 x_err_msg OUT VARCHAR2);
107
108 PROCEDURE wip_o(cur_trans_id IN NUMBER,
109 wip_ent_id IN NUMBER,
110 next_trans_id IN OUT NUMBER,
111 x_err_code OUT NUMBER,
112 x_err_msg OUT VARCHAR2);
113
114 PROCEDURE inv_o(item_id NUMBER,
115 lot_name VARCHAR2,
116 cur_trans_id NUMBER,
117 no_of_trans IN OUT NUMBER,
118 x_err_code OUT NUMBER,
119 x_err_msg OUT VARCHAR2);
120
121 PROCEDURE new_qty_o(trans_id NUMBER,
122 wip_ent_id NUMBER,qty IN OUT NUMBER,
123 x_err_code OUT NUMBER,
124 x_err_msg OUT VARCHAR2);
125
126 PROCEDURE issued_qty_o(wip_ent_id NUMBER,
127 qty IN OUT NUMBER,
128 x_err_code OUT NUMBER,
129 x_err_msg OUT VARCHAR2);
130
131 PROCEDURE wsm_inv_meaning_t (txn_id NUMBER,
132 tran_type OUT VARCHAR2,
133 wsm_inv_txn_type_id OUT NUMBER,
134 x_err_code OUT NUMBER,
135 x_err_msg OUT VARCHAR2);
136
137 PROCEDURE org_transfers_t(from_org_id NUMBER,
138 to_org_id NUMBER,
139 from_org_code IN OUT VARCHAR2,
140 to_org_code IN OUT VARCHAR2,
141 x_err_code OUT NUMBER,
142 x_err_msg OUT VARCHAR2);
143
144 PROCEDURE get_next_type_id_t(id NUMBER,
145 type_id IN OUT NUMBER,
146 x_err_code OUT NUMBER,
147 x_err_msg OUT VARCHAR2);
148
149 end WSMPGENE;
150