PACKAGE: APPS.WIP_DIAG_DISCRETE_LOT

Source

1 PACKAGE WIP_DIAG_DISCRETE_LOT  AS
2 /* $Header: WIPDJOBS.pls 120.0.12000000.1 2007/07/10 10:07:00 mraman noship $ */
3 
4 
5 sqltxt  varchar2(15000);
6 where_clause varchar2(100) ;
7 dummy_num       number;
8 reportStr   LONG;           -- REPORT
9 statusStr   VARCHAR2(50);   -- SUCCESS or FAILURE
10 errStr      VARCHAR2(4000); -- error message
11 fixInfo     VARCHAR2(4000); -- fix tip
12 isFatal     VARCHAR2(50);   -- TRUE or FALSE
13 apps_ver    VARCHAR2(20);
14 
15 
16 
17 PROCEDURE Uncosted_mat_txn_wdj ( p_org_id IN  NUMBER,
18                                report OUT NOCOPY JTF_DIAG_REPORT,
19                                reportClob OUT NOCOPY CLOB
20                                ) ;
21 PROCEDURE corrupt_osp_txn_wdj (p_org_id IN NUMBER,
22                                report OUT NOCOPY JTF_DIAG_REPORT,
23                                reportClob OUT NOCOPY CLOB
24                                ) ;
25 PROCEDURE dup_mat_txn_wdj      (p_org_id IN NUMBER ,
26                                report OUT NOCOPY JTF_DIAG_REPORT,
27                                reportClob OUT NOCOPY CLOB
28                                ) ;
29 
30 END;