DBA Data[Home] [Help]

APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_PAGE_OBJECT

Line 33: objTab JTF_PF_PAGE_OBJECT_TABLE,

29:
30: last_migrate_day DATE;
31:
32: PROCEDURE writePFObjectTable(
33: objTab JTF_PF_PAGE_OBJECT_TABLE,
34: write_to_jtf INTEGER,
35: tech_stack_tbl JTF_PF_TECHSTACK_TABLE,
36: track_prps_tbl JTF_PF_TRACKPURPOSE_TABLE,
37: dbdate OUT NOCOPY DATE)

Line 43: objTabLocal JTF_PF_PAGE_OBJECT_TABLE;

39: PRAGMA AUTONOMOUS_TRANSACTION;
40: enqueue_options dbms_aq.enqueue_options_t;
41: message_properties dbms_aq.message_properties_t;
42: message_handle RAW(16);
43: objTabLocal JTF_PF_PAGE_OBJECT_TABLE;
44: obj JTF_PF_PAGE_OBJECT;
45: dummyPageObj JTF_PF_PAGE_OBJECT;
46: seq_num INTEGER;
47: enable_site varchar2(10) := NULL;

Line 44: obj JTF_PF_PAGE_OBJECT;

40: enqueue_options dbms_aq.enqueue_options_t;
41: message_properties dbms_aq.message_properties_t;
42: message_handle RAW(16);
43: objTabLocal JTF_PF_PAGE_OBJECT_TABLE;
44: obj JTF_PF_PAGE_OBJECT;
45: dummyPageObj JTF_PF_PAGE_OBJECT;
46: seq_num INTEGER;
47: enable_site varchar2(10) := NULL;
48: enable_app varchar2(10) := NULL;

Line 45: dummyPageObj JTF_PF_PAGE_OBJECT;

41: message_properties dbms_aq.message_properties_t;
42: message_handle RAW(16);
43: objTabLocal JTF_PF_PAGE_OBJECT_TABLE;
44: obj JTF_PF_PAGE_OBJECT;
45: dummyPageObj JTF_PF_PAGE_OBJECT;
46: seq_num INTEGER;
47: enable_site varchar2(10) := NULL;
48: enable_app varchar2(10) := NULL;
49: enable_resp varchar2(10) := NULL;

Line 52: objTabLocal := JTF_PF_PAGE_OBJECT_TABLE();

48: enable_app varchar2(10) := NULL;
49: enable_resp varchar2(10) := NULL;
50: enable_user varchar2(10) := NULL;
51: BEGIN
52: objTabLocal := JTF_PF_PAGE_OBJECT_TABLE();
53: FOR i IN 1..objTab.COUNT
54: LOOP
55: obj := objTab(i);
56: objTabLocal.EXTEND;

Line 58: objTabLocal(i) := JTF_PF_PAGE_OBJECT(

54: LOOP
55: obj := objTab(i);
56: objTabLocal.EXTEND;
57: SELECT JTF_PF_SEQ.NEXTVAL INTO seq_num FROM dual;
58: objTabLocal(i) := JTF_PF_PAGE_OBJECT(
59: JTF_PF_INFO_OBJECT(seq_num,obj.info.Day,obj.info.Timestamp),
60: obj.dpf, obj.ses, obj.jsp, obj.loc, obj.lang, obj.client,
61: obj.params, obj.cookies, obj.headers, obj.prodinfo);
62: END LOOP;

Line 107: obj JTF_PF_PAGE_OBJECT,

103: | parent TRANSACTION commited OR rolled back , this TRANSACTION will
104: | COMMIT IF ALL goes well
105: ===========================================================================*/
106: PROCEDURE writePFObject(
107: obj JTF_PF_PAGE_OBJECT,
108: write_to_jtf INTEGER,
109: tech_stack VARCHAR2,
110: track_purpose VARCHAR2,
111: dbdate OUT NOCOPY DATE)

Line 114: pObject JTF_PF_PAGE_OBJECT;

110: track_purpose VARCHAR2,
111: dbdate OUT NOCOPY DATE)
112: IS
113: PRAGMA AUTONOMOUS_TRANSACTION;
114: pObject JTF_PF_PAGE_OBJECT;
115: enqueue_options dbms_aq.enqueue_options_t;
116: message_properties dbms_aq.message_properties_t;
117: message_handle RAW(16);
118: dummyPageObj JTF_PF_PAGE_OBJECT;

Line 118: dummyPageObj JTF_PF_PAGE_OBJECT;

114: pObject JTF_PF_PAGE_OBJECT;
115: enqueue_options dbms_aq.enqueue_options_t;
116: message_properties dbms_aq.message_properties_t;
117: message_handle RAW(16);
118: dummyPageObj JTF_PF_PAGE_OBJECT;
119: seq_num INTEGER;
120: enable_site varchar2(10) := NULL;
121: enable_app varchar2(10) := NULL;
122: enable_resp varchar2(10) := NULL;

Line 127: dummyPageObj := JTF_PF_PAGE_OBJECT(

123: enable_user varchar2(10) := NULL;
124: BEGIN
125: SELECT JTF_PF_SEQ.NEXTVAL INTO seq_num FROM dual;
126: SELECT sysdate INTO dbdate FROM dual;
127: dummyPageObj := JTF_PF_PAGE_OBJECT(
128: JTF_PF_INFO_OBJECT(seq_num,obj.info.Day,obj.info.Timestamp), obj.dpf,
129: obj.ses, obj.jsp, obj.loc, obj.lang, obj.client, obj.params,
130: obj.cookies, obj.headers, obj.prodinfo);
131:

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

164:
165: /* ==========================================================================
166: | Converts THE param names AND param VALUES, coming IN AS 2 separate arrays,
167: | FROM THE JAVA layer, INTO JTF_PF_PARAMS_TABLE |
168: | This IS used TO construct THE JTF_PF_PAGE_OBJECT |
169: ============================================================================*/
170: FUNCTION GetParams(
171: paramNames JTF_VARCHAR2_TABLE_300,
172: paramValues JTF_VARCHAR2_TABLE_4000,

Line 280: | This IS used TO construct THE JTF_PF_PAGE_OBJECT

276: END;
277: /* ==========================================================================
278: | Converts THE cookie names, cookie sizes AND cokie VALUES, coming IN AS
279: | 3 separate arrays,FROM THE JAVA layer, INTO JTF_PF_COOKIES_TABLE
280: | This IS used TO construct THE JTF_PF_PAGE_OBJECT
281: ============================================================================*/
282: FUNCTION GetCookies(
283: cookieNames JTF_VARCHAR2_TABLE_300,
284: cookieValues JTF_VARCHAR2_TABLE_4000,

Line 303: pgObjects JTF_PF_PAGE_OBJECT ;

299: | Upload THE data IN AQ periodically TO THE JTF Repository |
300: ============================================================================*/
301: PROCEDURE uploadAllNewPfObjects --ang This proc is currently not being invoked
302: IS --anywhere
303: pgObjects JTF_PF_PAGE_OBJECT ;
304: new_messages BOOLEAN :=TRUE;
305: dopt dbms_aq.dequeue_options_t;
306: mprop dbms_aq.message_properties_t;
307: deq_msgid RAW(16);

Line 597: nextpo JTF_PF_PAGE_OBJECT;

593: CURSOR cur_val IS
594: SELECT nvl(max_po,-100000000000), nvl(ses_seqid,0), nvl(anon_seqid,0)
595: FROM JTF_PF_SEQ_VL;
596:
597: nextpo JTF_PF_PAGE_OBJECT;
598: currpo JTF_PF_PAGE_OBJECT;
599: thinkT INTEGER;
600: seqcnt1 INTEGER;
601: seqcnt2 INTEGER;

Line 598: currpo JTF_PF_PAGE_OBJECT;

594: SELECT nvl(max_po,-100000000000), nvl(ses_seqid,0), nvl(anon_seqid,0)
595: FROM JTF_PF_SEQ_VL;
596:
597: nextpo JTF_PF_PAGE_OBJECT;
598: currpo JTF_PF_PAGE_OBJECT;
599: thinkT INTEGER;
600: seqcnt1 INTEGER;
601: seqcnt2 INTEGER;
602: maxpo INTEGER;