DBA Data[Home] [Help]

APPS.BIV_VERSION_SPECIFIC_PKG dependencies on CS_INCIDENTS_ALL_B

Line 5: return('cs_incidents_all_b');

1: PACKAGE BODY biv_version_specific_pkg AS
2: -- $Header: bivvrsnb.pls 115.1 2003/02/18 23:39:16 smisra noship $ */
3: function get_sr_table return varchar2 as
4: begin
5: return('cs_incidents_all_b');
6: end;
7: procedure set_update_program( p_sr_rec in out nocopy
8: CS_ServiceRequest_PVT.service_request_rec_type) as
9: begin

Line 15: l_type_id cs_incidents_all_b.incident_type_id % type;

11: end;
12: procedure status_lov(p_sr_id number,
13: p_lov_sttmnt out nocopy varchar2) as
14: l_status_group_id cs_sr_type_mapping.status_group_id % type;
15: l_type_id cs_incidents_all_b.incident_type_id % type;
16: l_old_status_id cs_incident_statuses_b.incident_status_id % type;
17: --
18: cursor c_type is
19: select incident_type_id, incident_status_id

Line 20: from cs_incidents_all_b

16: l_old_status_id cs_incident_statuses_b.incident_status_id % type;
17: --
18: cursor c_type is
19: select incident_type_id, incident_status_id
20: from cs_incidents_all_b
21: where incident_id = p_sr_id;
22: ---
23: cursor c_status_group1 is
24: select status_group_id