[Home] [Help]
PACKAGE: APPS.JTF_PF_CONV_PKG
Source
1 PACKAGE JTF_PF_CONV_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfpfconvpkgs.pls 120.6.12020000.2 2012/10/09 18:19:36 pdeluna 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, force_clean boolean default FALSE); -- 9431056
36 PROCEDURE purge_data(start_date DATE, force_purge IN VARCHAR2 default 'FALSE'); --9431056
37 PROCEDURE purge_data(ERRBUF OUT NOCOPY VARCHAR2, RETCODE OUT NOCOPY NUMBER , start_date_v IN varchar2,
38 force_purge IN VARCHAR2 default 'FALSE'); --6991900, 9431056
39 PROCEDURE multiply_data(days NUMBER);
40
41 -- PROCEDURE uploadAllNewPfObjects(qname VARCHAR2);
42 PROCEDURE uploadAllNewPfObjects;
43
44 FUNCTION GetParams (paramNames JTF_VARCHAR2_TABLE_300, paramValues JTF_VARCHAR2_TABLE_4000, paramSz INTEGER)
45 RETURN JTF_PF_PARAMS_TABLE;
46 FUNCTION GetProdParams (paramNames JTF_VARCHAR2_TABLE_300, paramValues JTF_VARCHAR2_TABLE_4000, paramSz INTEGER)
47 RETURN JTF_PF_PRODPARAMS_TABLE;
48
49 FUNCTION GetParamString(params JTF_PF_PARAMS_TABLE)
50 return CLOB;
51 FUNCTION GetCookieString(params JTF_PF_COOKIES_TABLE)
52 return CLOB;
53
54 FUNCTION GetParamNVs(po_id INTEGER)
55 RETURN JTF_VARCHAR2_TABLE_4000;
56
57 FUNCTION GetParamNames (params JTF_PF_PARAMS_TABLE, paramSz INTEGER)
58 RETURN JTF_VARCHAR2_TABLE_300;
59
60 FUNCTION GetParamValues (params JTF_PF_PARAMS_TABLE, paramSz INTEGER)
61 RETURN JTF_VARCHAR2_TABLE_4000;
62
63 FUNCTION GetCookies (cookieNames JTF_VARCHAR2_TABLE_300, cookieValues JTF_VARCHAR2_TABLE_4000,
64 cookieSizes JTF_NUMBER_TABLE, cookieSz INTEGER)
65 RETURN JTF_PF_COOKIES_TABLE;
66
67 FUNCTION GROUP_CONCAT(list IN JTF_PF_TABLETYPE, separator VARCHAR2)
68 RETURN VARCHAR2;
69
70 PROCEDURE MIGRATED_DATA(TRK_PRPS NUMBER, LST_RCD_MGRTD_TM DATE);
71 END JTF_PF_CONV_PKG;