[Home] [Help]
Skip to content
PACKAGE: APPS.FLM_EKANBAN_PUB
Source
1 PACKAGE FLM_EKANBAN_PUB AUTHID CURRENT_USER AS
2 /* $Header: FLMPEKBS.pls 120.0 2011/03/03 06:23:47 atjen noship $ */
3
4 -- Defining a structure of type pull sequence record type
5 TYPE pull_sequence_rec_type IS RECORD
6 ( pull_sequence_id NUMBER,
7 generate_cards VARCHAR2(1),
8 last_update_date DATE,
9 last_updated_by NUMBER,
10 creation_date DATE,
11 created_by NUMBER,
12 last_update_login NUMBER,
13 inventory_item_id NUMBER,
14 concatenated_segments VARCHAR2(40),
15 organization_code VARCHAR2(3),
16 organization_id NUMBER,
17 subinventory_name VARCHAR2(10),
18 source_type NUMBER,
19 locator_id NUMBER,
20 supplier_id NUMBER,
21 supplier_name VARCHAR2(240),
22 supplier_site_id NUMBER,
23 supplier_site_code VARCHAR2(15),
24 source_organization_id NUMBER,
25 source_subinventory VARCHAR2(10),
26 source_locator_id NUMBER,
27 wip_line_code VARCHAR2(10),
28 wip_line_id NUMBER,
29 replenishment_lead_time NUMBER,
30 calculate_kanban_flag NUMBER,
31 kanban_size NUMBER,
32 fixed_lot_multiplier NUMBER,
33 safety_stock_days NUMBER,
34 number_of_cards NUMBER,
35 minimum_order_quantity NUMBER,
36 aggregation_type NUMBER,
37 allocation_percent NUMBER,
38 release_kanban_flag NUMBER,
39 attribute_category VARCHAR2(30),
40 attribute1 VARCHAR2(150),
41 attribute2 VARCHAR2(150),
42 attribute3 VARCHAR2(150),
43 attribute4 VARCHAR2(150),
44 attribute5 VARCHAR2(150),
45 attribute6 VARCHAR2(150),
46 attribute7 VARCHAR2(150),
47 attribute8 VARCHAR2(150),
48 attribute9 VARCHAR2(150),
49 attribute10 VARCHAR2(150),
50 attribute11 VARCHAR2(150),
51 attribute12 VARCHAR2(150),
52 attribute13 VARCHAR2(150),
53 attribute14 VARCHAR2(150),
54 attribute15 VARCHAR2(150),
55 auto_request VARCHAR2(1),
56 auto_allocate_flag VARCHAR2(1),
57 replenishment_type NUMBER(1),
58 consolidation NUMBER,
59 consolidation_group VARCHAR2(20),
60 future_card_size NUMBER,
61 future_no_of_cards NUMBER,
62 planning_effectivity DATE,
63 avg_dependent_demand NUMBER,
64 avg_independent_demand NUMBER
65 );
66
67 -- Defining a structure of type kanban supplier record type
68 TYPE kanban_supplier_rec_type IS RECORD
69 ( pull_sequence_id NUMBER,
70 organization_id NUMBER,
71 supplier_id NUMBER,
72 supplier_name VARCHAR2(240),
73 supplier_site_id NUMBER,
74 supplier_site_code VARCHAR2(15),
75 sourcing_percentage NUMBER,
76 transaction_type NUMBER
77 );
78
79 -- Kanban supplier table type
80 TYPE kanban_supplier_tbl_type IS TABLE OF kanban_supplier_rec_type INDEX BY BINARY_INTEGER;
81
82 TYPE kanban_card_rec_type IS RECORD
83 ( pull_sequence_id NUMBER,
84 kanban_card_id NUMBER,
85 kanban_card_number VARCHAR2(200),
86 inventory_item_code VARCHAR2(40),
87 inventory_item_id NUMBER,
88 organization_code VARCHAR2(3),
89 organization_id NUMBER,
90 subinventory_name VARCHAR2(30),
91 supply_status NUMBER,
92 card_status NUMBER,
93 kanban_card_type NUMBER,
94 source_type NUMBER,
95 kanban_size NUMBER,
96 locator_id NUMBER,
97 supplier_id NUMBER,
98 supplier_name VARCHAR2(240),
99 supplier_site_id NUMBER,
100 supplier_site_code VARCHAR2(15),
101 source_organization_id NUMBER,
102 source_subinventory VARCHAR2(10),
103 source_locator_id NUMBER,
104 current_replnsh_cycle_id NUMBER,
105 kanban_error_code NUMBER,
106 wip_line_code VARCHAR2(10),
107 wip_line_id NUMBER,
108 attribute_category VARCHAR2(30),
109 attribute1 VARCHAR2(150),
110 attribute2 VARCHAR2(150),
111 attribute3 VARCHAR2(150),
112 attribute4 VARCHAR2(150),
113 attribute5 VARCHAR2(150),
114 attribute6 VARCHAR2(150),
115 attribute7 VARCHAR2(150),
116 attribute8 VARCHAR2(150),
117 attribute9 VARCHAR2(150),
118 attribute10 VARCHAR2(150),
119 attribute11 VARCHAR2(150),
120 attribute12 VARCHAR2(150),
121 attribute13 VARCHAR2(150),
122 attribute14 VARCHAR2(150),
123 attribute15 VARCHAR2(150),
124 last_print_date DATE,
125 last_update_date DATE,
126 last_update_by NUMBER,
127 creation_date DATE,
128 created_by NUMBER,
129 last_update_login NUMBER,
130 request_id NUMBER,
131 program_application_id NUMBER,
132 program_id NUMBER,
133 program_update_date DATE,
134 replenishment_count NUMBER, --Indicates the number of times the card was replenished
135 max_replenishments NUMBER, --This figure indicates the maximum number of replenishments the card can have.
136 disable_date DATE, --Disable Date for Card effectivity
137 replacement_flag NUMBER --Flag to indicate if kanban card is to be replaced
138 );
139
140
141 PROCEDURE receive
142 ( p_api_version IN NUMBER,
143 p_commit IN VARCHAR2 DEFAULT NULL,
144 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_kanban_card_number IN VARCHAR2,
149 p_organization_code IN VARCHAR2,
150 p_receipt_quantity IN NUMBER,
151 p_process_flag IN VARCHAR2 DEFAULT NULL,
152 x_receipt_number OUT NOCOPY NUMBER
153 );
154
155
156 PROCEDURE transfer
157 ( p_api_version IN NUMBER,
158 p_commit IN VARCHAR2 DEFAULT NULL,
159 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_kanban_card_number IN VARCHAR2,
164 p_organization_code IN VARCHAR2,
165 p_transfer_quantity IN NUMBER,
166 p_process_flag IN VARCHAR2 DEFAULT NULL
167 );
168
169
170 PROCEDURE process_pull_sequence
171 ( p_api_version IN NUMBER,
172 p_commit IN VARCHAR2 DEFAULT NULL,
173 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 x_pull_sequence_rec IN OUT NOCOPY pull_sequence_rec_type,
178 x_supplier_tbl IN OUT NOCOPY kanban_supplier_tbl_type,
179 p_transaction_type IN NUMBER
180 );
181
182
183 PROCEDURE process_cards
184 ( p_api_version IN NUMBER,
185 p_commit IN VARCHAR2 DEFAULT NULL,
186 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 x_kanban_card_rec IN OUT NOCOPY kanban_card_rec_type,
191 p_transaction_type IN NUMBER
192 );
193
194 PROCEDURE update_card_status
195 ( p_api_version IN NUMBER,
196 p_commit IN VARCHAR2 DEFAULT NULL,
197 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_kanban_card_number IN VARCHAR2,
202 p_organization_code IN VARCHAR2,
203 p_supply_status_from IN NUMBER DEFAULT NULL,
204 p_supply_status_to IN NUMBER DEFAULT NULL,
205 p_card_status_to IN NUMBER DEFAULT NULL
206 );
207
208 END FLM_EKANBAN_PUB;