DBA Data[Home] [Help]

APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_SEQ

Line 48: SELECT JTF_PF_SEQ.NEXTVAL INTO seq_num FROM dual;

44: FOR i IN 1..objTab.COUNT
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;

Line 89: SELECT JTF_PF_SEQ.NEXTVAL INTO seq_num FROM dual;

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;
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);

Line 430: CURSOR cur_val IS SELECT nvl(max_po,-100000000000), nvl(ses_seqid,0), nvl(anon_seqid,0) FROM JTF_PF_SEQ_VL;

426: WHERE x.pageobject.info.RecId > starting_po and
427: x.track_purpose not in (2, 4)
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;