DBA Data[Home] [Help]

APPS.CS_SR_DUP_CHK_PVT dependencies on CS_INCIDENTS_ALL_B

Line 883: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;

879: IS
880:
881: l_duplicate_date date;
882: l_incident_id number;
883: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
884: l_inv_item_serial_number CS_INCIDENTS_ALL_B.item_serial_number%type;
885: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
886: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
887:

Line 884: l_inv_item_serial_number CS_INCIDENTS_ALL_B.item_serial_number%type;

880:
881: l_duplicate_date date;
882: l_incident_id number;
883: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
884: l_inv_item_serial_number CS_INCIDENTS_ALL_B.item_serial_number%type;
885: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
886: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
887:
888: Cursor l_dup_sr_serialnum_csr is

Line 885: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;

881: l_duplicate_date date;
882: l_incident_id number;
883: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
884: l_inv_item_serial_number CS_INCIDENTS_ALL_B.item_serial_number%type;
885: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
886: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
887:
888: Cursor l_dup_sr_serialnum_csr is
889: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number

Line 1287: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;

1283: l_duplicate_date date;
1284: l_incident_id number;
1285: l_customer_id number;
1286: l_inventory_item_id number;
1287: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1288: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1289: l_inv_item_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1290: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
1291: l_dup_counter number := 0;

Line 1288: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;

1284: l_incident_id number;
1285: l_customer_id number;
1286: l_inventory_item_id number;
1287: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1288: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1289: l_inv_item_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1290: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
1291: l_dup_counter number := 0;
1292:

Line 1289: l_inv_item_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;

1285: l_customer_id number;
1286: l_inventory_item_id number;
1287: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1288: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1289: l_inv_item_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;
1290: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
1291: l_dup_counter number := 0;
1292:
1293: Cursor l_dup_sr_custprodsr_csr is