PACKAGE: APPS.FLM_KANBAN_MASSLOAD

Source

1 PACKAGE FLM_KANBAN_MASSLOAD AUTHID CURRENT_USER AS
2 /* $Header: FLMKBNMS.pls 120.1 2011/03/24 08:36:00 sisankar noship $ */
3 
4 --global constants
5 --Process status
6 PENDING     CONSTANT NUMBER := 1;
7 RUNNING     CONSTANT NUMBER := 2;
8 ERROR       CONSTANT NUMBER := 3;
9 WARNING     CONSTANT NUMBER := 4;
10 COMPLETED   CONSTANT NUMBER := 5;
11 
12 --Transaction type
13 KANBAN_ADD      CONSTANT NUMBER := 1;
14 KANBAN_CHANGE   CONSTANT NUMBER := 2;
15 KANBAN_DELETE   CONSTANT NUMBER := 3;
16 
17 --Replenishment type
18 PHYSICAL    CONSTANT NUMBER := 0;
19 LOGICAL     CONSTANT NUMBER := 1;
20 
21 --Consolidation
22 CONSOLIDATION_NO       NUMBER := 1;
23 CONSOLIDATION_YES      NUMBER := 2;
24 
25 
26 G_PRODUCTION_KANBAN CONSTANT NUMBER := -1;
27 
28 -- Locator
29 LOCATOR_NONE           NUMBER := 1;
30 
31 --Pull sequence interface table type
32 TYPE pull_seq_tbl_type IS TABLE OF FLM_EKB_PULL_SEQ_INTERFACE%ROWTYPE index by binary_integer;
33 
34 --Kanban supplier interface table type
35 TYPE kanban_supp_tbl_type IS TABLE OF FLM_EKB_SUPPLIER_INTERFACE%ROWTYPE index by binary_integer;
36 
37 --Kanban cards interface table type
38 TYPE card_int_tbl_type IS TABLE OF FLM_EKB_CARDS_INTERFACE%ROWTYPE INDEX BY binary_integer;
39 
40 -- Main procedure called by the kanaban mass register concurrent program
41 procedure load_kanban(retcode      OUT NOCOPY NUMBER
42                      ,errbuf       OUT NOCOPY VARCHAR2
43                      ,p_group_id   IN NUMBER);
44 
45 
46 END FLM_KANBAN_MASSLOAD;