APPS.CZ_RULE_IMPORT dependencies on CZ_XFR_RUN_INFOS

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

2570: --Create a control record for the current session.
2571:
2572: BEGIN
2573:
2574: SELECT NULL INTO v_null FROM cz_xfr_run_infos WHERE run_id = p_run_id;
2575: RAISE CZRI_ERR_RUNID_EXISTS;
2576:
2577: EXCEPTION
2578: WHEN NO_DATA_FOUND THEN

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

2576:
2577: EXCEPTION
2578: WHEN NO_DATA_FOUND THEN
2579:
2580: INSERT INTO cz_xfr_run_infos (run_id, started, last_activity, completed)
2581: VALUES (p_run_id, SYSDATE, SYSDATE, '0');
2582: END;
2583:
2584: --Call the import procedures.

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: