DBA Data[Home] [Help]

APPS.CZ_RULE_IMPORT dependencies on CZ_XFR_RUN_INFOS_S

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 2606: UPDATE cz_xfr_run_infos SET

2602: x_msg_data);
2603:
2604: --Update the control record for this session.
2605:
2606: UPDATE cz_xfr_run_infos SET
2607: last_activity = SYSDATE,
2608: completed = '1'
2609: WHERE run_id = p_run_id;
2610: