317:
318: CURSOR c_check_sr_pk_col_1(p_pk_col_1 IN NUMBER)IS
319: SELECT incident_id
320: ,incident_type_id
321: FROM cs_incidents_all_b
322: WHERE incident_id = p_pk_col_1;
323:
324: CURSOR c_check_pr_pk_cols( p_pk_col_1 IN NUMBER
325: ,p_pk_col_2 IN NUMBER
3916:
3917:
3918: CURSOR c_check_incident_id IS
3919: SELECT incident_id
3920: FROM cs_incidents_all_b
3921: WHERE incident_id = p_incident_id;
3922:
3923:
3924: cursor c_get_sr_ext_attr(p_incident_id IN NUMBER) IS