DBA Data[Home] [Help]

APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_SEQ

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

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

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

121: enable_app varchar2(10) := NULL;
122: enable_resp varchar2(10) := NULL;
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,

Line 595: FROM JTF_PF_SEQ_VL;

591: ORDER BY x.pageobject.ses.SessionId, x.pageobject.jsp.StartTime;
592:
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;