APPS.JTF_PF_CONV_PKG dependencies on DUAL

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 53: SELECT sysdate INTO dbdate 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;
54: IF (write_to_jtf = 1) THEN
55: FORALL indx IN objTabLocal.FIRST .. objTabLocal.LAST
56: INSERT INTO jtf_pf_repository(
57: pageobject, object_version_number,

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 90: SELECT sysdate INTO dbdate FROM dual;

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);
94: IF (write_to_jtf = 1) THEN

Line 309: SELECT trunc(sysdate) INTO today FROM dual;

305: -- to the OLAP Tables (JTF_PF_ANON_ACTIVITY, JTF_PF_SES_ACTIVITY).
306: PROCEDURE MIGRATE_DATA(timezone_offset IN NUMBER) IS
307: today DATE;
308: BEGIN
309: SELECT trunc(sysdate) INTO today FROM dual;
310: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_LOGINS_DATA(timezone_offset);
311: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_RESP_DATA(timezone_offset);
312: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_FORMS_DATA(timezone_offset);
313: migrate_data_raw;