PACKAGE: APPS.FLM_PURGE

Source

1 PACKAGE FLM_PURGE AUTHID CURRENT_USER AS
2 /* $Header: FLMCPPGS.pls 115.6 2003/08/13 06:48:58 nrajpal noship $ */
3 
4 SYS_YES                  CONSTANT NUMBER := 1;
5 SYS_NO                   CONSTANT NUMBER := 2;
6 
7 G_ZERO                   CONSTANT NUMBER := 0;
8 G_BATCH                  CONSTANT NUMBER := 500;
9 G_CLOSED_STATUS          CONSTANT NUMBER := 2;
10 
11 G_DEBUG                          BOOLEAN := FALSE;
12 G_SUCCESS                CONSTANT NUMBER := 0;
13 G_WARNING                CONSTANT NUMBER := 1;
14 G_ERROR                  CONSTANT NUMBER := 2;
15 
16 
17 PROCEDURE VERIFY_FOREIGN_KEYS(
18                     arg_wip_entity_id   in      NUMBER,
19                     arg_org_id          in      NUMBER,
20                     arg_item_id         in      NUMBER,
21                     arg_table_name      out     NOCOPY  VARCHAR2,
22                     arg_return_value    out     NOCOPY  NUMBER,
23                     errbuf              out     NOCOPY  VARCHAR2
24 );
25 
26 /* Added for Enhancement #2829204
27    Added arg_auto_replenish parameter, to delink the Kanban Card Activity
28    with the flow schedule, for flow schedules which has auto_replenish = 'Y' */
29 PROCEDURE DELETE_TABLES(
30                     arg_wip_entity_id   in      NUMBER,
31                     arg_org_id          in      NUMBER,
32 		    arg_auto_replenish  in      VARCHAR2,
33                     arg_return_value    out     NOCOPY  NUMBER,
34                     errbuf              out     NOCOPY  VARCHAR2
35 );
36 
37 /* Added arg_purge_option argument for deleting from wip_transactions
38 and wip_transaction_accounts tables only */
39 PROCEDURE PURGE_SCHEDULES(
40                     errbuf               out     NOCOPY varchar2,
41                     retcode              out     NOCOPY number,
42                     arg_org_id           in      number,
43                     arg_cutoff_date      in      varchar2,
44                     arg_line             in      VARCHAR2,
45                     arg_assembly         in      VARCHAR2,
46                     arg_purge_option     in      number
47 );
48 END FLM_PURGE;