DBA Data[Home] [Help]

APPS.CZ_RULE_IMPORT dependencies on CZ_XFR_RUN_INFOS_S

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 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: