APPS.CZ_LOGIC_GEN dependencies on DUAL

Line 220: 'SELECT 1 FROM DUAL WHERE EXISTS' ||

216:
217: h_containerReferred tIntegerArray_idx_vc2;
218: containerReferred VARCHAR2(4000) :=
219:
220: 'SELECT 1 FROM DUAL WHERE EXISTS' ||
221: ' (SELECT model_id FROM cz_model_ref_expls' ||
222: ' WHERE deleted_flag = ''' || FLAG_NOT_DELETED || '''' ||
223: ' AND ps_node_type IN (' || PS_NODE_TYPE_REFERENCE || ', ' || PS_NODE_TYPE_CONNECTOR || ')' ||
224: ' AND component_id = :1' ||

Line 245: SELECT cz_lce_headers_s.NEXTVAL INTO last_id_allocated FROM DUAL;

241: BEGIN
242: IF((last_id_allocated IS NULL) OR
243: (next_id_to_use = (NVL(last_id_allocated, 0) + CZ_SEQUENCE_INCREMENT)))THEN
244:
245: SELECT cz_lce_headers_s.NEXTVAL INTO last_id_allocated FROM DUAL;
246: next_id_to_use := last_id_allocated;
247: END IF;
248:
249: id_to_return := next_id_to_use;

Line 2247: SELECT NULL INTO v_null FROM DUAL WHERE val1 LIKE val2;

2243: ELSIF(OperType = OPERATOR_CONTAINS)THEN
2244: RETURN (INSTR(val1, val2) <> 0);
2245: ELSIF(OperType = OPERATOR_LIKE)THEN
2246: BEGIN
2247: SELECT NULL INTO v_null FROM DUAL WHERE val1 LIKE val2;
2248: RETURN TRUE;
2249: EXCEPTION
2250: WHEN NO_DATA_FOUND THEN
2251: RETURN FALSE;

Line 2255: SELECT NULL INTO v_null FROM DUAL WHERE val1 LIKE val2;

2251: RETURN FALSE;
2252: END;
2253: ELSIF(OperType = OPERATOR_MATCHES)THEN
2254: BEGIN
2255: SELECT NULL INTO v_null FROM DUAL WHERE val1 LIKE val2;
2256: RETURN TRUE;
2257: EXCEPTION
2258: WHEN NO_DATA_FOUND THEN
2259: RETURN FALSE;

Line 2269: SELECT NULL INTO v_null FROM DUAL WHERE val1 NOT LIKE val2;

2265: ELSIF(OperType = OPERATOR_DOESNOTCONTAIN)THEN
2266: RETURN (INSTR(val1, val2) = 0);
2267: ELSIF(OperType = OPERATOR_NOTLIKE)THEN
2268: BEGIN
2269: SELECT NULL INTO v_null FROM DUAL WHERE val1 NOT LIKE val2;
2270: RETURN TRUE;
2271: EXCEPTION
2272: WHEN NO_DATA_FOUND THEN
2273: RETURN FALSE;

Line 11346: SELECT cz_xfr_run_infos_s.NEXTVAL INTO thisRunId FROM DUAL;

11342: --Get the logic generation run id. If a valid value has been passed as a parameter, use it,
11343: --else generate a new value.
11344:
11345: IF(thisRunId IS NULL OR thisRunId = 0)THEN
11346: SELECT cz_xfr_run_infos_s.NEXTVAL INTO thisRunId FROM DUAL;
11347: END IF;
11348:
11349: --Read the cz_effectivity_sets table into memory and create hash tables for
11350: --effectivity dates