1 PACKAGE MRP_KANBAN_SNAPSHOT_PK AUTHID CURRENT_USER AS
2 /* $Header: MRPKSNPS.pls 115.11 2003/05/02 20:16:36 liyma ship $ */
3
4 VERSION CONSTANT CHAR(80) := '1.0';
5 KANBAN_RELEASE CONSTANT NUMBER := 6;
6
7 -- ========================================================================
8 --
9 -- This function will identify the list of items that need to be included
10 -- in the current kanban plan run. User can limit thelist of items by
11 -- specifying an item range or item categroy. It will select the bill
12 -- structure of these items and insert them into the table mrp_kanban_ll_code.
13 --
14 -- ========================================================================
15 FUNCTION SNAPSHOT_ITEM_LOCATIONS RETURN BOOLEAN;
16
17 -- ========================================================================
18 -- This procedure builds the where clause for the category range specified
19 -- The where clause is used in the first select statement while
20 -- snapshotting kanban items
21 -- ========================================================================
22 FUNCTION ITEM_WHERE_CLAUSE ( p_item_lo IN VARCHAR2,
23 p_item_hi IN VARCHAR2,
24 p_table_name IN VARCHAR2,
25 p_where OUT NOCOPY VARCHAR2 )
26 RETURN BOOLEAN;
27
28 -- ========================================================================
29 -- This procedure builds the where clause for the category range specified
30 -- The where clause is used in the first select statement while
31 -- snapshotting kanban items
32 -- ========================================================================
33
34 FUNCTION CATEGORY_WHERE_CLAUSE ( p_cat_lo IN VARCHAR2,
35 p_cat_hi IN VARCHAR2,
36 p_table_name IN VARCHAR2,
37 p_where OUT NOCOPY VARCHAR2 )
38 RETURN BOOLEAN;
39
40
41 FUNCTION Check_Min_Priority
42 ( p_assembly_item_id IN NUMBER,
43 p_organization_id IN NUMBER,
44 p_line_id IN NUMBER,
45 p_alternate_designator IN VARCHAR2)
46 RETURN NUMBER;
47
48 -- ========================================================================
49 -- This procedure builds the where clause to filter the rows for which
50 -- the component is a Model or an Option class and the assembly is
51 -- a Configured Item
52 -- ========================================================================
53
54 FUNCTION Check_assy_cfgitem
55 (p_assembly_item_id IN NUMBER,
56 p_comp_item_id IN NUMBER,
57 p_organization_id IN NUMBER)
58 RETURN NUMBER;
59
60 PRAGMA RESTRICT_REFERENCES (Check_Min_Priority,WNDS,WNPS);
61 PRAGMA RESTRICT_REFERENCES (Check_assy_cfgitem,WNDS,WNPS);
62
63 END mrp_kanban_snapshot_pk;
64