APPS.CZ_RULE_IMPORT dependencies on DUAL

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

497:
498: IF((last_id_allocated IS NULL) OR
499: (next_id_to_use = (NVL(last_id_allocated, 0) + id_increment)))THEN
500:
501: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM dual;
502: next_id_to_use := last_id_allocated;
503: END IF;
504:
505: id_to_return := next_id_to_use;

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

1883:
1884: IF((last_id_allocated IS NULL) OR
1885: (next_id_to_use = (NVL(last_id_allocated, 0) + id_increment)))THEN
1886:
1887: SELECT cz_intl_texts_s.NEXTVAL INTO last_id_allocated FROM dual;
1888: next_id_to_use := last_id_allocated;
1889: END IF;
1890:
1891: id_to_return := next_id_to_use;

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

2537: --If necessary, generate a run_id and update the source records with this value.
2538:
2539: IF(p_run_id IS NULL)THEN
2540:
2541: SELECT cz_xfr_run_infos_s.NEXTVAL INTO p_run_id FROM DUAL;
2542:
2543: UPDATE cz_imp_rules SET run_id = p_run_id
2544: WHERE disposition IS NULL
2545: AND rec_status IS NULL

Line 2558: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS

2554: END IF;
2555:
2556: BEGIN
2557:
2558: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS
2559: (SELECT NULL FROM cz_imp_rules WHERE run_id = p_run_id);
2560:
2561: EXCEPTION
2562: WHEN NO_DATA_FOUND THEN

Line 2619: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS

2615: --If there were no successfully transferred rules, the return status will be 'Error'.
2616:
2617: BEGIN
2618:
2619: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS
2620: (SELECT NULL FROM cz_imp_rules
2621: WHERE run_id = p_run_id
2622: AND rec_status = CZRI_RECSTATUS_XFR
2623: AND disposition IN (CZRI_DISPOSITION_INSERT, CZRI_DISPOSITION_MODIFY));