1 PACKAGE flm_kanban AUTHID CURRENT_USER AS
2 /* $Header: FLMKBNWS.pls 115.8 2003/05/29 16:55:51 nrajpal ship $ */
3
4 -- Constants
5 G_Source_Type_InterOrg CONSTANT NUMBER := 1;
6 G_Source_Type_Supplier CONSTANT NUMBER := 2;
7 G_Source_Type_IntraOrg CONSTANT NUMBER := 3;
8 G_Source_Type_Production CONSTANT NUMBER := 4;
9
10 TYPE point_record IS RECORD (
11 item_id INTEGER,
12 locator_id INTEGER
13 );
14
15 TYPE ret_sch_t IS TABLE OF point_record index by binary_integer;
16
17 TYPE t_sres IS TABLE OF VARCHAR2(32767) INDEX BY BINARY_INTEGER;
18
19 TYPE assembly_t IS TABLE OF number index by binary_integer;
20
21
22 PROCEDURE retrieve_schedules (i_locator_option NUMBER,
23 i_template_sub VARCHAR2,
24 i_default_locator_id NUMBER DEFAULT NULL,
25 i_org_id NUMBER,
26 i_line_id NUMBER,
27 i_standard_operation_id NUMBER,
28 i_operation_type NUMBER,
29 i_assembly IN assembly_t,
30 i_item_attributes IN VARCHAR2,
31 i_item_from IN VARCHAR2,
32 i_item_to IN VARCHAR2,
33 i_backflush_sub IN VARCHAR2,
34 i_cat_from IN VARCHAR2,
35 i_cat_to IN VARCHAR2,
36 i_category_set_id IN NUMBER,
37 i_category_structure_id IN NUMBER,
38 o_result OUT NOCOPY ret_sch_t,
39 o_error_num OUT NOCOPY NUMBER,
40 o_error_msg OUT NOCOPY VARCHAR2);
41
42 PROCEDURE demand_pegging_tree (i_pull_sequence_id IN NUMBER,
43 o_result OUT NOCOPY t_sres,
44 o_numdays OUT NOCOPY NUMBER,
45 o_error_num OUT NOCOPY NUMBER,
46 o_error_msg OUT NOCOPY VARCHAR2);
47
48 PROCEDURE demand_graph (i_pull_sequence_id IN NUMBER,
49 o_result OUT NOCOPY t_sres,
50 o_error_num OUT NOCOPY NUMBER,
51 o_error_msg OUT NOCOPY VARCHAR2);
52
53 -- This determines whether a Planning and Production Pull Sequence has a same Point of Supply
54 FUNCTION Plan_Prod_Same_Pos (p_plan_pull_seq_id NUMBER,
55 p_prod_pull_seq_id NUMBER) return BOOLEAN;
56
57 END flm_kanban;