APPS.JTF_IH_BULK dependencies on DUAL

Line 221: SELECT DBMS_UTILITY.get_time INTO G_CONC_REQUEST_ID FROM dual;

217: -- All the FND_GLOBAL values are -1 if this program is run in command line
218: -- mode. Some of the values are important for recovery and such, so they are
219: -- being taken care of.
220: IF (G_CONC_REQUEST_ID = -1) THEN
221: SELECT DBMS_UTILITY.get_time INTO G_CONC_REQUEST_ID FROM dual;
222: END IF;
223:
224: IF (G_CONC_PROGRAM_ID = -1) THEN
225: G_CONC_PROGRAM_ID := G_CONC_REQUEST_ID;

Line 229: SELECT UID INTO G_USER_ID FROM dual;

225: G_CONC_PROGRAM_ID := G_CONC_REQUEST_ID;
226: END IF;
227:
228: IF (G_USER_ID = -1) THEN
229: SELECT UID INTO G_USER_ID FROM dual;
230: END IF;
231:
232: -- Before we get to regular programming, check if any crash recovery needs to
233: -- be done.

Line 751: -- the job now is to get the individual elements out of the document and

747: END IF;
748: --END IF;
749:
750: -- the parse call above would have build the xml document in memory.
751: -- the job now is to get the individual elements out of the document and
752: -- process them with the regular IH public API.
753: g_hrt_beat := 1.7;
754: xml_doc := dbms_xmlparser.getDocument(xml_p);
755:

Line 1325: SELECT jtf_ih_media_items_s1.NEXTVAL INTO med_id FROM sys.dual;

1321: IF (med_id IS null) THEN
1322: g_hrt_beat := 13.11;
1323: l_media_id_given := FALSE;
1324: --dbms_output.PUT('media_id is null for media_ident ' || med_ident);
1325: SELECT jtf_ih_media_items_s1.NEXTVAL INTO med_id FROM sys.dual;
1326: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' obtained from db med_id = ' || med_id);
1327: ELSE
1328: g_hrt_beat := 13.12;
1329: l_media_id_given := TRUE;

Line 1973: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;

1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_ret_msg = ' || p_ret_msg);
1970: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'error_msg_2 = ' || error_msg_2);
1971: */
1972:
1973: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;
1974:
1975: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_ERROR_ID = ' || rec_id);
1976:
1977: -- Bug3781768 Perf issue with literal usage

Line 2100: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;

2096: error_msg_2 := SUBSTRB(p_error_msg, 0, 2000);
2097: error_msg_2 := error_msg_2 || SUBSTRB(' - ', 0, (2000 - LENGTHB(error_msg_2)));
2098: error_msg_2 := error_msg_2 || SUBSTRB(p_ret_msg, 0, (2000 - LENGTHB(error_msg_2)));
2099:
2100: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;
2101:
2102: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_ERROR_ID = ' || rec_id);
2103:
2104: -- Bug3781768 Perf issue with literal usage