PACKAGE: APPS.CSF_TDS_PUB

Source

1 PACKAGE CSF_TDS_PUB AUTHID CURRENT_USER AS
2 /*$Header: CSFPTDSS.pls 120.0.12010000.2 2008/10/08 13:28:18 gmarwah noship $  */
3 
4 type t_crs is ref cursor;
5 
6 G_PKG_NAME          CONSTANT VARCHAR2(30)   := 'CSF_TDS_PUB';
7 G_CONC_PROGRAM_NAME CONSTANT VARCHAR2(30)   := 'CSFTDPUB';
8 
9 G_VALID_TRUE  CONSTANT VARCHAR2(1)    := 'Y';
10 G_VALID_FALSE CONSTANT VARCHAR2(1)    := 'N';
11 G_DEBUG_P     CONSTANT VARCHAR2(100)  := 'begin dbms_'||'output'||'.put_line(:1); end;';
12 
13 G_LOG         CONSTANT NUMBER   := FND_FILE.LOG;
14 G_OUTPUT      CONSTANT NUMBER   := FND_FILE.OUTPUT;
15 
16 G_DEBUG       BOOLEAN  ;
17 
18 PROCEDURE PURGE_UNUSED_CACHE (
19       errbuf         OUT NOCOPY      VARCHAR2,
20       retcode        OUT NOCOPY      VARCHAR2,
21       p_start_date   IN              VARCHAR2 DEFAULT NULL,
22       p_end_date     IN              VARCHAR2 DEFAULT NULL
23    );
24 
25 
26   PROCEDURE TDS_ROUTES_TO_BE_CALCULATED(query_id IN NUMBER,config_string IN VARCHAR2,
27                 user_id IN NUMBER,status OUT NOCOPY  NUMBER , msg OUT NOCOPY  VARCHAR2);
28 
29 
30 PROCEDURE GEO_DISTANCE (srId IN NUMBER,x1 IN NUMBER, y1 IN NUMBER,
31                 x2 IN NUMBER,y2 IN NUMBER , result OUT NOCOPY NUMBER);
32 end CSF_TDS_PUB;