[Home] [Help]
PACKAGE: APPS.JTF_PF_CONV_PKG
Source
1 PACKAGE JTF_PF_CONV_PKG AS
2 /* $Header: jtfpfconvpkgs.pls 120.6 2008/04/28 15:31:43 rlandows ship $ */
3 /*===========================================================================+
4 | Copyright (c) 2002 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +===========================================================================+
8 | File name |
9 | jtfpfconvpkgs.pls |
10 | |
11 | Description |
12 | |
13 | This file contains the pakage specifications for the |
14 | JTF_PF_CONV_PKG , which is the PLSQL interface for the |
15 | jsp (activity) logging project |
16 | |
17 | Modification History: |
18 | 05-Feb-2004 Modified navkumar |
19 | split migrate_data to _stats and _raw for |
20 | troubleshooting |
21 | 14-Apr-2002 Modified navkumar |
22 | added a suite of PL/SQL functions and procedures |
23 | 11-Apr-2002 Created bsanghav |
24 |___________________________________________________________________________|*/
25 qname VARCHAR2(2000) := 'JTF_PF_LOGGING_QUEUE';
26 qtablename varchar2(2000) := 'JTF_PF_LOGGING_TABLE';
27
28 -- For Concurrent Manager
29 PROCEDURE synchronize_pageflow_data(ERRBUF OUT NOCOPY VARCHAR2, RETCODE OUT NOCOPY NUMBER);
30 PROCEDURE writePFObjectTable(objTab JTF_PF_PAGE_OBJECT_TABLE,write_to_jtf INTEGER,tech_stack_tbl JTF_PF_TECHSTACK_TABLE, track_prps_tbl JTF_PF_TRACKPURPOSE_TABLE, dbdate OUT NOCOPY DATE);
31 PROCEDURE writePFObject(obj JTF_PF_PAGE_OBJECT,write_to_jtf INTEGER,tech_stack VARCHAR2, track_purpose VARCHAR2, dbdate OUT NOCOPY DATE);
32 PROCEDURE migrate_data(timezone_offset IN NUMBER);
33 PROCEDURE migrate_data_stats(today DATE);
34 PROCEDURE migrate_data_raw;
35 PROCEDURE clean_data(start_date DATE);
36 PROCEDURE purge_data(start_date DATE);
37 PROCEDURE purge_data(ERRBUF OUT NOCOPY VARCHAR2, RETCODE OUT NOCOPY NUMBER , start_date_v IN varchar2); --6991900
38 PROCEDURE multiply_data(days NUMBER);
39
40 -- PROCEDURE uploadAllNewPfObjects(qname VARCHAR2);
41 PROCEDURE uploadAllNewPfObjects;
42
43 FUNCTION GetParams (paramNames JTF_VARCHAR2_TABLE_300, paramValues JTF_VARCHAR2_TABLE_4000, paramSz INTEGER)
44 RETURN JTF_PF_PARAMS_TABLE;
45 FUNCTION GetProdParams (paramNames JTF_VARCHAR2_TABLE_300, paramValues JTF_VARCHAR2_TABLE_4000, paramSz INTEGER)
46 RETURN JTF_PF_PRODPARAMS_TABLE;
47
48 FUNCTION GetParamString(params JTF_PF_PARAMS_TABLE)
49 return CLOB;
50 FUNCTION GetCookieString(params JTF_PF_COOKIES_TABLE)
51 return CLOB;
52
53 FUNCTION GetParamNVs(po_id INTEGER)
54 RETURN JTF_VARCHAR2_TABLE_4000;
55
56 FUNCTION GetParamNames (params JTF_PF_PARAMS_TABLE, paramSz INTEGER)
57 RETURN JTF_VARCHAR2_TABLE_300;
58
59 FUNCTION GetParamValues (params JTF_PF_PARAMS_TABLE, paramSz INTEGER)
60 RETURN JTF_VARCHAR2_TABLE_4000;
61
62 FUNCTION GetCookies (cookieNames JTF_VARCHAR2_TABLE_300, cookieValues JTF_VARCHAR2_TABLE_4000,
63 cookieSizes JTF_NUMBER_TABLE, cookieSz INTEGER)
64 RETURN JTF_PF_COOKIES_TABLE;
65
66 FUNCTION GROUP_CONCAT(list IN JTF_PF_TABLETYPE, separator VARCHAR2)
67 RETURN VARCHAR2;
68
69 PROCEDURE MIGRATED_DATA(TRK_PRPS NUMBER, LST_RCD_MGRTD_TM DATE);
70 END JTF_PF_CONV_PKG;