DBA Data[Home] [Help]

APPS.CS_SR_DUP_CHK_PVT dependencies on CS_INCIDENTS_ALL_B

Line 899: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;

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:

Line 900: l_inv_item_serial_number CS_INCIDENTS_ALL_B.item_serial_number%type;

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

Line 901: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;

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

Line 1335: l_current_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;

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;

Line 1336: l_instance_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;

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:

Line 1337: l_inv_item_serial_number CS_INCIDENTS_ALL_B.current_serial_number%type;

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