APPS.CS_SR_EXTATTRIBUTES_PVT dependencies on CS_INCIDENTS_ALL_B

Line 321: FROM cs_incidents_all_b

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

Line 3920: FROM cs_incidents_all_b

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: -- Fix for bug 8714809 by selecting only unique record from extensible table to
3924: -- avoid duplicacy when multi row records are created. Sanjana Rao, 05-aug-2009

Line 5216: update cs_incidents_all_b

5212: -- Update the cs header table whenver an extensible attribute is created
5213: -- Fix by Sanjana Rao 08-jan-2010 for bug 9125600
5214: If nvl(l_incident_id,-1)<>to_number(P_new_ext_attrs(l_table_index).pk_column_1) then
5215: l_incident_id:=to_number(P_new_ext_attrs(l_table_index).pk_column_1);
5216: update cs_incidents_all_b
5217: set last_update_date=l_modified_on,
5218: last_updated_by=l_modified_by,
5219: last_update_login=l_last_update_login
5220: where incident_id=l_incident_id;

Line 5850: update cs_incidents_all_b

5846: -- Update the cs header table whenver an extensible attribute is created
5847: -- Fix by Sanjana Rao , 08-jan-2010 for bug 9125600
5848: If nvl(l_incident_id,-1)<>to_number(P_new_ext_attrs(l_table_index).pk_column_1) then
5849: l_incident_id:=to_number(P_new_ext_attrs(l_table_index).pk_column_1);
5850: update cs_incidents_all_b
5851: set last_update_date=l_modified_on,
5852: last_updated_by=l_modified_by,
5853: last_update_login=l_last_update_login
5854: where incident_id=l_incident_id;