APPS.CZ_LOGIC_GEN dependencies on DUAL

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

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

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

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

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

2254: ELSIF(OperType = OPERATOR_CONTAINS)THEN
2255: RETURN (INSTR(val1, val2) <> 0);
2256: ELSIF(OperType = OPERATOR_LIKE)THEN
2257: BEGIN
2258: SELECT NULL INTO v_null FROM DUAL WHERE val1 LIKE val2;
2259: RETURN TRUE;
2260: EXCEPTION
2261: WHEN NO_DATA_FOUND THEN
2262: RETURN FALSE;

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

2262: RETURN FALSE;
2263: END;
2264: ELSIF(OperType = OPERATOR_MATCHES)THEN
2265: BEGIN
2266: SELECT NULL INTO v_null FROM DUAL WHERE val1 LIKE val2;
2267: RETURN TRUE;
2268: EXCEPTION
2269: WHEN NO_DATA_FOUND THEN
2270: RETURN FALSE;

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

2276: ELSIF(OperType = OPERATOR_DOESNOTCONTAIN)THEN
2277: RETURN (INSTR(val1, val2) = 0);
2278: ELSIF(OperType = OPERATOR_NOTLIKE)THEN
2279: BEGIN
2280: SELECT NULL INTO v_null FROM DUAL WHERE val1 NOT LIKE val2;
2281: RETURN TRUE;
2282: EXCEPTION
2283: WHEN NO_DATA_FOUND THEN
2284: RETURN FALSE;

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

11417: --Get the logic generation run id. If a valid value has been passed as a parameter, use it,
11418: --else generate a new value.
11419:
11420: IF(thisRunId IS NULL OR thisRunId = 0)THEN
11421: SELECT cz_xfr_run_infos_s.NEXTVAL INTO thisRunId FROM DUAL;
11422: END IF;
11423:
11424: --Read the cz_effectivity_sets table into memory and create hash tables for
11425: --effectivity dates