APPS.CZ_RULE_IMPORT dependencies on CZ_XFR_RUN_INFOS

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 2154: SELECT NULL INTO v_null FROM cz_xfr_run_infos WHERE run_id = p_run_id;

2150: --Create a control record for the current session.
2151:
2152: BEGIN
2153:
2154: SELECT NULL INTO v_null FROM cz_xfr_run_infos WHERE run_id = p_run_id;
2155: RAISE CZRI_ERR_RUNID_EXISTS;
2156:
2157: EXCEPTION
2158: WHEN NO_DATA_FOUND THEN

Line 2160: INSERT INTO cz_xfr_run_infos (run_id, started, last_activity, completed)

2156:
2157: EXCEPTION
2158: WHEN NO_DATA_FOUND THEN
2159:
2160: INSERT INTO cz_xfr_run_infos (run_id, started, last_activity, completed)
2161: VALUES (p_run_id, SYSDATE, SYSDATE, '0');
2162: END;
2163:
2164: --Call the import procedures.

Line 2186: UPDATE cz_xfr_run_infos SET

2182: x_msg_data);
2183:
2184: --Update the control record for this session.
2185:
2186: UPDATE cz_xfr_run_infos SET
2187: last_activity = SYSDATE,
2188: completed = '1'
2189: WHERE run_id = p_run_id;
2190: