[Home] [Help]
PACKAGE: APPS.CSF_TDS_PUB
Source
1 PACKAGE CSF_TDS_PUB 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;