895: IS
896:
897: l_duplicate_date date;
898: l_incident_id number;
899: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
900: l_inv_item_serial_number CS_INCIDENTS_ALL_B.item_serial_number%type;
901: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
902: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
903:
896:
897: l_duplicate_date date;
898: l_incident_id number;
899: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
900: l_inv_item_serial_number CS_INCIDENTS_ALL_B.item_serial_number%type;
901: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
902: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
903:
904: Cursor l_dup_sr_serialnum_csr is
897: l_duplicate_date date;
898: l_incident_id number;
899: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
900: l_inv_item_serial_number CS_INCIDENTS_ALL_B.item_serial_number%type;
901: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
902: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
903:
904: Cursor l_dup_sr_serialnum_csr is
905: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1331: l_duplicate_date date;
1332: l_incident_id number;
1333: l_customer_id number;
1334: l_inventory_item_id number;
1335: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1336: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1337: l_inv_item_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1338: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
1339: l_dup_counter number := 0;
1332: l_incident_id number;
1333: l_customer_id number;
1334: l_inventory_item_id number;
1335: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1336: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1337: l_inv_item_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1338: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
1339: l_dup_counter number := 0;
1340:
1333: l_customer_id number;
1334: l_inventory_item_id number;
1335: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1336: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1337: l_inv_item_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1338: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
1339: l_dup_counter number := 0;
1340:
1341: Cursor l_dup_sr_custprodsr_csr is