[Home] [Help]
PACKAGE: APPS.FLM_KANBAN_PURGE
Source
1 PACKAGE FLM_KANBAN_PURGE AUTHID CURRENT_USER AS
2 /* $Header: FLMCPPKS.pls 115.4 2002/11/27 10:59:10 nrajpal noship $ */
3
4 SYS_YES CONSTANT NUMBER := 1;
5 SYS_NO CONSTANT NUMBER := 2;
6
7 G_ZERO CONSTANT NUMBER := 0;
8
9 G_SUCCESS CONSTANT NUMBER := 0;
10 G_WARNING CONSTANT NUMBER := 1;
11 G_ERROR CONSTANT NUMBER := 2;
12
13
14 G_KANBAN_CARD CONSTANT NUMBER := 1;
15 G_PULL_SEQUENCE CONSTANT NUMBER := 2;
16 G_EXCEPTION CONSTANT NUMBER := 3;
17
18 G_BATCH CONSTANT NUMBER := 500;
19
20 G_CANCELLED_CARDS_ONLY CONSTANT NUMBER := 1;
21 G_CANCELLED_AND_NEW CONSTANT NUMBER := 2;
22
23 PROCEDURE PURGE_KANBAN_CARDS (
24 arg_pull_seq_id in number,
25 arg_org_id in number,
26 arg_item_id in number,
27 arg_subinv in varchar2,
28 arg_loc_id in number,
29 arg_delete_card in number,
30 arg_group_id in number,
31 retcode out NOCOPY number,
32 errbuf out NOCOPY varchar2
33 );
34
35 PROCEDURE CHECK_RESTRICTIONS (
36 arg_pull_seq_id in number,
37 arg_org_id in number,
38 arg_item_id in number,
39 arg_subinv in varchar2,
40 arg_loc_id in number,
41 arg_group_id in number,
42 retcode out NOCOPY number,
43 errbuf out NOCOPY varchar2
44 );
45
46 PROCEDURE PURGE_KANBAN (
47 errbuf out NOCOPY varchar2,
48 retcode out NOCOPY number,
49 arg_group_id in number,
50 arg_org_id in number,
51 arg_item_from in varchar2,
52 arg_item_to in varchar2,
53 arg_subinv_from in varchar2,
54 arg_subinv_to in varchar2,
55 arg_source_type in number,
56 arg_line_id in number,
57 arg_supplier_id in number,
58 arg_source_org_id in number,
59 arg_source_subinv in varchar2,
60 arg_delete_card in number
61 );
62
63 END FLM_KANBAN_PURGE;