27: INDEX BY BINARY_INTEGER;
28:
29: TYPE CS_Incident_Address_Rec IS RECORD
30: (
31: INCIDENT_ADDRESS cs_incidents_all_b.incident_address%type,
32: INCIDENT_CITY cs_incidents_all_b.incident_city%type,
33: INCIDENT_STATE cs_incidents_all_b.incident_state%type,
34: INCIDENT_COUNTRY cs_incidents_all_b.incident_country%type,
35: INCIDENT_PROVINCE cs_incidents_all_b.incident_province%type,
28:
29: TYPE CS_Incident_Address_Rec IS RECORD
30: (
31: INCIDENT_ADDRESS cs_incidents_all_b.incident_address%type,
32: INCIDENT_CITY cs_incidents_all_b.incident_city%type,
33: INCIDENT_STATE cs_incidents_all_b.incident_state%type,
34: INCIDENT_COUNTRY cs_incidents_all_b.incident_country%type,
35: INCIDENT_PROVINCE cs_incidents_all_b.incident_province%type,
36: INCIDENT_POSTAL_CODE cs_incidents_all_b.incident_postal_code%type,
29: TYPE CS_Incident_Address_Rec IS RECORD
30: (
31: INCIDENT_ADDRESS cs_incidents_all_b.incident_address%type,
32: INCIDENT_CITY cs_incidents_all_b.incident_city%type,
33: INCIDENT_STATE cs_incidents_all_b.incident_state%type,
34: INCIDENT_COUNTRY cs_incidents_all_b.incident_country%type,
35: INCIDENT_PROVINCE cs_incidents_all_b.incident_province%type,
36: INCIDENT_POSTAL_CODE cs_incidents_all_b.incident_postal_code%type,
37: INCIDENT_COUNTY cs_incidents_all_b.incident_county%type
30: (
31: INCIDENT_ADDRESS cs_incidents_all_b.incident_address%type,
32: INCIDENT_CITY cs_incidents_all_b.incident_city%type,
33: INCIDENT_STATE cs_incidents_all_b.incident_state%type,
34: INCIDENT_COUNTRY cs_incidents_all_b.incident_country%type,
35: INCIDENT_PROVINCE cs_incidents_all_b.incident_province%type,
36: INCIDENT_POSTAL_CODE cs_incidents_all_b.incident_postal_code%type,
37: INCIDENT_COUNTY cs_incidents_all_b.incident_county%type
38: );
31: INCIDENT_ADDRESS cs_incidents_all_b.incident_address%type,
32: INCIDENT_CITY cs_incidents_all_b.incident_city%type,
33: INCIDENT_STATE cs_incidents_all_b.incident_state%type,
34: INCIDENT_COUNTRY cs_incidents_all_b.incident_country%type,
35: INCIDENT_PROVINCE cs_incidents_all_b.incident_province%type,
36: INCIDENT_POSTAL_CODE cs_incidents_all_b.incident_postal_code%type,
37: INCIDENT_COUNTY cs_incidents_all_b.incident_county%type
38: );
39:
32: INCIDENT_CITY cs_incidents_all_b.incident_city%type,
33: INCIDENT_STATE cs_incidents_all_b.incident_state%type,
34: INCIDENT_COUNTRY cs_incidents_all_b.incident_country%type,
35: INCIDENT_PROVINCE cs_incidents_all_b.incident_province%type,
36: INCIDENT_POSTAL_CODE cs_incidents_all_b.incident_postal_code%type,
37: INCIDENT_COUNTY cs_incidents_all_b.incident_county%type
38: );
39:
40: G_PKG_NAME VARCHAR2(30) := 'TEST_AN_CS_SR_DUP_CHK_PVT';
33: INCIDENT_STATE cs_incidents_all_b.incident_state%type,
34: INCIDENT_COUNTRY cs_incidents_all_b.incident_country%type,
35: INCIDENT_PROVINCE cs_incidents_all_b.incident_province%type,
36: INCIDENT_POSTAL_CODE cs_incidents_all_b.incident_postal_code%type,
37: INCIDENT_COUNTY cs_incidents_all_b.incident_county%type
38: );
39:
40: G_PKG_NAME VARCHAR2(30) := 'TEST_AN_CS_SR_DUP_CHK_PVT';
41: