APPS.JTF_PF_CONV_PKG dependencies on DUAL

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

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;
63:
64: SELECT sysdate INTO dbdate FROM dual;
65:
66: IF (write_to_jtf = 1) THEN
67: FORALL indx IN objTabLocal.FIRST .. objTabLocal.LAST
68: INSERT INTO jtf_pf_repository(

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

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,
130: obj.cookies, obj.headers, obj.prodinfo);

Line 396: FROM dual;

392: today DATE;
393: BEGIN
394: SELECT trunc(sysdate)
395: INTO today
396: FROM dual;
397:
398: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_LOGINS_DATA(timezone_offset);
399: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_RESP_DATA(timezone_offset);
400: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_FORMS_DATA(timezone_offset);