APPS.IEU_PVT dependencies on DUAL

Line 317: select instr(str, '|') into pos from dual;

313: l_ctr := i + 1;
314:
315: str := l_uuid_string_list;
316: len := length(str);
317: select instr(str, '|') into pos from dual;
318: while len > 0 loop
319: select instr(str, '|') into pos from dual;
320: if pos = 0 then
321: text := str;

Line 319: select instr(str, '|') into pos from dual;

315: str := l_uuid_string_list;
316: len := length(str);
317: select instr(str, '|') into pos from dual;
318: while len > 0 loop
319: select instr(str, '|') into pos from dual;
320: if pos = 0 then
321: text := str;
322: str := null;
323: else

Line 1245: dual;

1241: (instr(l_res_cat_where_clause, ':resource_id', 1, 1)), 0, 'F','T' )
1242: into
1243: l_enum_bind_var_flag
1244: from
1245: dual;
1246: else
1247: l_enum_bind_var_flag := 'F';
1248: end if;
1249:

Line 1390: dual;

1386: decode((instr(l_where_clause, ':resource_id', 1, 1)), 0, 'F','T' )
1387: into
1388: l_resource_id_flag
1389: from
1390: dual;
1391: else
1392: l_resource_id_flag := 'F';
1393: end if;
1394:

Line 2622: SELECT IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL INTO L_SEL_RT_NODE_ID FROM DUAL;

2618:
2619: L_RTNODE_INSERT_FLAG := 'N';
2620: EXCEPTION
2621: WHEN NO_DATA_FOUND THEN
2622: SELECT IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL INTO L_SEL_RT_NODE_ID FROM DUAL;
2623: L_RTNODE_INSERT_FLAG := 'Y';
2624: END;
2625: IF NVL(L_RTNODE_INSERT_FLAG, 'X') = 'N' THEN
2626: IEU_PVT.LAST_UPDATED_BY_LIST(i) := FND_GLOBAL.USER_ID;

Line 2765: SELECT IEU_UWQ_RTNODE_BIND_VALS_S1.NEXTVAL INTO L_RTNODE_BIND_VAR_ID FROM DUAL;

2761:
2762: L_BINDVALS_INSERT_FLAG := 'N';
2763: EXCEPTION
2764: WHEN NO_DATA_FOUND THEN
2765: SELECT IEU_UWQ_RTNODE_BIND_VALS_S1.NEXTVAL INTO L_RTNODE_BIND_VAR_ID FROM DUAL;
2766: L_BINDVALS_INSERT_FLAG := 'Y';
2767: END;
2768: IF NVL(L_BINDVALS_INSERT_FLAG, 'X') = 'N' THEN
2769: IEU_PVT.BIND_LAST_UPDATED_BY_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.USER_ID;