111: END IF;
112:
113: select to_char(sysdate,'YY-MON-DD HH:MI:SS')
114: into l_start_time
115: from dual ;
116:
117: -- Initialize the given instance to non-visited table
118:
119: l_non_visited_tbl(1).instance_id := p_instance_id ;
222: END LOOP ; -- l_non_visited_tbl.COUNT > 0
223:
224: select to_char(sysdate,'YY-MON-DD HH:MI:SS')
225: into l_end_time
226: from dual ;
227:
228: EXCEPTION
229: WHEN fnd_api.g_exc_unexpected_error THEN
230: --ROLLBACK TO get_cylic_relationships_pvt;
299: BEGIN
300: i:= 0;
301: SELECT SYSDATE
302: INTO l_sysdate
303: FROM dual;
304: --
305: -- srramakr Bug # 2882876
306: IF p_time_stamp = FND_API.G_MISS_DATE THEN
307: l_time_stamp := null;
413:
414: BEGIN
415: SELECT SYSDATE
416: INTO l_sysdate
417: FROM DUAL;
418: --
419: -- srramakr Bug # 2882876
420: IF p_time_stamp = FND_API.G_MISS_DATE THEN
421: l_time_stamp := null;
640: )
641: IS
642: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
643: SELECT instr(p_rec_item, '%', 1, 1)
644: FROM dual;
645: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
646: SELECT instr(p_rec_item, '_', 1, 1)
647: FROM dual;
648:
643: SELECT instr(p_rec_item, '%', 1, 1)
644: FROM dual;
645: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
646: SELECT instr(p_rec_item, '_', 1, 1)
647: FROM dual;
648:
649: -- return values from cursors
650: str_csr1 NUMBER;
651: str_csr2 NUMBER;
1377: COMP_EXCEP EXCEPTION;
1378: BEGIN
1379: select sysdate
1380: into l_sysdate
1381: from dual;
1382: --
1383: IF p_time_stamp IS NOT NULL THEN
1384: l_active_instances_only := FND_API.G_FALSE;
1385: l_active_relationship_only := FND_API.G_FALSE;