APPS.CZ_RULE_IMPORT dependencies on DUAL

Line 414: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM dual;

410:
411: IF((last_id_allocated IS NULL) OR
412: (next_id_to_use = (NVL(last_id_allocated, 0) + id_increment)))THEN
413:
414: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM dual;
415: next_id_to_use := last_id_allocated;
416: END IF;
417:
418: id_to_return := next_id_to_use;

Line 1519: SELECT cz_intl_texts_s.NEXTVAL INTO last_id_allocated FROM dual;

1515:
1516: IF((last_id_allocated IS NULL) OR
1517: (next_id_to_use = (NVL(last_id_allocated, 0) + id_increment)))THEN
1518:
1519: SELECT cz_intl_texts_s.NEXTVAL INTO last_id_allocated FROM dual;
1520: next_id_to_use := last_id_allocated;
1521: END IF;
1522:
1523: id_to_return := next_id_to_use;

Line 2121: SELECT cz_xfr_run_infos_s.NEXTVAL INTO p_run_id FROM DUAL;

2117: --If necessary, generate a run_id and update the source records with this value.
2118:
2119: IF(p_run_id IS NULL)THEN
2120:
2121: SELECT cz_xfr_run_infos_s.NEXTVAL INTO p_run_id FROM DUAL;
2122:
2123: UPDATE cz_imp_rules SET run_id = p_run_id
2124: WHERE disposition IS NULL
2125: AND rec_status IS NULL

Line 2138: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS

2134: END IF;
2135:
2136: BEGIN
2137:
2138: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS
2139: (SELECT NULL FROM cz_imp_rules WHERE run_id = p_run_id);
2140:
2141: EXCEPTION
2142: WHEN NO_DATA_FOUND THEN

Line 2199: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS

2195: --If there were no successfully transferred rules, the return status will be 'Error'.
2196:
2197: BEGIN
2198:
2199: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS
2200: (SELECT NULL FROM cz_imp_rules
2201: WHERE run_id = p_run_id
2202: AND rec_status = CZRI_RECSTATUS_XFR
2203: AND disposition IN (CZRI_DISPOSITION_INSERT, CZRI_DISPOSITION_MODIFY));