eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_PAGE_OBJECT

Line 32: 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) IS

28: |___________________________________________________________________________|*/
29:
30: last_migrate_day DATE;
31:
32: 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) IS
33: PRAGMA AUTONOMOUS_TRANSACTION;
34: enqueue_options dbms_aq.enqueue_options_t;
35: message_properties dbms_aq.message_properties_t;
36: message_handle RAW(16);

Line 37: objTabLocal JTF_PF_PAGE_OBJECT_TABLE;

33: PRAGMA AUTONOMOUS_TRANSACTION;
34: enqueue_options dbms_aq.enqueue_options_t;
35: message_properties dbms_aq.message_properties_t;
36: message_handle RAW(16);
37: objTabLocal JTF_PF_PAGE_OBJECT_TABLE;
38: obj JTF_PF_PAGE_OBJECT;
39: dummyPageObj JTF_PF_PAGE_OBJECT;
40: seq_num INTEGER;
41:

Line 38: obj JTF_PF_PAGE_OBJECT;

34: enqueue_options dbms_aq.enqueue_options_t;
35: message_properties dbms_aq.message_properties_t;
36: message_handle RAW(16);
37: objTabLocal JTF_PF_PAGE_OBJECT_TABLE;
38: obj JTF_PF_PAGE_OBJECT;
39: dummyPageObj JTF_PF_PAGE_OBJECT;
40: seq_num INTEGER;
41:
42: BEGIN

Line 39: dummyPageObj JTF_PF_PAGE_OBJECT;

35: message_properties dbms_aq.message_properties_t;
36: message_handle RAW(16);
37: objTabLocal JTF_PF_PAGE_OBJECT_TABLE;
38: obj JTF_PF_PAGE_OBJECT;
39: dummyPageObj JTF_PF_PAGE_OBJECT;
40: seq_num INTEGER;
41:
42: BEGIN
43: objTabLocal := JTF_PF_PAGE_OBJECT_TABLE();

Line 43: objTabLocal := JTF_PF_PAGE_OBJECT_TABLE();

39: dummyPageObj JTF_PF_PAGE_OBJECT;
40: seq_num INTEGER;
41:
42: BEGIN
43: objTabLocal := JTF_PF_PAGE_OBJECT_TABLE();
44: FOR i IN 1..objTab.COUNT
45: LOOP
46: obj := objTab(i);
47: objTabLocal.EXTEND;

Line 49: objTabLocal(i) := JTF_PF_PAGE_OBJECT(JTF_PF_INFO_OBJECT(seq_num,obj.info.Day,obj.info.Timestamp),obj.dpf,obj.ses,obj.jsp,

45: LOOP
46: obj := objTab(i);
47: objTabLocal.EXTEND;
48: SELECT JTF_PF_SEQ.NEXTVAL INTO seq_num FROM dual;
49: objTabLocal(i) := JTF_PF_PAGE_OBJECT(JTF_PF_INFO_OBJECT(seq_num,obj.info.Day,obj.info.Timestamp),obj.dpf,obj.ses,obj.jsp,
50: obj.loc,obj.lang,obj.client,obj.params,
51: obj.cookies,obj.headers, obj.prodinfo);
52: END LOOP;
53: SELECT sysdate INTO dbdate FROM dual;

Line 80: PROCEDURE writePFObject(obj JTF_PF_PAGE_OBJECT,write_to_jtf INTEGER,tech_stack VARCHAR2, track_purpose VARCHAR2, dbdate OUT NOCOPY DATE) IS

76: | INTO JTF_PF_PARAMS_TABLE
77: | This IS an autonomous TRANSACTION i.e. It does NOT matter whether THE parent TRANSACTION
78: | commited OR rolled back , this TRANSACTION will COMMIT IF ALL goes well
79: ============================================================================================================*/
80: PROCEDURE writePFObject(obj JTF_PF_PAGE_OBJECT,write_to_jtf INTEGER,tech_stack VARCHAR2, track_purpose VARCHAR2, dbdate OUT NOCOPY DATE) IS
81: PRAGMA AUTONOMOUS_TRANSACTION;
82: pObject JTF_PF_PAGE_OBJECT;
83: enqueue_options dbms_aq.enqueue_options_t;
84: message_properties dbms_aq.message_properties_t;

Line 82: pObject JTF_PF_PAGE_OBJECT;

78: | commited OR rolled back , this TRANSACTION will COMMIT IF ALL goes well
79: ============================================================================================================*/
80: PROCEDURE writePFObject(obj JTF_PF_PAGE_OBJECT,write_to_jtf INTEGER,tech_stack VARCHAR2, track_purpose VARCHAR2, dbdate OUT NOCOPY DATE) IS
81: PRAGMA AUTONOMOUS_TRANSACTION;
82: pObject JTF_PF_PAGE_OBJECT;
83: enqueue_options dbms_aq.enqueue_options_t;
84: message_properties dbms_aq.message_properties_t;
85: message_handle RAW(16);
86: dummyPageObj JTF_PF_PAGE_OBJECT;

Line 86: dummyPageObj JTF_PF_PAGE_OBJECT;

82: pObject JTF_PF_PAGE_OBJECT;
83: enqueue_options dbms_aq.enqueue_options_t;
84: message_properties dbms_aq.message_properties_t;
85: message_handle RAW(16);
86: dummyPageObj JTF_PF_PAGE_OBJECT;
87: seq_num INTEGER;
88: BEGIN
89: SELECT JTF_PF_SEQ.NEXTVAL INTO seq_num FROM dual;
90: SELECT sysdate INTO dbdate FROM dual;

Line 91: dummyPageObj := JTF_PF_PAGE_OBJECT(JTF_PF_INFO_OBJECT(seq_num,obj.info.Day,obj.info.Timestamp),obj.dpf,obj.ses,obj.jsp,

87: seq_num INTEGER;
88: BEGIN
89: SELECT JTF_PF_SEQ.NEXTVAL INTO seq_num FROM dual;
90: SELECT sysdate INTO dbdate FROM dual;
91: dummyPageObj := JTF_PF_PAGE_OBJECT(JTF_PF_INFO_OBJECT(seq_num,obj.info.Day,obj.info.Timestamp),obj.dpf,obj.ses,obj.jsp,
92: obj.loc,obj.lang,obj.client,obj.params,
93: obj.cookies,obj.headers,obj.prodinfo);
94: IF (write_to_jtf = 1) THEN
95: INSERT INTO jtf_pf_repository(

Line 115: | This IS used TO construct THE JTF_PF_PAGE_OBJECT |

111:
112: /* ============================================================================================================
113: | Converts THE param names AND param VALUES, coming IN AS 2 seperate arrays, FROM THE JAVA layer, |
114: | INTO JTF_PF_PARAMS_TABLE |
115: | This IS used TO construct THE JTF_PF_PAGE_OBJECT |
116: ===============================================================================================================*/
117: FUNCTION GetParams (paramNames JTF_VARCHAR2_TABLE_300, paramValues JTF_VARCHAR2_TABLE_4000, paramSz INTEGER)
118: RETURN JTF_PF_PARAMS_TABLE IS
119: params JTF_PF_PARAMS_TABLE := JTF_PF_PARAMS_TABLE();

Line 220: | This IS used TO construct THE JTF_PF_PAGE_OBJECT |

216:
217: /* ============================================================================================================
218: | Converts THE cookie names, cookie sizes AND cokie VALUES, coming IN AS 3 seperate arrays, |
219: | FROM THE JAVA layer, INTO JTF_PF_COOKIES_TABLE |
220: | This IS used TO construct THE JTF_PF_PAGE_OBJECT |
221: ===============================================================================================================*/
222: FUNCTION GetCookies (cookieNames JTF_VARCHAR2_TABLE_300, cookieValues JTF_VARCHAR2_TABLE_4000,
223: cookieSizes JTF_NUMBER_TABLE, cookieSz INTEGER)
224: RETURN JTF_PF_COOKIES_TABLE IS

Line 240: pgObjects JTF_PF_PAGE_OBJECT ;

236: | Upload THE data IN AQ periodically TO THE JTF Repository |
237: =============================================================================================================*/
238:
239: PROCEDURE uploadAllNewPfObjects IS --ang This proc is currently not being invoked anywhere
240: pgObjects JTF_PF_PAGE_OBJECT ;
241: new_messages BOOLEAN :=TRUE;
242: dopt dbms_aq.dequeue_options_t;
243: mprop dbms_aq.message_properties_t;
244: deq_msgid RAW(16);

Line 432: nextpo JTF_PF_PAGE_OBJECT;

428: ORDER BY x.pageobject.ses.SessionId, x.pageobject.jsp.StartTime;
429:
430: CURSOR cur_val IS SELECT nvl(max_po,-100000000000), nvl(ses_seqid,0), nvl(anon_seqid,0) FROM JTF_PF_SEQ_VL;
431:
432: nextpo JTF_PF_PAGE_OBJECT;
433: currpo JTF_PF_PAGE_OBJECT;
434: thinkT INTEGER;
435: seqcnt1 INTEGER;
436: seqcnt2 INTEGER;

Line 433: currpo JTF_PF_PAGE_OBJECT;

429:
430: CURSOR cur_val IS SELECT nvl(max_po,-100000000000), nvl(ses_seqid,0), nvl(anon_seqid,0) FROM JTF_PF_SEQ_VL;
431:
432: nextpo JTF_PF_PAGE_OBJECT;
433: currpo JTF_PF_PAGE_OBJECT;
434: thinkT INTEGER;
435: seqcnt1 INTEGER;
436: seqcnt2 INTEGER;
437: maxpo INTEGER;