291: FUNCTION VALIDATE_ITEM_INSTANCE(p_instance_id NUMBER) RETURN VARCHAR2 IS
292:
293: CURSOR c1 IS
294: SELECT INSTANCE_NUMBER
295: FROM CSI_ITEM_INSTANCES
296: WHERE INSTANCE_ID = p_instance_id;
297:
298: l_instance_number VARCHAR2(30);
299: BEGIN
1023: AND BILLING_TYPE = p_billing_Type;
1024:
1025: CURSOR CUR_ITEM_INSTANCE(p_item_id NUMBER, p_serial_number NUMBER) IS
1026: SELECT instance_number, instance_id
1027: FROM csi_item_instances
1028: WHERE inventory_item_id = p_item_id
1029: AND serial_number = p_serial_number;
1030:
1031: l_billing_Type VARCHAR2(1);